VIEW: WIP.WIP_COMPLETION_INTERFACE#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, BATCH_ID BATCH_ID, ROW_ID ROW_ID, WIP_ENTITY_NAME WIP_ENTITY_NAME, WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, DESCRIPTION DESCRIPTION, ASSET_NUMBER ASSET_NUMBER, ASSET_GROUP_ID ASSET_GROUP_ID, REBUILD_ITEM_ID REBUILD_ITEM_ID, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE, EAM_LINEAR_LOCATION_ID EAM_LINEAR_LOCATION_ID, CLASS_CODE CLASS_CODE, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID, ACTIVITY_TYPE ACTIVITY_TYPE, ACTIVITY_CAUSE ACTIVITY_CAUSE, ACTIVITY_SOURCE ACTIVITY_SOURCE, WORK_ORDER_TYPE WORK_ORDER_TYPE, STATUS_TYPE STATUS_TYPE, JOB_QUANTITY JOB_QUANTITY, DATE_RELEASED DATE_RELEASED, OWNING_DEPARTMENT OWNING_DEPARTMENT, PRIORITY PRIORITY, REQUESTED_START_DATE REQUESTED_START_DATE, DUE_DATE DUE_DATE, SHUTDOWN_TYPE SHUTDOWN_TYPE, FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG, NOTIFICATION_REQUIRED NOTIFICATION_REQUIRED, TAGOUT_REQUIRED TAGOUT_REQUIRED, PLAN_MAINTENANCE PLAN_MAINTENANCE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, BOM_REVISION_DATE BOM_REVISION_DATE, ROUTING_REVISION_DATE ROUTING_REVISION_DATE, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ROUTING_REVISION ROUTING_REVISION, BOM_REVISION BOM_REVISION, PARENT_WIP_ENTITY_ID PARENT_WIP_ENTITY_ID, MANUAL_REBUILD_FLAG MANUAL_REBUILD_FLAG, PM_SCHEDULE_ID PM_SCHEDULE_ID, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, MATERIAL_ACCOUNT MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT, MATERIAL_VARIANCE_ACCOUNT MATERIAL_VARIANCE_ACCOUNT, RESOURCE_VARIANCE_ACCOUNT RESOURCE_VARIANCE_ACCOUNT, OUTSIDE_PROC_VARIANCE_ACCOUNT OUTSIDE_PROC_VARIANCE_ACCOUNT, STD_COST_ADJUSTMENT_ACCOUNT STD_COST_ADJUSTMENT_ACCOUNT, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT, OVERHEAD_VARIANCE_ACCOUNT OVERHEAD_VARIANCE_ACCOUNT, SCHEDULED_START_DATE SCHEDULED_START_DATE, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE, PM_SUGGESTED_START_DATE PM_SUGGESTED_START_DATE, PM_SUGGESTED_END_DATE PM_SUGGESTED_END_DATE, PM_BASE_METER_READING PM_BASE_METER_READING, PM_BASE_METER PM_BASE_METER, COMMON_BOM_SEQUENCE_ID COMMON_BOM_SEQUENCE_ID, COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID, PO_CREATION_TIME PO_CREATION_TIME, GEN_OBJECT_ID GEN_OBJECT_ID, USER_DEFINED_STATUS_ID USER_DEFINED_STATUS_ID, PENDING_FLAG PENDING_FLAG, MATERIAL_SHORTAGE_CHECK_DATE MATERIAL_SHORTAGE_CHECK_DATE, MATERIAL_SHORTAGE_FLAG MATERIAL_SHORTAGE_FLAG, WORKFLOW_TYPE WORKFLOW_TYPE, WARRANTY_CLAIM_STATUS WARRANTY_CLAIM_STATUS, CYCLE_ID CYCLE_ID, SEQ_ID SEQ_ID, DS_SCHEDULED_FLAG DS_SCHEDULED_FLAG, WARRANTY_ACTIVE WARRANTY_ACTIVE, ASSIGNMENT_COMPLETE ASSIGNMENT_COMPLETE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, MATERIAL_ISSUE_BY_MO MATERIAL_ISSUE_BY_MO, ISSUE_ZERO_COST_FLAG ISSUE_ZERO_COST_FLAG, REPORT_TYPE REPORT_TYPE, ACTUAL_CLOSE_DATE ACTUAL_CLOSE_DATE, SUBMISSION_DATE SUBMISSION_DATE, USER_ID USER_ID, RESPONSIBILITY_ID RESPONSIBILITY_ID, REQUEST_ID REQUEST_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_CODE SOURCE_CODE, VALIDATE_STRUCTURE VALIDATE_STRUCTURE, RETURN_STATUS RETURN_STATUS, TRANSACTION_TYPE TRANSACTION_TYPE, FAILURE_CODE_REQUIRED FAILURE_CODE_REQUIRED, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, ENTITY_TYPE ENTITY_TYPE, TRANSACTION_DATE TRANSACTION_DATE, ACTUAL_START_DATE ACTUAL_START_DATE, ACTUAL_END_DATE ACTUAL_END_DATE, ACTUAL_DURATION ACTUAL_DURATION from "WIP"."WIP_COMPLETION_INTERFACE"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, BATCH_ID BATCH_ID
, ROW_ID ROW_ID
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DESCRIPTION DESCRIPTION
, ASSET_NUMBER ASSET_NUMBER
, ASSET_GROUP_ID ASSET_GROUP_ID
, REBUILD_ITEM_ID REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER
, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID
, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE
, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE
, EAM_LINEAR_LOCATION_ID EAM_LINEAR_LOCATION_ID
, CLASS_CODE CLASS_CODE
, ASSET_ACTIVITY_ID ASSET_ACTIVITY_ID
, ACTIVITY_TYPE ACTIVITY_TYPE
, ACTIVITY_CAUSE ACTIVITY_CAUSE
, ACTIVITY_SOURCE ACTIVITY_SOURCE
, WORK_ORDER_TYPE WORK_ORDER_TYPE
, STATUS_TYPE STATUS_TYPE
, JOB_QUANTITY JOB_QUANTITY
, DATE_RELEASED DATE_RELEASED
, OWNING_DEPARTMENT OWNING_DEPARTMENT
, PRIORITY PRIORITY
, REQUESTED_START_DATE REQUESTED_START_DATE
, DUE_DATE DUE_DATE
, SHUTDOWN_TYPE SHUTDOWN_TYPE
, FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG
, NOTIFICATION_REQUIRED NOTIFICATION_REQUIRED
, TAGOUT_REQUIRED TAGOUT_REQUIRED
, PLAN_MAINTENANCE PLAN_MAINTENANCE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID
, BOM_REVISION_DATE BOM_REVISION_DATE
, ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ROUTING_REVISION ROUTING_REVISION
, BOM_REVISION BOM_REVISION
, PARENT_WIP_ENTITY_ID PARENT_WIP_ENTITY_ID
, MANUAL_REBUILD_FLAG MANUAL_REBUILD_FLAG
, PM_SCHEDULE_ID PM_SCHEDULE_ID
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, MATERIAL_ACCOUNT MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT OUTSIDE_PROCESSING_ACCOUNT
, MATERIAL_VARIANCE_ACCOUNT MATERIAL_VARIANCE_ACCOUNT
, RESOURCE_VARIANCE_ACCOUNT RESOURCE_VARIANCE_ACCOUNT
, OUTSIDE_PROC_VARIANCE_ACCOUNT OUTSIDE_PROC_VARIANCE_ACCOUNT
, STD_COST_ADJUSTMENT_ACCOUNT STD_COST_ADJUSTMENT_ACCOUNT
, OVERHEAD_ACCOUNT OVERHEAD_ACCOUNT
, OVERHEAD_VARIANCE_ACCOUNT OVERHEAD_VARIANCE_ACCOUNT
, SCHEDULED_START_DATE SCHEDULED_START_DATE
, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
, PM_SUGGESTED_START_DATE PM_SUGGESTED_START_DATE
, PM_SUGGESTED_END_DATE PM_SUGGESTED_END_DATE
, PM_BASE_METER_READING PM_BASE_METER_READING
, PM_BASE_METER PM_BASE_METER
, COMMON_BOM_SEQUENCE_ID COMMON_BOM_SEQUENCE_ID
, COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID
, PO_CREATION_TIME PO_CREATION_TIME
, GEN_OBJECT_ID GEN_OBJECT_ID
, USER_DEFINED_STATUS_ID USER_DEFINED_STATUS_ID
, PENDING_FLAG PENDING_FLAG
, MATERIAL_SHORTAGE_CHECK_DATE MATERIAL_SHORTAGE_CHECK_DATE
, MATERIAL_SHORTAGE_FLAG MATERIAL_SHORTAGE_FLAG
, WORKFLOW_TYPE WORKFLOW_TYPE
, WARRANTY_CLAIM_STATUS WARRANTY_CLAIM_STATUS
, CYCLE_ID CYCLE_ID
, SEQ_ID SEQ_ID
, DS_SCHEDULED_FLAG DS_SCHEDULED_FLAG
, WARRANTY_ACTIVE WARRANTY_ACTIVE
, ASSIGNMENT_COMPLETE ASSIGNMENT_COMPLETE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, MATERIAL_ISSUE_BY_MO MATERIAL_ISSUE_BY_MO
, ISSUE_ZERO_COST_FLAG ISSUE_ZERO_COST_FLAG
, REPORT_TYPE REPORT_TYPE
, ACTUAL_CLOSE_DATE ACTUAL_CLOSE_DATE
, SUBMISSION_DATE SUBMISSION_DATE
, USER_ID USER_ID
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_CODE SOURCE_CODE
, VALIDATE_STRUCTURE VALIDATE_STRUCTURE
, RETURN_STATUS RETURN_STATUS
, TRANSACTION_TYPE TRANSACTION_TYPE
, FAILURE_CODE_REQUIRED FAILURE_CODE_REQUIRED
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, ENTITY_TYPE ENTITY_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTUAL_END_DATE ACTUAL_END_DATE
, ACTUAL_DURATION ACTUAL_DURATION
FROM "WIP"."WIP_COMPLETION_INTERFACE"