eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QA_SL_SP_RCV_CRITERIA_ALL_V

Source

View Text - Preformatted


SELECT QSSRC.ROWID RCV_CRITERIA_ROW_ID, QSLA.ROWID SL_ROW_ID, QSPA.ROWID SP_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, QSLA.PROCESS_ID, QSLP.PROCESS_CODE, QSLA.EFFECTIVE_FROM SL_EFFECTIVE_FROM, QSLA.EFFECTIVE_TO SL_EFFECTIVE_TO, QSLA.LOTSIZE_FROM, QSLA.LOTSIZE_TO, QSLA.WF_ROLE_NAME SL_WF_ROLE_NAME, QSPA.SAMPLING_PLAN_ID, QSPP.SAMPLING_PLAN_CODE, QSPA.COLLECTION_PLAN_ID, QP.NAME COLLECTION_PLAN_NAME, QSPA.WF_ROLE_NAME SP_WF_ROLE_NAME, QSPA.EFFECTIVE_FROM SP_EFFECTIVE_FROM, QSPA.EFFECTIVE_TO SP_EFFECTIVE_TO 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, QA_SKIPLOT_ASSOCIATION QSLA, QA_SKIPLOT_PROCESSES QSLP, QA_SAMPLING_ASSOCIATION QSPA, QA_SAMPLING_PLANS QSPP, QA_PLANS QP 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 (+) AND QSSRC.CRITERIA_ID = QSLA.CRITERIA_ID(+) AND QSLA.PROCESS_ID = QSLP.PROCESS_ID (+) AND QSSRC.CRITERIA_ID = QSPA.CRITERIA_ID (+) AND QSPA.COLLECTION_PLAN_ID = QP.PLAN_ID (+) AND QSPA.SAMPLING_PLAN_ID = QSPP.SAMPLING_PLAN_ID (+)

View Text - HTML Formatted

SELECT QSSRC.ROWID RCV_CRITERIA_ROW_ID
, QSLA.ROWID SL_ROW_ID
, QSPA.ROWID SP_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
, QSLA.PROCESS_ID
, QSLP.PROCESS_CODE
, QSLA.EFFECTIVE_FROM SL_EFFECTIVE_FROM
, QSLA.EFFECTIVE_TO SL_EFFECTIVE_TO
, QSLA.LOTSIZE_FROM
, QSLA.LOTSIZE_TO
, QSLA.WF_ROLE_NAME SL_WF_ROLE_NAME
, QSPA.SAMPLING_PLAN_ID
, QSPP.SAMPLING_PLAN_CODE
, QSPA.COLLECTION_PLAN_ID
, QP.NAME COLLECTION_PLAN_NAME
, QSPA.WF_ROLE_NAME SP_WF_ROLE_NAME
, QSPA.EFFECTIVE_FROM SP_EFFECTIVE_FROM
, QSPA.EFFECTIVE_TO SP_EFFECTIVE_TO
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
, QA_SKIPLOT_ASSOCIATION QSLA
, QA_SKIPLOT_PROCESSES QSLP
, QA_SAMPLING_ASSOCIATION QSPA
, QA_SAMPLING_PLANS QSPP
, QA_PLANS QP
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 (+)
AND QSSRC.CRITERIA_ID = QSLA.CRITERIA_ID(+)
AND QSLA.PROCESS_ID = QSLP.PROCESS_ID (+)
AND QSSRC.CRITERIA_ID = QSPA.CRITERIA_ID (+)
AND QSPA.COLLECTION_PLAN_ID = QP.PLAN_ID (+)
AND QSPA.SAMPLING_PLAN_ID = QSPP.SAMPLING_PLAN_ID (+)