DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.WIP_EAM_PARAMETERS_V

Object Details
Object Name: WIP_EAM_PARAMETERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWIP.WIP_EAM_PARAMETERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
MEANING VARCHAR2 (80) Yes Cost category meaning
AUTO_APPROVE_ENABLED_FLAG VARCHAR2 (1)
Auto approve enabled flag
EAM_COST_ELEMENT VARCHAR2 (50)
Meaning of cost element
DEF_EAM_COST_ELEMENT_ID NUMBER
Yes Default eAM cost element identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
DEF_MAINT_COST_CATEGORY NUMBER
Yes Default maintenance cost category identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
WORK_REQ_EXTENDED_LOG_FLAG VARCHAR2 (1)
Work request extended log enable flag
EASY_WORK_ORDER_PREFIX VARCHAR2 (30)
Easy work order prefix
WORK_ORDER_PREFIX VARCHAR2 (30)
Work order prefix
DEFAULT_EAM_CLASS VARCHAR2 (10) Yes Default eAM accounting class
DESCRIPTION VARCHAR2 (240)
Description
SERIAL_NUMBER_ENABLED VARCHAR2 (1)
Serial number generation enabled
AUTO_FIRM_FLAG VARCHAR2 (1)
Auto firm flag
MAINTENANCE_OFFSET_ACCOUNT NUMBER

Maintenance Offset Account
DEFAULT_DEPARTMENT_ID NUMBER (30)
Default Department Identifier
DEFAULT_DEPARTMENT VARCHAR2 (10)
Default Department
WIP_EAM_REQUEST_TYPE NUMBER

WIP EAM Request Type
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
Material Issue By MO
INVOICE_BILLABLE_ITEMS_ONLY VARCHAR2 (1)
Invoice Billable Items Only
DEFAULT_ASSET_FLAG VARCHAR2 (1)
Default Asset Flag
PM_IGNORE_MISSED_WO VARCHAR2 (1)
PM Ignore Missed WO
ISSUE_ZERO_COST_FLAG VARCHAR2 (1)
Issue Zero Cost Flag
WORK_REQUEST_ASSET_NUM_REQD VARCHAR2 (1)
Work Request Asset Number Required
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.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      MEANING
,      AUTO_APPROVE_ENABLED_FLAG
,      EAM_COST_ELEMENT
,      DEF_EAM_COST_ELEMENT_ID
,      ORGANIZATION_ID
,      DEF_MAINT_COST_CATEGORY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WORK_REQ_EXTENDED_LOG_FLAG
,      EASY_WORK_ORDER_PREFIX
,      WORK_ORDER_PREFIX
,      DEFAULT_EAM_CLASS
,      DESCRIPTION
,      SERIAL_NUMBER_ENABLED
,      AUTO_FIRM_FLAG
,      MAINTENANCE_OFFSET_ACCOUNT
,      DEFAULT_DEPARTMENT_ID
,      DEFAULT_DEPARTMENT
,      WIP_EAM_REQUEST_TYPE
,      MATERIAL_ISSUE_BY_MO
,      INVOICE_BILLABLE_ITEMS_ONLY
,      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 APPS.WIP_EAM_PARAMETERS_V;

Dependencies

[top of page]

APPS.WIP_EAM_PARAMETERS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymCST_EAM_COST_ELEMENTS
ViewMFG_LOOKUPS
SynonymWIP_ACCOUNTING_CLASSES
SynonymWIP_EAM_PARAMETERS

APPS.WIP_EAM_PARAMETERS_V is not referenced by any database object