VIEW: APPS.QA_SKIPLOT_PLAN_STATE_V

Source

View Text - Preformatted

SELECT QSPS.PROCESS_PLAN_ID, QSP.PROCESS_ID, QSP.PROCESS_CODE, QSPP.PLAN_ID, QP.NAME PLAN_NAME, QSPS.CRITERIA_ID, QSPS.CURRENT_RULE, QSPPR.FREQUENCY_NUM, QSPPR.FREQUENCY_DENOM, QSPPR.ROUNDS TOTAL_ROUNDS, QSPS.CURRENT_ROUND, QSPS.CURRENT_LOT, QSPS.LOT_ACCEPTED, QSPS.RULE_START_DATE, QSPS.LAST_UPDATE_DATE, QSPS.LAST_UPDATED_BY, QSPS.CREATION_DATE, QSPS.CREATED_BY, QSPS.LAST_UPDATE_LOGIN FROM QA_SKIPLOT_PLAN_STATES QSPS, QA_SKIPLOT_PROCESSES QSP, QA_SKIPLOT_PROCESS_PLANS QSPP, QA_SKIPLOT_PROCESS_PLAN_RULES QSPPR, QA_PLANS QP WHERE QSPS.PROCESS_PLAN_ID = QSPP.PROCESS_PLAN_ID AND QSPP.PROCESS_ID = QSP.PROCESS_ID AND QSPP.PLAN_ID = QP.PLAN_ID AND QSPS.PROCESS_PLAN_ID = QSPPR.PROCESS_PLAN_ID AND QSPS.CURRENT_RULE = QSPPR.RULE_SEQ

View Text - HTML Formatted

SELECT QSPS.PROCESS_PLAN_ID
, QSP.PROCESS_ID
, QSP.PROCESS_CODE
, QSPP.PLAN_ID
, QP.NAME PLAN_NAME
, QSPS.CRITERIA_ID
, QSPS.CURRENT_RULE
, QSPPR.FREQUENCY_NUM
, QSPPR.FREQUENCY_DENOM
, QSPPR.ROUNDS TOTAL_ROUNDS
, QSPS.CURRENT_ROUND
, QSPS.CURRENT_LOT
, QSPS.LOT_ACCEPTED
, QSPS.RULE_START_DATE
, QSPS.LAST_UPDATE_DATE
, QSPS.LAST_UPDATED_BY
, QSPS.CREATION_DATE
, QSPS.CREATED_BY
, QSPS.LAST_UPDATE_LOGIN
FROM QA_SKIPLOT_PLAN_STATES QSPS
, QA_SKIPLOT_PROCESSES QSP
, QA_SKIPLOT_PROCESS_PLANS QSPP
, QA_SKIPLOT_PROCESS_PLAN_RULES QSPPR
, QA_PLANS QP
WHERE QSPS.PROCESS_PLAN_ID = QSPP.PROCESS_PLAN_ID
AND QSPP.PROCESS_ID = QSP.PROCESS_ID
AND QSPP.PLAN_ID = QP.PLAN_ID
AND QSPS.PROCESS_PLAN_ID = QSPPR.PROCESS_PLAN_ID
AND QSPS.CURRENT_RULE = QSPPR.RULE_SEQ