View: PAY_PAYWSQEE_MESSAGES

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYWSQEE_MESSAGES

View Text

SELECT ALL_MESSAGES.LINE_SEQUENCE
, ALL_MESSAGES.PAYROLL_ID
, (SELECT MEANING
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'MESSAGE_LEVEL'
AND LOOKUP_CODE= ALL_MESSAGES.MESSAGE_LEVEL) MESSAGE_LEVEL
, ALL_MESSAGES.SOURCE_ID
, ALL_MESSAGES.SOURCE_TYPE
, (SELECT MEANING
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'MESSAGE_SOURCE_TYPE'
AND LOOKUP_CODE= ALL_MESSAGES.SOURCE_TYPE) SOURCE_TYPE_MEANING
, ALL_MESSAGES.LINE_TEXT
, ALL_MESSAGES.BATCH_ID
, ALL_MESSAGES.IDENTIFIER
, (SELECT MEANING
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'CONTROL_TYPE'
AND LOOKUP_CODE= ALL_MESSAGES.CONTROL_TYPE) CONTROL_TYPE_MEANING
, ALL_MESSAGES.ASSIGNMENT_NUMBER
, ALL_MESSAGES.ELEMENT_NAME
FROM ( SELECT MESSAGE.LINE_SEQUENCE
, MESSAGE.PAYROLL_ID
, MESSAGE.MESSAGE_LEVEL
, MESSAGE.SOURCE_ID
, MESSAGE.SOURCE_TYPE
, MESSAGE.LINE_TEXT
, BATCH.BATCH_ID
, BATCH.BATCH_NAME IDENTIFIER
, NULL CONTROL_TYPE
, NULL ASSIGNMENT_NUMBER
, NULL ELEMENT_NAME
FROM PAY_MESSAGE_LINES MESSAGE
, PAY_BATCH_HEADERS BATCH /* MESSAGES FOR BATCH HEADER */
WHERE MESSAGE.SOURCE_TYPE = 'H'
AND MESSAGE.SOURCE_ID = BATCH.BATCH_ID UNION SELECT MESSAGE.LINE_SEQUENCE
, MESSAGE.PAYROLL_ID
, MESSAGE.MESSAGE_LEVEL
, MESSAGE.SOURCE_ID
, MESSAGE.SOURCE_TYPE
, MESSAGE.LINE_TEXT
, LINE.BATCH_ID
, TO_CHAR (LINE.BATCH_SEQUENCE) IDENTIFIER
, NULL CONTROL_TYPE
, LINE.ASSIGNMENT_NUMBER
, ELE.ELEMENT_NAME
FROM PAY_MESSAGE_LINES MESSAGE
, PAY_BATCH_LINES LINE
, PAY_ELEMENT_TYPES_F_TL ELE
, PAY_BATCH_HEADERS BATCH /* MESSAGES FOR BATCH LINES */
WHERE MESSAGE.SOURCE_TYPE = 'L'
AND MESSAGE.SOURCE_ID = LINE.BATCH_LINE_ID
AND LINE.BATCH_ID = BATCH.BATCH_ID
AND ELE.ELEMENT_TYPE_ID (+) = LINE.ELEMENT_TYPE_ID
AND ELE.LANGUAGE (+) = USERENV('LANG') UNION SELECT MESSAGE.LINE_SEQUENCE
, MESSAGE.PAYROLL_ID
, MESSAGE.MESSAGE_LEVEL
, MESSAGE.SOURCE_ID
, MESSAGE.SOURCE_TYPE
, MESSAGE.LINE_TEXT
, CONTROL.BATCH_ID
, CONTROL.CONTROL_TYPE IDENTIFIER
, CONTROL.CONTROL_TYPE
, NULL ASSIGNMENT_NUMEBR
, NULL ELEMENT_NAME
FROM PAY_MESSAGE_LINES MESSAGE
, PAY_BATCH_CONTROL_TOTALS CONTROL
, PAY_BATCH_HEADERS BATCH /* MESSAGES FOR BATCH CONTROL TOTALS */
WHERE MESSAGE.SOURCE_TYPE = 'C'
AND MESSAGE.SOURCE_ID = CONTROL.BATCH_CONTROL_ID
AND CONTROL.BATCH_ID = BATCH.BATCH_ID ) ALL_MESSAGES

Columns