DBA Data[Home] [Help]

VIEW: APPS.PAY_GB_SOE_MESSAGE_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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