[Home] [Help]
View: 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
Name |
ITEM_NUM |
ITEM_DESCRIPTION |
UNIT_OF_MEASURE |
ITEM_ID |
BUYER_ID |
BUYER_NAME |
VENDOR_NAME |
VENDOR_ID |
EFFECTIVE_DATE |
EXPIRATION_DATE |
RANK |
SPLIT |
SUPPLIER_URL |
ITEM_URL |
INVENTORY_ORGANIZATION_ID |