[Home] [Help]
[Dependency Information]
| Object Name: | MSC_DEMANDS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: | MSC.MSC_DEMANDS
|
| Subobject Name: | |
| Status: | VALID |
This table stores all the demands taken into account for planning. Disposition_id would be a foreign key to MSC_SUPPLIES for dependent demands. For independent demands, disposition_id holds MRP_SCHEDULE_DATES.MPS_TRANSACTION_ID.
| Tablespace: | ![]() |
|---|---|
| PCT Free: | |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_DEMANDS_U1 | NORMAL | UNIQUE |
|
PLAN_ID
DEMAND_ID
SR_INSTANCE_ID
|
| MSC_DEMANDS_N1 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
UPDATED
APPLIED
STATUS
|
| MSC_DEMANDS_N2 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
USING_ASSEMBLY_ITEM_ID
USING_ASSEMBLY_DEMAND_DATE
|
| MSC_DEMANDS_N3 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
ORIGINATION_TYPE
|
| MSC_DEMANDS_N4 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
DISPOSITION_ID
ORIGINATION_TYPE
|
| MSC_DEMANDS_N5 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
ORIGINATION_TYPE
WIP_ENTITY_ID
OP_SEQ_NUM
REPETITIVE_SCHEDULE_ID
|
| MSC_DEMANDS_N6 | NORMAL | NONUNIQUE |
|
PLAN_ID
SR_INSTANCE_ID
SALES_ORDER_LINE_ID
|
| MSC_DEMANDS_N7 | NORMAL | NONUNIQUE |
|
PLAN_ID
ORIGINATION_TYPE
SCHEDULE_DESIGNATOR_ID
ORGANIZATION_ID
SR_INSTANCE_ID
BUCKET_TYPE
INVENTORY_ITEM_ID
|
| MSC_DEMANDS_N8 | NORMAL | NONUNIQUE |
|
PLAN_ID
ORIGINAL_DEMAND_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORDER_PRIORITY | NUMBER | Order priority | ||
| FORECAST_MAD | NUMBER | Forecash MAD | ||
| DEMAND_ID | NUMBER | Yes | Demand identifier | |
| SCHEDULE_DESIGNATOR_ID | NUMBER | Schedule designator identifier | ||
| USING_REQUIREMENT_QUANTITY | NUMBER | Yes | Required quantity | |
| ASSEMBLY_DEMAND_COMP_DATE | DATE | Using assembly completion date | ||
| USING_ASSEMBLY_DEMAND_DATE | DATE | Yes | Demand date (due date) | |
| DEMAND_TYPE | NUMBER | Yes | Demand type. Discrete Demand(1), Rate-based demand(2) | |
| ORIGINATION_TYPE | NUMBER | Origin of the demand: Planned order, hard reservation, etc... | ||
| DEMAND_PRIORITY | NUMBER | Demand priority. Used by scheduling heuristic | ||
| SALES_ORDER_PRIORITY | NUMBER | Sales order quantity | ||
| FORECAST_PRIORITY | NUMBER | Forecast priority | ||
| PLANNING_GROUP | VARCHAR2 | (30) | Planning group | |
| DAILY_DEMAND_RATE | NUMBER | Repetitive demand rate | ||
| UNIT_NUMBER | VARCHAR2 | (30) | Unit number | |
| DISPOSITION_ID | NUMBER | Disposition identifier, reference to the supply generating the demand. | ||
| USING_ASSEMBLY_ITEM_ID | NUMBER | Yes | Using assembly iten identifier (item generating the demand for dependent demands) | |
| PLAN_ID | NUMBER | Yes | Plan identifier | |
| ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Demanded item identifier | |
| PROJECT_ID | NUMBER | (15) | Project identifier to which the demand applies | |
| TASK_ID | NUMBER | (15) | Task identifier to which the demand applies | |
| CUSTOMER_ID | NUMBER | Customer identifier | ||
| CUSTOMER_SITE_ID | NUMBER | Customer site identifier | ||
| SR_INSTANCE_ID | NUMBER | Yes | Source application instance identifier | |
| SHIP_TO_SITE_ID | NUMBER | Destination of the product | ||
| PROMISE_DATE | DATE | Date promised to the customer | ||
| SELLING_PRICE | NUMBER | Selling price | ||
| DMD_LATENESS_COST | NUMBER | Demand lateness cost for independent demands | ||
| DMD_SATISFIED_DATE | DATE | Date demand is satisfied | ||
| OP_SEQ_NUM | NUMBER | Operation sequence number within the routing used by the source supply | ||
| UPDATED | NUMBER | Flag to determine whether add workday modification was applied | ||
| STATUS | NUMBER | Used for online replanning | ||
| APPLIED | NUMBER | Used for online replanning | ||
| DEMAND_CLASS | VARCHAR2 | (34) | Demand class code | |
| FIRM_QUANTITY | NUMBER | Firm quantity | ||
| FIRM_DATE | DATE | Firm quantity | ||
| OLD_DEMAND_QUANTITY | NUMBER | Old demand quantity | ||
| OLD_DEMAND_DATE | DATE | Old order due date | ||
| SOURCE_ORGANIZATION_ID | NUMBER | Source application identifier | ||
| RESERVATION_ID | NUMBER | Reservation identifier | ||
| PARENT_ID | NUMBER | Demand identifier of the parent demand transaction | ||
| LENDING_PROJECT_ID | NUMBER | Lending project identifier for Payback Demand | ||
| LENDING_TASK_ID | NUMBER | Lending task identifier for Payback Demand | ||
| SUBST_ITEM_FLAG | NUMBER | Flag indicating whether item is a substitute item | ||
| ORDER_NUMBER | VARCHAR2 | (62) | Wip entity name | |
| RESERVED_QUANTITY | NUMBER | Quantity reserved | ||
| 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 | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| 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 | |
| WIP_ENTITY_ID | NUMBER | WIP job identifier | ||
| ISSUED_QUANTITY | NUMBER | Quantity issued | ||
| REPETITIVE_SCHEDULE_ID | NUMBER | Repetitive schedule identifier | ||
| REFRESH_NUMBER | NUMBER | Refresh number populated by the collection program | ||
| REQUEST_DATE | DATE | Request date | ||
| WIP_STATUS_CODE | NUMBER | WIP job status code | ||
| WIP_SUPPLY_TYPE | NUMBER | WIP supply type | ||
| SOURCE_ORG_INSTANCE_ID | NUMBER | Source Org Instance Identifier | ||
| SALES_ORDER_LINE_ID | NUMBER | Sales order line identifier | ||
| CONFIDENCE_PERCENTAGE | NUMBER | Forecast confidence percentage | ||
| BUCKET_TYPE | NUMBER | Bucket type | ||
| BILL_ID | NUMBER | Forecast billing address identifier | ||
| PROBABILITY | NUMBER | Probability | ||
| FORECAST_SET_ID | NUMBER | Forecast set identifier | ||
| GROUP_ID | NUMBER | Group identifier | ||
| SERVICE_LEVEL | NUMBER | Service Level | ||
| QUANTITY_BY_DUE_DATE | NUMBER | Quantity By Due Date | ||
| TARGET_SAFETY_STOCK | NUMBER | Target Safety Stock | ||
| SCENARIO_SET | NUMBER | Scenario Set | ||
| DEMAND_SOURCE_TYPE | NUMBER | Forecast billing address identifier | ||
| SUPPLY_ID | NUMBER | Forecast billing address identifier | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | (50) | Original System Reference | |
| ORIGINAL_SYSTEM_LINE_REFERENCE | VARCHAR2 | (50) | Original System Line Reference | |
| STOLEN_FLAG | VARCHAR2 | (1) | Stolen Flag | |
| OLD_USING_REQUIREMENT_QUANTITY | NUMBER | Old requirement quantity for ATP Summary Calculation | ||
| OLD_USING_ASSEMBLY_DEMAND_DATE | DATE | Old demand date for ATP Summary Calculation | ||
| OLD_ASSEMBLY_DEMAND_COMP_DATE | DATE | For ATP Summary Calculation | ||
| CUMMULATIVE_PROBABILITY | NUMBER | Cumulative Probaility | ||
| ORIGINAL_ITEM_ID | NUMBER | Original Item Id | ||
| UNMET_QUANTITY | NUMBER | Unmet Quantity for Independent Demands | ||
| RECORD_SOURCE | NUMBER | For plan order demands generated by ATP this field will have value 2. If this field is 1 or null then the plan order is generated by MBP | ||
| LINK_TO_LINE_ID | NUMBER | Parent Line Identifier | ||
| ERROR_TYPE | NUMBER | 1=MAD, 2=MAPE, Null= Neither | ||
| ATP_SYNCHRONIZATION_FLAG | NUMBER | ATP Synchronization Flag for 24x7 ATP | ||
| COMP_SEQ_ID | NUMBER | Component Sequence Id | ||
| QUANTITY_PER_ASSEMBLY | NUMBER | Part usage quantity | ||
| RELEASE_STATUS | NUMBER | Release status | ||
| RESCHEDULE_FLAG | NUMBER | Reschedule Flag | ||
| LOAD_TYPE | NUMBER | Load Type | ||
| IMPLEMENT_ORG_ID | NUMBER | Implement Org ID | ||
| IMPLEMENT_INSTANCE_ID | NUMBER | Implement Source Instance ID | ||
| IMPLEMENT_DATE | DATE | Implement Schedule Ship Date | ||
| RELEASE_ERRORS | VARCHAR2 | (250) | Release Errors | |
| ORG_FIRM_FLAG | NUMBER | Org Firm Flag | ||
| ORIGINAL_ORG_ID | NUMBER | For Sales Orders : Original Organization Id on the Order | ||
| ORIGINAL_INST_ID | NUMBER | For Sales Orders : Original Instance Id on the Sales Order | ||
| ARRIVAL_SET_ID | NUMBER | Arrival Set Id | ||
| SHIP_SET_ID | NUMBER | Ship Set Id | ||
| ORDER_DATE_TYPE_CODE | NUMBER | For sales Order if type is Ship or Arrival | ||
| SCHEDULE_ARRIVAL_DATE | DATE | Schedule Arrival Date of Demand | ||
| LATEST_ACCEPTABLE_DATE | DATE | Latest Acceptable Date on Sales Order | ||
| SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Ship Method Code | |
| PLANNED_ARRIVAL_DATE | DATE | Updated after Planning : the planned arrival date | ||
| REQUEST_SHIP_DATE | DATE | Request Ship Date | ||
| PROMISE_SHIP_DATE | DATE | Promise Ship Date | ||
| SCHEDULE_SHIP_DATE | DATE | Shedule Ship Date | ||
| ORIGINAL_DEMAND_ID | NUMBER | Original Demand Id refers to the Original Demand.This could be a Sales Order or a Forecast.In a Global Forecast Situation a Sales Order can get split into multiple demands satisfied indifferent organizations. When NULL, Original_Demand_Id is the same as Demand_Id. | ||
| ZONE_ID | NUMBER | Zone id | ||
| ORIG_SHIPPING_METHOD_CODE | VARCHAR2 | (30) | Original shipping method code on demand | |
| INTRANSIT_LEAD_TIME | NUMBER | Intransit Lead Time | ||
| ORIG_INTRANSIT_LEAD_TIME | NUMBER | Original Intransit Lead Time | ||
| ATP_OVERRIDE_FLAG | NUMBER | atp_override_flag | ||
| IMPLEMENT_FIRM | NUMBER | Implement FIrm Flag | ||
| IMPLEMENT_EARLIEST_DATE | DATE | Implement Earliest Ship Date | ||
| IMPLEMENT_ARRIVAL_DATE | DATE | Implement Schedule Arrival Date | ||
| UNBUCKETED_DEMAND_DATE | DATE | Stores the unbucketed demand date | ||
| ATO_LINE_ID | NUMBER | LINE ID of top ATO model | ||
| TOP_MODEL_LINE_ID | NUMBER | Line id Of the Top Model | ||
| PARENT_MODEL_LINE_ID | NUMBER | Line ID of parent model | ||
| STD_MANDATORY_COMP_FLAG | NUMBER | Flag indicating whether the record if standard mandatory component or not. | ||
| OLD_REFRESH_NUMBER | NUMBER | Old Refresh Number | ||
| SHIP_METHOD | VARCHAR2 | (30) | Ship method | |
| SHIP_CALENDAR | VARCHAR2 | (15) | Shipping calendar | |
| RECEIVING_CALENDAR | VARCHAR2 | (15) | Receiving calendar | |
| INTRANSIT_CALENDAR | VARCHAR2 | (15) | Intransit calendar | |
| SHIP_TO_LOCATION_ID | NUMBER | Will store the external location id. | ||
| ORIGINAL_QUANTITY | NUMBER | Original Quantity of the demand | ||
| FINAL_USE_PRIORITY | NUMBER | Final use priority. Used in DRP allocation. | ||
| FINAL_USE_DATE | DATE | Final use date | ||
| ARRIVAL_SET_NAME | VARCHAR2 | (30) | To capture Arrival Set Name | |
| SHIP_SET_NAME | VARCHAR2 | (30) | To capture Ship set name | |
| SOURCE_PHANTOM_ID | NUMBER | Top Level Phantom Component Identifier | ||
| PRIMARY_COMPONENT_ID | NUMBER | Component identifier of t he primary component for the current component | ||
| ATP_SESSION_ID | NUMBER | Session Id for ATP inquiry | ||
| IMPLEMENT_SHIP_DATE | DATE | Ship date entered by user during release. | ||
| PLANNED_SHIP_DATE | DATE | Planned Ship Date | ||
| PRIOR_ALLOCATION_QTY | NUMBER | |||
| MANUAL_ALLOCATION_QTY | NUMBER | |||
| MANUAL_ALLOCATION_DATE | DATE | |||
| FIRM_ALLOCATION_FLAG | NUMBER | |||
| ASSET_SERIAL_NUMBER | VARCHAR2 | (30) | Asset number or rebuild serial number | |
| ASSET_ITEM_ID | NUMBER | Fk it item id. Asset group id or rebuild_item_id | ||
| EXPIRATION_DATE | DATE | |||
| SALES_ORDER_LINE_SPLIT | NUMBER | |||
| PLANNED_INBOUND_DUE_DATE | DATE | Due date of the planned order created during the push down phase of DRP. | ||
| FILL_KILL_FLAG | NUMBER | Flag to indicate whether a SO line has been killed. | ||
| DEFINITION_LEVEL_USED | NUMBER | The most specific definition level used for the current demand record | ||
| DEMAND_FULFILLMENT_LEAD_TIME | NUMBER | Demand Fulfillment Lead time | ||
| COMPONENT_SCALING_TYPE | NUMBER | Whether required component quantity is item-based or lot-based | ||
| COMPONENT_YIELD_FACTOR | NUMBER | Component Yield | ||
| SPLIT_FROM_DEMAND_ID | NUMBER | |||
| PREV_SUBST_ITEM | NUMBER | |||
| PREV_SUBST_ORG | NUMBER | |||
| ITEM_TYPE_ID | NUMBER | Code for Criterion on which this item is categorised into types | ||
| ITEM_TYPE_VALUE | NUMBER | Item type code per classification per the criterion indicated by the item_type_id | ||
| REPAIR_LINE_ID | NUMBER | (15) | ||
| OTM_ARRIVAL_DATE | DATE | |||
| WIP_ENTITY_NAME | VARCHAR2 | (240) | ||
| MIN_REM_SHELF_LIFE_DAYS | NUMBER | |||
| PARENT_MODEL_ITEM_ID | NUMBER | |||
| TOP_MODEL_ITEM_ID | NUMBER | |||
| DAYS_LATE | NUMBER | |||
| REVISED_DMD_DATE | DATE | |||
| REVISED_DMD_PRIORITY | NUMBER | |||
| OBJECT_TYPE | VARCHAR2 | (3) | ||
| ORIG_FIRM_DATE | DATE | |||
| ORIG_FIRM_QUANTITY | NUMBER | |||
| MAINTENANCE_OBJECT_SOURCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ORDER_PRIORITY
, FORECAST_MAD
, DEMAND_ID
, SCHEDULE_DESIGNATOR_ID
, USING_REQUIREMENT_QUANTITY
, ASSEMBLY_DEMAND_COMP_DATE
, USING_ASSEMBLY_DEMAND_DATE
, DEMAND_TYPE
, ORIGINATION_TYPE
, DEMAND_PRIORITY
, SALES_ORDER_PRIORITY
, FORECAST_PRIORITY
, PLANNING_GROUP
, DAILY_DEMAND_RATE
, UNIT_NUMBER
, DISPOSITION_ID
, USING_ASSEMBLY_ITEM_ID
, PLAN_ID
, ORGANIZATION_ID
, INVENTORY_ITEM_ID
, PROJECT_ID
, TASK_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, SR_INSTANCE_ID
, SHIP_TO_SITE_ID
, PROMISE_DATE
, SELLING_PRICE
, DMD_LATENESS_COST
, DMD_SATISFIED_DATE
, OP_SEQ_NUM
, UPDATED
, STATUS
, APPLIED
, DEMAND_CLASS
, FIRM_QUANTITY
, FIRM_DATE
, OLD_DEMAND_QUANTITY
, OLD_DEMAND_DATE
, SOURCE_ORGANIZATION_ID
, RESERVATION_ID
, PARENT_ID
, LENDING_PROJECT_ID
, LENDING_TASK_ID
, SUBST_ITEM_FLAG
, ORDER_NUMBER
, RESERVED_QUANTITY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, WIP_ENTITY_ID
, ISSUED_QUANTITY
, REPETITIVE_SCHEDULE_ID
, REFRESH_NUMBER
, REQUEST_DATE
, WIP_STATUS_CODE
, WIP_SUPPLY_TYPE
, SOURCE_ORG_INSTANCE_ID
, SALES_ORDER_LINE_ID
, CONFIDENCE_PERCENTAGE
, BUCKET_TYPE
, BILL_ID
, PROBABILITY
, FORECAST_SET_ID
, GROUP_ID
, SERVICE_LEVEL
, QUANTITY_BY_DUE_DATE
, TARGET_SAFETY_STOCK
, SCENARIO_SET
, DEMAND_SOURCE_TYPE
, SUPPLY_ID
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE
, STOLEN_FLAG
, OLD_USING_REQUIREMENT_QUANTITY
, OLD_USING_ASSEMBLY_DEMAND_DATE
, OLD_ASSEMBLY_DEMAND_COMP_DATE
, CUMMULATIVE_PROBABILITY
, ORIGINAL_ITEM_ID
, UNMET_QUANTITY
, RECORD_SOURCE
, LINK_TO_LINE_ID
, ERROR_TYPE
, ATP_SYNCHRONIZATION_FLAG
, COMP_SEQ_ID
, QUANTITY_PER_ASSEMBLY
, RELEASE_STATUS
, RESCHEDULE_FLAG
, LOAD_TYPE
, IMPLEMENT_ORG_ID
, IMPLEMENT_INSTANCE_ID
, IMPLEMENT_DATE
, RELEASE_ERRORS
, ORG_FIRM_FLAG
, ORIGINAL_ORG_ID
, ORIGINAL_INST_ID
, ARRIVAL_SET_ID
, SHIP_SET_ID
, ORDER_DATE_TYPE_CODE
, SCHEDULE_ARRIVAL_DATE
, LATEST_ACCEPTABLE_DATE
, SHIPPING_METHOD_CODE
, PLANNED_ARRIVAL_DATE
, REQUEST_SHIP_DATE
, PROMISE_SHIP_DATE
, SCHEDULE_SHIP_DATE
, ORIGINAL_DEMAND_ID
, ZONE_ID
, ORIG_SHIPPING_METHOD_CODE
, INTRANSIT_LEAD_TIME
, ORIG_INTRANSIT_LEAD_TIME
, ATP_OVERRIDE_FLAG
, IMPLEMENT_FIRM
, IMPLEMENT_EARLIEST_DATE
, IMPLEMENT_ARRIVAL_DATE
, UNBUCKETED_DEMAND_DATE
, ATO_LINE_ID
, TOP_MODEL_LINE_ID
, PARENT_MODEL_LINE_ID
, STD_MANDATORY_COMP_FLAG
, OLD_REFRESH_NUMBER
, SHIP_METHOD
, SHIP_CALENDAR
, RECEIVING_CALENDAR
, INTRANSIT_CALENDAR
, SHIP_TO_LOCATION_ID
, ORIGINAL_QUANTITY
, FINAL_USE_PRIORITY
, FINAL_USE_DATE
, ARRIVAL_SET_NAME
, SHIP_SET_NAME
, SOURCE_PHANTOM_ID
, PRIMARY_COMPONENT_ID
, ATP_SESSION_ID
, IMPLEMENT_SHIP_DATE
, PLANNED_SHIP_DATE
, PRIOR_ALLOCATION_QTY
, MANUAL_ALLOCATION_QTY
, MANUAL_ALLOCATION_DATE
, FIRM_ALLOCATION_FLAG
, ASSET_SERIAL_NUMBER
, ASSET_ITEM_ID
, EXPIRATION_DATE
, SALES_ORDER_LINE_SPLIT
, PLANNED_INBOUND_DUE_DATE
, FILL_KILL_FLAG
, DEFINITION_LEVEL_USED
, DEMAND_FULFILLMENT_LEAD_TIME
, COMPONENT_SCALING_TYPE
, COMPONENT_YIELD_FACTOR
, SPLIT_FROM_DEMAND_ID
, PREV_SUBST_ITEM
, PREV_SUBST_ORG
, ITEM_TYPE_ID
, ITEM_TYPE_VALUE
, REPAIR_LINE_ID
, OTM_ARRIVAL_DATE
, WIP_ENTITY_NAME
, MIN_REM_SHELF_LIFE_DAYS
, PARENT_MODEL_ITEM_ID
, TOP_MODEL_ITEM_ID
, DAYS_LATE
, REVISED_DMD_DATE
, REVISED_DMD_PRIORITY
, OBJECT_TYPE
, ORIG_FIRM_DATE
, ORIG_FIRM_QUANTITY
, MAINTENANCE_OBJECT_SOURCE
FROM MSC.MSC_DEMANDS;
MSC.MSC_DEMANDS does not reference any database object
MSC.MSC_DEMANDS is referenced by following:
MSC
MSC_DEMANDS#
|
|
|
|