[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WIP_FLOW_SCHEDULES |
|---|---|
| Object Type: | TABLE |
| Owner: | WIP |
| FND Design Data: |  WIP.WIP_FLOW_SCHEDULES
|
| Subobject Name: | |
| Status: | VALID |
WIP_FLOW_SCHEDULES stores Work Order-less Flow schedule information. Each row represents a Flow schedule and contains information about the assembly being built, the assembly revision, the schedule quantity, the status of the Flow schedule, and accounting information. Oracle Work in Process uses this information to control Flow schedule production.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WIP_FLOW_SCHEDULES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 WIP_ENTITY_ID
ORGANIZATION_ID
|
| WIP_FLOW_SCHEDULES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
SCHEDULE_NUMBER
ORGANIZATION_ID
|
| WIP_FLOW_SCHEDULES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRIMARY_ITEM_ID
LINE_ID
SCHEDULE_GROUP_ID
BUILD_SEQUENCE
|
| WIP_FLOW_SCHEDULES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_ID
SCHEDULED_COMPLETION_DATE
SCHEDULE_GROUP_ID
PRIMARY_ITEM_ID
BUILD_SEQUENCE
|
| WIP_FLOW_SCHEDULES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEMAND_SOURCE_LINE
|
| WIP_FLOW_SCHEDULES_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORGANIZATION_ID
LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SCHEDULED_FLAG | NUMBER | Yes | Whether a scheduled or unscheduled assembly | |
| WIP_ENTITY_ID | NUMBER | Yes | WIP Flow schedule 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 | ||
| PRIMARY_ITEM_ID | NUMBER | Inventory item Identifier for the assembly the Flow schedule creates | ||
| CLASS_CODE | VARCHAR2 | (10) | Yes | Accounting class associated with the Flow schedule |
| SCHEDULED_START_DATE | DATE | Yes | Date on which the Flow schedule is scheduled to start | |
| DATE_CLOSED | DATE | Last unit actual completion date | ||
| PLANNED_QUANTITY | NUMBER | Yes | Flow schedule initial planned quantity | |
| QUANTITY_COMPLETED | NUMBER | Yes | Current Flow schedule quantity completed | |
| MPS_SCHEDULED_COMPLETION_DATE | DATE | Date used by MRP to relieve the MPS for the Flow schedule (used by MRP only) | ||
| MPS_NET_QUANTITY | NUMBER | Quantity used by MRP to relieve MPS for the Flow schedule (used by MRP only) | ||
| BOM_REVISION | VARCHAR2 | (3) | Inventory item revision code | |
| ROUTING_REVISION | VARCHAR2 | (3) | Routing revision code | |
| BOM_REVISION_DATE | DATE | Date of inventory item revision used to explode the bill of materials used in the Flow schedule | ||
| ROUTING_REVISION_DATE | DATE | Routing revision date | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | Alternate bill of material used in a Flow schedule | |
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate routing used in a Flow schedule | |
| COMPLETION_SUBINVENTORY | VARCHAR2 | (10) | Default completion subinventory for assemblies completed by the Flow schedule | |
| COMPLETION_LOCATOR_ID | NUMBER | Default completion locator identifier for assemblies completed by the Flow schedule | ||
| MATERIAL_ACCOUNT | NUMBER | General Ledger account to accumulate material charges for a Flow schedule | ||
| MATERIAL_OVERHEAD_ACCOUNT | NUMBER | General Ledger account to accumulate material overhead charges for a Flow schedule | ||
| RESOURCE_ACCOUNT | NUMBER | General Ledger account to accumulate resource charges for a Flow schedule | ||
| OUTSIDE_PROCESSING_ACCOUNT | NUMBER | General Ledger account to accumulate outside processing charges for a Flow schedule | ||
| MATERIAL_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate material variances for a Flow schedule | ||
| RESOURCE_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate resource variances for a Flow schedule | ||
| OUTSIDE_PROC_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate outside processing variances for a Flow schedule | ||
| STD_COST_ADJUSTMENT_ACCOUNT | NUMBER | General Ledger account to accumulate standard cost variances for a Flow schedule | ||
| OVERHEAD_ACCOUNT | NUMBER | General Ledger account to accumulate overhead charges for a Flow schedule | ||
| OVERHEAD_VARIANCE_ACCOUNT | NUMBER | General Ledger account to accumulate overhead variances for a Flow schedule | ||
| DEMAND_CLASS | VARCHAR2 | (30) | Type of demand the schedule satisfies | |
| SCHEDULED_COMPLETION_DATE | DATE | Yes | Scheduled completion date | |
| SCHEDULE_GROUP_ID | NUMBER | Schedule group for the Flow schedule | ||
| BUILD_SEQUENCE | NUMBER | Build sequence | ||
| LINE_ID | NUMBER | Production line Identifier | ||
| PROJECT_ID | NUMBER | Project Identifier | ||
| TASK_ID | NUMBER | Project task Identifier | ||
| STATUS | NUMBER | Yes | WIP entity type code | |
| SCHEDULE_NUMBER | VARCHAR2 | (30) | Yes | Flow schedule reference code |
| 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 | |
| DEMAND_SOURCE_HEADER_ID | NUMBER | Sales order Identifier | ||
| DEMAND_SOURCE_LINE | VARCHAR2 | (30) | Sales order line Identifier | |
| DEMAND_SOURCE_DELIVERY | VARCHAR2 | (30) | Delivery Identifier | |
| DEMAND_SOURCE_TYPE | NUMBER | Demand source type | ||
| KANBAN_CARD_ID | NUMBER | Production kanban replentished by the schedule | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Assembly unit number Identifier to support Project Manufacturing in Model Unit Effectivity | |
| QUANTITY_SCRAPPED | NUMBER | Yes | Number of assemblies scrapped for this schedule | |
| CURRENT_LINE_OPERATION | NUMBER | The line operation where the assembly is in production | ||
| SYNCH_SCHEDULE_NUM | VARCHAR2 | (30) | Synchronization Schedule Num | |
| SYNCH_OPERATION_SEQ_NUM | NUMBER | Synchronization Operation Seq Num | ||
| ROLL_FORWARDED_FLAG | NUMBER | Roll Forwarded Flag | ||
| ALLOCATED_FLAG | VARCHAR2 | (1) | allocated flag | |
| AUTO_REPLENISH | VARCHAR2 | (1) | Auto Replenish flag, to indicate if the auto replenishment request has been run for this flow schedule | |
| TRANSACTED_FLAG | VARCHAR2 | (1) | This flag indicates whether there is completion transaction against this flow schedule or not. |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULED_FLAG
, 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
, PRIMARY_ITEM_ID
, CLASS_CODE
, SCHEDULED_START_DATE
, DATE_CLOSED
, PLANNED_QUANTITY
, QUANTITY_COMPLETED
, MPS_SCHEDULED_COMPLETION_DATE
, MPS_NET_QUANTITY
, BOM_REVISION
, ROUTING_REVISION
, BOM_REVISION_DATE
, ROUTING_REVISION_DATE
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, COMPLETION_SUBINVENTORY
, COMPLETION_LOCATOR_ID
, 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
, DEMAND_CLASS
, SCHEDULED_COMPLETION_DATE
, SCHEDULE_GROUP_ID
, BUILD_SEQUENCE
, LINE_ID
, PROJECT_ID
, TASK_ID
, STATUS
, SCHEDULE_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, DEMAND_SOURCE_TYPE
, KANBAN_CARD_ID
, END_ITEM_UNIT_NUMBER
, QUANTITY_SCRAPPED
, CURRENT_LINE_OPERATION
, SYNCH_SCHEDULE_NUM
, SYNCH_OPERATION_SEQ_NUM
, ROLL_FORWARDED_FLAG
, ALLOCATED_FLAG
, AUTO_REPLENISH
, TRANSACTED_FLAG
FROM WIP.WIP_FLOW_SCHEDULES;
WIP.WIP_FLOW_SCHEDULES does not reference any database object
WIP.WIP_FLOW_SCHEDULES is referenced by following:
APPS
WIP_FLOW_SCHEDULES
WIP_FLOW_SCHEDULES_ARD
WIP_FLOW_SCHEDULES_BRD
WIP_FLOW_SCHEDULES_BRI
WIP_FLOW_SCHEDULES_BRU
|
|
|
|