DBA Data[Home] [Help]

VIEW: WIP.WIP_DISCRETE_JOBS#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SOURCE_LINE_ID SOURCE_LINE_ID, SOURCE_CODE SOURCE_CODE, DESCRIPTION DESCRIPTION, STATUS_TYPE STATUS_TYPE, PRIMARY_ITEM_ID PRIMARY_ITEM_ID, FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG, JOB_TYPE JOB_TYPE, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, CLASS_CODE CLASS_CODE, 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, DATE_RELEASED DATE_RELEASED, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE, DATE_COMPLETED DATE_COMPLETED, DATE_CLOSED DATE_CLOSED, START_QUANTITY START_QUANTITY, QUANTITY_COMPLETED QUANTITY_COMPLETED, QUANTITY_SCRAPPED QUANTITY_SCRAPPED, NET_QUANTITY NET_QUANTITY, BOM_REFERENCE_ID BOM_REFERENCE_ID, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID, COMMON_BOM_SEQUENCE_ID COMMON_BOM_SEQUENCE_ID, COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID, BOM_REVISION BOM_REVISION, ROUTING_REVISION ROUTING_REVISION, BOM_REVISION_DATE BOM_REVISION_DATE, ROUTING_REVISION_DATE ROUTING_REVISION_DATE, LOT_NUMBER LOT_NUMBER, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID, MPS_SCHEDULED_COMPLETION_DATE MPS_SCHEDULED_COMPLETION_DATE, MPS_NET_QUANTITY MPS_NET_QUANTITY, DEMAND_CLASS DEMAND_CLASS, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID, BUILD_SEQUENCE BUILD_SEQUENCE, LINE_ID LINE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, KANBAN_CARD_ID KANBAN_CARD_ID, OVERCOMPLETION_TOLERANCE_TYPE OVERCOMPLETION_TOLERANCE_TYPE, OVERCOMPLETION_TOLERANCE_VALUE OVERCOMPLETION_TOLERANCE_VALUE, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, 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, PO_CREATION_TIME PO_CREATION_TIME, PRIORITY PRIORITY, DUE_DATE DUE_DATE, EST_SCRAP_ACCOUNT EST_SCRAP_ACCOUNT, EST_SCRAP_VAR_ACCOUNT EST_SCRAP_VAR_ACCOUNT, EST_SCRAP_PRIOR_QTY EST_SCRAP_PRIOR_QTY, DUE_DATE_PENALTY DUE_DATE_PENALTY, DUE_DATE_TOLERANCE DUE_DATE_TOLERANCE, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY, PARENT_WIP_ENTITY_ID PARENT_WIP_ENTITY_ID, ASSET_NUMBER ASSET_NUMBER, ASSET_GROUP_ID ASSET_GROUP_ID, REBUILD_ITEM_ID REBUILD_ITEM_ID, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER, MANUAL_REBUILD_FLAG MANUAL_REBUILD_FLAG, SHUTDOWN_TYPE SHUTDOWN_TYPE, ESTIMATION_STATUS ESTIMATION_STATUS, REQUESTED_START_DATE REQUESTED_START_DATE, NOTIFICATION_REQUIRED NOTIFICATION_REQUIRED, WORK_ORDER_TYPE WORK_ORDER_TYPE, OWNING_DEPARTMENT OWNING_DEPARTMENT, ACTIVITY_TYPE ACTIVITY_TYPE, ACTIVITY_CAUSE ACTIVITY_CAUSE, TAGOUT_REQUIRED TAGOUT_REQUIRED, PLAN_MAINTENANCE PLAN_MAINTENANCE, PM_SCHEDULE_ID PM_SCHEDULE_ID, LAST_ESTIMATION_DATE LAST_ESTIMATION_DATE, LAST_ESTIMATION_REQ_ID LAST_ESTIMATION_REQ_ID, ACTIVITY_SOURCE ACTIVITY_SOURCE, SERIALIZATION_START_OP SERIALIZATION_START_OP, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE, MATERIAL_ISSUE_BY_MO MATERIAL_ISSUE_BY_MO, SCHEDULING_REQUEST_ID SCHEDULING_REQUEST_ID, ISSUE_ZERO_COST_FLAG ISSUE_ZERO_COST_FLAG, EAM_LINEAR_LOCATION_ID EAM_LINEAR_LOCATION_ID, ACTUAL_START_DATE ACTUAL_START_DATE, EXPECTED_HOLD_RELEASE_DATE EXPECTED_HOLD_RELEASE_DATE, EXPEDITED EXPEDITED, JOB_NOTE JOB_NOTE from "WIP"."WIP_DISCRETE_JOBS"
View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SOURCE_LINE_ID SOURCE_LINE_ID
, SOURCE_CODE SOURCE_CODE
, DESCRIPTION DESCRIPTION
, STATUS_TYPE STATUS_TYPE
, PRIMARY_ITEM_ID PRIMARY_ITEM_ID
, FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG
, JOB_TYPE JOB_TYPE
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, CLASS_CODE CLASS_CODE
, 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
, DATE_RELEASED DATE_RELEASED
, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
, DATE_COMPLETED DATE_COMPLETED
, DATE_CLOSED DATE_CLOSED
, START_QUANTITY START_QUANTITY
, QUANTITY_COMPLETED QUANTITY_COMPLETED
, QUANTITY_SCRAPPED QUANTITY_SCRAPPED
, NET_QUANTITY NET_QUANTITY
, BOM_REFERENCE_ID BOM_REFERENCE_ID
, ROUTING_REFERENCE_ID ROUTING_REFERENCE_ID
, COMMON_BOM_SEQUENCE_ID COMMON_BOM_SEQUENCE_ID
, COMMON_ROUTING_SEQUENCE_ID COMMON_ROUTING_SEQUENCE_ID
, BOM_REVISION BOM_REVISION
, ROUTING_REVISION ROUTING_REVISION
, BOM_REVISION_DATE BOM_REVISION_DATE
, ROUTING_REVISION_DATE ROUTING_REVISION_DATE
, LOT_NUMBER LOT_NUMBER
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, COMPLETION_SUBINVENTORY COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID COMPLETION_LOCATOR_ID
, MPS_SCHEDULED_COMPLETION_DATE MPS_SCHEDULED_COMPLETION_DATE
, MPS_NET_QUANTITY MPS_NET_QUANTITY
, DEMAND_CLASS DEMAND_CLASS
, SCHEDULE_GROUP_ID SCHEDULE_GROUP_ID
, BUILD_SEQUENCE BUILD_SEQUENCE
, LINE_ID LINE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, KANBAN_CARD_ID KANBAN_CARD_ID
, OVERCOMPLETION_TOLERANCE_TYPE OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE OVERCOMPLETION_TOLERANCE_VALUE
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, 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
, PO_CREATION_TIME PO_CREATION_TIME
, PRIORITY PRIORITY
, DUE_DATE DUE_DATE
, EST_SCRAP_ACCOUNT EST_SCRAP_ACCOUNT
, EST_SCRAP_VAR_ACCOUNT EST_SCRAP_VAR_ACCOUNT
, EST_SCRAP_PRIOR_QTY EST_SCRAP_PRIOR_QTY
, DUE_DATE_PENALTY DUE_DATE_PENALTY
, DUE_DATE_TOLERANCE DUE_DATE_TOLERANCE
, COPRODUCTS_SUPPLY COPRODUCTS_SUPPLY
, PARENT_WIP_ENTITY_ID PARENT_WIP_ENTITY_ID
, ASSET_NUMBER ASSET_NUMBER
, ASSET_GROUP_ID ASSET_GROUP_ID
, REBUILD_ITEM_ID REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER REBUILD_SERIAL_NUMBER
, MANUAL_REBUILD_FLAG MANUAL_REBUILD_FLAG
, SHUTDOWN_TYPE SHUTDOWN_TYPE
, ESTIMATION_STATUS ESTIMATION_STATUS
, REQUESTED_START_DATE REQUESTED_START_DATE
, NOTIFICATION_REQUIRED NOTIFICATION_REQUIRED
, WORK_ORDER_TYPE WORK_ORDER_TYPE
, OWNING_DEPARTMENT OWNING_DEPARTMENT
, ACTIVITY_TYPE ACTIVITY_TYPE
, ACTIVITY_CAUSE ACTIVITY_CAUSE
, TAGOUT_REQUIRED TAGOUT_REQUIRED
, PLAN_MAINTENANCE PLAN_MAINTENANCE
, PM_SCHEDULE_ID PM_SCHEDULE_ID
, LAST_ESTIMATION_DATE LAST_ESTIMATION_DATE
, LAST_ESTIMATION_REQ_ID LAST_ESTIMATION_REQ_ID
, ACTIVITY_SOURCE ACTIVITY_SOURCE
, SERIALIZATION_START_OP SERIALIZATION_START_OP
, MAINTENANCE_OBJECT_ID MAINTENANCE_OBJECT_ID
, MAINTENANCE_OBJECT_TYPE MAINTENANCE_OBJECT_TYPE
, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE
, MATERIAL_ISSUE_BY_MO MATERIAL_ISSUE_BY_MO
, SCHEDULING_REQUEST_ID SCHEDULING_REQUEST_ID
, ISSUE_ZERO_COST_FLAG ISSUE_ZERO_COST_FLAG
, EAM_LINEAR_LOCATION_ID EAM_LINEAR_LOCATION_ID
, ACTUAL_START_DATE ACTUAL_START_DATE
, EXPECTED_HOLD_RELEASE_DATE EXPECTED_HOLD_RELEASE_DATE
, EXPEDITED EXPEDITED
, JOB_NOTE JOB_NOTE
FROM "WIP"."WIP_DISCRETE_JOBS"