View: PA_PTE_DL_LKUP_V

View Text

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, SUBSTR(DESCRIPTION
, 1
, 240) DESCRIPTION
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE IN ( 'EXPENDITURE STATUS'
, 'UNIT'
, 'TRANSACTION REJECTION REASON'
, 'MESSAGE'
, 'TRANSLATION'
, 'PROMPT' ) UNION SELECT 'TRANSACTION REJECTION REASON'
, MESSAGE_NAME
, SUBSTR(MESSAGE_TEXT
, 1
, 80)
, MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE APPLICATION_ID = 275
AND MESSAGE_NAME IN ( 'PA_EX_QTY_EXIST'
, 'PA_EXP_INV_PJTK'
, 'PA_EX_PROJECT_DATE'
, 'PA_EX_PROJECT_CLOSED'
, 'PA_EXP_TASK_EFF'
, 'PA_EXP_TASK_STATUS'
, 'PA_EXP_PJ_TC'
, 'PA_EXP_TASK_TC' ) OR MESSAGE_NAME LIKE ('PATCX%') UNION SELECT 'MESSAGE'
, MESSAGE_NAME
, SUBSTR(MESSAGE_TEXT
, 1
, 80)
, MESSAGE_TEXT
FROM FND_NEW_MESSAGES
WHERE APPLICATION_ID = 275
AND MESSAGE_NAME = 'PA_ALL_WORKING'

Columns