VIEW: APPS.PAY_PAYWSQEE_MESSAGES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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