Skip to content

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

VIEW: EAM.EAM_WORK_ORDER_IMPORT#

Object Details
Object Name: EAM_WORK_ORDER_IMPORT#
Object Type: VIEW
Owner: EAM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes
GROUP_ID NUMBER
Yes
ROW_ID NUMBER

WIP_ENTITY_NAME VARCHAR2 (240)
WIP_ENTITY_ID NUMBER

ORGANIZATION_ID NUMBER

DESCRIPTION VARCHAR2 (240)
ASSET_NUMBER VARCHAR2 (30)
ASSET_GROUP_ID NUMBER

REBUILD_ITEM_ID NUMBER

REBUILD_SERIAL_NUMBER VARCHAR2 (30)
MAINTENANCE_OBJECT_ID NUMBER

MAINTENANCE_OBJECT_TYPE NUMBER

MAINTENANCE_OBJECT_SOURCE NUMBER

CLASS_CODE VARCHAR2 (10)
ASSET_ACTIVITY_ID NUMBER

ACTIVITY_TYPE VARCHAR2 (30)
ACTIVITY_CAUSE VARCHAR2 (30)
ACTIVITY_SOURCE VARCHAR2 (30)
WORK_ORDER_TYPE VARCHAR2 (30)
STATUS_TYPE NUMBER

JOB_QUANTITY NUMBER

DATE_RELEASED DATE

OWNING_DEPARTMENT NUMBER

PRIORITY NUMBER

REQUESTED_START_DATE DATE

DUE_DATE DATE

SHUTDOWN_TYPE VARCHAR2 (30)
FIRM_PLANNED_FLAG NUMBER

NOTIFICATION_REQUIRED VARCHAR2 (1)
TAGOUT_REQUIRED VARCHAR2 (1)
PLAN_MAINTENANCE VARCHAR2 (1)
PROJECT_ID NUMBER

TASK_ID NUMBER

END_ITEM_UNIT_NUMBER VARCHAR2 (30)
SCHEDULE_GROUP_ID NUMBER

BOM_REVISION_DATE DATE

ROUTING_REVISION_DATE DATE

ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
ROUTING_REVISION VARCHAR2 (3)
BOM_REVISION VARCHAR2 (3)
PARENT_WIP_ENTITY_ID NUMBER

MANUAL_REBUILD_FLAG VARCHAR2 (1)
PM_SCHEDULE_ID NUMBER

WIP_SUPPLY_TYPE NUMBER

MATERIAL_ACCOUNT NUMBER

MATERIAL_OVERHEAD_ACCOUNT NUMBER

RESOURCE_ACCOUNT NUMBER

OUTSIDE_PROCESSING_ACCOUNT NUMBER

MATERIAL_VARIANCE_ACCOUNT NUMBER

RESOURCE_VARIANCE_ACCOUNT NUMBER

OUTSIDE_PROC_VARIANCE_ACCOUNT NUMBER

STD_COST_ADJUSTMENT_ACCOUNT NUMBER

OVERHEAD_ACCOUNT NUMBER

OVERHEAD_VARIANCE_ACCOUNT NUMBER

SCHEDULED_START_DATE DATE

SCHEDULED_COMPLETION_DATE DATE

COMMON_BOM_SEQUENCE_ID NUMBER

COMMON_ROUTING_SEQUENCE_ID NUMBER

PO_CREATION_TIME NUMBER

GEN_OBJECT_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
MATERIAL_ISSUE_BY_MO VARCHAR2 (1)
ISSUE_ZERO_COST_FLAG VARCHAR2 (1)
USER_ID NUMBER

RESPONSIBILITY_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

SOURCE_LINE_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
PROCESS_STATUS NUMBER

TOP_WIP_ENTITY_ID NUMBER

RETURN_STATUS VARCHAR2 (1)
TRANSACTION_TYPE NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT HEADER_ID
,      GROUP_ID
,      ROW_ID
,      WIP_ENTITY_NAME
,      WIP_ENTITY_ID
,      ORGANIZATION_ID
,      DESCRIPTION
,      ASSET_NUMBER
,      ASSET_GROUP_ID
,      REBUILD_ITEM_ID
,      REBUILD_SERIAL_NUMBER
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_SOURCE
,      CLASS_CODE
,      ASSET_ACTIVITY_ID
,      ACTIVITY_TYPE
,      ACTIVITY_CAUSE
,      ACTIVITY_SOURCE
,      WORK_ORDER_TYPE
,      STATUS_TYPE
,      JOB_QUANTITY
,      DATE_RELEASED
,      OWNING_DEPARTMENT
,      PRIORITY
,      REQUESTED_START_DATE
,      DUE_DATE
,      SHUTDOWN_TYPE
,      FIRM_PLANNED_FLAG
,      NOTIFICATION_REQUIRED
,      TAGOUT_REQUIRED
,      PLAN_MAINTENANCE
,      PROJECT_ID
,      TASK_ID
,      END_ITEM_UNIT_NUMBER
,      SCHEDULE_GROUP_ID
,      BOM_REVISION_DATE
,      ROUTING_REVISION_DATE
,      ALTERNATE_ROUTING_DESIGNATOR
,      ALTERNATE_BOM_DESIGNATOR
,      ROUTING_REVISION
,      BOM_REVISION
,      PARENT_WIP_ENTITY_ID
,      MANUAL_REBUILD_FLAG
,      PM_SCHEDULE_ID
,      WIP_SUPPLY_TYPE
,      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
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      PO_CREATION_TIME
,      GEN_OBJECT_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MATERIAL_ISSUE_BY_MO
,      ISSUE_ZERO_COST_FLAG
,      USER_ID
,      RESPONSIBILITY_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      SOURCE_LINE_ID
,      SOURCE_CODE
,      PROCESS_STATUS
,      TOP_WIP_ENTITY_ID
,      RETURN_STATUS
,      TRANSACTION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_WORK_ORDER_IMPORT#;

Dependencies

[top of page]

EAM.EAM_WORK_ORDER_IMPORT# references the following:

SchemaEAM
TableEAM_WORK_ORDER_IMPORT
EAM.EAM_WORK_ORDER_IMPORT# is referenced by following:

SchemaAPPS
SynonymEAM_WORK_ORDER_IMPORT