PO Vendor Volume Analysis

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source: Vendor Volume Analysis Report (XML)
Short Name: POXVCVAR_XML
DB package: PO_POXVCVAR_XMLP_PKG
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
P_BASE_CURRENCY
 
LOV Oracle
Organization
 
LOV Oracle
To
 
Date
Creation Dates From
 
Date
To
 
Items From
 
Title