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.FII_PROJ_TOP_TASK_LCV

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
TOP_TASK_PK	VARCHAR2	(78)
NAME	VARCHAR2	(47)
TOP_TASK	VARCHAR2	(30)
TASK_NUMBER	VARCHAR2	(25)
PROJECT_FK	VARCHAR2	(74)
INSTANCE	VARCHAR2	(30)
TASK_START_DATE	DATE
TASK_END_DATE	DATE
SERVICE_TYPE_CODE	VARCHAR2	(30)
LABOR_COST_MULT	VARCHAR2	(20)
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)

Query Text

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


SELECT TOP_TASK_PK
,      NAME
,      TOP_TASK
,      TASK_NUMBER
,      PROJECT_FK
,      INSTANCE
,      TASK_START_DATE
,      TASK_END_DATE
,      SERVICE_TYPE_CODE
,      LABOR_COST_MULT
,      LAST_UPDATE_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
FROM APPS.FII_PROJ_TOP_TASK_LCV;

Dependencies

[top of page]

APPS.FII_PROJ_TOP_TASK_LCV references the following:

APPS: FIIBV_PROJ_TOP_TASK_LCV

APPS.FII_PROJ_TOP_TASK_LCV is referenced by following:

APPS: FII_PROJECT_M_C - show dependent code