DBA Data[Home] [Help] [Dependency Information]

TABLE: MSC.MSC_SUPPLIES

Object Details
Object Name: MSC_SUPPLIES
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_SUPPLIES
Subobject Name:
Status: VALID


This table lists all the supplies for this plan. The supplies created by the planning process are added to this table.


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_SUPPLIES_U1 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnTRANSACTION_ID
ColumnSR_INSTANCE_ID
MSC_SUPPLIES_N1 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnNEW_SCHEDULE_DATE
MSC_SUPPLIES_N2 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnORDER_TYPE
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnLINE_ID
MSC_SUPPLIES_N3 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnLOAD_TYPE
ColumnINVENTORY_ITEM_ID
MSC_SUPPLIES_N4 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnAPPLIED
ColumnSTATUS
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnUPDATED
MSC_SUPPLIES_N5 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnORDER_TYPE
ColumnNEW_SCHEDULE_DATE
MSC_SUPPLIES_N6 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnDISPOSITION_ID
ColumnORDER_TYPE
ColumnOPERATION_SEQ_NUM
MSC_SUPPLIES_N7 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSOURCE_ORGANIZATION_ID
ColumnSOURCE_SR_INSTANCE_ID
ColumnSR_INSTANCE_ID
ColumnINVENTORY_ITEM_ID
ColumnORDER_TYPE
MSC_SUPPLIES_N8 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORDER_TYPE
ColumnSR_MTL_SUPPLY_ID
MSC_SUPPLIES_N9 NORMAL NONUNIQUE Tablespace ColumnBATCH_ID
ColumnLOAD_TYPE
ColumnRELEASABLE
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan identifier
TRANSACTION_ID NUMBER
Yes Transaction Identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier of the item org
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
SCHEDULE_DESIGNATOR_ID NUMBER

Schedule designator
REVISION VARCHAR2 (10)
Inventory item revision code
UNIT_NUMBER VARCHAR2 (30)
Unit number of the item
NEW_SCHEDULE_DATE DATE
Yes End date of the supply (completion date of first unit)
OLD_SCHEDULE_DATE DATE

Old schedule date
NEW_WIP_START_DATE DATE

New WIP schedule start date
OLD_WIP_START_DATE DATE

Old WIP schedule start date
FIRST_UNIT_COMPLETION_DATE DATE

First unit completion date for recommended repetitive schedules
LAST_UNIT_COMPLETION_DATE DATE

Last unit completion date for recommended repetitive schedule
FIRST_UNIT_START_DATE DATE

First unit start date for recommended repetitive schedule
LAST_UNIT_START_DATE DATE

Last unit start date for recommended repetitive schedule
DISPOSITION_ID NUMBER

Identifier which references to source of supply
DISPOSITION_STATUS_TYPE NUMBER

Identifies the status of supply. Not cancelled(1), Cancelled(2)
ORDER_TYPE NUMBER
Yes Specifies type of order: planned order, purchase order, etc...
SUPPLIER_ID NUMBER

Supplier identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
NEW_ORDER_QUANTITY NUMBER

Supply quantity
OLD_ORDER_QUANTITY NUMBER

Old supply quantity
NEW_ORDER_PLACEMENT_DATE DATE

Start date of the supply
OLD_ORDER_PLACEMENT_DATE DATE

Old start date of the supply
RESCHEDULE_DAYS NUMBER

Different between old and new schedule dates
RESCHEDULE_FLAG NUMBER

Flag indicating if this row been rescheduled using th Planner Workbench form
SCHEDULE_COMPRESS_DAYS NUMBER

Old schedule compress days
NEW_PROCESSING_DAYS NUMBER

Repetitive schedule processing days
PURCH_LINE_NUM NUMBER

Purchase order line number (for purchase order)
QUANTITY_IN_PROCESS NUMBER

Quantity being processed by the WIP/PO interface processes. Not yet in execution system
IMPLEMENTED_QUANTITY NUMBER

Planned order implemented quantity
FIRM_PLANNED_TYPE NUMBER
Yes Flag indicating whether the order is firm
FIRM_QUANTITY NUMBER

Firm planned quantity
FIRM_DATE DATE

Firm date for order
IMPLEMENT_DEMAND_CLASS VARCHAR2 (30)
Implement demand class
IMPLEMENT_DATE DATE

Implement due date
IMPLEMENT_QUANTITY NUMBER

Implement quantity
IMPLEMENT_FIRM NUMBER

Implement firm type
IMPLEMENT_WIP_CLASS_CODE VARCHAR2 (10)
Implement WIP class code
IMPLEMENT_JOB_NAME VARCHAR2 (240)
Implement job name
IMPLEMENT_DOCK_DATE DATE

Implement dock date
IMPLEMENT_STATUS_CODE NUMBER

Implement job status code
IMPLEMENT_EMPLOYEE_ID NUMBER

Implement employee identifier
IMPLEMENT_UOM_CODE VARCHAR2 (3)
Implement UOM code
IMPLEMENT_LOCATION_ID NUMBER

Implement location identifier
IMPLEMENT_SOURCE_ORG_ID NUMBER

Implement source organization identifier
IMPLEMENT_SR_INSTANCE_ID NUMBER

Source application instance identifier associated with implement source organization identifier
IMPLEMENT_SUPPLIER_ID NUMBER

Implement supplier identifier
IMPLEMENT_SUPPLIER_SITE_ID NUMBER

Implement supplier site identifier
IMPLEMENT_AS NUMBER

Implement order type. None(1), Purchase requisition(2), Discrete job(3)
RELEASE_STATUS NUMBER

Flag indicating release status
LOAD_TYPE NUMBER

Load program to excecute
PROCESS_SEQ_ID NUMBER

Process eff identifier
SCO_SUPPLY_FLAG NUMBER

Flag to indicate if supply was suggested by SCO
ALTERNATE_BOM_DESIGNATOR VARCHAR2 (10)
Alternate BOM designator
ALTERNATE_ROUTING_DESIGNATOR VARCHAR2 (10)
Alternate routing designator
OPERATION_SEQ_NUM NUMBER

Sequence number of the next Operation within the routing
BY_PRODUCT_USING_ASSY_ID NUMBER

Product using assembly identifier
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier for inter organization transfers
SOURCE_SR_INSTANCE_ID NUMBER

Source application instance identifier associated with source organization identifier
SOURCE_SUPPLIER_SITE_ID NUMBER

Source supplier site identifier
SOURCE_SUPPLIER_ID NUMBER

Source supplier identifier
SHIP_METHOD VARCHAR2 (30)
Ship method used for transfer
WEIGHT_CAPACITY_USED NUMBER

Weight capacity used in transportation
VOLUME_CAPACITY_USED NUMBER

Volumne capacity used in transportation
NEW_SHIP_DATE DATE

New ship date
NEW_DOCK_DATE DATE

Suggested dock date
OLD_DOCK_DATE DATE

Old suggested dock date
LINE_ID NUMBER

Line identifier
PROJECT_ID NUMBER (15)
Project identifier
TASK_ID NUMBER (15)
Task identifier
PLANNING_GROUP VARCHAR2 (30)
Project planning group
IMPLEMENT_PROJECT_ID NUMBER (15)
Implement project identifier
IMPLEMENT_TASK_ID NUMBER (15)
Implement task identifier
IMPLEMENT_SCHEDULE_GROUP_ID NUMBER

Implement schedule group identifier
IMPLEMENT_BUILD_SEQUENCE NUMBER

Build Sequence for the Planned Order to be implemented as a discrete job
IMPLEMENT_ALTERNATE_BOM VARCHAR2 (10)
Alternate bom designator of the planned order to be implemented
IMPLEMENT_ALTERNATE_ROUTING VARCHAR2 (10)
Alternate routing designator of the planned order to be implemented
IMPLEMENT_UNIT_NUMBER VARCHAR2 (30)
End item unit number of the planned order to be implemented
IMPLEMENT_LINE_ID NUMBER

Implement Repetitive Line Identifier
RELEASE_ERRORS VARCHAR2 (250)
Release error ???
NUMBER1 NUMBER

Rel_all_qty ???
SOURCE_ITEM_ID NUMBER

Source item identifier
ORDER_NUMBER VARCHAR2 (240)
Order number (purchase order number)
SCHEDULE_GROUP_ID NUMBER

Schedule group identifier
BUILD_SEQUENCE NUMBER

Build Sequence for the Planned Order
WIP_ENTITY_NAME VARCHAR2 (240)
WIP entity name
IMPLEMENT_PROCESSING_DAYS NUMBER

Implement processing days
DELIVERY_PRICE NUMBER

Supply unit price for purchasing supply
LATE_SUPPLY_DATE DATE

Supply date for the shadow part of the split supplies
LATE_SUPPLY_QTY NUMBER

Shadow supply quantity
LOT_NUMBER VARCHAR2 (80)
Lot number for on-hand quantities
SUBINVENTORY_CODE VARCHAR2 (10)
Subinventory for on-hand quantity
QTY_SCRAPPED NUMBER

Current job scrapped units
EXPECTED_SCRAP_QTY NUMBER

Expected scrap qty
QTY_COMPLETED NUMBER

Current job quantity completed
DAILY_RATE NUMBER

Daily rate for recommended repetitive schedules
SCHEDULE_GROUP_NAME VARCHAR2 (30)
WIP schedule group name
UPDATED NUMBER

Flag to determine whether add workday modification was applied
SUBST_ITEM_FLAG NUMBER

Flag indicating whether item is a substitute item
STATUS NUMBER

Attribute used for online replanning
APPLIED NUMBER

Attribute used for online replanning
EXPIRATION_QUANTITY NUMBER

Expiration quantity
EXPIRATION_DATE DATE

Expiration date
NON_NETTABLE_QTY NUMBER

Non-nettable onhand quantity
IMPLEMENT_WIP_START_DATE DATE

Implement start date
REFRESH_NUMBER NUMBER

Refresh number assigned by the collection program
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
IMPLEMENT_DAILY_RATE NUMBER

Implement daily rate
NEED_BY_DATE DATE

Need by date
SOURCE_SUPPLY_ID NUMBER

Source supply identifier
SR_MTL_SUPPLY_ID NUMBER

Source mtl supply identifier
WIP_STATUS_CODE NUMBER

WIP job status code
DEMAND_CLASS VARCHAR2 (34)
Demand class code
FROM_ORGANIZATION_ID NUMBER

From organization identifier
WIP_SUPPLY_TYPE NUMBER

WIP supply type
PO_LINE_ID NUMBER

Purchase order line identifier
LOAD_FACTOR_RATE NUMBER

Load factor rate for suggested repetitive schedules
ROUTING_SEQUENCE_ID NUMBER

Supply identifier from the source
BILL_SEQUENCE_ID NUMBER

Supply identifier from the source
COPRODUCTS_SUPPLY NUMBER

Supply identifier from the source
CFM_ROUTING_FLAG NUMBER

Supply identifier from the source
CUSTOMER_ID NUMBER

Customer Identifier
SHIP_TO_SITE_ID NUMBER

Ship To Site Identifier
OLD_NEED_BY_DATE DATE

Old Need By Date for ATP SUmmary Calculation
OLD_DAILY_RATE NUMBER

for ATP SUmmary Calculation
OLD_FIRST_UNIT_START_DATE DATE

for ATP SUmmary Calculation
OLD_LAST_UNIT_COMPLETION_DATE DATE

for ATP SUmmary Calculation
OLD_NEW_SCHEDULE_DATE DATE

for ATP SUmmary Calculation
OLD_QTY_COMPLETED NUMBER

for ATP SUmmary Calculation
OLD_NEW_ORDER_QUANTITY NUMBER

for ATP SUmmary Calculation
OLD_FIRM_QUANTITY NUMBER

for ATP SUmmary Calculation
OLD_FIRM_DATE DATE

for ATP SUmmary Calculation
PLANNING_PARTNER_SITE_ID NUMBER

Planning Partner Site Identifier
PLANNING_TP_TYPE NUMBER

Planning Partner Type Identifier
OWNING_PARTNER_SITE_ID NUMBER

Owning Partner Site Identifier
OWNING_TP_TYPE NUMBER

Owning Partner Type Identifier
VMI_FLAG NUMBER

Flag to identify VMI
EARLIEST_START_DATE DATE

For Improved Exceptions
EARLIEST_COMPLETION_DATE DATE

For Improved Exceptions
MIN_START_DATE DATE

For Improved Exceptions
SCHEDULED_DEMAND_ID NUMBER

For Improved Exceptions
EXPLOSION_DATE DATE

SCO supply date (Updated need by date)
SCO_SUPPLY_DATE DATE

Supply Date as suggested by Optimizer Engine (SCO)
RECORD_SOURCE NUMBER

For plan orders generated by ATP this field will have value 2. If this field is 1 or null then the plan order is generated by MBP
SUPPLY_IS_SHARED NUMBER

1 if supply is shared, 2 if the supply is not shared, populated by HLS
ULPSD DATE

Unconstrained Latest Possible Start Date/Time
ULPCD DATE

Unconstrained Latest Possible Completion Date/Time
UEPSD DATE

Unconstrained Earliest Possible Start Date/Time
UEPCD DATE

Unconstrained Earliest Possible Completion Date/Time
EACD DATE

Earliest Allowable Completion Date/Time
ORIGINAL_NEED_BY_DATE DATE

Need-by Date for the shipment schedule
ORIGINAL_QUANTITY NUMBER

Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether acceptance from the supplier is required or not
PROMISED_DATE DATE

Supplier promised delivery date
WIP_START_QUANTITY NUMBER

This column stores the start quantity of the lot based job. This quantity will be released back as the start quantity of the job
END_ORDER_NUMBER VARCHAR2 (240)
Used to store a supplier change request
END_ORDER_LINE_NUMBER VARCHAR2 (25)
End Order Line Number
ORDER_LINE_NUMBER VARCHAR2 (25)
Order Line Number
QUANTITY_PER_ASSEMBLY NUMBER

Part usage quantity
QUANTITY_ISSUED NUMBER

Part quantity issued
UNBUCKETED_DEMAND_DATE DATE

Stores the unbucketed demand date
SHIPMENT_ID NUMBER

Shipment ID for DRP
JOB_OP_SEQ_NUM NUMBER

Job sequence number of the current operation. Populated only for lot-based jobs.
JUMP_OP_SEQ_NUM NUMBER

Routing sequence number of the jumped operation. If the operation is outside the network then a value of 50000 is populated. Populated only for lot-based jobs.
SHIP_CALENDAR VARCHAR2 (15)
SHipping Calendar
RECEIVING_CALENDAR VARCHAR2 (15)
Receiving Calendar
INTRANSIT_CALENDAR VARCHAR2 (15)
Intransit Calendar
INTRANSIT_LEAD_TIME NUMBER

Intransit Lead Time
OLD_SHIP_DATE VARCHAR2 (240)
Old Ship Date
IMPLEMENT_SHIP_DATE DATE

implement ship date
ORIG_SHIP_METHOD VARCHAR2 (30)
Default Shipping Method
ORIG_INTRANSIT_LEAD_TIME NUMBER

Default Intransit Lead Time
PARENT_ID NUMBER

Parent Identifier
DAYS_LATE NUMBER

Tell how many days the planned order from source plan will get delayed
SCHEDULE_PRIORITY NUMBER

Highest End Demand Priority
PO_LINE_LOCATION_ID NUMBER

Purchase order line location identifier
PO_DISTRIBUTION_ID NUMBER

Purchase order distribution identifier
WSM_FAULTY_NETWORK NUMBER

Flag to represent whether the OSFM job involves a faulty network
IMPLEMENT_DEST_ORG_ID NUMBER

Implement Destination Organization ID
IMPLEMENT_DEST_INST_ID NUMBER

Implement Destination Sr Instance ID
REQUESTED_START_DATE DATE

Requested start dat eof the wo
REQUESTED_COMPLETION_DATE DATE

Requested completion/Due date of the wo
ASSET_SERIAL_NUMBER VARCHAR2 (30)
Asset number or rebuild serial number
ASSET_ITEM_ID NUMBER

Fk to item id. Asset group id or rebuild_item_id
TOP_TRANSACTION_ID NUMBER

supply for top work order for eam work order hierarchy
UNBUCKETED_NEW_SCHED_DATE DATE

Unbucketed New Schedule Date
IMPLEMENT_SHIP_METHOD VARCHAR2 (30)
IMPLEMENT SHIP METHOD
ACTUAL_START_DATE DATE

Actual start date & time for the WIP job
FIRM_SHIP_DATE DATE

SCHEDULE_ORIGINATION_TYPE NUMBER

UNBUCKETED_START_DATE DATE

SR_CUSTOMER_ACCT_ID NUMBER

ITEM_TYPE_ID NUMBER

Code for Criterion on which this item is categorised into types
CUSTOMER_PRODUCT_ID NUMBER (15)
RO_STATUS_CODE VARCHAR2 (30)
SR_REPAIR_GROUP_ID NUMBER

SR_REPAIR_TYPE_ID NUMBER (15)
ITEM_TYPE_VALUE NUMBER

Item type code per classification per the criterion indicated by the item_type_id
ZONE_ID NUMBER

RO_CREATION_DATE DATE

REPAIR_LEAD_TIME NUMBER

FIRM_START_DATE DATE

REQ_LINE_ID NUMBER

Requisition Line Identifier
INTRANSIT_OWNING_ORG_ID NUMBER

INTRANSIT_OWNING_ORG_ID
RELEASABLE NUMBER

BATCH_ID NUMBER

OTM_ARRIVAL_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      INVENTORY_ITEM_ID
,      SCHEDULE_DESIGNATOR_ID
,      REVISION
,      UNIT_NUMBER
,      NEW_SCHEDULE_DATE
,      OLD_SCHEDULE_DATE
,      NEW_WIP_START_DATE
,      OLD_WIP_START_DATE
,      FIRST_UNIT_COMPLETION_DATE
,      LAST_UNIT_COMPLETION_DATE
,      FIRST_UNIT_START_DATE
,      LAST_UNIT_START_DATE
,      DISPOSITION_ID
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      NEW_ORDER_QUANTITY
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_PLACEMENT_DATE
,      OLD_ORDER_PLACEMENT_DATE
,      RESCHEDULE_DAYS
,      RESCHEDULE_FLAG
,      SCHEDULE_COMPRESS_DAYS
,      NEW_PROCESSING_DAYS
,      PURCH_LINE_NUM
,      QUANTITY_IN_PROCESS
,      IMPLEMENTED_QUANTITY
,      FIRM_PLANNED_TYPE
,      FIRM_QUANTITY
,      FIRM_DATE
,      IMPLEMENT_DEMAND_CLASS
,      IMPLEMENT_DATE
,      IMPLEMENT_QUANTITY
,      IMPLEMENT_FIRM
,      IMPLEMENT_WIP_CLASS_CODE
,      IMPLEMENT_JOB_NAME
,      IMPLEMENT_DOCK_DATE
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_EMPLOYEE_ID
,      IMPLEMENT_UOM_CODE
,      IMPLEMENT_LOCATION_ID
,      IMPLEMENT_SOURCE_ORG_ID
,      IMPLEMENT_SR_INSTANCE_ID
,      IMPLEMENT_SUPPLIER_ID
,      IMPLEMENT_SUPPLIER_SITE_ID
,      IMPLEMENT_AS
,      RELEASE_STATUS
,      LOAD_TYPE
,      PROCESS_SEQ_ID
,      SCO_SUPPLY_FLAG
,      ALTERNATE_BOM_DESIGNATOR
,      ALTERNATE_ROUTING_DESIGNATOR
,      OPERATION_SEQ_NUM
,      BY_PRODUCT_USING_ASSY_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SR_INSTANCE_ID
,      SOURCE_SUPPLIER_SITE_ID
,      SOURCE_SUPPLIER_ID
,      SHIP_METHOD
,      WEIGHT_CAPACITY_USED
,      VOLUME_CAPACITY_USED
,      NEW_SHIP_DATE
,      NEW_DOCK_DATE
,      OLD_DOCK_DATE
,      LINE_ID
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
,      IMPLEMENT_PROJECT_ID
,      IMPLEMENT_TASK_ID
,      IMPLEMENT_SCHEDULE_GROUP_ID
,      IMPLEMENT_BUILD_SEQUENCE
,      IMPLEMENT_ALTERNATE_BOM
,      IMPLEMENT_ALTERNATE_ROUTING
,      IMPLEMENT_UNIT_NUMBER
,      IMPLEMENT_LINE_ID
,      RELEASE_ERRORS
,      NUMBER1
,      SOURCE_ITEM_ID
,      ORDER_NUMBER
,      SCHEDULE_GROUP_ID
,      BUILD_SEQUENCE
,      WIP_ENTITY_NAME
,      IMPLEMENT_PROCESSING_DAYS
,      DELIVERY_PRICE
,      LATE_SUPPLY_DATE
,      LATE_SUPPLY_QTY
,      LOT_NUMBER
,      SUBINVENTORY_CODE
,      QTY_SCRAPPED
,      EXPECTED_SCRAP_QTY
,      QTY_COMPLETED
,      DAILY_RATE
,      SCHEDULE_GROUP_NAME
,      UPDATED
,      SUBST_ITEM_FLAG
,      STATUS
,      APPLIED
,      EXPIRATION_QUANTITY
,      EXPIRATION_DATE
,      NON_NETTABLE_QTY
,      IMPLEMENT_WIP_START_DATE
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      IMPLEMENT_DAILY_RATE
,      NEED_BY_DATE
,      SOURCE_SUPPLY_ID
,      SR_MTL_SUPPLY_ID
,      WIP_STATUS_CODE
,      DEMAND_CLASS
,      FROM_ORGANIZATION_ID
,      WIP_SUPPLY_TYPE
,      PO_LINE_ID
,      LOAD_FACTOR_RATE
,      ROUTING_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      COPRODUCTS_SUPPLY
,      CFM_ROUTING_FLAG
,      CUSTOMER_ID
,      SHIP_TO_SITE_ID
,      OLD_NEED_BY_DATE
,      OLD_DAILY_RATE
,      OLD_FIRST_UNIT_START_DATE
,      OLD_LAST_UNIT_COMPLETION_DATE
,      OLD_NEW_SCHEDULE_DATE
,      OLD_QTY_COMPLETED
,      OLD_NEW_ORDER_QUANTITY
,      OLD_FIRM_QUANTITY
,      OLD_FIRM_DATE
,      PLANNING_PARTNER_SITE_ID
,      PLANNING_TP_TYPE
,      OWNING_PARTNER_SITE_ID
,      OWNING_TP_TYPE
,      VMI_FLAG
,      EARLIEST_START_DATE
,      EARLIEST_COMPLETION_DATE
,      MIN_START_DATE
,      SCHEDULED_DEMAND_ID
,      EXPLOSION_DATE
,      SCO_SUPPLY_DATE
,      RECORD_SOURCE
,      SUPPLY_IS_SHARED
,      ULPSD
,      ULPCD
,      UEPSD
,      UEPCD
,      EACD
,      ORIGINAL_NEED_BY_DATE
,      ORIGINAL_QUANTITY
,      ACCEPTANCE_REQUIRED_FLAG
,      PROMISED_DATE
,      WIP_START_QUANTITY
,      END_ORDER_NUMBER
,      END_ORDER_LINE_NUMBER
,      ORDER_LINE_NUMBER
,      QUANTITY_PER_ASSEMBLY
,      QUANTITY_ISSUED
,      UNBUCKETED_DEMAND_DATE
,      SHIPMENT_ID
,      JOB_OP_SEQ_NUM
,      JUMP_OP_SEQ_NUM
,      SHIP_CALENDAR
,      RECEIVING_CALENDAR
,      INTRANSIT_CALENDAR
,      INTRANSIT_LEAD_TIME
,      OLD_SHIP_DATE
,      IMPLEMENT_SHIP_DATE
,      ORIG_SHIP_METHOD
,      ORIG_INTRANSIT_LEAD_TIME
,      PARENT_ID
,      DAYS_LATE
,      SCHEDULE_PRIORITY
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      WSM_FAULTY_NETWORK
,      IMPLEMENT_DEST_ORG_ID
,      IMPLEMENT_DEST_INST_ID
,      REQUESTED_START_DATE
,      REQUESTED_COMPLETION_DATE
,      ASSET_SERIAL_NUMBER
,      ASSET_ITEM_ID
,      TOP_TRANSACTION_ID
,      UNBUCKETED_NEW_SCHED_DATE
,      IMPLEMENT_SHIP_METHOD
,      ACTUAL_START_DATE
,      FIRM_SHIP_DATE
,      SCHEDULE_ORIGINATION_TYPE
,      UNBUCKETED_START_DATE
,      SR_CUSTOMER_ACCT_ID
,      ITEM_TYPE_ID
,      CUSTOMER_PRODUCT_ID
,      RO_STATUS_CODE
,      SR_REPAIR_GROUP_ID
,      SR_REPAIR_TYPE_ID
,      ITEM_TYPE_VALUE
,      ZONE_ID
,      RO_CREATION_DATE
,      REPAIR_LEAD_TIME
,      FIRM_START_DATE
,      REQ_LINE_ID
,      INTRANSIT_OWNING_ORG_ID
,      RELEASABLE
,      BATCH_ID
,      OTM_ARRIVAL_DATE
FROM MSC.MSC_SUPPLIES;

Dependencies

[top of page]

MSC.MSC_SUPPLIES does not reference any database object

MSC.MSC_SUPPLIES is referenced by following:

SchemaAPPS
SynonymMSC_SUPPLIES