Product: | QA - Quality |
---|---|
Description: | Valid Skip Lot Criteria for Receiving |
Implementation/DBA Data: | APPS.QA_SKIPLOT_PROCESSES_V |
SELECT DISTINCT QSP.PROCESS_ID
, QSP.ROWID ROW_ID
, QSP.PROCESS_CODE
, QSP.DESCRIPTION PROCESS_DESC
, QSPPR.ROUNDS QUALIFICATION_LOTS
, QSPPR.DAYS_SPAN QUALIFICATION_DAYS
, QSP.DISQUALIFICATION_LOTS
, QSP.DISQUALIFICATION_DAYS
, QSP.ORGANIZATION_ID
, QSP.LAST_UPDATE_DATE
, QSP.LAST_UPDATED_BY
, QSP.CREATION_DATE
, QSP.CREATED_BY
, QSP.LAST_UPDATE_LOGIN
FROM QA_SKIPLOT_PROCESSES QSP
, QA_SKIPLOT_PROCESS_PLANS QSPP
, QA_SKIPLOT_PROCESS_PLAN_RULES QSPPR
WHERE QSP.PROCESS_ID = QSPP.PROCESS_ID
AND QSPP.PROCESS_PLAN_ID = QSPPR.PROCESS_PLAN_ID
AND QSPPR.RULE_SEQ = 0