How to Find Total Production of Finished Goods in a Query

SELECT
(Select MSI.Segment1 From MTL_SYSTEM_ITEMS_B MSI where MSI.INVENTORY_ITEM_ID=M.INVENTORY_ITEM_ID AND M.ORGANIZATION_ID=MSI.ORGANIZATION_ID)Item,
(Select MSI.DESCRIPTION From MTL_SYSTEM_ITEMS_B MSI where MSI.INVENTORY_ITEM_ID=M.INVENTORY_ITEM_ID AND M.ORGANIZATION_ID=MSI.ORGANIZATION_ID) DESCRIPTION,
(Select MSI.PRIMARY_UOM_CODE From MTL_SYSTEM_ITEMS_B MSI where MSI.INVENTORY_ITEM_ID=M.INVENTORY_ITEM_ID AND M.ORGANIZATION_ID=MSI.ORGANIZATION_ID) UOM,
NVL(M.Total_qty+NVL(N.Total_QTY,0),0) Total_Quantity
FROM
(SELECT MMT.INVENTORY_ITEM_ID,MMT.ORGANIZATION_ID, NVL(SUM(MMT.PRIMARY_QUANTITY),0) Total_QTY
From MTL_MATERIAL_TRANSACTIONS MMT
WHERE      MMT.ORGANIZATION_ID = NVL(:P_ORGANIZATION_ID,MMT.ORGANIZATION_ID)
AND     MMT.TRANSACTION_TYPE_ID=44 --WIP Complition
AND     MMT.TRANSACTION_SOURCE_TYPE_ID=5  --Job or Schedule
AND     TRUNC(MMT.TRANSACTION_DATE) BETWEEN :start_date AND :end_date
GROUP BY MMT.INVENTORY_ITEM_ID,MMT.ORGANIZATION_ID)M,
(SELECT MMT.INVENTORY_ITEM_ID,MMT.ORGANIZATION_ID, NVL(SUM(MMT.PRIMARY_QUANTITY),0) Total_QTY
From MTL_MATERIAL_TRANSACTIONS MMT
WHERE      MMT.ORGANIZATION_ID = NVL(:P_ORGANIZATION_ID,MMT.ORGANIZATION_ID)
AND     MMT.TRANSACTION_TYPE_ID=17  --WIP Complition Return
AND     MMT.TRANSACTION_SOURCE_TYPE_ID=5  --Job or Schedule
AND     TRUNC(MMT.TRANSACTION_DATE) BETWEEN :start_date AND :end_date
GROUP BY MMT.INVENTORY_ITEM_ID,MMT.ORGANIZATION_ID)N
Where M.INVENTORY_ITEM_ID=N.INVENTORY_ITEM_ID(+)
AND     M.ORGANIZATION_ID=N.ORGANIZATION_ID(+)
Order By Item

How to Find Custom Concurrent Program Name in a Single Query

SELECT a.cpname, a.UCPNAME, a.param, f.FLEX_VALUE_SET_NAME FROM
(
select V.CONCURRENT_PROGRAM_NAME CPNAME, V.USER_CONCURRENT_PROGRAM_NAME UCPNAME, nvl(VC.END_USER_COLUMN_NAME,'NULL PARAM') param,
NVL(vc.FLEX_VALUE_SET_ID,0) valueset
from FND_CONCURRENT_PROGRAMS_VL v,
FND_DESCR_FLEX_COL_USAGE_VL VC
where V.USER_CONCURRENT_PROGRAM_NAME like 'XX%' AND V.APPLICATION_ID = VC.APPLICATION_ID(+)
AND VC.DESCRIPTIVE_FLEXFIELD_NAME(+) = '$SRS$.'||V.CONCURRENT_PROGRAM_NAME
) a,
fnd_flex_value_sets f
where a.valueset = f.flex_value_set_id(+)