View: PAYBV_MESSAGE_LINE

Product:	PAY - Payroll
Description:	Discoverer base view for pay_message_lines.
Implementation/DBA Data:	APPS.PAYBV_MESSAGE_LINE

View Text

SELECT PML.LINE_SEQUENCE
, HR_BIS.BIS_DECODE_LOOKUP('MESSAGE_LEVEL'
, PML.MESSAGE_LEVEL) MESSAGE_LEVEL
, PML.LINE_TEXT
, HR_BIS.BIS_DECODE_LOOKUP('MESSAGE_SOURCE_TYPE'
, PML.SOURCE_TYPE) SOURCE_TYPE
, PML.MESSAGE_LEVEL
, PML.SOURCE_TYPE
, PML.SOURCE_ID
, PML.PAYROLL_ID
FROM PAY_MESSAGE_LINES PML WITH READ ONLY

Columns