[Home] [Help] [Dependency Information]
Object Name: | PA_SUMM_BALANCES# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | (15) | Yes | |
VERSION_ID | NUMBER | Yes | ||
OBJECT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
PERIOD_TYPE | VARCHAR2 | (2) | Yes | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | |
PERIOD_NAME | VARCHAR2 | (15) | Yes | |
GLOBAL_EXP_PERIOD_END_DATE | DATE | Yes | ||
PERIOD_YEAR | NUMBER | Yes | ||
QUARTER_OR_MONTH_NUMBER | NUMBER | Yes | ||
AMOUNT_TYPE_ID | NUMBER | Yes | ||
PERIOD_NUM | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
PERIOD_BALANCE | NUMBER | |||
GLOBAL_CURRENCY_CODE | VARCHAR2 | (15) | ||
GLOBAL_PERIOD_BALANCE | NUMBER | |||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | ||
DENOM_PERIOD_BALANCE | NUMBER | |||
PVDR_CURRENCY_CODE | VARCHAR2 | (15) | ||
PVDR_PERIOD_BALANCE | NUMBER | |||
RCVR_CURRENCY_CODE | VARCHAR2 | (15) | ||
RCVR_PERIOD_BALANCE | NUMBER | |||
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJ_PERIOD_BALANCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, VERSION_ID
, OBJECT_TYPE_CODE
, PERIOD_TYPE
, PERIOD_SET_NAME
, PERIOD_NAME
, GLOBAL_EXP_PERIOD_END_DATE
, PERIOD_YEAR
, QUARTER_OR_MONTH_NUMBER
, AMOUNT_TYPE_ID
, PERIOD_NUM
, UNIT_OF_MEASURE
, PERIOD_BALANCE
, GLOBAL_CURRENCY_CODE
, GLOBAL_PERIOD_BALANCE
, DENOM_CURRENCY_CODE
, DENOM_PERIOD_BALANCE
, PVDR_CURRENCY_CODE
, PVDR_PERIOD_BALANCE
, RCVR_CURRENCY_CODE
, RCVR_PERIOD_BALANCE
, PROJ_CURRENCY_CODE
, PROJ_PERIOD_BALANCE
FROM PA.PA_SUMM_BALANCES#;
|
|
|