VIEW: APPS.QA_SL_SP_RCV_CRITERIA_V

Source

View Text - Preformatted

SELECT QSSRC.ROWID RCV_CRITERIA_ROW_ID, QSSRC.CRITERIA_ID, QSSRC.ORGANIZATION_ID, DECODE(QSSRC.VENDOR_ID, -1, null, QSSRC.VENDOR_ID) VENDOR_ID, hp.party_name VENDOR_NAME, DECODE(QSSRC.VENDOR_SITE_ID, -1, null,QSSRC.VENDOR_SITE_ID) VENDOR_SITE_ID, PVS.VENDOR_SITE_CODE, DECODE(QSSRC.ITEM_ID, -1, null, QSSRC.ITEM_ID) ITEM_ID, MSI.SEGMENT1 ITEM, DECODE(QSSRC.ITEM_REVISION, '-1', null, QSSRC.ITEM_REVISION) ITEM_REVISION, DECODE(QSSRC.ITEM_CATEGORY_ID, -1, null, QSSRC.ITEM_CATEGORY_ID) ITEM_CATEGORY_ID, MCK.CONCATENATED_SEGMENTS CATEGORY_DESC, DECODE(QSSRC.MANUFACTURER_ID, -1, null,QSSRC.MANUFACTURER_ID) MANUFACTURER_ID, MM.MANUFACTURER_NAME, DECODE(QSSRC.PROJECT_ID, -1, null, QSSRC.PROJECT_ID) PROJECT_ID, QA_FLEX_UTIL.PROJECT_NUMBER(QSSRC.PROJECT_ID) PROJECT_NUMBER, DECODE(QSSRC.TASK_ID, -1, null, QSSRC.TASK_ID) TASK_ID, PT.TASK_NUMBER, QSSRC.LAST_UPDATE_DATE, QSSRC.LAST_UPDATED_BY, QSSRC.CREATION_DATE, QSSRC.CREATED_BY, QSSRC.LAST_UPDATE_LOGIN FROM QA_SL_SP_RCV_CRITERIA QSSRC, ap_suppliers PV, hz_parties hp, ap_supplier_sites_all PVS, MTL_SYSTEM_ITEMS MSI, MTL_CATEGORIES_KFV MCK, MTL_MANUFACTURERS MM, PA_TASKS PT WHERE QSSRC.VENDOR_ID = PV.VENDOR_ID (+) AND pv.party_id = hp.party_id (+) AND QSSRC.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+) AND QSSRC.ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND QSSRC.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+) AND QSSRC.ITEM_CATEGORY_ID = MCK.CATEGORY_ID(+) AND QSSRC.MANUFACTURER_ID = MM.MANUFACTURER_ID (+) AND QSSRC.TASK_ID = PT.TASK_ID (+)

View Text - HTML Formatted

SELECT QSSRC.ROWID RCV_CRITERIA_ROW_ID
, QSSRC.CRITERIA_ID
, QSSRC.ORGANIZATION_ID
, DECODE(QSSRC.VENDOR_ID
, -1
, NULL
, QSSRC.VENDOR_ID) VENDOR_ID
, HP.PARTY_NAME VENDOR_NAME
, DECODE(QSSRC.VENDOR_SITE_ID
, -1
, NULL
, QSSRC.VENDOR_SITE_ID) VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE
, DECODE(QSSRC.ITEM_ID
, -1
, NULL
, QSSRC.ITEM_ID) ITEM_ID
, MSI.SEGMENT1 ITEM
, DECODE(QSSRC.ITEM_REVISION
, '-1'
, NULL
, QSSRC.ITEM_REVISION) ITEM_REVISION
, DECODE(QSSRC.ITEM_CATEGORY_ID
, -1
, NULL
, QSSRC.ITEM_CATEGORY_ID) ITEM_CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_DESC
, DECODE(QSSRC.MANUFACTURER_ID
, -1
, NULL
, QSSRC.MANUFACTURER_ID) MANUFACTURER_ID
, MM.MANUFACTURER_NAME
, DECODE(QSSRC.PROJECT_ID
, -1
, NULL
, QSSRC.PROJECT_ID) PROJECT_ID
, QA_FLEX_UTIL.PROJECT_NUMBER(QSSRC.PROJECT_ID) PROJECT_NUMBER
, DECODE(QSSRC.TASK_ID
, -1
, NULL
, QSSRC.TASK_ID) TASK_ID
, PT.TASK_NUMBER
, QSSRC.LAST_UPDATE_DATE
, QSSRC.LAST_UPDATED_BY
, QSSRC.CREATION_DATE
, QSSRC.CREATED_BY
, QSSRC.LAST_UPDATE_LOGIN
FROM QA_SL_SP_RCV_CRITERIA QSSRC
, AP_SUPPLIERS PV
, HZ_PARTIES HP
, AP_SUPPLIER_SITES_ALL PVS
, MTL_SYSTEM_ITEMS MSI
, MTL_CATEGORIES_KFV MCK
, MTL_MANUFACTURERS MM
, PA_TASKS PT
WHERE QSSRC.VENDOR_ID = PV.VENDOR_ID (+)
AND PV.PARTY_ID = HP.PARTY_ID (+)
AND QSSRC.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+)
AND QSSRC.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND QSSRC.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND QSSRC.ITEM_CATEGORY_ID = MCK.CATEGORY_ID(+)
AND QSSRC.MANUFACTURER_ID = MM.MANUFACTURER_ID (+)
AND QSSRC.TASK_ID = PT.TASK_ID (+)