[Home] [Help]
View: PAY_ASG_LATEST_BALANCES_V1
View Text
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
Columns
Name |
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 |
TABLE_SOURCE |