PO Vendor Service Performance Analysis

Description

Categories
Enginatics
Application
Purchasing
Source
Vendor Service Performance Analysis Report (XML)
Short Name
POXSERPR_XML
DB package
PO_POXSERPR_XMLP_PKG
Repository
GitHub
Imported from BI Publisher

SQL 164 lines

Parameters 9

ParameterTypeList of values SQL
Operating UnitLOV
hou.name=:operating_unit
VendorLOV
aps.vendor_name=:vendor
BuyerLOV
papf.full_name=:buyer
Creation Date FromDate
decode(pll.shipment_type,'STANDARD',trunc(poh.creation_date),trunc(por.creation_date))>=:creation_date_from
Creation Date ToDate
decode(pll.shipment_type,'STANDARD',trunc(poh.creation_date),trunc(por.creation_date))<=:creation_date_to
ItemLOV
pol.item_id in (select msiv.inventory_item_id from mtl_system_items_vl msiv where msiv.organization_id=fspa.inventory_organization_id and msiv.concatenated_segments like :item)
Category FromLOV
mcbk.concatenated_segments>=:category_from
Category ToLOV
mcbk.concatenated_segments<=:category_to
Quantity PrecisionLOV Oracle