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

VIEW: APPS.FIIBV_PA_PABU_BUDGET_LCV

Object Details
Object Name: FIIBV_PA_PABU_BUDGET_LCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FIIBV_PA_PABU_BUDGET_LCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


FIIBV_PA_PABU_BUDGET_LCV is the Budget level source view for the Project Budget dimension in EDW


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUDGET_PK VARCHAR2 (71)
Unique identifier of the project budget
NAME VARCHAR2 (162)
Budget name
BUDGET_TYPE VARCHAR2 (30) Yes Budget type
VERSION_NAME VARCHAR2 (103)
Budget version name
PROJECT_NAME VARCHAR2 (25) Yes Name of the project to which the budget belongs
CURRENT_FLAG VARCHAR2 (1) Yes Flag that indicates whether the budget is current
ORIGINAL_FLAG VARCHAR2 (1) Yes Flag that indicates whether the budget is original
CURRENT_ORIGINAL_FLAG VARCHAR2 (1) Yes Flag that indicates whether the budget is current original
INSTANCE VARCHAR2 (30)
Instance identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
_DF:BDT:_EDW CHAR (35)
This column is for internal use only
_DF:BDV:_EDW CHAR (38)
This column is for internal use only
_DF:PRJ:_EDW CHAR (32)
This column is for internal use only
Query Text

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


SELECT BUDGET_PK
,      NAME
,      BUDGET_TYPE
,      VERSION_NAME
,      PROJECT_NAME
,      CURRENT_FLAG
,      ORIGINAL_FLAG
,      CURRENT_ORIGINAL_FLAG
,      INSTANCE
,      LAST_UPDATE_DATE
,      _DF:BDT:_EDW
,      _DF:BDV:_EDW
,      _DF:PRJ:_EDW
FROM APPS.FIIBV_PA_PABU_BUDGET_LCV;

Dependencies

[top of page]

APPS.FIIBV_PA_PABU_BUDGET_LCV references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymPA_BUDGET_TYPES
SynonymPA_BUDGET_VERSIONS
SynonymPA_PROJECTS_ALL
APPS.FIIBV_PA_PABU_BUDGET_LCV is referenced by following:

SchemaAPPS
ViewFII_PA_PABU_BUDGET_LCV