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

VIEW: APPS.GLFV_GL_BUDGET_ASSIGNMENTS

Object Details
Object Name: GLFV_GL_BUDGET_ASSIGNMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLGL.GLFV_GL_BUDGET_ASSIGNMENTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


General Ledger budget assignements are accounts associated with a budget organization.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15) Yes Accounting books defining column
LEDGER_NAME VARCHAR2 (30) Yes
BUDGET_ORGANIZATION_ID NUMBER (15) Yes Budget version defining column
BUDGET_ORGANIZATION_NAME VARCHAR2 (25) Yes Budget organization name
ACCOUNT_ID NUMBER (15) Yes Key flexfield combination defining column
_KF:ACCOUNT CHAR (17)
CURRENCY VARCHAR2 (15) Yes
_LA:ENTRY_TYPE CHAR (46)
_LA:AMOUNT_TYPE CHAR (49)
_LA:BOUNDARY CHAR (53)
FUNDING_BUDGET_ID NUMBER (15)
BUDGET_NAME VARCHAR2 (15)
_LA:FUNDS_CHECK_LEVEL CHAR (66)
AUTO_ENCUMBRANCE_FLAG VARCHAR2 (0)
Query Text

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


SELECT LEDGER_ID
,      LEDGER_NAME
,      BUDGET_ORGANIZATION_ID
,      BUDGET_ORGANIZATION_NAME
,      ACCOUNT_ID
,      _KF:ACCOUNT
,      CURRENCY
,      _LA:ENTRY_TYPE
,      _LA:AMOUNT_TYPE
,      _LA:BOUNDARY
,      FUNDING_BUDGET_ID
,      BUDGET_NAME
,      _LA:FUNDS_CHECK_LEVEL
,      AUTO_ENCUMBRANCE_FLAG
FROM APPS.GLFV_GL_BUDGET_ASSIGNMENTS;

Dependencies

[top of page]

APPS.GLFV_GL_BUDGET_ASSIGNMENTS references the following:

SchemaAPPS
SynonymGL_BUDGET_ASSIGNMENTS
SynonymGL_BUDGET_ENTITIES
SynonymGL_BUDGET_VERSIONS
SynonymGL_BUDORG_BC_OPTIONS
SynonymGL_CODE_COMBINATIONS
SynonymGL_LEDGERS

APPS.GLFV_GL_BUDGET_ASSIGNMENTS is not referenced by any database object