FND Design Data [Home] [Help]

View: PAY_GB_SOE_MESSAGE_V

Product: PAY - Payroll
Description: Report pay action message lines
Implementation/DBA Data: ViewAPPS.PAY_GB_SOE_MESSAGE_V
View Text

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

Columns

Name
LINE_SEQUENCE
SOURCE_ID
LINE_TEXT