CST Period Close Reconciliation

Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Period Close Reconciliation Report (XML)
Short Name: CSTRPCRE_XML
DB package: BOM_CSTRPCRE_XMLP_PKG
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
Parameter Name SQL text Validation
CST_SRS_RATE_TYPE
 
Number
CST_SRS_INVERSE_RATE
 
Report Type
 
LOV Oracle
Chart of Accounts ID
 
Number
Organization ID
 
Number
Exchange Rate
 
LOV Oracle
Currency
 
LOV Oracle
Item To
 
Item From
 
Subinventory To
 
LOV Oracle
Subinventory From
 
LOV Oracle
Cost Group To
 
LOV Oracle
Cost Group From
 
LOV Oracle
Run To Date
 
Date
Period
 
LOV Oracle
Sort Option
 
LOV Oracle
Ask a question