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

VIEW: APPS.IGC_CBC_SUMMARY_BAL_V

Object Details
Object Name: IGC_CBC_SUMMARY_BAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGC_CBC_SUMMARY_BAL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY_CODE VARCHAR2 (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
CODE_COMBINATION_ID NUMBER (15) Yes
FUNCTIONAL_PERIOD_NET_DR NUMBER

FUNCTIONAL_PERIOD_NET_CR NUMBER

PERIOD_NAME VARCHAR2 (15)
PERIOD_YEAR NUMBER (15)
PERIOD_NUM NUMBER (15)
QUARTER_NUM NUMBER (15)
ACTUAL_FLAG VARCHAR2 (1) Yes
SHOW_ACTUAL_FLAG VARCHAR2 (240)
ENCUMBRANCE_TYPE_ID NUMBER (15)
ENCUMBRANCE_TYPE VARCHAR2 (30)
BUDGET_VERSION_ID NUMBER (15)
BUDGET_NAME VARCHAR2 (15)
TEMPLATE_ID NUMBER (15) Yes
TEMPLATE_NAME VARCHAR2 (50)
QTD_BALANCE NUMBER

YTD_BALANCE NUMBER

PTD_BALANCE NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CURRENCY_CODE
,      SET_OF_BOOKS_ID
,      CODE_COMBINATION_ID
,      FUNCTIONAL_PERIOD_NET_DR
,      FUNCTIONAL_PERIOD_NET_CR
,      PERIOD_NAME
,      PERIOD_YEAR
,      PERIOD_NUM
,      QUARTER_NUM
,      ACTUAL_FLAG
,      SHOW_ACTUAL_FLAG
,      ENCUMBRANCE_TYPE_ID
,      ENCUMBRANCE_TYPE
,      BUDGET_VERSION_ID
,      BUDGET_NAME
,      TEMPLATE_ID
,      TEMPLATE_NAME
,      QTD_BALANCE
,      YTD_BALANCE
,      PTD_BALANCE
FROM APPS.IGC_CBC_SUMMARY_BAL_V;

Dependencies

[top of page]

APPS.IGC_CBC_SUMMARY_BAL_V references the following:

SchemaAPPS
SynonymGL_ACCOUNT_HIERARCHIES
SynonymGL_BUDGET_VERSIONS
SynonymGL_ENCUMBRANCE_TYPES
ViewGL_LOOKUPS
ViewGL_SETS_OF_BOOKS
SynonymGL_SUMMARY_TEMPLATES
PL/SQL PackageIGC_CBC_INQUIRY_PKG - show dependent code
ViewIGC_CBC_JE_LINES_BAL_ALL_V
APPS.IGC_CBC_SUMMARY_BAL_V is referenced by following:

SchemaAPPS
ViewIGC_CBC_ALL_BAL_V