DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_SUMM_BALANCES#

Object Details
Object Name: PA_SUMM_BALANCES#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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#;

Dependencies

[top of page]

PA.PA_SUMM_BALANCES# references the following:

SchemaPA
TablePA_SUMM_BALANCES
PA.PA_SUMM_BALANCES# is referenced by following:

SchemaAPPS
SynonymPA_SUMM_BALANCES