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

VIEW: APPS.IGI_BUD_CODE_COMBINATIONS_V

Object Details
Object Name: IGI_BUD_CODE_COMBINATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGI.IGI_BUD_CODE_COMBINATIONS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
CODE_COMBINATION_ID NUMBER (15) Yes Code combination identifier
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes As GL_CODE_COMBINATIONS table
DETAIL_POSTING_ALLOWED_FLAG VARCHAR2 (1) Yes As GL_CODE_COMBINATIONS table
DETAIL_BUDGETING_ALLOWED_FLAG VARCHAR2 (1) Yes As GL_CODE_COMBINATIONS table
ACCOUNT_TYPE VARCHAR2 (1) Yes As GL_CODE_COMBINATIONS table
SHOW_ACCOUNT_TYPE VARCHAR2 (240)
As GL_CODE_COMBINATIONS table
ENABLED_FLAG VARCHAR2 (1) Yes As GL_CODE_COMBINATIONS table
SUMMARY_FLAG VARCHAR2 (1) Yes As GL_CODE_COMBINATIONS table
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)
As GL_CODE_COMBINATIONS table
SEGMENT22 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT23 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT24 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT25 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT26 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT27 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT28 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT29 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
SEGMENT30 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
DESCRIPTION VARCHAR2 (240)
As GL_CODE_COMBINATIONS table
TEMPLATE_ID NUMBER (15)
As GL_CODE_COMBINATIONS table
START_DATE_ACTIVE DATE

As GL_CODE_COMBINATIONS table
END_DATE_ACTIVE DATE

As GL_CODE_COMBINATIONS table
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)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE1 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE2 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE3 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE4 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE5 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE6 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE7 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE8 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE9 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE10 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE11 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE12 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE13 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE14 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE15 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE16 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE17 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE18 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE19 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE20 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE21 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE22 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE23 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE24 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE25 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE26 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE27 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE28 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE29 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE30 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE31 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE32 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE33 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE34 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE35 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE36 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE37 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE38 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE39 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE40 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE41 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
SEGMENT_ATTRIBUTE42 VARCHAR2 (60)
As GL_CODE_COMBINATIONS table
JGZZ_RECON_CONTEXT VARCHAR2 (30)
As GL_CODE_COMBINATIONS table
JGZZ_RECON_FLAG VARCHAR2 (1)
As GL_CODE_COMBINATIONS table
REFERENCE1 VARCHAR2 (1)
As GL_CODE_COMBINATIONS table
REFERENCE2 VARCHAR2 (1)
As GL_CODE_COMBINATIONS table
REFERENCE3 VARCHAR2 (25)
As GL_CODE_COMBINATIONS table
REFERENCE4 VARCHAR2 (1)
As GL_CODE_COMBINATIONS table
REFERENCE5 VARCHAR2 (1)
As GL_CODE_COMBINATIONS table
IGI_BALANCED_BUDGET_FLAG VARCHAR2 (1)
Balanced Budget flag for IGI
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes 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 ROW_ID
,      CODE_COMBINATION_ID
,      CHART_OF_ACCOUNTS_ID
,      DETAIL_POSTING_ALLOWED_FLAG
,      DETAIL_BUDGETING_ALLOWED_FLAG
,      ACCOUNT_TYPE
,      SHOW_ACCOUNT_TYPE
,      ENABLED_FLAG
,      SUMMARY_FLAG
,      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
,      TEMPLATE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      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
,      JGZZ_RECON_CONTEXT
,      JGZZ_RECON_FLAG
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      IGI_BALANCED_BUDGET_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.IGI_BUD_CODE_COMBINATIONS_V;

Dependencies

[top of page]

APPS.IGI_BUD_CODE_COMBINATIONS_V references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
ViewGL_LOOKUPS

APPS.IGI_BUD_CODE_COMBINATIONS_V is not referenced by any database object