eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: QA_SKIPLOT_PLAN_STATE_V

Product:	QA - Quality
Description:	Skip Lot plan state
Implementation/DBA Data:	APPS.QA_SKIPLOT_PLAN_STATE_V

View Text

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

Columns

Name
PROCESS_PLAN_ID
PROCESS_ID
PROCESS_CODE
PLAN_ID
PLAN_NAME
CRITERIA_ID
CURRENT_RULE
FREQUENCY_NUM
FREQUENCY_DENOM
TOTAL_ROUNDS
CURRENT_ROUND
CURRENT_LOT
LOT_ACCEPTED
RULE_START_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN