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_SAMPLING_RCV_CRITERIA_V

Source

View Text - Preformatted


SELECT QSSRC.ROWID ROW_ID, QSSRC.CRITERIA_ID, QSPA.SAMPLING_PLAN_ID, QSP.SAMPLING_PLAN_CODE SAMPLING_PLAN_CODE, QSP.DESCRIPTION SAMPLING_PLAN_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, 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, qa_flex_util.mtl_categories_description(QSSRC.ITEM_CATEGORY_ID) CATEGORY_DESC, 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, DECODE(QSPA.COLLECTION_PLAN_ID, -1, null,QSPA.COLLECTION_PLAN_ID) COLLECTION_PLAN_ID, QP.NAME COLLECTION_PLAN_NAME, QSPA.EFFECTIVE_FROM, QSPA.EFFECTIVE_TO, QSPA.WF_ROLE_NAME, 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_SAMPLING_ASSOCIATION QSPA, QA_SAMPLING_PLANS QSP, AP_SUPPLIERS PV, HZ_PARTIES HP, AP_SUPPLIER_SITES_ALL PVS, MTL_SYSTEM_ITEMS MSI, PA_TASKS PT, QA_PLANS QP WHERE QSSRC.CRITERIA_ID = QSPA.CRITERIA_ID AND QSPA.SAMPLING_PLAN_ID = QSP.SAMPLING_PLAN_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 = MSI.INVENTORY_ITEM_ID(+) AND QSSRC.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+) AND QSSRC.TASK_ID = PT.TASK_ID (+) AND QSPA.COLLECTION_PLAN_ID = QP.PLAN_ID (+)

View Text - HTML Formatted

SELECT QSSRC.ROWID ROW_ID
, QSSRC.CRITERIA_ID
, QSPA.SAMPLING_PLAN_ID
, QSP.SAMPLING_PLAN_CODE SAMPLING_PLAN_CODE
, QSP.DESCRIPTION SAMPLING_PLAN_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
, 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
, QA_FLEX_UTIL.MTL_CATEGORIES_DESCRIPTION(QSSRC.ITEM_CATEGORY_ID) CATEGORY_DESC
, 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
, DECODE(QSPA.COLLECTION_PLAN_ID
, -1
, NULL
, QSPA.COLLECTION_PLAN_ID) COLLECTION_PLAN_ID
, QP.NAME COLLECTION_PLAN_NAME
, QSPA.EFFECTIVE_FROM
, QSPA.EFFECTIVE_TO
, QSPA.WF_ROLE_NAME
, 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_SAMPLING_ASSOCIATION QSPA
, QA_SAMPLING_PLANS QSP
, AP_SUPPLIERS PV
, HZ_PARTIES HP
, AP_SUPPLIER_SITES_ALL PVS
, MTL_SYSTEM_ITEMS MSI
, PA_TASKS PT
, QA_PLANS QP
WHERE QSSRC.CRITERIA_ID = QSPA.CRITERIA_ID
AND QSPA.SAMPLING_PLAN_ID = QSP.SAMPLING_PLAN_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 = MSI.INVENTORY_ITEM_ID(+)
AND QSSRC.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND QSSRC.TASK_ID = PT.TASK_ID (+)
AND QSPA.COLLECTION_PLAN_ID = QP.PLAN_ID (+)