[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WIP_EAM_PARAMETERS |
|---|---|
| Object Type: | TABLE |
| Owner: | WIP |
| FND Design Data: |  WIP.WIP_EAM_PARAMETERS
|
| Subobject Name: | |
| Status: | VALID |
For EAM enabled organization, this table stores organization parameters specific to EAM functionality.
Whenever an organization level default is required, all EAM modules obtain the default value from this table through the view WIP_EAM_PARAMETERS_V.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WIP_EAM_PARAMETERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORGANIZATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
| WORK_REQUEST_AUTO_APPROVE | VARCHAR2 | (1) | Auto Approve Flag | |
| DEF_MAINT_COST_CATEGORY | NUMBER | Yes | Default Maintenance Cost Category | |
| DEF_EAM_COST_ELEMENT_ID | NUMBER | Yes | Default Cost Element Identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Columns | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who Columns | |
| CREATION_DATE | DATE | Yes | Standard Who Columns | |
| CREATED_BY | NUMBER | Yes | Standard Who Columns | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Columns | ||
| WORK_REQ_EXTENDED_LOG_FLAG | VARCHAR2 | (1) | Work Request Extended Log Flag | |
| DEFAULT_EAM_CLASS | VARCHAR2 | (10) | Yes | Default EAM WIP Accounting Class |
| EASY_WORK_ORDER_PREFIX | VARCHAR2 | (30) | Easy Work Order Prefix | |
| WORK_ORDER_PREFIX | VARCHAR2 | (30) | Work Order Prefix | |
| SERIAL_NUMBER_ENABLED | VARCHAR2 | (1) | Serial Number Enabled | |
| AUTO_FIRM_FLAG | VARCHAR2 | (1) | A flag to indicate auto firming of the job upon release | |
| MAINTENANCE_OFFSET_ACCOUNT | NUMBER | Maintenance Offset Account | ||
| WIP_EAM_REQUEST_TYPE | NUMBER | Request Type - Work Request or Service Request | ||
| DEFAULT_DEPARTMENT_ID | NUMBER | (30) | Default Department ID | |
| MATERIAL_ISSUE_BY_MO | VARCHAR2 | (1) | Enable Material Issue Requests | |
| INVOICE_BILLABLE_ITEMS_ONLY | VARCHAR2 | (1) | Whether you want to invoice billable materials only or any material. If this is Yes, you can invoice a different billable material from the one chosen. | |
| BILLING_BASIS | NUMBER | (38) | Billing Basis: 1=Price List, 2=Cost Plus | |
| BILLING_METHOD | NUMBER | (38) | Billing Method: 1=Bill By Requirements, 2=Bill By Activity | |
| OVERRIDE_BILL_AMOUNT | VARCHAR2 | (1) | Reserved for future use | |
| DYNAMIC_BILLING_ACTIVITY | VARCHAR2 | (1) | Reserved for future use | |
| DEFAULT_ASSET_FLAG | VARCHAR2 | (1) | Whether to default asset number based on PN location. | |
| PM_IGNORE_MISSED_WO | VARCHAR2 | (1) | Whether Preventive Maintenance Engine should generate past work orders. | |
| ISSUE_ZERO_COST_FLAG | VARCHAR2 | (1) | Whether to issue rebuildables at zero cost or item cost. | |
| WORK_REQUEST_ASSET_NUM_REQD | VARCHAR2 | (1) | Flag to denote whether asset number is mandatory during work request creation | |
| EAM_WO_WORKFLOW_ENABLED | VARCHAR2 | (1) | Stores whether any of the workflow events can be raised for this organization or not. 'Y' indicates the events can be raised, 'N'/Null indicates the events cannot be raised | |
| AUTO_FIRM_ON_CREATE | VARCHAR2 | (1) | A flag to indicate auto firming of the job on creation | |
| INTERMEDIATE_SUBINVENTORY | VARCHAR2 | (10) | Intermediate Subinventory for the Misc. Rec. of Asset with no On Hand Quantity during Asset Move WB. | |
| INTERMEDIATE_LOCATOR | VARCHAR2 | (20) | Intermediate Locator for the Misc. Rec. of Asset with no On Hand Quantity during Asset Move WB. |
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
FROM WIP.WIP_EAM_PARAMETERS;
WIP.WIP_EAM_PARAMETERS does not reference any database object
WIP.WIP_EAM_PARAMETERS is referenced by following:
APPS
WIP_EAM_PARAMETERS
|
|
|
|