View: QA_PLAN_CHAR_ACTIONS_V

Product:	QA - Quality
Description:	Shows collection plan , elements and actions
Implementation/DBA Data:	APPS.QA_PLAN_CHAR_ACTIONS_V

View Text

SELECT QPCA.ROWID ROW_ID
, QPCA.PLAN_CHAR_ACTION_ID
, QPCA.LAST_UPDATE_DATE
, QPCA.LAST_UPDATED_BY
, QPCA.CREATION_DATE
, QPCA.CREATED_BY
, QPCA.LAST_UPDATE_LOGIN
, QPCA.PLAN_CHAR_ACTION_TRIGGER_ID
, QPCAT.TRIGGER_SEQUENCE
, QPCA.ACTION_ID
, QA.DESCRIPTION ACTION_DESCRIPTION
, QPCA.CAR_NAME_PREFIX
, QPCA.CAR_TYPE_ID
, NULL CAR_TYPE_NAME
, QPCA.CAR_OWNER
, NULL CAR_OWNER_NAME
, QPCA.MESSAGE
, QPCA.STATUS_CODE
, QPCA.STATUS_ID
, QPCA.ALR_ACTION_SET_ID
, QPCA.ALR_ACTION_ID
, QPCA.ASSIGNED_CHAR_ID
, QC1.NAME ASSIGNED_CHAR_NAME
, QPCA.ASSIGN_TYPE
, QPCAT.PLAN_ID
, QP.NAME PLAN_NAME
, QPCAT.CHAR_ID
, QC.NAME CHAR_NAME
FROM QA_PLAN_CHAR_ACTION_TRIGGERS QPCAT
, QA_PLANS QP
, QA_ACTIONS QA
, QA_CHARS QC
, QA_CHARS QC1
, QA_PLAN_CHAR_ACTIONS QPCA
WHERE QPCA.PLAN_CHAR_ACTION_TRIGGER_ID = QPCAT.PLAN_CHAR_ACTION_TRIGGER_ID
AND QPCAT.PLAN_ID = QP.PLAN_ID
AND QPCAT.CHAR_ID = QC.CHAR_ID
AND QPCA.ASSIGNED_CHAR_ID = QC1.CHAR_ID (+)
AND QPCA.ACTION_ID = QA.ACTION_ID

Columns