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_SKIPLOT_PROCESS_PLANS_V

Source

View Text - Preformatted


SELECT QSPP.ROWID ROW_ID, QSPP.PROCESS_PLAN_ID, QSPP.PROCESS_ID, QSPP.PLAN_ID, QP1.NAME PLAN_NAME, FCL1.MEANING PLAN_TYPE, QSPP.ALTERNATE_PLAN_ID, QP2.NAME ALTERNATE_PLAN_NAME, FCL2.MEANING ALT_PLAN_TYPE, QSPP.LAST_UPDATE_DATE, QSPP.LAST_UPDATED_BY, QSPP.CREATION_DATE, QSPP.CREATED_BY, QSPP.LAST_UPDATE_LOGIN FROM QA_SKIPLOT_PROCESS_PLANS QSPP, QA_PLANS QP1, QA_PLANS QP2, FND_COMMON_LOOKUPS FCL1, FND_COMMON_LOOKUPS FCL2 WHERE QSPP.PLAN_ID = QP1.PLAN_ID AND QSPP.ALTERNATE_PLAN_ID = QP2.PLAN_ID (+) AND FCL1.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE' AND FCL2.LOOKUP_TYPE (+) = 'COLLECTION_PLAN_TYPE' AND QP1.PLAN_TYPE_CODE = FCL1.LOOKUP_CODE AND QP2.PLAN_TYPE_CODE = FCL2.LOOKUP_CODE (+)

View Text - HTML Formatted

SELECT QSPP.ROWID ROW_ID
, QSPP.PROCESS_PLAN_ID
, QSPP.PROCESS_ID
, QSPP.PLAN_ID
, QP1.NAME PLAN_NAME
, FCL1.MEANING PLAN_TYPE
, QSPP.ALTERNATE_PLAN_ID
, QP2.NAME ALTERNATE_PLAN_NAME
, FCL2.MEANING ALT_PLAN_TYPE
, QSPP.LAST_UPDATE_DATE
, QSPP.LAST_UPDATED_BY
, QSPP.CREATION_DATE
, QSPP.CREATED_BY
, QSPP.LAST_UPDATE_LOGIN
FROM QA_SKIPLOT_PROCESS_PLANS QSPP
, QA_PLANS QP1
, QA_PLANS QP2
, FND_COMMON_LOOKUPS FCL1
, FND_COMMON_LOOKUPS FCL2
WHERE QSPP.PLAN_ID = QP1.PLAN_ID
AND QSPP.ALTERNATE_PLAN_ID = QP2.PLAN_ID (+)
AND FCL1.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
AND FCL2.LOOKUP_TYPE (+) = 'COLLECTION_PLAN_TYPE'
AND QP1.PLAN_TYPE_CODE = FCL1.LOOKUP_CODE
AND QP2.PLAN_TYPE_CODE = FCL2.LOOKUP_CODE (+)