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
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
|
|
|