CST Period Close Reconciliation

Description
Categories: BI Publisher
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)