CST Period Close Reconciliation

SELECT
CPCS.subinventory_code sub_code,
DECODE(CPCS.subinventory_code,
              NULL, :P_NULLSUB,
              SUB.description) sub_description,
fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_seg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') sub_item,
round(SUM(CPCS.accounted_value) * (:P_EXCHANGE_RATE) / :P_ROUND_UNIT) * :P_ROUND_UNIT sub_acc_val,
round(SUM(CPCS.rollback_value) * (:P_EXCHANGE_RATE) / :P_ROUND_UNIT) * :P_ROUND_UNIT sub_onh_val,
round(SUM(CPCS.rollback_value - CPCS.accounted_value) * (:P_EXCHANGE_RATE) / :P_ROUND_UNIT) * :P_ROUND_UNIT sub_adj_val
FROM
mtl_system_items_b_kfv MSI,
mtl_secondary_inventories SUB,
&P_SOURCE_TABLE CPCS
WHERE	MSI.organization_id = :p_org_id
AND	SUB.organization_id(+) = :p_org_id
AND	CPCS.inventory_item_id = MSI.inventory_item_id
AND	CPCS.subinventory_code = SUB.secondary_inventory_name(+)
AND	MSI.concatenated_segments
	BETWEEN	NVL(:P_ITEM_FROM, MSI.concatenated_segments)
	AND	NVL(:P_ITEM_TO, MSI.concatenated_segments)
AND         NVL(CPCS.subinventory_code,-1)
                BETWEEN NVL(:P_SUB_FROM,  NVL(CPCS.subinventory_code,-1))
                AND          NVL(:P_SUB_TO, NVL(CPCS.subinventory_code,-1))
AND	&P_CPCS_WHERE
GROUP
BY	CPCS.subinventory_code,
                DECODE(CPCS.subinventory_code,
                               NULL, :P_NULLSUB,
                               SUB.description),
	fnd_flex_xml_publisher_apis.process_kff_combination_1('p_item_seg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')
&P_SUB_SORT_TEXT