CST Invoice Transfer to Inventory

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Invoice Transfer to Inventory
Application: Bills of Material
Source: Invoice Transfer to Inventory (XML)
Short Name: CSTRIVTI_XML
DB package: BOM_CSTRIVTI_XMLP_PKG
Run CST Invoice Transfer to Inventory and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Batch 
 
 LOV Oracle
Inventory Item 
 
 Char
Download
Related Blitz Reports
CAC Invoice Price Variance CST Simulate Transfer Shop Floor Invoice Variance CST Shop Floor Invoice Variance CST Periodic Accrual Rebuild Reconciliation CST Periodic Accrual Reconciliation CAC ICP PII WIP Material Usage Variance CAC Open Purchase Orders CAC WIP Material Usage with Configuration and Lot Variances CAC Manufacturing Variance Summary
Blitz Report™

Blitz Report™ provides multiple benefits: