[Home] [Help] [Dependency Information]
Object Name: | MSC_SUPPLIES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.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.
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_SUPPLIES_U1 | NORMAL | UNIQUE |
PLAN_ID
TRANSACTION_ID SR_INSTANCE_ID | |
MSC_SUPPLIES_N1 | NORMAL | NONUNIQUE |
PLAN_ID
INVENTORY_ITEM_ID ORGANIZATION_ID SR_INSTANCE_ID NEW_SCHEDULE_DATE | |
MSC_SUPPLIES_N2 | NORMAL | NONUNIQUE |
PLAN_ID
ORDER_TYPE SR_INSTANCE_ID ORGANIZATION_ID LINE_ID | |
MSC_SUPPLIES_N3 | NORMAL | NONUNIQUE |
PLAN_ID
SR_INSTANCE_ID ORGANIZATION_ID LOAD_TYPE INVENTORY_ITEM_ID | |
MSC_SUPPLIES_N4 | NORMAL | NONUNIQUE |
PLAN_ID
APPLIED STATUS SR_INSTANCE_ID ORGANIZATION_ID UPDATED | |
MSC_SUPPLIES_N5 | NORMAL | NONUNIQUE |
PLAN_ID
INVENTORY_ITEM_ID ORGANIZATION_ID SR_INSTANCE_ID ORDER_TYPE NEW_SCHEDULE_DATE | |
MSC_SUPPLIES_N6 | NORMAL | NONUNIQUE |
PLAN_ID
SR_INSTANCE_ID DISPOSITION_ID ORDER_TYPE OPERATION_SEQ_NUM | |
MSC_SUPPLIES_N7 | NORMAL | NONUNIQUE |
PLAN_ID
SOURCE_ORGANIZATION_ID SOURCE_SR_INSTANCE_ID SR_INSTANCE_ID INVENTORY_ITEM_ID ORDER_TYPE | |
MSC_SUPPLIES_N8 | NORMAL | NONUNIQUE |
PLAN_ID
SR_INSTANCE_ID ORDER_TYPE SR_MTL_SUPPLY_ID | |
MSC_SUPPLIES_N9 | NORMAL | NONUNIQUE |
BATCH_ID
LOAD_TYPE RELEASABLE |
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 |
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;
MSC.MSC_SUPPLIES does not reference any database object
MSC.MSC_SUPPLIES is referenced by following:
|
|
|