[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_CFR_WORK_ORDER_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WIP_ENTITY_ID | NUMBER | Yes | Work Order Identifier | |
| WIP_ENTITY_NAME | VARCHAR2 | (240) | Yes | Work Order Name |
| ENTITY_TYPE | NUMBER | Yes | Entity Type | |
| ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
| DESCRIPTION | VARCHAR2 | (240) | Work Order Description | |
| ASSET_GROUP_ID | NUMBER | Asset Group Id - Inventory Item Id of the Asset | ||
| ASSET_GROUP | VARCHAR2 | (40) | Concatenated segments for Asset Group / Rebuild Items | |
| ASSET_GROUP_DESCRIPTION | VARCHAR2 | (240) | Asset Group Description | |
| INSTANCE_ID | NUMBER | Instance Id | ||
| ASSET_NUMBER | VARCHAR2 | (30) | Asset Number | |
| ASSET_SERIAL_NUMBER | VARCHAR2 | (30) | Asset Serial Number | |
| ASSET_NUMBER_DESCRIPTION | VARCHAR2 | (240) | Asset Number Description | |
| ASSET_TYPE | NUMBER | Asset Type | ||
| ASSET_TYPE_DISP | VARCHAR2 | (80) | Yes | Asset Type-Meaning from Lookup |
| ASSET_ACTIVITY_ID | NUMBER | Asset Activity Id | ||
| ASSET_ACTIVITY | VARCHAR2 | (40) | Asset Activity | |
| ASSET_ACTIVITY_DESCRIPTION | VARCHAR2 | (240) | Asset Activity Description | |
| CLASS_CODE | VARCHAR2 | (10) | Yes | Accounting Class Code |
| SYSTEM_STATUS_TYPE | NUMBER | Yes | Status of job | |
| SYSTEM_STATUS_DISP | VARCHAR2 | (80) | Yes | Status of job-Meaning from Lookup |
| PM_SCHEDULE_ID | NUMBER | PM Schedule Id | ||
| MANUAL_REBUILD_FLAG | VARCHAR2 | (1) | Manual Rebuild Flag | |
| MANUAL_REBUILD_FLAG_DISP | VARCHAR2 | (80) | Yes | Manual Rebuild Flag-Meaning from Lookup |
| WORK_ORDER_TYPE | VARCHAR2 | (30) | Work Order Type | |
| WORK_ORDER_TYPE_DISP | VARCHAR2 | (80) | Work Order Type - Meanings from Lookup | |
| MATERIAL_ACCOUNT | NUMBER | Material Account | ||
| MATERIAL_OVERHEAD_ACCOUNT | NUMBER | Material Overhead Account | ||
| RESOURCE_ACCOUNT | NUMBER | Resource Account | ||
| OUTSIDE_PROCESSING_ACCOUNT | NUMBER | Outside Processing Account | ||
| MATERIAL_VARIANCE_ACCOUNT | NUMBER | Material Variance Account | ||
| RESOURCE_VARIANCE_ACCOUNT | NUMBER | Resource Variance Account | ||
| OUTSIDE_PROC_VARIANCE_ACCOUNT | NUMBER | Outside Processing Variance Account | ||
| STD_COST_ADJUSTMENT_ACCOUNT | NUMBER | Standard Cost Adjustment Account | ||
| OVERHEAD_ACCOUNT | NUMBER | Overhead Account | ||
| OVERHEAD_VARIANCE_ACCOUNT | NUMBER | Overhead Variance Account | ||
| SCHEDULED_START_DATE | DATE | Yes | Work Order Scheduled Start Date | |
| SCHEDULED_COMPLETION_DATE | DATE | Yes | Work Order Scheduled Completion Date | |
| DATE_RELEASED | DATE | Work Order Release Date | ||
| DATE_COMPLETED | DATE | Completion Date of Work Order | ||
| DATE_CLOSED | DATE | Closing Date of Work Order | ||
| OWNING_DEPARTMENT_ID | NUMBER | Owning Department of Work Order | ||
| OWNING_DEPARTMENT_CODE | VARCHAR2 | (10) | Owning Department Code of Work Order | |
| ACTIVITY_TYPE | VARCHAR2 | (30) | Activity Type | |
| ACTIVITY_TYPE_DISP | VARCHAR2 | (80) | Activity Type - Meaning from Lookup | |
| ACTIVITY_CAUSE | VARCHAR2 | (30) | Activity Cause | |
| ACTIVITY_CAUSE_DISP | VARCHAR2 | (80) | Activity Cause -Meaning from Lookup | |
| PRIORITY | NUMBER | Priority | ||
| PRIORITY_DISP | VARCHAR2 | (80) | Priority - Meaning from Lookup | |
| REQUESTED_START_DATE | DATE | Requested Start Date | ||
| DUE_DATE | DATE | Requested Due Date | ||
| ESTIMATION_STATUS | NUMBER | Estimation Status | ||
| ESTIMATION_STATUS_DISP | VARCHAR2 | (80) | Yes | |
| NOTIFICATION_REQUIRED | VARCHAR2 | (1) | Notification Required Flag | |
| NOTIFICATION_REQUIRED_DISP | VARCHAR2 | (80) | Yes | Notification Required-Meaning form Lookup |
| SHUTDOWN_TYPE | VARCHAR2 | (30) | Shutdown Type | |
| SHUTDOWN_TYPE_DISP | VARCHAR2 | (80) | Shutdown Type - Meaning from Lookup | |
| SHUTDOWN_START_DATE | DATE | Shutdown Start Date | ||
| SHUTDOWN_END_DATE | DATE | Shutdown End Date | ||
| TAGOUT_REQUIRED | VARCHAR2 | (1) | Tagout Required Flag | |
| TAGOUT_REQUIRED_DISP | VARCHAR2 | (80) | Yes | Tagout Required-Meaning from Lookup |
| PLAN_MAINTENANCE | VARCHAR2 | (1) | Planned Maintenance Flag | |
| PLAN_MAINTENANCE_DISP | VARCHAR2 | (80) | Yes | Planned Maintenance-Meaning from Lookup |
| FIRM_PLANNED_FLAG | NUMBER | Yes | Firm Flag | |
| FIRM_PLANNED_FLAG_DISP | VARCHAR2 | (80) | Yes | Firm flag-Meaning from Lookup |
| SCHEDULE_GROUP_ID | NUMBER | Schedule Group Id | ||
| SCHEDULE_GROUP_NAME | VARCHAR2 | (30) | Schedule Group Name | |
| PROJECT_NUMBER | VARCHAR2 | (4000) | Project Number | |
| PROJECT_NAME | VARCHAR2 | (4000) | Project Name | |
| PROJECT_ID | NUMBER | Project Id | ||
| TASK_NUMBER | VARCHAR2 | (4000) | Task Number | |
| TASK_NAME | VARCHAR2 | (4000) | Task Name | |
| TASK_ID | NUMBER | Task Id | ||
| PARENT_WIP_ENTITY_ID | NUMBER | Parent Wip Entity Id - Parent Work Order Id | ||
| BOM_REFERENCE_ID | NUMBER | Bill of Materials Reference Id | ||
| ROUTING_REFERENCE_ID | NUMBER | Routing Reference Id | ||
| COMMON_BOM_SEQUENCE_ID | NUMBER | Common BOM Sequence Id | ||
| COMMON_ROUTING_SEQUENCE_ID | NUMBER | Common Routing Sequence Id | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate BOM Designator | |
| BOM_REVISION | VARCHAR2 | (3) | Revision of Bill of Materials | |
| BOM_REVISION_DATE | DATE | Revision Date of Bill of Materials | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate Routing Designator | |
| ROUTING_REVISION | VARCHAR2 | (3) | Routing Revision | |
| ROUTING_REVISION_DATE | DATE | Routing Revision Date | ||
| COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Completion Subinventory | |
| COMPLETION_LOCATOR_ID | NUMBER | Completion Locator Id | ||
| LOT_NUMBER | VARCHAR2 | (80) | Lot Number | |
| DEMAND_CLASS | VARCHAR2 | (30) | Demand Class | |
| ISSUE_ZERO_COST_FLAG | VARCHAR2 | (1) | Issue asset items from Expense subinventory at Zero cost | |
| ISSUE_ZERO_COST_FLAG_DISP | VARCHAR2 | (80) | Yes | Issue zero cost flag-Meaning from Lookup |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
| MAINTENANCE_OBJECT_SOURCE | NUMBER | Maintenance Object Source | ||
| MAINTENANCE_OBJECT_TYPE | NUMBER | Maintenance Object Type | ||
| MAINTENANCE_OBJECT_ID | NUMBER | Maintenance Object Id | ||
| MATERIAL_ISSUE_BY_MO | VARCHAR2 | (1) | Material Issue By Move Order | |
| MATERIAL_ISSUE_BY_MO_DISP | VARCHAR2 | (80) | Yes | Material Issue By Move Order-Meaning from Lookup |
| ACTIVITY_SOURCE_ID | VARCHAR2 | (30) | Activity Source Id | |
| ACTIVITY_SOURCE | VARCHAR2 | (80) | Activity Source | |
| EAM_LINEAR_LOCATION_ID | NUMBER | Linear Asset Location Identifier | ||
| LOCATION_NAME | VARCHAR2 | (70) | Location Name | |
| LOCATION_CODE | VARCHAR2 | (90) | Another way of uniquely identifying a location. The locations are classified as: BUILDING, FLOOR and OFFICE. Oracle Property Manager generates this unique code based on the input provided by the user in the location_alias data element. | |
| EAM_PN_LOCATION_ID | NUMBER | eAM PN Location Id | ||
| AREA | VARCHAR2 | (4000) | Asset Area | |
| PENDING_FLAG | VARCHAR2 | (1) | Stores whether status change has some pending approval.Y indicates status is pending, N or Null indicates not pending | |
| MATERIAL_SHORTAGE_CHECK_DATE | DATE | Material Shortage check date | ||
| MATERIAL_SHORTAGE_FLAG | NUMBER | Stores the material shortage status of the workorder. 2 if all material is available, 1 if some/all material is not available, null if shortage has not been calculated yet, 3 if an error occurred when calculating the shortage | ||
| MATERIAL_SHORTAGE_DISP | VARCHAR2 | (80) | Material Shortage Flag-Meaning from Lookup | |
| WORKFLOW_TYPE | NUMBER | Stores the Workflow Type to find the workflow process to be followed. Maps to lookup_code for EAM_WORKFLOW_TYPE lookup type | ||
| WORKFLOW_TYPE_DISP | VARCHAR2 | (80) | Workflow Type-Meaning from Lookup | |
| WARRANTY_CLAIM_STATUS | NUMBER | The status of the warranty claim. | ||
| WARRANTY_CLAIM_STATUS_DISP | VARCHAR2 | (80) | Warranty Claim Status-Meaning from Lookup | |
| ASSIGNMENT_COMPLETE | VARCHAR2 | (1) | Assignment status of work order | |
| ASSIGNMENT_COMPLETE_DISP | VARCHAR2 | (80) | Yes | Assignment Complete- Meaning from Lookup |
| CYCLE_ID | NUMBER | Used by Multiple Asset Activity PM | ||
| SEQ_ID | NUMBER | Used by Multiple Asset Activity PM | ||
| DS_SCHEDULED_FLAG | VARCHAR2 | (1) | Identify if the Detailed Scheduler has scheduled the work order. | |
| USER_DEFINED_STATUS_ID | NUMBER | User defined work order status | ||
| USER_DEFINED_STATUS_DISP | VARCHAR2 | (4000) | User defined work order status-Meaning from Lookup | |
| PM_SUGGESTED_START_DATE | DATE | Original Scheduled Start Date | ||
| PM_SUGGESTED_END_DATE | DATE | Original Scheduled End Date | ||
| PM_BASE_METER_READING | NUMBER | Stores the PM Base Meter Reading based on which work order is generated | ||
| PM_BASE_METER_ID | NUMBER | Stores the PM Base Meter Id based on which work order is generated | ||
| PM_BASE_METER_NAME | VARCHAR2 | (80) | Stores the PM Base Meter Name based on which work order is generated |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, WIP_ENTITY_NAME
, ENTITY_TYPE
, ORGANIZATION_ID
, DESCRIPTION
, ASSET_GROUP_ID
, ASSET_GROUP
, ASSET_GROUP_DESCRIPTION
, INSTANCE_ID
, ASSET_NUMBER
, ASSET_SERIAL_NUMBER
, ASSET_NUMBER_DESCRIPTION
, ASSET_TYPE
, ASSET_TYPE_DISP
, ASSET_ACTIVITY_ID
, ASSET_ACTIVITY
, ASSET_ACTIVITY_DESCRIPTION
, CLASS_CODE
, SYSTEM_STATUS_TYPE
, SYSTEM_STATUS_DISP
, PM_SCHEDULE_ID
, MANUAL_REBUILD_FLAG
, MANUAL_REBUILD_FLAG_DISP
, WORK_ORDER_TYPE
, WORK_ORDER_TYPE_DISP
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, MATERIAL_VARIANCE_ACCOUNT
, RESOURCE_VARIANCE_ACCOUNT
, OUTSIDE_PROC_VARIANCE_ACCOUNT
, STD_COST_ADJUSTMENT_ACCOUNT
, OVERHEAD_ACCOUNT
, OVERHEAD_VARIANCE_ACCOUNT
, SCHEDULED_START_DATE
, SCHEDULED_COMPLETION_DATE
, DATE_RELEASED
, DATE_COMPLETED
, DATE_CLOSED
, OWNING_DEPARTMENT_ID
, OWNING_DEPARTMENT_CODE
, ACTIVITY_TYPE
, ACTIVITY_TYPE_DISP
, ACTIVITY_CAUSE
, ACTIVITY_CAUSE_DISP
, PRIORITY
, PRIORITY_DISP
, REQUESTED_START_DATE
, DUE_DATE
, ESTIMATION_STATUS
, ESTIMATION_STATUS_DISP
, NOTIFICATION_REQUIRED
, NOTIFICATION_REQUIRED_DISP
, SHUTDOWN_TYPE
, SHUTDOWN_TYPE_DISP
, SHUTDOWN_START_DATE
, SHUTDOWN_END_DATE
, TAGOUT_REQUIRED
, TAGOUT_REQUIRED_DISP
, PLAN_MAINTENANCE
, PLAN_MAINTENANCE_DISP
, FIRM_PLANNED_FLAG
, FIRM_PLANNED_FLAG_DISP
, SCHEDULE_GROUP_ID
, SCHEDULE_GROUP_NAME
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ID
, TASK_NUMBER
, TASK_NAME
, TASK_ID
, PARENT_WIP_ENTITY_ID
, BOM_REFERENCE_ID
, ROUTING_REFERENCE_ID
, COMMON_BOM_SEQUENCE_ID
, COMMON_ROUTING_SEQUENCE_ID
, ALTERNATE_BOM_DESIGNATOR
, BOM_REVISION
, BOM_REVISION_DATE
, ALTERNATE_ROUTING_DESIGNATOR
, ROUTING_REVISION
, ROUTING_REVISION_DATE
, COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID
, LOT_NUMBER
, DEMAND_CLASS
, ISSUE_ZERO_COST_FLAG
, ISSUE_ZERO_COST_FLAG_DISP
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MAINTENANCE_OBJECT_SOURCE
, MAINTENANCE_OBJECT_TYPE
, MAINTENANCE_OBJECT_ID
, MATERIAL_ISSUE_BY_MO
, MATERIAL_ISSUE_BY_MO_DISP
, ACTIVITY_SOURCE_ID
, ACTIVITY_SOURCE
, EAM_LINEAR_LOCATION_ID
, LOCATION_NAME
, LOCATION_CODE
, EAM_PN_LOCATION_ID
, AREA
, PENDING_FLAG
, MATERIAL_SHORTAGE_CHECK_DATE
, MATERIAL_SHORTAGE_FLAG
, MATERIAL_SHORTAGE_DISP
, WORKFLOW_TYPE
, WORKFLOW_TYPE_DISP
, WARRANTY_CLAIM_STATUS
, WARRANTY_CLAIM_STATUS_DISP
, ASSIGNMENT_COMPLETE
, ASSIGNMENT_COMPLETE_DISP
, CYCLE_ID
, SEQ_ID
, DS_SCHEDULED_FLAG
, USER_DEFINED_STATUS_ID
, USER_DEFINED_STATUS_DISP
, PM_SUGGESTED_START_DATE
, PM_SUGGESTED_END_DATE
, PM_BASE_METER_READING
, PM_BASE_METER_ID
, PM_BASE_METER_NAME
FROM APPS.EAM_CFR_WORK_ORDER_V;
APPS
BOM_DEPARTMENTS
CSI_COUNTERS_TL
CSI_ITEM_INSTANCES
EAM_ASSET_STATUS_HISTORY
EAM_COMMON_UTILITIES_PVT
- show dependent code
EAM_WORK_ORDER_DETAILS
EAM_WO_STATUSES_V
FND_MESSAGE
- show dependent code
MFG_LOOKUPS
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_KFV
PJM_PROJECT
- show dependent code
PN_LOCATIONS_ALL
WIP_DISCRETE_JOBS
WIP_ENTITIES
WIP_SCHEDULE_GROUPS
APPS.EAM_CFR_WORK_ORDER_V is not referenced by any database object
|
|
|
|