[Home] [Help]
View: JAI_AR_RG_BAL_V
View Text
SELECT DISTINCT REGISTER
, RG23A_BALANCE
, ORGANIZATION_ID
, LOCATION_ID
FROM ( SELECT 'RG 23A PART - II' REGISTER
, RG23A_BALANCE
, ORGANIZATION_ID
, LOCATION_ID
FROM JAI_CMN_RG_BALANCES UNION ALL SELECT 'PLA' REGISTER
, PLA_BALANCE
, ORGANIZATION_ID
, LOCATION_ID
FROM JAI_CMN_RG_BALANCES )
Columns
Name |
REGISTER |
RG23A_BALANCE |
ORGANIZATION_ID |
LOCATION_ID |