View: ICX_PO_SUPPLIER_ITEMS_V

Product:	ICX - Oracle iProcurement
Description:	Supplier Items View
Implementation/DBA Data:	APPS.ICX_PO_SUPPLIER_ITEMS_V

View Text

SELECT /*+ ORDERED USE_NL(MISL
, MSI
, POV
, HRV
, FSP) INDEX(HRV PER_PEOPLE_F_PK)*/ MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, MSI.PRIMARY_UNIT_OF_MEASURE
, MISL.INVENTORY_ITEM_ID
, MSI.BUYER_ID
, HRV.FULL_NAME
, POV.VENDOR_NAME
, MISL.VENDOR_ID
, MISL.EFFECTIVE_DATE
, MISL.DISABLE_DATE
, MISL.RANK
, MISL.ALLOCATION_PERCENT
, POV.ATTRIBUTE14
, MSI.ATTRIBUTE14
, FSP.INVENTORY_ORGANIZATION_ID
FROM MRP_ITEM_SOURCING_LEVELS_V MISL
, MTL_SYSTEM_ITEMS_KFV MSI
, PO_VENDORS POV
, PER_PEOPLE_F HRV
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE (SYSDATE BETWEEN MISL.EFFECTIVE_DATE
AND NVL(MISL.DISABLE_DATE
, SYSDATE+1))
AND MISL.VENDOR_ID = POV.VENDOR_ID
AND MISL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MISL.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND HRV.PERSON_ID(+) = MSI.BUYER_ID
AND MISL.ORGANIZATION_ID = FSP.INVENTORY_ORGANIZATION_ID

Columns