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

VIEW: WIP.WIP_COMPLETION_INTERFACE#

Object Details
Object Name: WIP_COMPLETION_INTERFACE#
Object Type: VIEW
Owner: WIP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

BATCH_ID NUMBER

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 VARCHAR2 (240)
MAINTENANCE_OBJECT_SOURCE NUMBER

EAM_LINEAR_LOCATION_ID 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

PM_SUGGESTED_START_DATE DATE

PM_SUGGESTED_END_DATE DATE

PM_BASE_METER_READING NUMBER

PM_BASE_METER NUMBER

COMMON_BOM_SEQUENCE_ID NUMBER

COMMON_ROUTING_SEQUENCE_ID NUMBER

PO_CREATION_TIME NUMBER

GEN_OBJECT_ID NUMBER

USER_DEFINED_STATUS_ID NUMBER

PENDING_FLAG VARCHAR2 (1)
MATERIAL_SHORTAGE_CHECK_DATE DATE

MATERIAL_SHORTAGE_FLAG NUMBER

WORKFLOW_TYPE NUMBER

WARRANTY_CLAIM_STATUS NUMBER

CYCLE_ID NUMBER

SEQ_ID NUMBER

DS_SCHEDULED_FLAG VARCHAR2 (1)
WARRANTY_ACTIVE NUMBER

ASSIGNMENT_COMPLETE VARCHAR2 (1)
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)
REPORT_TYPE NUMBER

ACTUAL_CLOSE_DATE DATE

SUBMISSION_DATE DATE

USER_ID NUMBER

RESPONSIBILITY_ID NUMBER

REQUEST_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

SOURCE_LINE_ID NUMBER

SOURCE_CODE VARCHAR2 (30)
VALIDATE_STRUCTURE VARCHAR2 (1)
RETURN_STATUS VARCHAR2 (1)
TRANSACTION_TYPE VARCHAR2 (1)
FAILURE_CODE_REQUIRED VARCHAR2 (1)
LAST_UPDATE_DATE DATE

CREATION_DATE DATE

LAST_UPDATED_BY NUMBER

CREATED_BY NUMBER

ENTITY_TYPE NUMBER

TRANSACTION_DATE DATE

ACTUAL_START_DATE DATE

ACTUAL_END_DATE DATE

ACTUAL_DURATION NUMBER

Query Text

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


SELECT HEADER_ID
,      BATCH_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
,      EAM_LINEAR_LOCATION_ID
,      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
,      PM_SUGGESTED_START_DATE
,      PM_SUGGESTED_END_DATE
,      PM_BASE_METER_READING
,      PM_BASE_METER
,      COMMON_BOM_SEQUENCE_ID
,      COMMON_ROUTING_SEQUENCE_ID
,      PO_CREATION_TIME
,      GEN_OBJECT_ID
,      USER_DEFINED_STATUS_ID
,      PENDING_FLAG
,      MATERIAL_SHORTAGE_CHECK_DATE
,      MATERIAL_SHORTAGE_FLAG
,      WORKFLOW_TYPE
,      WARRANTY_CLAIM_STATUS
,      CYCLE_ID
,      SEQ_ID
,      DS_SCHEDULED_FLAG
,      WARRANTY_ACTIVE
,      ASSIGNMENT_COMPLETE
,      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
,      REPORT_TYPE
,      ACTUAL_CLOSE_DATE
,      SUBMISSION_DATE
,      USER_ID
,      RESPONSIBILITY_ID
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      SOURCE_LINE_ID
,      SOURCE_CODE
,      VALIDATE_STRUCTURE
,      RETURN_STATUS
,      TRANSACTION_TYPE
,      FAILURE_CODE_REQUIRED
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      ENTITY_TYPE
,      TRANSACTION_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      ACTUAL_DURATION
FROM WIP.WIP_COMPLETION_INTERFACE#;

Dependencies

[top of page]

WIP.WIP_COMPLETION_INTERFACE# references the following:

SchemaWIP
TableWIP_COMPLETION_INTERFACE
WIP.WIP_COMPLETION_INTERFACE# is referenced by following:

SchemaAPPS
SynonymWIP_COMPLETION_INTERFACE