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