Product: | QA - Quality |
---|---|
Description: | plan element actions view for electronic records |
Implementation/DBA Data: | APPS.QA_ERES_PLAN_CHAR_ACTIONS_V |
SELECT QPCA.PLAN_CHAR_ACTION_ID
, QPCA.PLAN_CHAR_ACTION_TRIGGER_ID
, 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
, QA_ERES_PKG.COLLAPSE_MSG_TOKENS(QPCA.MESSAGE)
, QPCA.STATUS_CODE
, QPCA.STATUS_ID
, QPCA.ASSIGNED_CHAR_ID
, QC.NAME ASSIGNED_CHAR_NAME
, QPCA.ASSIGN_TYPE
, DECODE(QPCA.ACTION_ID
, 28
, WF.DISPLAY_NAME
, NULL)
, QPCA.ALR_ACTION_SET_ID
, QPCA.ALR_ACTION_ID
, QA_ERES_PKG.COLLAPSE_MSG_TOKENS(ALRA.BODY)
, FA.APPLICATION_NAME
, ALRA.FILE_NAME
, ALRA.ARGUMENT_STRING
, DL.NAME LIST
, ALRA.TO_RECIPIENTS
, ALRA.CC_RECIPIENTS
, ALRA.BCC_RECIPIENTS
, ALRA.SUBJECT
, ALRA.REPLY_TO
FROM QA_ACTIONS QA
, QA_CHARS QC
, QA_PLAN_CHAR_ACTIONS QPCA
, ALR_ACTIONS ALRA
, FND_APPLICATION_TL FA
, WF_ITEM_TYPES_TL WF
, ALR_DISTRIBUTION_LISTS DL
WHERE QPCA.ASSIGNED_CHAR_ID = QC.CHAR_ID (+)
AND QPCA.ACTION_ID = QA.ACTION_ID
AND QPCA.ALR_ACTION_ID = ALRA.ACTION_ID(+)
AND ALRA.APPLICATION_ID(+) = 250
AND (ALRA.END_DATE_ACTIVE IS NULL OR ALRA.END_DATE_ACTIVE >= SYSDATE)
AND ALRA.PROGRAM_APPLICATION_ID = FA.APPLICATION_ID(+)
AND FA.LANGUAGE(+) = USERENV('LANG')
AND ALRA.LIST_ID = DL.LIST_ID(+)
AND DL.ENABLED_FLAG(+) = 'Y'
AND DL.APPLICATION_ID(+) = 250
AND QPCA.MESSAGE = WF.NAME(+)
AND WF.LANGUAGE(+) = USERENV('LANG')