View: QA_SKIPLOT_PROCESS_PLANS_V

Product:	QA - Quality
Description:	Skip Lot process plans
Implementation/DBA Data:	APPS.QA_SKIPLOT_PROCESS_PLANS_V

View Text

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

Columns