eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_IE_SOE_MESSAGE_V

Product:	PAY - Payroll
Description:	Used to display Messages in IE SOE Form
Implementation/DBA Data:	APPS.PAY_IE_SOE_MESSAGE_V

View Text

SELECT PAL.LINE_SEQUENCE
, PAL.SOURCE_ID
, PAL.LINE_TEXT
FROM PAY_MESSAGE_LINES PAL UNION SELECT PAL.LINE_SEQUENCE
, PAI.LOCKING_ACTION_ID SOURCE_ID
, PAL.LINE_TEXT
FROM PAY_MESSAGE_LINES PAL
, PAY_ACTION_INTERLOCKS PAI
WHERE PAL.SOURCE_ID = PAI.LOCKED_ACTION_ID

Columns

Name
LINE_SEQUENCE
SOURCE_ID
LINE_TEXT