View: QA_SAMPLING_RCV_CRITERIA_VAL_V

Product:	QA - Quality
Description:	Valid Sampling criteria for Receiving
Implementation/DBA Data:	APPS.QA_SAMPLING_RCV_CRITERIA_VAL_V

View Text

SELECT QSSRC.CRITERIA_ID
, QSPA.SAMPLING_PLAN_ID
, QSSRC.ORGANIZATION_ID
, QSSRC.VENDOR_ID
, QSSRC.VENDOR_SITE_ID
, QSSRC.ITEM_ID
, QSSRC.ITEM_REVISION
, QSSRC.ITEM_CATEGORY_ID
, QSSRC.PROJECT_ID
, QSSRC.TASK_ID
, QSPA.COLLECTION_PLAN_ID
, 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
WHERE QSSRC.CRITERIA_ID = QSPA.CRITERIA_ID

Columns