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

Object Details

Object Name:	WIP_EAM_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WIP.WIP_EAM_PARAMETERS_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	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
MEANING	VARCHAR2	(80)	Yes	Cost category meaning
AUTO_APPROVE_ENABLED_FLAG	VARCHAR2	(1)		Auto approve enabled flag
EAM_COST_ELEMENT	VARCHAR2	(50)		Meaning of cost element
DEF_EAM_COST_ELEMENT_ID	NUMBER		Yes	Default eAM cost element identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
DEF_MAINT_COST_CATEGORY	NUMBER		Yes	Default maintenance cost category identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
WORK_REQ_EXTENDED_LOG_FLAG	VARCHAR2	(1)		Work request extended log enable flag
EASY_WORK_ORDER_PREFIX	VARCHAR2	(30)		Easy work order prefix
WORK_ORDER_PREFIX	VARCHAR2	(30)		Work order prefix
DEFAULT_EAM_CLASS	VARCHAR2	(10)	Yes	Default eAM accounting class
DESCRIPTION	VARCHAR2	(240)		Description
SERIAL_NUMBER_ENABLED	VARCHAR2	(1)		Serial number generation enabled
AUTO_FIRM_FLAG	VARCHAR2	(1)		Auto firm flag
MAINTENANCE_OFFSET_ACCOUNT	NUMBER			Maintenance Offset Account
DEFAULT_DEPARTMENT_ID	NUMBER	(30)
DEFAULT_DEPARTMENT	VARCHAR2	(10)
WIP_EAM_REQUEST_TYPE	NUMBER
MATERIAL_ISSUE_BY_MO	VARCHAR2	(1)
INVOICE_BILLABLE_ITEMS_ONLY	VARCHAR2	(1)
DEFAULT_ASSET_FLAG	VARCHAR2	(1)
PM_IGNORE_MISSED_WO	VARCHAR2	(1)
ISSUE_ZERO_COST_FLAG	VARCHAR2	(1)
WORK_REQUEST_ASSET_NUM_REQD	VARCHAR2	(1)
EAM_WO_WORKFLOW_ENABLED	VARCHAR2	(1)		Stores whether any of the workflow events can be raised for this organization or not. 'Y' indicates the events can be raised, 'N'/Null indicates the events cannot be raised
EAM_SAFETY_WORKFLOW_ENABLED	VARCHAR2	(1)		Stores whether any of the safety workflow events can be raised for this organization or not. 'Y' indicates the events can be raised, 'N'/Null indicates the events cannot be raised
AUTO_FIRM_ON_CREATE	VARCHAR2	(1)		A flag to indicate auto firming of the job on creation
INTERMEDIATE_SUBINVENTORY	VARCHAR2	(10)		Intermediate Subinventory for the Misc. Rec. of Asset with no On Hand Quantity during Asset Move WB.
INTERMEDIATE_LOCATOR	VARCHAR2	(20)		Intermediate Locator for the Misc. Rec. of Asset with no On Hand Quantity during Asset Move WB.
PM_WORK_ORDER_PREFIX	VARCHAR2	(30)

Query Text

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


SELECT ROW_ID
,      MEANING
,      AUTO_APPROVE_ENABLED_FLAG
,      EAM_COST_ELEMENT
,      DEF_EAM_COST_ELEMENT_ID
,      ORGANIZATION_ID
,      DEF_MAINT_COST_CATEGORY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WORK_REQ_EXTENDED_LOG_FLAG
,      EASY_WORK_ORDER_PREFIX
,      WORK_ORDER_PREFIX
,      DEFAULT_EAM_CLASS
,      DESCRIPTION
,      SERIAL_NUMBER_ENABLED
,      AUTO_FIRM_FLAG
,      MAINTENANCE_OFFSET_ACCOUNT
,      DEFAULT_DEPARTMENT_ID
,      DEFAULT_DEPARTMENT
,      WIP_EAM_REQUEST_TYPE
,      MATERIAL_ISSUE_BY_MO
,      INVOICE_BILLABLE_ITEMS_ONLY
,      DEFAULT_ASSET_FLAG
,      PM_IGNORE_MISSED_WO
,      ISSUE_ZERO_COST_FLAG
,      WORK_REQUEST_ASSET_NUM_REQD
,      EAM_WO_WORKFLOW_ENABLED
,      EAM_SAFETY_WORKFLOW_ENABLED
,      AUTO_FIRM_ON_CREATE
,      INTERMEDIATE_SUBINVENTORY
,      INTERMEDIATE_LOCATOR
,      PM_WORK_ORDER_PREFIX
FROM APPS.WIP_EAM_PARAMETERS_V;

Dependencies

[top of page]

APPS.WIP_EAM_PARAMETERS_V references the following:

APPS: BOM_DEPARTMENTS; CST_EAM_COST_ELEMENTS; MFG_LOOKUPS; WIP_ACCOUNTING_CLASSES; WIP_EAM_PARAMETERS

APPS.WIP_EAM_PARAMETERS_V is not referenced by any database object