SELECT ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, DEFINED_BALANCE_ID, VALUE, LATEST_BALANCE_ID, EXPIRED_ASSIGNMENT_ACTION_ID, EXPIRED_VALUE, PREV_BALANCE_VALUE, PREV_ASSIGNMENT_ACTION_ID, 'A' TABLE_SOURCE FROM PAY_ASSIGNMENT_LATEST_BALANCES UNION ALL SELECT ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, DEFINED_BALANCE_ID, VALUE, LATEST_BALANCE_ID, EXPIRED_ASSIGNMENT_ACTION_ID, EXPIRED_VALUE, PREV_BALANCE_VALUE, PREV_ASSIGNMENT_ACTION_ID, 'L' TABLE_SOURCE FROM PAY_LATEST_BALANCES WHERE ASSIGNMENT_ID is not null
SELECT ASSIGNMENT_ID
, ASSIGNMENT_ACTION_ID
, DEFINED_BALANCE_ID
, VALUE
, LATEST_BALANCE_ID
, EXPIRED_ASSIGNMENT_ACTION_ID
, EXPIRED_VALUE
, PREV_BALANCE_VALUE
, PREV_ASSIGNMENT_ACTION_ID
, 'A' TABLE_SOURCE
FROM PAY_ASSIGNMENT_LATEST_BALANCES UNION ALL SELECT ASSIGNMENT_ID
, ASSIGNMENT_ACTION_ID
, DEFINED_BALANCE_ID
, VALUE
, LATEST_BALANCE_ID
, EXPIRED_ASSIGNMENT_ACTION_ID
, EXPIRED_VALUE
, PREV_BALANCE_VALUE
, PREV_ASSIGNMENT_ACTION_ID
, 'L' TABLE_SOURCE
FROM PAY_LATEST_BALANCES
WHERE ASSIGNMENT_ID IS NOT NULL
|
|
|