VIEW: APPS.QA_ERES_PLAN_CHAR_ACTIONS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')