CST Invoice Transfer to Inventory

Description
Categories: BI Publisher, Financials, Manufacturing
Application: Bills of Material
Source: Invoice Transfer to Inventory (XML)
Short Name: CSTRIVTI_XML
DB package: BOM_CSTRIVTI_XMLP_PKG
select
                  null  ITEM_NAME,
                   batch_id,
                   null adjustment_account,
                   project_number ,
                   cost_group,
                   transaction_date,
                   variance_header_id interface_txn_src_line,
                   msi.description item_description,
                   current_quantity,
                   ROUND(current_item_cost * 1 / :ROUND_UNIT) * :ROUND_UNIT current_item_cost,
                   ROUND(pcnt_value_change,2) pcnt_value_change,
                   po_number,
                   po_line_num,
                   invoice_num,
                   invoice_dist_line_num,
                   po_distribution_num,
                   null po_dist_account,
                   ROUND(header_var_amount * 1 / :ROUND_UNIT) * :ROUND_UNIT header_var_amount,
                   ROUND(line_var_amount * 1 / :ROUND_UNIT) * :ROUND_UNIT line_var_amount,
                   cavv.inventory_item_id item_id,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('adjustment_account_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') adjustment_account_seg,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') ITEM_PSEG,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_SEGMENT,
                fnd_flex_xml_publisher_apis.process_kff_combination_1('po_dist_account_seg', 'SQLGL', 'GL#', CC2.CHART_OF_ACCOUNTS_ID, NULL, CC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') po_dist_account_seg
            from cst_ap_variance_v cavv,
                     mtl_system_items msi,
                     gl_code_combinations cc1,
                     gl_code_combinations cc2
            where  cavv.organization_id = :p_org_id
            and cavv.batch_id = nvl(:p_batch_id, cavv.batch_id)
            and cavv.inventory_item_id = nvl(:p_inventory_item_id,cavv.inventory_item_id)
            and msi.organization_id = :p_org_id
            and msi.inventory_item_id = cavv.inventory_item_id
            and cc1.code_combination_id = cavv.adjustment_account
            and cc2.code_combination_id = cavv.po_dist_account
			ORDER BY 2 ASC,3 ASC,5 ASC,8 ASC,20 ASC,10 ASC,9 ASC,13 ASC,12 ASC,16 ASC,6 ASC,7 ASC,18 ASC,11 ASC,17 ASC
Parameter Name SQL text Validation
View Cost Privilege
 
Number
Chart of Accounts Id
 
Number
Organization_Id
 
Number
Inventory Item
 
Batch
 
LOV Oracle