VIEW: APPS.WIP_EAM_PARAMETERS_V

Source

View Text - Preformatted

SELECT e1.ROWID ROW_ID, b1.meaning, e1.work_request_auto_approve as auto_approve_enabled_flag, c1.eam_cost_element,e1.def_eam_cost_element_id, e1.organization_id, e1.def_maint_cost_category, e1.last_update_date, e1.last_updated_by, e1.creation_date, e1.created_by, e1.last_update_login, e1.work_req_extended_log_flag, e1.easy_work_order_prefix, e1.work_order_prefix, e1.default_eam_class, w1.description, e1.serial_number_enabled, e1.auto_firm_flag, e1.maintenance_offset_account, e1.default_department_id, bd.department_code default_department, e1.wip_eam_request_type, e1.material_issue_by_mo, e1.invoice_billable_items_only, e1.default_asset_flag, e1.pm_ignore_missed_wo, e1.issue_zero_cost_flag, e1.work_request_asset_num_reqd, e1.eam_wo_workflow_enabled, e1.auto_firm_on_create, e1.intermediate_subinventory, e1.intermediate_locator from wip_eam_parameters e1, mfg_lookups b1, cst_eam_cost_elements c1, wip_accounting_classes w1, bom_departments bd WHERE e1.def_maint_cost_category = b1.lookup_code and b1.lookup_type = 'BOM_EAM_COST_CATEGORY' and c1.eam_cost_element_id(+) = e1.def_eam_cost_element_id and w1.class_code(+) = e1.default_eam_class and w1.organization_id(+) = e1.organization_id and bd.department_id(+) = e1.default_department_id

View Text - HTML Formatted

SELECT E1.ROWID ROW_ID
, B1.MEANING
, E1.WORK_REQUEST_AUTO_APPROVE AS AUTO_APPROVE_ENABLED_FLAG
, C1.EAM_COST_ELEMENT
, E1.DEF_EAM_COST_ELEMENT_ID
, E1.ORGANIZATION_ID
, E1.DEF_MAINT_COST_CATEGORY
, E1.LAST_UPDATE_DATE
, E1.LAST_UPDATED_BY
, E1.CREATION_DATE
, E1.CREATED_BY
, E1.LAST_UPDATE_LOGIN
, E1.WORK_REQ_EXTENDED_LOG_FLAG
, E1.EASY_WORK_ORDER_PREFIX
, E1.WORK_ORDER_PREFIX
, E1.DEFAULT_EAM_CLASS
, W1.DESCRIPTION
, E1.SERIAL_NUMBER_ENABLED
, E1.AUTO_FIRM_FLAG
, E1.MAINTENANCE_OFFSET_ACCOUNT
, E1.DEFAULT_DEPARTMENT_ID
, BD.DEPARTMENT_CODE DEFAULT_DEPARTMENT
, E1.WIP_EAM_REQUEST_TYPE
, E1.MATERIAL_ISSUE_BY_MO
, E1.INVOICE_BILLABLE_ITEMS_ONLY
, E1.DEFAULT_ASSET_FLAG
, E1.PM_IGNORE_MISSED_WO
, E1.ISSUE_ZERO_COST_FLAG
, E1.WORK_REQUEST_ASSET_NUM_REQD
, E1.EAM_WO_WORKFLOW_ENABLED
, E1.AUTO_FIRM_ON_CREATE
, E1.INTERMEDIATE_SUBINVENTORY
, E1.INTERMEDIATE_LOCATOR
FROM WIP_EAM_PARAMETERS E1
, MFG_LOOKUPS B1
, CST_EAM_COST_ELEMENTS C1
, WIP_ACCOUNTING_CLASSES W1
, BOM_DEPARTMENTS BD
WHERE E1.DEF_MAINT_COST_CATEGORY = B1.LOOKUP_CODE
AND B1.LOOKUP_TYPE = 'BOM_EAM_COST_CATEGORY'
AND C1.EAM_COST_ELEMENT_ID(+) = E1.DEF_EAM_COST_ELEMENT_ID
AND W1.CLASS_CODE(+) = E1.DEFAULT_EAM_CLASS
AND W1.ORGANIZATION_ID(+) = E1.ORGANIZATION_ID
AND BD.DEPARTMENT_ID(+) = E1.DEFAULT_DEPARTMENT_ID