View: POS_PO_SUPPLIER_ITEMS_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_PO_SUPPLIER_ITEMS_V

View Text

SELECT /*+ ORDERED USE_NL(MISL
, MSI
, POV
, HRV
, FSP) INDEX(HRV PER_PEOPLE_F_PK)*/ DISTINCT 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
, MSI.ORGANIZATION_ID
, HOU.NAME
, ASL.PRIMARY_VENDOR_ITEM
FROM MRP_ITEM_SOURCING_LEVELS_V MISL
, MTL_SYSTEM_ITEMS_KFV MSI
, PO_VENDORS POV
, PER_ALL_PEOPLE_F HRV
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PO_APPROVED_SUPPLIER_LIST ASL
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 ASL.ITEM_ID = MSI.INVENTORY_ITEM_ID
AND ASL.VENDOR_ID = MISL.VENDOR_ID
AND MISL.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND HRV.PERSON_ID(+) = MSI.BUYER_ID
AND HOU.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')

Columns