VIEW: APPS.QA_PLAN_CHAR_ACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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