PO Vendor Volume Analysis

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Vendor Volume Analysis Report
Application: Purchasing
Source: Vendor Volume Analysis Report (XML)
Short Name: POXVCVAR_XML
DB package: PO_POXVCVAR_XMLP_PKG
Run PO Vendor Volume Analysis and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT null                           C_FLEX_ITEM 
,      msi.description                        Description
,      sv.vendor                                 Vendor
,      sv.rank                                      Rank
,      round((nvl(sv.quantity,0)- 
          nvl(sv.quantity_cancelled,0))*
          nvl(sv.price_override,0) * nvl(sv.rate,1) ,:precision)    Expenditure
,         sv.split                                                  Split, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM_DISP, 
	PO_POXVCVAR_XMLP_PKG.get_actual(:Expenditure_Total, :C_Vendor_total) C_actual, 
	PO_POXVCVAR_XMLP_PKG.c_intendedformula(sv.split, :Expenditure_Total) C_intended
FROM   po_source_vendors_v  sv
,      mtl_system_items             msi
WHERE  sv.item_id           = msi.inventory_item_id(+)
AND    po_creation_date     
         BETWEEN  nvl(:P_Creation_Date_From,po_creation_date - 1)   
         AND      nvl(:P_Creation_Date_To,po_creation_date + 1)   
   AND sv.assignment_set_id = :P_ASSIGNMENT_SET_ID_Qry
   AND  sv.organization_id = :P_ORGANIZATION_ID
   AND  nvl(msi.organization_id,:P_ORGANIZATION_ID) = :P_ORGANIZATION_ID
AND    &P_WHERE_ITEM
ORDER BY  msi.description, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')
,        sv.vendor
,        sv.split, sv.rank
Parameter Name SQL text Validation
Operating Unit 
 
 LOV
Title 
 
 Char
Items From 
 
 Char
To 
 
 Char
Creation Dates From 
 
 Date
To 2 
 
 Date
Organization 
 
 LOV Oracle
Download
Related Blitz Reports
CAC Intercompany SO Price List vs. Item Cost Comparison PO Unordered Receipts CST AP and PO Accrual Reconciliation PO Receiving Account Distribution WSH Open Deliveries PO Expected Receipts CAC Purchase Price Variance WSH Vehicle Load Sheet Details ECC Lease Contracts, Lease Meter Errors
Blitz Report™

Blitz Report™ provides multiple benefits: