[Home] [Help] [Dependency Information]
Object Name: | WIP_EAM_PARAMETERS# |
---|---|
Object Type: | VIEW |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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#;
|
|
|