VIEW: APPS.ICX_PO_SUPPLIER_ITEMS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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