VIEW: PA.PA_SUMM_BALANCES#

Source

View Text - Preformatted

select OBJECT_ID OBJECT_ID, VERSION_ID VERSION_ID, OBJECT_TYPE_CODE OBJECT_TYPE_CODE, PERIOD_TYPE PERIOD_TYPE, PERIOD_SET_NAME PERIOD_SET_NAME, PERIOD_NAME PERIOD_NAME, GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE, PERIOD_YEAR PERIOD_YEAR, QUARTER_OR_MONTH_NUMBER QUARTER_OR_MONTH_NUMBER, AMOUNT_TYPE_ID AMOUNT_TYPE_ID, PERIOD_NUM PERIOD_NUM, UNIT_OF_MEASURE UNIT_OF_MEASURE, PERIOD_BALANCE PERIOD_BALANCE, GLOBAL_CURRENCY_CODE GLOBAL_CURRENCY_CODE, GLOBAL_PERIOD_BALANCE GLOBAL_PERIOD_BALANCE, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE, DENOM_PERIOD_BALANCE DENOM_PERIOD_BALANCE, PVDR_CURRENCY_CODE PVDR_CURRENCY_CODE, PVDR_PERIOD_BALANCE PVDR_PERIOD_BALANCE, RCVR_CURRENCY_CODE RCVR_CURRENCY_CODE, RCVR_PERIOD_BALANCE RCVR_PERIOD_BALANCE, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE, PROJ_PERIOD_BALANCE PROJ_PERIOD_BALANCE from "PA"."PA_SUMM_BALANCES"

View Text - HTML Formatted

SELECT OBJECT_ID OBJECT_ID
, VERSION_ID VERSION_ID
, OBJECT_TYPE_CODE OBJECT_TYPE_CODE
, PERIOD_TYPE PERIOD_TYPE
, PERIOD_SET_NAME PERIOD_SET_NAME
, PERIOD_NAME PERIOD_NAME
, GLOBAL_EXP_PERIOD_END_DATE GLOBAL_EXP_PERIOD_END_DATE
, PERIOD_YEAR PERIOD_YEAR
, QUARTER_OR_MONTH_NUMBER QUARTER_OR_MONTH_NUMBER
, AMOUNT_TYPE_ID AMOUNT_TYPE_ID
, PERIOD_NUM PERIOD_NUM
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, PERIOD_BALANCE PERIOD_BALANCE
, GLOBAL_CURRENCY_CODE GLOBAL_CURRENCY_CODE
, GLOBAL_PERIOD_BALANCE GLOBAL_PERIOD_BALANCE
, DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, DENOM_PERIOD_BALANCE DENOM_PERIOD_BALANCE
, PVDR_CURRENCY_CODE PVDR_CURRENCY_CODE
, PVDR_PERIOD_BALANCE PVDR_PERIOD_BALANCE
, RCVR_CURRENCY_CODE RCVR_CURRENCY_CODE
, RCVR_PERIOD_BALANCE RCVR_PERIOD_BALANCE
, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE
, PROJ_PERIOD_BALANCE PROJ_PERIOD_BALANCE
FROM "PA"."PA_SUMM_BALANCES"