Product: | WIP - Work in Process |
---|---|
Description: | View for EAM organization parameters. |
Implementation/DBA Data: | APPS.WIP_EAM_PARAMETERS_V |
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
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