eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.FIIBV_PROJ_PROJECT_LCV

Object Details

Object Name:	FIIBV_PROJ_PROJECT_LCV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FII.FIIBV_PROJ_PROJECT_LCV
Subobject Name:
Status:	VALID

View Type

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

FIIBV_PROJ_PROJECT_LCV is the Project level base view for the Project dimension in EDW

[View Source]

Columns

Name	Datatype	Length	Comments
PROJECT_PK	VARCHAR2	(74)	The unique identifier of the project
NAME	VARCHAR2	(25)	Project name
PROJECT	VARCHAR2	(30)	Project
PROJECT_NUMBER	VARCHAR2	(25)	Project Number
PRJ_TYP_FK	VARCHAR2	(92)	Foreign key to the project type level
PROJ_CLS1_FK	VARCHAR2	(4000)	Foreign key to the project class level
PROJ_CLS2_FK	VARCHAR2	(4000)	Foreign key to the project class level
PROJ_CLS3_FK	VARCHAR2	(4000)	Foreign key to the project class level
PROJ_CLS4_FK	VARCHAR2	(4000)	Foreign key to the project class level
PROJ_CLS5_FK	VARCHAR2	(4000)	Foreign key to the project class level
PROJ_CLS6_FK	VARCHAR2	(4000)	Foreign key to the project class level
PROJ_CLS7_FK	VARCHAR2	(4000)	Foreign key to the project class level
INSTANCE	VARCHAR2	(30)	Instance identifier
DISTRIBUTION_RULE	VARCHAR2	(30)	The distribution rule that specifies the contract project's revenue accrual and billing method
PROJECT_STATUS_CODE	VARCHAR2	(30)	The status of the project
PROJECT_MANAGER	VARCHAR2	(0)	Project manager name
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
_DF:PRJ:_EDW	VARCHAR2	(38)	This column is for internal use only
_DF:PSB:_EDW	VARCHAR2	(36)	This column is for internal use only

Query Text

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


SELECT PROJECT_PK
,      NAME
,      PROJECT
,      PROJECT_NUMBER
,      PRJ_TYP_FK
,      PROJ_CLS1_FK
,      PROJ_CLS2_FK
,      PROJ_CLS3_FK
,      PROJ_CLS4_FK
,      PROJ_CLS5_FK
,      PROJ_CLS6_FK
,      PROJ_CLS7_FK
,      INSTANCE
,      DISTRIBUTION_RULE
,      PROJECT_STATUS_CODE
,      PROJECT_MANAGER
,      LAST_UPDATE_DATE
,      _DF:PRJ:_EDW
,      _DF:PSB:_EDW
FROM APPS.FIIBV_PROJ_PROJECT_LCV;

Dependencies

[top of page]

APPS.FIIBV_PROJ_PROJECT_LCV references the following:

APPS: EDW_LOCAL_INSTANCE; EDW_LOCAL_SYSTEM_PARAMETERS; EDW_PROJ_CLS - show dependent code; PA_PROJECTS_ALL; PJM_SEIBAN_NUMBERS

APPS.FIIBV_PROJ_PROJECT_LCV is referenced by following:

APPS: FII_PROJ_PROJECT_LCV