[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;
|
|
|