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

Object Details

Object Name:	EAM_FORECAST_WORK_ORDER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_FORECAST_WORK_ORDER_V
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
FORECAST_ID	NUMBER		Forecast Identifier
WIP_ENTITY_ID	NUMBER		WIP Job Identifier
WIP_ENTITY_NAME	VARCHAR2	(240)	WIP Entity Name
ORGANIZATION_ID	NUMBER		Organization Identifier
ASSET_NUMBER	VARCHAR2	(30)	Asset Number
ASSET_DESCRIPTION	VARCHAR2	(240)	Asset Description
ASSET_GROUP	VARCHAR2	(40)	Asset Group
ASSET_ACTIVITY	VARCHAR2	(40)	Asset Activity
ASSET_LOCATION	VARCHAR2	(30)	Asset Area
WORK_ORDER_TYPE	VARCHAR2	(80)	Work Order Type
DESCRIPTION	VARCHAR2	(240)	Description
START_DATE	DATE		Work Order Start Date
COMPLETION_DATE	DATE		Work Order Completion Date
ACTIVITY_TYPE	VARCHAR2	(80)	Activity Type
ACTIVITY_CAUSE	VARCHAR2	(80)	Activity Cause
OWNING_DEPARTMENT	VARCHAR2	(10)	Owning Department
CLASS_CODE	VARCHAR2	(10)	Class Code
PLAN_MAINTENANCE	VARCHAR2	(1)	Plan Maintenance Flag
PROJECT	VARCHAR2	(30)	Project
ACTIVITY_SOURCE	VARCHAR2	(80)	Activity Source
PM_SCHEDULE_ID	NUMBER		Preventive Maintenance Schedule Identifier
TASK	VARCHAR2	(20)	Project Task

Query Text

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


SELECT FORECAST_ID
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      ORGANIZATION_ID
,      ASSET_NUMBER
,      ASSET_DESCRIPTION
,      ASSET_GROUP
,      ASSET_ACTIVITY
,      ASSET_LOCATION
,      WORK_ORDER_TYPE
,      DESCRIPTION
,      START_DATE
,      COMPLETION_DATE
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      OWNING_DEPARTMENT
,      CLASS_CODE
,      PLAN_MAINTENANCE
,      PROJECT
,      ACTIVITY_SOURCE
,      PM_SCHEDULE_ID
,      TASK
FROM APPS.EAM_FORECAST_WORK_ORDER_V;

Dependencies

[top of page]

APPS.EAM_FORECAST_WORK_ORDER_V references the following:

APPS: BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; EAM_FORECAST_WDJ; EAM_ORG_MAINT_DEFAULTS; FND_PROFILE - show dependent code; MFG_LOOKUPS; MTL_EAM_LOCATIONS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_KFV; PA_TASK_UTILS - show dependent code; PJM_TASKS_V; WIP_ENTITIES

APPS.EAM_FORECAST_WORK_ORDER_V is not referenced by any database object