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


VIEW: APPS.GL_BUDGET_ASSIGNMENT_RANGES_V

Object Details
Object Name: GL_BUDGET_ASSIGNMENT_RANGES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GL_BUDGET_ASSIGNMENT_RANGES_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)
LEDGER_ID NUMBER (15) Yes
BUDGET_ENTITY_ID NUMBER (15) Yes
RANGE_ID NUMBER (15) Yes
SEQUENCE_NUMBER NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
ENTRY_CODE VARCHAR2 (1) Yes
STATUS VARCHAR2 (1) Yes
SHOW_STATUS VARCHAR2 (80)
SEGMENT1_LOW VARCHAR2 (25)
SEGMENT2_LOW VARCHAR2 (25)
SEGMENT3_LOW VARCHAR2 (25)
SEGMENT4_LOW VARCHAR2 (25)
SEGMENT5_LOW VARCHAR2 (25)
SEGMENT6_LOW VARCHAR2 (25)
SEGMENT7_LOW VARCHAR2 (25)
SEGMENT8_LOW VARCHAR2 (25)
SEGMENT9_LOW VARCHAR2 (25)
SEGMENT10_LOW VARCHAR2 (25)
SEGMENT11_LOW VARCHAR2 (25)
SEGMENT12_LOW VARCHAR2 (25)
SEGMENT13_LOW VARCHAR2 (25)
SEGMENT14_LOW VARCHAR2 (25)
SEGMENT15_LOW VARCHAR2 (25)
SEGMENT16_LOW VARCHAR2 (25)
SEGMENT17_LOW VARCHAR2 (25)
SEGMENT18_LOW VARCHAR2 (25)
SEGMENT19_LOW VARCHAR2 (25)
SEGMENT20_LOW VARCHAR2 (25)
SEGMENT21_LOW VARCHAR2 (25)
SEGMENT22_LOW VARCHAR2 (25)
SEGMENT23_LOW VARCHAR2 (25)
SEGMENT24_LOW VARCHAR2 (25)
SEGMENT25_LOW VARCHAR2 (25)
SEGMENT26_LOW VARCHAR2 (25)
SEGMENT27_LOW VARCHAR2 (25)
SEGMENT28_LOW VARCHAR2 (25)
SEGMENT29_LOW VARCHAR2 (25)
SEGMENT30_LOW VARCHAR2 (25)
SEGMENT1_HIGH VARCHAR2 (25)
SEGMENT2_HIGH VARCHAR2 (25)
SEGMENT3_HIGH VARCHAR2 (25)
SEGMENT4_HIGH VARCHAR2 (25)
SEGMENT5_HIGH VARCHAR2 (25)
SEGMENT6_HIGH VARCHAR2 (25)
SEGMENT7_HIGH VARCHAR2 (25)
SEGMENT8_HIGH VARCHAR2 (25)
SEGMENT9_HIGH VARCHAR2 (25)
SEGMENT10_HIGH VARCHAR2 (25)
SEGMENT11_HIGH VARCHAR2 (25)
SEGMENT12_HIGH VARCHAR2 (25)
SEGMENT13_HIGH VARCHAR2 (25)
SEGMENT14_HIGH VARCHAR2 (25)
SEGMENT15_HIGH VARCHAR2 (25)
SEGMENT16_HIGH VARCHAR2 (25)
SEGMENT17_HIGH VARCHAR2 (25)
SEGMENT18_HIGH VARCHAR2 (25)
SEGMENT19_HIGH VARCHAR2 (25)
SEGMENT20_HIGH VARCHAR2 (25)
SEGMENT21_HIGH VARCHAR2 (25)
SEGMENT22_HIGH VARCHAR2 (25)
SEGMENT23_HIGH VARCHAR2 (25)
SEGMENT24_HIGH VARCHAR2 (25)
SEGMENT25_HIGH VARCHAR2 (25)
SEGMENT26_HIGH VARCHAR2 (25)
SEGMENT27_HIGH VARCHAR2 (25)
SEGMENT28_HIGH VARCHAR2 (25)
SEGMENT29_HIGH VARCHAR2 (25)
SEGMENT30_HIGH VARCHAR2 (25)
CONTEXT VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      LEDGER_ID
,      BUDGET_ENTITY_ID
,      RANGE_ID
,      SEQUENCE_NUMBER
,      CURRENCY_CODE
,      ENTRY_CODE
,      STATUS
,      SHOW_STATUS
,      SEGMENT1_LOW
,      SEGMENT2_LOW
,      SEGMENT3_LOW
,      SEGMENT4_LOW
,      SEGMENT5_LOW
,      SEGMENT6_LOW
,      SEGMENT7_LOW
,      SEGMENT8_LOW
,      SEGMENT9_LOW
,      SEGMENT10_LOW
,      SEGMENT11_LOW
,      SEGMENT12_LOW
,      SEGMENT13_LOW
,      SEGMENT14_LOW
,      SEGMENT15_LOW
,      SEGMENT16_LOW
,      SEGMENT17_LOW
,      SEGMENT18_LOW
,      SEGMENT19_LOW
,      SEGMENT20_LOW
,      SEGMENT21_LOW
,      SEGMENT22_LOW
,      SEGMENT23_LOW
,      SEGMENT24_LOW
,      SEGMENT25_LOW
,      SEGMENT26_LOW
,      SEGMENT27_LOW
,      SEGMENT28_LOW
,      SEGMENT29_LOW
,      SEGMENT30_LOW
,      SEGMENT1_HIGH
,      SEGMENT2_HIGH
,      SEGMENT3_HIGH
,      SEGMENT4_HIGH
,      SEGMENT5_HIGH
,      SEGMENT6_HIGH
,      SEGMENT7_HIGH
,      SEGMENT8_HIGH
,      SEGMENT9_HIGH
,      SEGMENT10_HIGH
,      SEGMENT11_HIGH
,      SEGMENT12_HIGH
,      SEGMENT13_HIGH
,      SEGMENT14_HIGH
,      SEGMENT15_HIGH
,      SEGMENT16_HIGH
,      SEGMENT17_HIGH
,      SEGMENT18_HIGH
,      SEGMENT19_HIGH
,      SEGMENT20_HIGH
,      SEGMENT21_HIGH
,      SEGMENT22_HIGH
,      SEGMENT23_HIGH
,      SEGMENT24_HIGH
,      SEGMENT25_HIGH
,      SEGMENT26_HIGH
,      SEGMENT27_HIGH
,      SEGMENT28_HIGH
,      SEGMENT29_HIGH
,      SEGMENT30_HIGH
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM APPS.GL_BUDGET_ASSIGNMENT_RANGES_V;

Dependencies

[top of page]

APPS.GL_BUDGET_ASSIGNMENT_RANGES_V references the following:

SchemaAPPS
SynonymGL_BUDGET_ASSIGNMENT_RANGES
ViewGL_LOOKUPS
APPS.GL_BUDGET_ASSIGNMENT_RANGES_V is referenced by following:

SchemaAPPS
Package BodyIGC_UPGRADE_DATA_R12 - show dependent code
ViewIGI_DOS_BUD_ASS_CAND_V