[Home] [Help] [Dependency Information]
Object Name: | FIIBV_PROJ_PROJECT_LCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FIIBV_PROJ_PROJECT_LCV |
Subobject Name: | |
Status: | VALID |
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
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|