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

VIEW: APPS.FIIBV_PA_EXP_TYPES_V

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

View Type

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


FIIBV_PA_EXP_TYPES_V is the Project Expenditure Type level base view for the Project Expenditure Type dimension in EDW


[View Source]

Columns
Name Datatype Length Mandatory Comments
EXP_TYPE_PK VARCHAR2 (111)
Unique Identifier
ALL_FK CHAR (3)
Foreign key to the top level
CREATION_DATE DATE

Standard who column - date when this row was created.
EXP_TYPE_NAME VARCHAR2 (80)
Expenditure type
INSTANCE VARCHAR2 (30)
Instance identifier
NAME VARCHAR2 (80)
Expenditure type name
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
_DF:EXT:_EDW VARCHAR2 (48)
This column is for internal use only
Query Text

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


SELECT EXP_TYPE_PK
,      ALL_FK
,      CREATION_DATE
,      EXP_TYPE_NAME
,      INSTANCE
,      NAME
,      LAST_UPDATE_DATE
,      _DF:EXT:_EDW
FROM APPS.FIIBV_PA_EXP_TYPES_V;

Dependencies

[top of page]

APPS.FIIBV_PA_EXP_TYPES_V references the following:

SchemaAPPS
SynonymEDW_LOCAL_INSTANCE
SynonymPA_EXPENDITURE_TYPES
ViewPA_LOOKUPS
APPS.FIIBV_PA_EXP_TYPES_V is referenced by following:

SchemaAPPS
ViewFII_PA_EXP_TYPES_V