DBA Data[Home] [Help]

VIEW: APPS.QA_SKIPLOT_PROCESSES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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