View: QA_SL_SP_RCV_CRITERIA_V

Product:	QA - Quality
Description:	Skip Lot/Sampling Criteria for Receiving
Implementation/DBA Data:	APPS.QA_SL_SP_RCV_CRITERIA_V

View Text

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 (+)

Columns