View: QA_SP_CRITERIA_ASSOCIATION_V

Product:	QA - Quality
Description:	Sampling association with criteria header in the criteria setup form
Implementation/DBA Data:	APPS.QA_SP_CRITERIA_ASSOCIATION_V

View Text

SELECT QSPA.ROWID SP_ROW_ID
, QSPA.CRITERIA_ID
, 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
, QSPA.LAST_UPDATE_DATE
, QSPA.LAST_UPDATED_BY
, QSPA.CREATION_DATE
, QSPA.CREATED_BY
, QSPA.LAST_UPDATE_LOGIN
FROM QA_SAMPLING_ASSOCIATION QSPA
, QA_SAMPLING_PLANS QSPP
, QA_PLANS QP
WHERE QSPA.COLLECTION_PLAN_ID = QP.PLAN_ID (+)
AND QSPA.SAMPLING_PLAN_ID = QSPP.SAMPLING_PLAN_ID

Columns