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.

[Home] [Help]

VIEW: WIP.WIP_EAM_PARAMETERS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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