VIEW: APPS.QA_SKIPLOT_RCV_CRITERIA_V

Source

View Text - Preformatted

SELECT QSSRC.ROWID ROW_ID, QSSRC.CRITERIA_ID, QSLA.PROCESS_ID, QSP.PROCESS_CODE, QSP.DESCRIPTION PROCESS_DESC, 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, MSIK.CONCATENATED_SEGMENTS 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, qa_flex_util.mtl_categories_description(QSSRC.ITEM_CATEGORY_ID) 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, QSLA.EFFECTIVE_FROM, QSLA.EFFECTIVE_TO, QSLA.LOTSIZE_FROM, QSLA.LOTSIZE_TO, QSLA.WF_ROLE_NAME, qa_flex_util.get_qa_lookups_meaning('QA_SKIPLOT_STAGE', qsla.insp_stage) INSP_STAGE, 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, QA_SKIPLOT_PROCESSES QSP, QA_SKIPLOT_ASSOCIATION QSLA, AP_SUPPLIERS PV, HZ_PARTIES HP, AP_SUPPLIER_SITES_ALL PVS, MTL_SYSTEM_ITEMS_KFV MSIK, MTL_MANUFACTURERS MM, PA_TASKS PT WHERE QSSRC.CRITERIA_ID = QSLA.CRITERIA_ID AND QSLA.PROCESS_ID = QSP.PROCESS_ID AND 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 = MSIK.INVENTORY_ITEM_ID(+) AND QSSRC.ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)AND QSSRC.MANUFACTURER_ID = MM.MANUFACTURER_ID (+)AND QSSRC.TASK_ID = PT.TASK_ID (+)

View Text - HTML Formatted

SELECT QSSRC.ROWID ROW_ID
, QSSRC.CRITERIA_ID
, QSLA.PROCESS_ID
, QSP.PROCESS_CODE
, QSP.DESCRIPTION PROCESS_DESC
, 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
, MSIK.CONCATENATED_SEGMENTS 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
, QA_FLEX_UTIL.MTL_CATEGORIES_DESCRIPTION(QSSRC.ITEM_CATEGORY_ID) 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
, QSLA.EFFECTIVE_FROM
, QSLA.EFFECTIVE_TO
, QSLA.LOTSIZE_FROM
, QSLA.LOTSIZE_TO
, QSLA.WF_ROLE_NAME
, QA_FLEX_UTIL.GET_QA_LOOKUPS_MEANING('QA_SKIPLOT_STAGE'
, QSLA.INSP_STAGE) INSP_STAGE
, 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
, QA_SKIPLOT_PROCESSES QSP
, QA_SKIPLOT_ASSOCIATION QSLA
, AP_SUPPLIERS PV
, HZ_PARTIES HP
, AP_SUPPLIER_SITES_ALL PVS
, MTL_SYSTEM_ITEMS_KFV MSIK
, MTL_MANUFACTURERS MM
, PA_TASKS PT
WHERE QSSRC.CRITERIA_ID = QSLA.CRITERIA_ID
AND QSLA.PROCESS_ID = QSP.PROCESS_ID
AND 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 = MSIK.INVENTORY_ITEM_ID(+)
AND QSSRC.ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)AND QSSRC.MANUFACTURER_ID = MM.MANUFACTURER_ID (+)AND QSSRC.TASK_ID = PT.TASK_ID (+)