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_PM_SCHEDULINGS_V

Object Details

Object Name:	EAM_PM_SCHEDULINGS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_PM_SCHEDULINGS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
PM_SCHEDULE_ID	NUMBER		Identifier for this PM Schedule
ORGANIZATION_ID	NUMBER		Organization Identifier
INVENTORY_ITEM_ID	NUMBER		Asset Group Identifier
ASSET_NUMBER	VARCHAR2	(30)	Asset number or Rebuild Serial number
NON_SCHEDULED_FLAG	VARCHAR2	(1)	Non Scheduled Flag
FROM_EFFECTIVE_DATE	DATE		Date From whcih this PM Schedule is Effective
TO_EFFECTIVE_DATE	DATE		Date till which this PM Schedule id Effective
RESCHEDULING_POINT	NUMBER		Rescheduling Point
LEAD_TIME	NUMBER		Lead Time
CREATED_BY	NUMBER		Standard WHO column
CREATION_DATE	DATE		Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column
LAST_UPDATE_DATE	DATE		Standard WHO column
LAST_UPDATED_BY	NUMBER		Standard WHO column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Attribute Category
ATTRIBUTE1	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE2	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE3	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE4	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE5	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE6	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE7	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE8	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE9	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE10	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE11	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE12	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE13	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE14	VARCHAR2	(150)	Descriptive Flexfield column
ATTRIBUTE15	VARCHAR2	(150)	Descriptive Flexfield column
PM_SOURCE_CODE	VARCHAR2	(30)	Application that the PM is created in
PM_SOURCE_LINE	VARCHAR2	(30)	Source that PM is created from.
DEFAULT_IMPLEMENT	VARCHAR2	(1)	Flag that tells whether this PM schedule is a default shcedule
WHICHEVER_FIRST	VARCHAR2	(1)	Whichever first or later
INCLUDE_MANUAL	VARCHAR2	(1)	Flag to indicate whether to include manual WOs
SET_NAME_ID	NUMBER		PM Set Name id for this Schedule
SET_NAME	VARCHAR2	(80)	PM Set Name for this schedule
SCHEDULING_METHOD_CODE	NUMBER		Scheduling method code
TYPE_CODE	NUMBER		Schedule Type code
SOURCE_TMPL_ID	NUMBER		Schedule identifier from which this schedule is instantiated
AUTO_INSTANTIATION_FLAG	VARCHAR2	(1)	Auto Instantiation flag
NAME	VARCHAR2	(50)	Schedule Name
TMPL_FLAG	VARCHAR2	(1)	Flag to indicate whether this schedule is template
MAINTENANCE_OBJECT_ID	NUMBER		gen_object_id of the maintenance object
MAINTENANCE_OBJECT_TYPE	NUMBER		type of the maintenance object
EAM_ITEM_TYPE	NUMBER		Eam Item Type
GENERATE_WO_STATUS	NUMBER		Generate Work order status identifier, which indicates in which status work order has to be created, based on PM schedule.
WORK_ORDER_STATUS	VARCHAR2	(80)	Description of Work Order Status Id
INTERVAL_PER_CYCLE	NUMBER		This will store the number in which the cycle will be divided
CURRENT_CYCLE	NUMBER		This will store the Current Cycle based on which the PM Schedule will be defined.
CURRENT_SEQ	NUMBER		This will store the current sequence within a cycle and will be used for resequencing of work orders.
BASE_DATE	DATE		This will store the Base Date from which the PM engine has to generate the Work Orders.
BASE_READING	NUMBER		This will store the Base Reading from which the PM engine has to generate the Work Orders.
EAM_LAST_CYCLIC_ACT	NUMBER		This will store the last cyclical activity performed for that PM Schedule
INSTANCE_ID	NUMBER		This will display the Instance Id of Asset. Unique identifier
CONCATENATED_SEGMENTS	VARCHAR2	(40)	Displays the Asset Group
DESCRIPTION	VARCHAR2	(240)	Displays the Asset Group Description
INSTANCE_DESCRIPTION	VARCHAR2	(240)	Asset Serial Number Description
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number
LOCAL_FLAG	VARCHAR2	(1)	Flag indicating whether the PM set is globally visible or only visible for the owning organization
OWNING_ORGANIZATION_ID	NUMBER		The Organization in which the PM Set currently belongs to
NETWORK_ASSET	VARCHAR2	(1)	Network asset flag
LAST_REVIEWED_BY_ID	NUMBER	(15)	PM Last Review By ID
LAST_REVIEWED_DATE	DATE		PM Last Review Date
LAST_REVIEWED_BY	VARCHAR2	(240)	M Last Reviewed by
GENERATE_NEXT_WORK_ORDER	VARCHAR2	(1)	Flag to generate next work order only
PLANNER_MAINTENANCE	NUMBER		Planner lookup code
PLANNER_MAINTENANCE_DISP	VARCHAR2	(80)	Displays Planner that gets defaulted to generated WO

Query Text

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


SELECT PM_SCHEDULE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ASSET_NUMBER
,      NON_SCHEDULED_FLAG
,      FROM_EFFECTIVE_DATE
,      TO_EFFECTIVE_DATE
,      RESCHEDULING_POINT
,      LEAD_TIME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PM_SOURCE_CODE
,      PM_SOURCE_LINE
,      DEFAULT_IMPLEMENT
,      WHICHEVER_FIRST
,      INCLUDE_MANUAL
,      SET_NAME_ID
,      SET_NAME
,      SCHEDULING_METHOD_CODE
,      TYPE_CODE
,      SOURCE_TMPL_ID
,      AUTO_INSTANTIATION_FLAG
,      NAME
,      TMPL_FLAG
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      EAM_ITEM_TYPE
,      GENERATE_WO_STATUS
,      WORK_ORDER_STATUS
,      INTERVAL_PER_CYCLE
,      CURRENT_CYCLE
,      CURRENT_SEQ
,      BASE_DATE
,      BASE_READING
,      EAM_LAST_CYCLIC_ACT
,      INSTANCE_ID
,      CONCATENATED_SEGMENTS
,      DESCRIPTION
,      INSTANCE_DESCRIPTION
,      SERIAL_NUMBER
,      LOCAL_FLAG
,      OWNING_ORGANIZATION_ID
,      NETWORK_ASSET
,      LAST_REVIEWED_BY_ID
,      LAST_REVIEWED_DATE
,      LAST_REVIEWED_BY
,      GENERATE_NEXT_WORK_ORDER
,      PLANNER_MAINTENANCE
,      PLANNER_MAINTENANCE_DISP
FROM APPS.EAM_PM_SCHEDULINGS_V;

Dependencies

[top of page]

APPS.EAM_PM_SCHEDULINGS_V references the following:

APPS: CSI_ITEM_INSTANCES; EAM_PM_ACTIVITIES; EAM_PM_SCHEDULINGS; EAM_PM_SET_NAMES; EAM_WO_STATUSES_V; FND_USER; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MFG_LOOKUPS; MTL_EAM_ASSET_ACTIVITIES; MTL_PARAMETERS; MTL_SYSTEM_ITEMS_VL; PER_PEOPLE_F

APPS.EAM_PM_SCHEDULINGS_V is not referenced by any database object