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: WIP.WIP_EAM_PARAMETERS#

Object Details

Object Name:	WIP_EAM_PARAMETERS#
Object Type:	VIEW
Owner:	WIP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORGANIZATION_ID	NUMBER		Yes
WORK_REQUEST_AUTO_APPROVE	VARCHAR2	(1)
DEF_MAINT_COST_CATEGORY	NUMBER		Yes
DEF_EAM_COST_ELEMENT_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
WORK_REQ_EXTENDED_LOG_FLAG	VARCHAR2	(1)
DEFAULT_EAM_CLASS	VARCHAR2	(10)	Yes
EASY_WORK_ORDER_PREFIX	VARCHAR2	(30)
WORK_ORDER_PREFIX	VARCHAR2	(30)
SERIAL_NUMBER_ENABLED	VARCHAR2	(1)
AUTO_FIRM_FLAG	VARCHAR2	(1)
MAINTENANCE_OFFSET_ACCOUNT	NUMBER
WIP_EAM_REQUEST_TYPE	NUMBER
DEFAULT_DEPARTMENT_ID	NUMBER	(30)
MATERIAL_ISSUE_BY_MO	VARCHAR2	(1)
INVOICE_BILLABLE_ITEMS_ONLY	VARCHAR2	(1)
BILLING_BASIS	NUMBER	(38)
BILLING_METHOD	NUMBER	(38)
OVERRIDE_BILL_AMOUNT	VARCHAR2	(1)
DYNAMIC_BILLING_ACTIVITY	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)
AUTO_FIRM_ON_CREATE	VARCHAR2	(1)
INTERMEDIATE_SUBINVENTORY	VARCHAR2	(10)
INTERMEDIATE_LOCATOR	VARCHAR2	(20)
EAM_SAFETY_WORKFLOW_ENABLED	VARCHAR2	(1)
PM_WORK_ORDER_PREFIX	VARCHAR2	(30)

Query Text

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


SELECT ORGANIZATION_ID
,      WORK_REQUEST_AUTO_APPROVE
,      DEF_MAINT_COST_CATEGORY
,      DEF_EAM_COST_ELEMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WORK_REQ_EXTENDED_LOG_FLAG
,      DEFAULT_EAM_CLASS
,      EASY_WORK_ORDER_PREFIX
,      WORK_ORDER_PREFIX
,      SERIAL_NUMBER_ENABLED
,      AUTO_FIRM_FLAG
,      MAINTENANCE_OFFSET_ACCOUNT
,      WIP_EAM_REQUEST_TYPE
,      DEFAULT_DEPARTMENT_ID
,      MATERIAL_ISSUE_BY_MO
,      INVOICE_BILLABLE_ITEMS_ONLY
,      BILLING_BASIS
,      BILLING_METHOD
,      OVERRIDE_BILL_AMOUNT
,      DYNAMIC_BILLING_ACTIVITY
,      DEFAULT_ASSET_FLAG
,      PM_IGNORE_MISSED_WO
,      ISSUE_ZERO_COST_FLAG
,      WORK_REQUEST_ASSET_NUM_REQD
,      EAM_WO_WORKFLOW_ENABLED
,      AUTO_FIRM_ON_CREATE
,      INTERMEDIATE_SUBINVENTORY
,      INTERMEDIATE_LOCATOR
,      EAM_SAFETY_WORKFLOW_ENABLED
,      PM_WORK_ORDER_PREFIX
FROM WIP.WIP_EAM_PARAMETERS#;

Dependencies

[top of page]

WIP.WIP_EAM_PARAMETERS# references the following:

WIP: WIP_EAM_PARAMETERS

WIP.WIP_EAM_PARAMETERS# is referenced by following:

APPS: WIP_EAM_PARAMETERS