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

VIEW: APPS.IGC_CBC_BALANCES_V

Object Details
Object Name: IGC_CBC_BALANCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGC.IGC_CBC_BALANCES_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
CODE_COMBINATION_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER

BUDGET_AMOUNT NUMBER

COMM_AMOUNT NUMBER

ACT_AMOUNT NUMBER

OTH_AMOUNT NUMBER

TOT_AMOUNT NUMBER

FA_AMOUNT NUMBER

AMOUNT_TYPE VARCHAR2 (4)
PERIOD_NAME VARCHAR2 (20)
TEMPLATE_ID NUMBER

CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
ACCOUNT_TYPE VARCHAR2 (1) Yes
SEGMENT1 VARCHAR2 (25)
Key flexfield segment
SEGMENT2 VARCHAR2 (25)
Key flexfield segment
SEGMENT3 VARCHAR2 (25)
Key flexfield segment
SEGMENT4 VARCHAR2 (25)
Key flexfield segment
SEGMENT5 VARCHAR2 (25)
Key flexfield segment
SEGMENT6 VARCHAR2 (25)
Key flexfield segment
SEGMENT7 VARCHAR2 (25)
Key flexfield segment
SEGMENT8 VARCHAR2 (25)
Key flexfield segment
SEGMENT9 VARCHAR2 (25)
Key flexfield segment
SEGMENT10 VARCHAR2 (25)
Key flexfield segment
SEGMENT11 VARCHAR2 (25)
Key flexfield segment
SEGMENT12 VARCHAR2 (25)
Key flexfield segment
SEGMENT13 VARCHAR2 (25)
Key flexfield segment
SEGMENT14 VARCHAR2 (25)
Key flexfield segment
SEGMENT15 VARCHAR2 (25)
Key flexfield segment
SEGMENT16 VARCHAR2 (25)
Key flexfield segment
SEGMENT17 VARCHAR2 (25)
Key flexfield segment
SEGMENT18 VARCHAR2 (25)
Key flexfield segment
SEGMENT19 VARCHAR2 (25)
Key flexfield segment
SEGMENT20 VARCHAR2 (25)
Key flexfield segment
SEGMENT21 VARCHAR2 (25)
SEGMENT22 VARCHAR2 (25)
SEGMENT23 VARCHAR2 (25)
SEGMENT24 VARCHAR2 (25)
SEGMENT25 VARCHAR2 (25)
SEGMENT26 VARCHAR2 (25)
SEGMENT27 VARCHAR2 (25)
SEGMENT28 VARCHAR2 (25)
SEGMENT29 VARCHAR2 (25)
SEGMENT30 VARCHAR2 (25)
DESCRIPTION VARCHAR2 (240)
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
CONTEXT VARCHAR2 (150)
SEGMENT_ATTRIBUTE1 VARCHAR2 (60)
SEGMENT_ATTRIBUTE2 VARCHAR2 (60)
SEGMENT_ATTRIBUTE3 VARCHAR2 (60)
SEGMENT_ATTRIBUTE4 VARCHAR2 (60)
SEGMENT_ATTRIBUTE5 VARCHAR2 (60)
SEGMENT_ATTRIBUTE6 VARCHAR2 (60)
SEGMENT_ATTRIBUTE7 VARCHAR2 (60)
SEGMENT_ATTRIBUTE8 VARCHAR2 (60)
SEGMENT_ATTRIBUTE9 VARCHAR2 (60)
SEGMENT_ATTRIBUTE10 VARCHAR2 (60)
SEGMENT_ATTRIBUTE11 VARCHAR2 (60)
SEGMENT_ATTRIBUTE12 VARCHAR2 (60)
SEGMENT_ATTRIBUTE13 VARCHAR2 (60)
SEGMENT_ATTRIBUTE14 VARCHAR2 (60)
SEGMENT_ATTRIBUTE15 VARCHAR2 (60)
SEGMENT_ATTRIBUTE16 VARCHAR2 (60)
SEGMENT_ATTRIBUTE17 VARCHAR2 (60)
SEGMENT_ATTRIBUTE18 VARCHAR2 (60)
SEGMENT_ATTRIBUTE19 VARCHAR2 (60)
SEGMENT_ATTRIBUTE20 VARCHAR2 (60)
SEGMENT_ATTRIBUTE21 VARCHAR2 (60)
SEGMENT_ATTRIBUTE22 VARCHAR2 (60)
SEGMENT_ATTRIBUTE23 VARCHAR2 (60)
SEGMENT_ATTRIBUTE24 VARCHAR2 (60)
SEGMENT_ATTRIBUTE25 VARCHAR2 (60)
SEGMENT_ATTRIBUTE26 VARCHAR2 (60)
SEGMENT_ATTRIBUTE27 VARCHAR2 (60)
SEGMENT_ATTRIBUTE28 VARCHAR2 (60)
SEGMENT_ATTRIBUTE29 VARCHAR2 (60)
SEGMENT_ATTRIBUTE30 VARCHAR2 (60)
SEGMENT_ATTRIBUTE31 VARCHAR2 (60)
SEGMENT_ATTRIBUTE32 VARCHAR2 (60)
SEGMENT_ATTRIBUTE33 VARCHAR2 (60)
SEGMENT_ATTRIBUTE34 VARCHAR2 (60)
SEGMENT_ATTRIBUTE35 VARCHAR2 (60)
SEGMENT_ATTRIBUTE36 VARCHAR2 (60)
SEGMENT_ATTRIBUTE37 VARCHAR2 (60)
SEGMENT_ATTRIBUTE38 VARCHAR2 (60)
SEGMENT_ATTRIBUTE39 VARCHAR2 (60)
SEGMENT_ATTRIBUTE40 VARCHAR2 (60)
SEGMENT_ATTRIBUTE41 VARCHAR2 (60)
SEGMENT_ATTRIBUTE42 VARCHAR2 (60)
REFERENCE1 VARCHAR2 (1)
REFERENCE2 VARCHAR2 (1)
REFERENCE3 VARCHAR2 (25)
REFERENCE4 VARCHAR2 (1)
REFERENCE5 VARCHAR2 (1)
SET_OF_BOOKS_ID NUMBER (15)
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT CODE_COMBINATION_ID
,      BUDGET_VERSION_ID
,      BUDGET_AMOUNT
,      COMM_AMOUNT
,      ACT_AMOUNT
,      OTH_AMOUNT
,      TOT_AMOUNT
,      FA_AMOUNT
,      AMOUNT_TYPE
,      PERIOD_NAME
,      TEMPLATE_ID
,      CHART_OF_ACCOUNTS_ID
,      ACCOUNT_TYPE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      DESCRIPTION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      CONTEXT
,      SEGMENT_ATTRIBUTE1
,      SEGMENT_ATTRIBUTE2
,      SEGMENT_ATTRIBUTE3
,      SEGMENT_ATTRIBUTE4
,      SEGMENT_ATTRIBUTE5
,      SEGMENT_ATTRIBUTE6
,      SEGMENT_ATTRIBUTE7
,      SEGMENT_ATTRIBUTE8
,      SEGMENT_ATTRIBUTE9
,      SEGMENT_ATTRIBUTE10
,      SEGMENT_ATTRIBUTE11
,      SEGMENT_ATTRIBUTE12
,      SEGMENT_ATTRIBUTE13
,      SEGMENT_ATTRIBUTE14
,      SEGMENT_ATTRIBUTE15
,      SEGMENT_ATTRIBUTE16
,      SEGMENT_ATTRIBUTE17
,      SEGMENT_ATTRIBUTE18
,      SEGMENT_ATTRIBUTE19
,      SEGMENT_ATTRIBUTE20
,      SEGMENT_ATTRIBUTE21
,      SEGMENT_ATTRIBUTE22
,      SEGMENT_ATTRIBUTE23
,      SEGMENT_ATTRIBUTE24
,      SEGMENT_ATTRIBUTE25
,      SEGMENT_ATTRIBUTE26
,      SEGMENT_ATTRIBUTE27
,      SEGMENT_ATTRIBUTE28
,      SEGMENT_ATTRIBUTE29
,      SEGMENT_ATTRIBUTE30
,      SEGMENT_ATTRIBUTE31
,      SEGMENT_ATTRIBUTE32
,      SEGMENT_ATTRIBUTE33
,      SEGMENT_ATTRIBUTE34
,      SEGMENT_ATTRIBUTE35
,      SEGMENT_ATTRIBUTE36
,      SEGMENT_ATTRIBUTE37
,      SEGMENT_ATTRIBUTE38
,      SEGMENT_ATTRIBUTE39
,      SEGMENT_ATTRIBUTE40
,      SEGMENT_ATTRIBUTE41
,      SEGMENT_ATTRIBUTE42
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      SET_OF_BOOKS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGC_CBC_BALANCES_V;

Dependencies

[top of page]

APPS.IGC_CBC_BALANCES_V references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
ViewIGC_CBC_BAL_V
PL/SQL PackageIGC_CBC_INQUIRY_PKG - show dependent code

APPS.IGC_CBC_BALANCES_V is not referenced by any database object