[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WIP_DISCRETE_JOBS |
|---|---|
| Object Type: | TABLE |
| Owner: | WIP |
| FND Design Data: |  WIP.WIP_DISCRETE_JOBS
|
| Subobject Name: | |
| Status: | VALID |
WIP_DISCRETE_JOBS stores discrete job information. Each row
represents a discrete job, and contains information about the assembly
being built, the revision of the assembly, the job quantity, the
status of the job, the material control method, accounting
information, and job schedule dates. Oracle Work in Process uses this
information to control discrete production.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| SYS_IL0000045949C00121$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| WIP_DISCRETE_JOBS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 WIP_ENTITY_ID
ORGANIZATION_ID
|
| WIP_DISCRETE_JOBS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIMARY_ITEM_ID
|
| WIP_DISCRETE_JOBS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_WIP_ENTITY_ID
MANUAL_REBUILD_FLAG
|
| WIP_DISCRETE_JOBS_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REBUILD_ITEM_ID
|
| WIP_DISCRETE_JOBS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
PROJECT_ID
|
| WIP_DISCRETE_JOBS_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| WIP_DISCRETE_JOBS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DATE_CLOSED
ORGANIZATION_ID
|
| WIP_DISCRETE_JOBS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BOM_REFERENCE_ID
ORGANIZATION_ID
|
| WIP_DISCRETE_JOBS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ROUTING_REFERENCE_ID
ORGANIZATION_ID
|
| WIP_DISCRETE_JOBS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CLASS_CODE
ORGANIZATION_ID
ATTRIBUTE1
ATTRIBUTE2
|
| WIP_DISCRETE_JOBS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FIRM_PLANNED_FLAG
STATUS_TYPE
|
| WIP_DISCRETE_JOBS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SCHEDULE_GROUP_ID
BUILD_SEQUENCE
|
| WIP_DISCRETE_JOBS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS_TYPE
ORGANIZATION_ID
SCHEDULED_START_DATE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
|
| WIP_DISCRETE_JOBS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_ID
ORGANIZATION_ID
|
| WIP_DISCRETE_JOBS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
MAINTENANCE_OBJECT_TYPE
MAINTENANCE_OBJECT_ID
MAINTENANCE_OBJECT_SOURCE
ORGANIZATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| WIP_ENTITY_ID | NUMBER | Yes | WIP Job Identifier | |
| ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Enhanced Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Enhanced Who column | ||
| PROGRAM_ID | NUMBER | Enhanced Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Enhanced Who column | ||
| SOURCE_LINE_ID | NUMBER | Identifier of the source system that generated the job record | ||
| SOURCE_CODE | VARCHAR2 | (30) | Code of the process that generated the job record(null if created by Oracle Work In Process) | |
| DESCRIPTION | VARCHAR2 | (240) | Descriptive text | |
| STATUS_TYPE | NUMBER | Yes | Status of job | |
| PRIMARY_ITEM_ID | NUMBER | Inventory item Identifier for the assembly the job creates | ||
| FIRM_PLANNED_FLAG | NUMBER | Yes | Control for MRP rescheduling | |
| JOB_TYPE | NUMBER | Yes | Type of discrete job | |
| WIP_SUPPLY_TYPE | NUMBER | Yes | Method of material consumption within WIP | |
| CLASS_CODE | VARCHAR2 | (10) | Yes | Accounting class associated with job |
| MATERIAL_ACCOUNT | NUMBER | General Ledger account to accumulate material charges for a job | ||
| MATERIAL_OVERHEAD_ACCOUNT | NUMBER | General Ledger account to accumulate material overhead charges for a job | ||
| RESOURCE_ACCOUNT | NUMBER | General Ledger account to accumulate resource charges for a job | ||
| OUTSIDE_PROCESSING_ACCOUNT | NUMBER | General Ledger account to accumulate outside processing charges for a job | ||
| MATERIAL_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate material variances for a job | ||
| RESOURCE_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate resource variances for a job | ||
| OUTSIDE_PROC_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate outside processing variances for a job | ||
| STD_COST_ADJUSTMENT_ACCOUNT | NUMBER | General Ledger account to accumulate standard cost variances for a job | ||
| OVERHEAD_ACCOUNT | NUMBER | General Ledger account to accumulate overhead charges for a job | ||
| OVERHEAD_VARIANCE_ACCOUNT | NUMBER | General ledger account to accumulate overhead variances for a job | ||
| SCHEDULED_START_DATE | DATE | Yes | Date on which job is scheduled to start | |
| DATE_RELEASED | DATE | Date on which job is released | ||
| SCHEDULED_COMPLETION_DATE | DATE | Yes | Last unit scheduled completion date | |
| DATE_COMPLETED | DATE | Last unit actual completion date | ||
| DATE_CLOSED | DATE | Date on which job was closed | ||
| START_QUANTITY | NUMBER | Yes | Job start quantity | |
| QUANTITY_COMPLETED | NUMBER | Yes | Current job quantity completed | |
| QUANTITY_SCRAPPED | NUMBER | Yes | Number of units scrapped on the current job | |
| NET_QUANTITY | NUMBER | Yes | Number of assemblies netted to supply by MRP | |
| BOM_REFERENCE_ID | NUMBER | Assembly identifier used as bill of material reference for explosions of nonstandard job | ||
| ROUTING_REFERENCE_ID | NUMBER | Assembly identifier used as routing reference for explosions of nonstandard job | ||
| COMMON_BOM_SEQUENCE_ID | NUMBER | Bill of material identifier when a common bill is used | ||
| COMMON_ROUTING_SEQUENCE_ID | NUMBER | Routing identifier when a common routing is used | ||
| BOM_REVISION | VARCHAR2 | (3) | BOM revision for the primary assembly | |
| ROUTING_REVISION | VARCHAR2 | (3) | Short code that uniquely identifies the Routing revision | |
| BOM_REVISION_DATE | DATE | Date of assembly item revision used to explode the bills of material used in the job | ||
| ROUTING_REVISION_DATE | DATE | Routing revision date | ||
| LOT_NUMBER | VARCHAR2 | (80) | Default lot number to assign to assemblies completed from the job | |
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate bill of material used in a job | |
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate routing used in a job | |
| COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Default completion subinventory for assemblies completed by the job | |
| COMPLETION_LOCATOR_ID | NUMBER | Default completion locator identifier for assemblies completed by the job | ||
| MPS_SCHEDULED_COMPLETION_DATE | DATE | Date used by MRP to relieve the MPS for the job (used by MRP only) | ||
| MPS_NET_QUANTITY | NUMBER | Quantity used by MRP to relieve MPS for the job (used by MRP only) | ||
| DEMAND_CLASS | VARCHAR2 | (30) | Type of demand the job satisfies | |
| SCHEDULE_GROUP_ID | NUMBER | Identifier for the job schedule group | ||
| BUILD_SEQUENCE | NUMBER | Build sequence | ||
| LINE_ID | NUMBER | Production line Identifier | ||
| PROJECT_ID | NUMBER | Project Identifier | ||
| TASK_ID | NUMBER | Project task Identifier | ||
| KANBAN_CARD_ID | NUMBER | Identifier for production kanban replentished by the job | ||
| OVERCOMPLETION_TOLERANCE_TYPE | NUMBER | Unit of OVERCOMPLETION_TOLERANCE_VALUE (percent or amount) | ||
| OVERCOMPLETION_TOLERANCE_VALUE | NUMBER | Percent or amount above start quantity that this job is allowed to complete | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Assembly unit number identifier to support Project Manufacturing in Model Unit Effectivity. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| PO_CREATION_TIME | NUMBER | PO Creation Time for Outside Processing | ||
| PRIORITY | NUMBER | Priority of this job | ||
| DUE_DATE | DATE | Due date of this job | ||
| EST_SCRAP_ACCOUNT | NUMBER | Estimated Scrap account | ||
| EST_SCRAP_VAR_ACCOUNT | NUMBER | Estimated Scrap variance account | ||
| EST_SCRAP_PRIOR_QTY | NUMBER | Estimated quantity completed for calculation of operation yield | ||
| DUE_DATE_PENALTY | NUMBER | Penalty incurred if job is late (in days) | ||
| DUE_DATE_TOLERANCE | NUMBER | Number of days a job can be late | ||
| COPRODUCTS_SUPPLY | NUMBER | Flag indicating if this job forms supply for co-products also | ||
| PARENT_WIP_ENTITY_ID | NUMBER | Parent Job Identifier | ||
| ASSET_NUMBER | VARCHAR2 | (30) | Asset Number | |
| ASSET_GROUP_ID | NUMBER | Asset Group Identifer | ||
| REBUILD_ITEM_ID | NUMBER | Rebuild Item Identifier | ||
| REBUILD_SERIAL_NUMBER | VARCHAR2 | (30) | Rebuild Serial Number | |
| MANUAL_REBUILD_FLAG | VARCHAR2 | (1) | The flag indicating whether this rebuild work order is created manually. | |
| SHUTDOWN_TYPE | VARCHAR2 | (30) | Shutdown Type | |
| ESTIMATION_STATUS | NUMBER | Costing Estimation Status | ||
| REQUESTED_START_DATE | DATE | Requested Start Date | ||
| NOTIFICATION_REQUIRED | VARCHAR2 | (1) | Notification Requried Flag | |
| WORK_ORDER_TYPE | VARCHAR2 | (30) | Work Order Type | |
| OWNING_DEPARTMENT | NUMBER | Work order owning department | ||
| ACTIVITY_TYPE | VARCHAR2 | (30) | Activity Type | |
| ACTIVITY_CAUSE | VARCHAR2 | (30) | Activity Cause | |
| TAGOUT_REQUIRED | VARCHAR2 | (1) | Tagout required flag | |
| PLAN_MAINTENANCE | VARCHAR2 | (1) | Planned Maintenance Flag | |
| PM_SCHEDULE_ID | NUMBER | The preventive maintenance schedule that generates this work order. | ||
| LAST_ESTIMATION_DATE | DATE | last estimation date | ||
| LAST_ESTIMATION_REQ_ID | NUMBER | last estimation ID | ||
| ACTIVITY_SOURCE | VARCHAR2 | (30) | activity source | |
| SERIALIZATION_START_OP | NUMBER | first operation under serialized control | ||
| MAINTENANCE_OBJECT_ID | NUMBER | maintenance object id | ||
| MAINTENANCE_OBJECT_TYPE | NUMBER | maintenance object type | ||
| MAINTENANCE_OBJECT_SOURCE | NUMBER | maintenance object source | ||
| MATERIAL_ISSUE_BY_MO | VARCHAR2 | (1) | Enable Material Issue Requests | |
| SCHEDULING_REQUEST_ID | NUMBER | Constraint Based Scheduling Request Identifier | ||
| ISSUE_ZERO_COST_FLAG | VARCHAR2 | (1) | Issue asset items from Expense subinventory at Zero cost | |
| EAM_LINEAR_LOCATION_ID | NUMBER | Linear Asset Location Identifier | ||
| ACTUAL_START_DATE | DATE | An actual job start time calculated based on info collected. | ||
| EXPECTED_HOLD_RELEASE_DATE | DATE | An expected time to release job from on hold. | ||
| EXPEDITED | VARCHAR2 | (1) | Expedited flag | |
| JOB_NOTE | CLOB | (4000) | Job Note |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_LINE_ID
, SOURCE_CODE
, DESCRIPTION
, STATUS_TYPE
, PRIMARY_ITEM_ID
, FIRM_PLANNED_FLAG
, JOB_TYPE
, WIP_SUPPLY_TYPE
, CLASS_CODE
, 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
, DATE_RELEASED
, SCHEDULED_COMPLETION_DATE
, DATE_COMPLETED
, DATE_CLOSED
, START_QUANTITY
, QUANTITY_COMPLETED
, QUANTITY_SCRAPPED
, NET_QUANTITY
, BOM_REFERENCE_ID
, ROUTING_REFERENCE_ID
, COMMON_BOM_SEQUENCE_ID
, COMMON_ROUTING_SEQUENCE_ID
, BOM_REVISION
, ROUTING_REVISION
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, LOT_NUMBER
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID
, MPS_SCHEDULED_COMPLETION_DATE
, MPS_NET_QUANTITY
, DEMAND_CLASS
, SCHEDULE_GROUP_ID
, BUILD_SEQUENCE
, LINE_ID
, PROJECT_ID
, TASK_ID
, KANBAN_CARD_ID
, OVERCOMPLETION_TOLERANCE_TYPE
, OVERCOMPLETION_TOLERANCE_VALUE
, END_ITEM_UNIT_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PO_CREATION_TIME
, PRIORITY
, DUE_DATE
, EST_SCRAP_ACCOUNT
, EST_SCRAP_VAR_ACCOUNT
, EST_SCRAP_PRIOR_QTY
, DUE_DATE_PENALTY
, DUE_DATE_TOLERANCE
, COPRODUCTS_SUPPLY
, PARENT_WIP_ENTITY_ID
, ASSET_NUMBER
, ASSET_GROUP_ID
, REBUILD_ITEM_ID
, REBUILD_SERIAL_NUMBER
, MANUAL_REBUILD_FLAG
, SHUTDOWN_TYPE
, ESTIMATION_STATUS
, REQUESTED_START_DATE
, NOTIFICATION_REQUIRED
, WORK_ORDER_TYPE
, OWNING_DEPARTMENT
, ACTIVITY_TYPE
, ACTIVITY_CAUSE
, TAGOUT_REQUIRED
, PLAN_MAINTENANCE
, PM_SCHEDULE_ID
, LAST_ESTIMATION_DATE
, LAST_ESTIMATION_REQ_ID
, ACTIVITY_SOURCE
, SERIALIZATION_START_OP
, MAINTENANCE_OBJECT_ID
, MAINTENANCE_OBJECT_TYPE
, MAINTENANCE_OBJECT_SOURCE
, MATERIAL_ISSUE_BY_MO
, SCHEDULING_REQUEST_ID
, ISSUE_ZERO_COST_FLAG
, EAM_LINEAR_LOCATION_ID
, ACTUAL_START_DATE
, EXPECTED_HOLD_RELEASE_DATE
, EXPEDITED
, JOB_NOTE
FROM WIP.WIP_DISCRETE_JOBS;
WIP.WIP_DISCRETE_JOBS does not reference any database object
WIP.WIP_DISCRETE_JOBS is referenced by following:
WIP
WIP_DISCRETE_JOBS#
|
|
|
|