[Home] [Help]
[Dependency Information]
| Object Name: | FII_PROJ_PROJECT_LCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | FII.FII_PROJ_PROJECT_LCV
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_PK | VARCHAR2 | (74) | ||
| NAME | VARCHAR2 | (25) | ||
| PROJECT | VARCHAR2 | (30) | ||
| PROJECT_NUMBER | VARCHAR2 | (25) | ||
| PRJ_TYP_FK | VARCHAR2 | (92) | ||
| PROJ_CLS1_FK | VARCHAR2 | (4000) | ||
| PROJ_CLS2_FK | VARCHAR2 | (4000) | ||
| PROJ_CLS3_FK | VARCHAR2 | (4000) | ||
| PROJ_CLS4_FK | VARCHAR2 | (4000) | ||
| PROJ_CLS5_FK | VARCHAR2 | (4000) | ||
| PROJ_CLS6_FK | VARCHAR2 | (4000) | ||
| PROJ_CLS7_FK | VARCHAR2 | (4000) | ||
| INSTANCE | VARCHAR2 | (30) | ||
| DISTRIBUTION_RULE | VARCHAR2 | (30) | ||
| PROJECT_STATUS_CODE | VARCHAR2 | (30) | ||
| PROJECT_MANAGER | VARCHAR2 | (0) | ||
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| USER_ATTRIBUTE1 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE2 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE3 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE4 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE5 | VARCHAR2 | (0) |
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
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.FII_PROJ_PROJECT_LCV;
APPS
EDW_PROJ_CLS
- show dependent code
FIIBV_PROJ_PROJECT_LCV
APPS
FII_PROJECT_M_C
- show dependent code
|
|
|
|