Product: | QA - Quality |
---|---|
Description: | Valid Skip Lot criteria for Receiving |
Implementation/DBA Data: | APPS.QA_SKIPLOT_RCV_CRITERIA_VAL_V |
SELECT QSSRC.CRITERIA_ID
, QSLA.PROCESS_ID
, QSSRC.ORGANIZATION_ID
, QSSRC.VENDOR_ID
, QSSRC.VENDOR_SITE_ID
, QSSRC.ITEM_ID
, QSSRC.ITEM_REVISION
, QSSRC.ITEM_CATEGORY_ID
, QSSRC.MANUFACTURER_ID
, QSSRC.PROJECT_ID
, QSSRC.TASK_ID
, QSLA.EFFECTIVE_FROM
, QSLA.EFFECTIVE_TO
, QSLA.LOTSIZE_FROM
, QSLA.LOTSIZE_TO
, QSLA.WF_ROLE_NAME
, QSLA.INSP_STAGE
, 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_SKIPLOT_ASSOCIATION QSLA
WHERE QSSRC.CRITERIA_ID = QSLA.CRITERIA_ID