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

TABLE: MSC.MSC_ST_SUPPLIES

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

The staging table used by the collection program to validate and process data for table MSC_SUPPLIES.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER

Plan identifier
TRANSACTION_ID NUMBER

Transaction unique identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ORGANIZATION_ID NUMBER

Organization identifier
SCHEDULE_DESIGNATOR_ID NUMBER

Schedule designator identifier
SOURCE_SCHEDULE_NAME VARCHAR2 (10)
Source schedule name
REVISION VARCHAR2 (10)
Inventory item revision code
UNIT_NUMBER VARCHAR2 (30)
Unit number
NEW_SCHEDULE_DATE DATE

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 schedules
FIRST_UNIT_START_DATE DATE

First unit start date for repetitive schedule
LAST_UNIT_START_DATE DATE

Last unit start date for repetitive schedule
DISPOSITION_ID NUMBER

Identifier which references to source of supply
DISPOSITION_STATUS_TYPE NUMBER

Dispostion type code
ORDER_TYPE NUMBER

Specifies type of order: planned order, purchase order, etc...
SUPPLIER_ID NUMBER

Supplier identifier
NEW_ORDER_QUANTITY NUMBER

Supply quantity
OLD_ORDER_QUANTITY NUMBER

Old order quantity
NEW_ORDER_PLACEMENT_DATE DATE

New order placement date
OLD_ORDER_PLACEMENT_DATE DATE

Old order placement date
RESCHEDULE_DAYS NUMBER

Different between old and new schedule dates
RESCHEDULE_FLAG NUMBER

Flag indicating if this row been rescheduled
SCHEDULE_COMPRESS_DAYS NUMBER

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
IMPLEMENTED_QUANTITY NUMBER

Planned order implemented quantity
FIRM_PLANNED_TYPE NUMBER

Flag indicating whether the order is firm
FIRM_QUANTITY NUMBER

Firm quantity
FIRM_DATE DATE

Firm date
IMPLEMENT_DEMAND_CLASS VARCHAR2 (34)
Implement demand class
IMPLEMENT_DATE DATE

Implement due date
IMPLEMENT_QUANTITY NUMBER

Planned order implemented quantity
IMPLEMENT_FIRM NUMBER

Implement firm flag
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 status code
IMPLEMENT_UOM_CODE VARCHAR2 (3)
Implement unit of measure code
IMPLEMENT_LOCATION_ID NUMBER

Implement location identifier
IMPLEMENT_SOURCE_ORG_ID NUMBER

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
RELEASE_STATUS NUMBER

Release status code
LOAD_TYPE NUMBER

Load program to execute
PROCESS_SEQ_ID NUMBER

Process sequence 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

Operation sequence number
SOURCE NUMBER

Source
BY_PRODUCT_USING_ASSY_ID NUMBER

Using assy identifier for by-products
SOURCE_ORGANIZATION_ID NUMBER

Source organization identifier
SOURCE_SR_INSTANCE_ID NUMBER

Source org instance identifier
SOURCE_SUPPLIER_SITE_ID NUMBER

Source supplier site identifier
SOURCE_SUPPLIER_ID NUMBER

Source supplier identifier
SHIP_METHOD NUMBER

Ship method
WEIGHT_CAPACITY_USED NUMBER

Weight capacity used
VOLUME_CAPACITY_USED NUMBER

Volume capacity used
SOURCE_SUPPLY_SCHEDULE_NAME NUMBER

Source supply schedule name
NEW_SHIP_DATE DATE

New ship date
NEW_DOCK_DATE DATE

New suggested dock date
LINE_ID NUMBER

Manufacturing line identifier
PROJECT_ID NUMBER (15)
Project identifer
TASK_ID NUMBER (15)
Task identifer
PLANNING_GROUP VARCHAR2 (30)
Planning group code
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

Implement build sequence for the planned order to be implemented as a discrete job
IMPLEMENT_ALTERNATE_BOM VARCHAR2 (10)
Implement alternate BOM designator
IMPLEMENT_ALTERNATE_ROUTING VARCHAR2 (10)
Implement alternate routing
IMPLEMENT_UNIT_NUMBER VARCHAR2 (30)
Implement unit number
IMPLEMENT_LINE_ID NUMBER

Implement line identifier
RELEASE_ERRORS VARCHAR2 (1)
Release error code
NUMBER1 NUMBER

???
SOURCE_ITEM_ID NUMBER

Source item identifer
ORDER_NUMBER VARCHAR2 (240)
Order number
SCHEDULE_GROUP_ID NUMBER

Schedule group identifier
SCHEDULE_GROUP_NAME VARCHAR2 (30)
Schedule group name
BUILD_SEQUENCE NUMBER

Build Sequence for the Planned Order
WIP_ENTITY_ID NUMBER

WIP entity identifier
WIP_ENTITY_NAME VARCHAR2 (240)
WIP entity name
WO_LATENESS_COST NUMBER

Work order lateness cost
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
SUBINVENTORY_CODE VARCHAR2 (10)
Sub-inventory code
DELETED_FLAG NUMBER

Yes/No flag indicates whether corresponding record in ODS will be deleted
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

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
SR_INSTANCE_ID NUMBER

Source application instance identifier
SCHEDULE_DESIGNATOR VARCHAR2 (10)
Schedule designator
VENDOR_ID NUMBER

Supplier identifier
VENDOR_SITE_ID NUMBER

Supplier site identifier
SUPPLIER_SITE_ID NUMBER

Supplier site identifier
PURCH_ORDER_ID NUMBER

Purchase order identifier
EXPECTED_SCRAP_QTY NUMBER

Expected scrap qty
QTY_SCRAPPED NUMBER

Current job scrapped units
QTY_COMPLETED NUMBER

Current job quantity completed
LOT_NUMBER VARCHAR2 (80)
Lot number for on-hand quantities
EXPIRATION_DATE DATE

Expiration date
WIP_STATUS_CODE NUMBER

WIP job status code
DAILY_RATE NUMBER

Daily rate for recommended repetitive schedules
LOCATOR_ID NUMBER

Locator identifier
SERIAL_NUMBER VARCHAR2 (30)
Serial number
REFRESH_ID NUMBER

Refresh identifier
LOCATOR_NAME VARCHAR2 (204)
Locator name
ONHAND_SOURCE_TYPE NUMBER

Onhand source type
SR_MTL_SUPPLY_ID NUMBER

Supply identifier from the source
DEMAND_CLASS VARCHAR2 (34)
Demand class code
FROM_ORGANIZATION_ID NUMBER

From organization identifier
WIP_SUPPLY_TYPE NUMBER

WIP supply tpe
PO_LINE_ID NUMBER

Purchase order line identifier
BILL_SEQUENCE_ID NUMBER

Supply identifier from the source
ROUTING_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
COMPANY_ID NUMBER

Company identifier
COMPANY_NAME VARCHAR2 (255)
Company name
ITEM_NAME VARCHAR2 (250)
Item Name
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
FROM_ORGANIZATION_CODE VARCHAR2 (7)
Organization from where this item is going to come
SUPPLIER_NAME VARCHAR2 (255)
Supplier Name
SOURCE_SR_INSTANCE_CODE VARCHAR2 (3)
Source Application Instance Code
SOURCE_SUPPLIER_SITE_CODE VARCHAR2 (30)
Source Supplier Site Code
SOURCE_SUPPLIER_NAME VARCHAR2 (80)
Source Supplier Name
PROJECT_NUMBER VARCHAR2 (25)
Project Number
TASK_NUMBER VARCHAR2 (25)
Task Number
SR_INSTANCE_CODE VARCHAR2 (3)
Source Instance Code
VENDOR_NAME VARCHAR2 (80)
Supplier Name
VENDOR_SITE_CODE VARCHAR2 (30)
Supplier Location Name
SUPPLIER_SITE_CODE VARCHAR2 (30)
Supplier Location Name
MESSAGE_ID NUMBER

This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML
PROCESS_FLAG NUMBER

Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed
DATA_SOURCE_TYPE VARCHAR2 (15)
Source Typs indicates the source of records, Batch/XML
ST_TRANSACTION_ID NUMBER

Transaction ID generated during pre-processing to uniquely identify a record in the staging table
SCHEDULE_LINE_NUM VARCHAR2 (10)
Schedule Line Number. This would be used to uniqely identify a demand record for a schedule during batch loads.
ERROR_TEXT VARCHAR2 (2000)
If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error
OPERATION_SEQ_CODE VARCHAR2 (10)
Operation Sequence Code
BATCH_ID NUMBER

Batch identifier generated during pre-processing
BILL_NAME VARCHAR2 (250)
BOM Name
ROUTING_NAME VARCHAR2 (250)
Routing Name
CURR_OP_SEQ_ID NUMBER

Current Operation Sequence Identifier
LINE_CODE VARCHAR2 (10)
Line Code
EFFECTIVITY_DATE DATE

Effectivity date
SHIP_FROM_PARTY_NAME VARCHAR2 (80)
Ship From Party Name
SHIP_FROM_SITE_CODE VARCHAR2 (240)
Ship From Site Code
END_ORDER_NUMBER VARCHAR2 (240)
End Order Number
END_ORDER_RELEASE_NUMBER VARCHAR2 (20)
End Order Release Number
END_ORDER_LINE_NUMBER VARCHAR2 (20)
End Order Line Number
ORDER_RELEASE_NUMBER VARCHAR2 (20)
Order Release Number
COMMENTS VARCHAR2 (1000)
Comments
SHIP_TO_PARTY_NAME VARCHAR2 (80)
Ship To Party Name
SHIP_TO_SITE_CODE VARCHAR2 (240)
Ship To Site Code
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 VARCHAR2 (1)
Flag to identify VMI
NON_NETTABLE_QTY NUMBER

Non Nettable Quantity
ORIGINAL_NEED_BY_DATE DATE

ORIGINAL_QUANTITY NUMBER

PROMISED_DATE DATE

NEED_BY_DATE DATE

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
END_ORDER_SHIPMENT_NUMBER NUMBER

POSTPROCESSING_LEAD_TIME NUMBER

WIP_START_QUANTITY NUMBER

WIP Start Quantity
ORDER_LINE_NUMBER VARCHAR2 (25)
UOM_CODE VARCHAR2 (25)
QUANTITY_PER_ASSEMBLY NUMBER

QUANTITY_ISSUED NUMBER

ACK_REFERENCE_NUMBER VARCHAR2 (200)
JOB_OP_SEQ_NUM NUMBER

JUMP_OP_SEQ_NUM NUMBER

JOB_OP_SEQ_CODE VARCHAR2 (10)
JUMP_OP_SEQ_CODE VARCHAR2 (10)
JUMP_OP_EFFECTIVITY_DATE DATE

SOURCE_ORG_ID NUMBER

SOURCE_INVENTORY_ITEM_ID NUMBER

SOURCE_VENDOR_ID NUMBER

SOURCE_VENDOR_SITE_ID NUMBER

SOURCE_TASK_ID NUMBER

SOURCE_PROJECT_ID NUMBER

SOURCE_FROM_ORGANIZATION_ID NUMBER

SOURCE_SR_MTL_SUPPLY_ID NUMBER

SOURCE_DISPOSITION_ID NUMBER

SOURCE_BILL_SEQUENCE_ID NUMBER

SOURCE_ROUTING_SEQUENCE_ID NUMBER

SOURCE_SCHEDULE_GROUP_ID NUMBER

SOURCE_WIP_ENTITY_ID NUMBER

PO_LINE_LOCATION_ID NUMBER

PO_DISTRIBUTION_ID NUMBER

REQUESTED_START_DATE DATE

REQUESTED_COMPLETION_DATE DATE

SCHEDULE_PRIORITY NUMBER

ASSET_SERIAL_NUMBER VARCHAR2 (30)
ASSET_ITEM_ID NUMBER

ASSET_ITEM_NAME VARCHAR2 (240)
PLANNING_PARTNER_SITE_CODE VARCHAR2 (240)
OWNING_PARTNER_SITE_CODE VARCHAR2 (240)
ACTUAL_START_DATE DATE

SCHEDULE_ORIGINATION_TYPE NUMBER

SR_CUSTOMER_ACCT_ID NUMBER

ITEM_TYPE_ID NUMBER

ITEM_TYPE_VALUE NUMBER

CUSTOMER_PRODUCT_ID NUMBER

RO_STATUS_CODE VARCHAR2 (30)
SR_REPAIR_GROUP_ID NUMBER

SR_REPAIR_TYPE_ID NUMBER

RO_CREATION_DATE DATE

REPAIR_LEAD_TIME NUMBER

REQ_LINE_ID NUMBER

INTRANSIT_OWNING_ORG_ID NUMBER

CONDITION_TYPE VARCHAR2 (240)
REPAIR_NUMBER VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
MAINTENANCE_OBJECT_SOURCE NUMBER

PRODUCES_TO_STOCK NUMBER

ACTIVITY_TYPE VARCHAR2 (30)
CLASS_CODE VARCHAR2 (10)
SHUTDOWN_TYPE NUMBER

TO_BE_EXPLODED NUMBER

OBJECT_TYPE VARCHAR2 (3)
MAINTENANCE_TYPE_CODE VARCHAR2 (30)
ACTIVITY_ITEM_ID NUMBER

VISIT_ID NUMBER

ASSET_NUMBER VARCHAR2 (30)
MAINTENANCE_OBJECT_ID NUMBER

MAINTENANCE_OBJECT_TYPE NUMBER

OPERATING_FLEET NUMBER

MAINTENANCE_REQUIREMENT VARCHAR2 (30)
PRODUCT_CLASSIFICATION VARCHAR2 (150)
COLL_ORDER_TYPE NUMBER

Query Text

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


SELECT PLAN_ID
,      TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SCHEDULE_DESIGNATOR_ID
,      SOURCE_SCHEDULE_NAME
,      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
,      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_UOM_CODE
,      IMPLEMENT_LOCATION_ID
,      IMPLEMENT_SOURCE_ORG_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
,      SOURCE
,      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
,      SOURCE_SUPPLY_SCHEDULE_NAME
,      NEW_SHIP_DATE
,      NEW_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
,      SCHEDULE_GROUP_NAME
,      BUILD_SEQUENCE
,      WIP_ENTITY_ID
,      WIP_ENTITY_NAME
,      WO_LATENESS_COST
,      IMPLEMENT_PROCESSING_DAYS
,      DELIVERY_PRICE
,      LATE_SUPPLY_DATE
,      LATE_SUPPLY_QTY
,      SUBINVENTORY_CODE
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      SCHEDULE_DESIGNATOR
,      VENDOR_ID
,      VENDOR_SITE_ID
,      SUPPLIER_SITE_ID
,      PURCH_ORDER_ID
,      EXPECTED_SCRAP_QTY
,      QTY_SCRAPPED
,      QTY_COMPLETED
,      LOT_NUMBER
,      EXPIRATION_DATE
,      WIP_STATUS_CODE
,      DAILY_RATE
,      LOCATOR_ID
,      SERIAL_NUMBER
,      REFRESH_ID
,      LOCATOR_NAME
,      ONHAND_SOURCE_TYPE
,      SR_MTL_SUPPLY_ID
,      DEMAND_CLASS
,      FROM_ORGANIZATION_ID
,      WIP_SUPPLY_TYPE
,      PO_LINE_ID
,      BILL_SEQUENCE_ID
,      ROUTING_SEQUENCE_ID
,      COPRODUCTS_SUPPLY
,      CFM_ROUTING_FLAG
,      COMPANY_ID
,      COMPANY_NAME
,      ITEM_NAME
,      ORGANIZATION_CODE
,      FROM_ORGANIZATION_CODE
,      SUPPLIER_NAME
,      SOURCE_SR_INSTANCE_CODE
,      SOURCE_SUPPLIER_SITE_CODE
,      SOURCE_SUPPLIER_NAME
,      PROJECT_NUMBER
,      TASK_NUMBER
,      SR_INSTANCE_CODE
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      SUPPLIER_SITE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      DATA_SOURCE_TYPE
,      ST_TRANSACTION_ID
,      SCHEDULE_LINE_NUM
,      ERROR_TEXT
,      OPERATION_SEQ_CODE
,      BATCH_ID
,      BILL_NAME
,      ROUTING_NAME
,      CURR_OP_SEQ_ID
,      LINE_CODE
,      EFFECTIVITY_DATE
,      SHIP_FROM_PARTY_NAME
,      SHIP_FROM_SITE_CODE
,      END_ORDER_NUMBER
,      END_ORDER_RELEASE_NUMBER
,      END_ORDER_LINE_NUMBER
,      ORDER_RELEASE_NUMBER
,      COMMENTS
,      SHIP_TO_PARTY_NAME
,      SHIP_TO_SITE_CODE
,      PLANNING_PARTNER_SITE_ID
,      PLANNING_TP_TYPE
,      OWNING_PARTNER_SITE_ID
,      OWNING_TP_TYPE
,      VMI_FLAG
,      NON_NETTABLE_QTY
,      ORIGINAL_NEED_BY_DATE
,      ORIGINAL_QUANTITY
,      PROMISED_DATE
,      NEED_BY_DATE
,      ACCEPTANCE_REQUIRED_FLAG
,      END_ORDER_SHIPMENT_NUMBER
,      POSTPROCESSING_LEAD_TIME
,      WIP_START_QUANTITY
,      ORDER_LINE_NUMBER
,      UOM_CODE
,      QUANTITY_PER_ASSEMBLY
,      QUANTITY_ISSUED
,      ACK_REFERENCE_NUMBER
,      JOB_OP_SEQ_NUM
,      JUMP_OP_SEQ_NUM
,      JOB_OP_SEQ_CODE
,      JUMP_OP_SEQ_CODE
,      JUMP_OP_EFFECTIVITY_DATE
,      SOURCE_ORG_ID
,      SOURCE_INVENTORY_ITEM_ID
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_TASK_ID
,      SOURCE_PROJECT_ID
,      SOURCE_FROM_ORGANIZATION_ID
,      SOURCE_SR_MTL_SUPPLY_ID
,      SOURCE_DISPOSITION_ID
,      SOURCE_BILL_SEQUENCE_ID
,      SOURCE_ROUTING_SEQUENCE_ID
,      SOURCE_SCHEDULE_GROUP_ID
,      SOURCE_WIP_ENTITY_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      REQUESTED_START_DATE
,      REQUESTED_COMPLETION_DATE
,      SCHEDULE_PRIORITY
,      ASSET_SERIAL_NUMBER
,      ASSET_ITEM_ID
,      ASSET_ITEM_NAME
,      PLANNING_PARTNER_SITE_CODE
,      OWNING_PARTNER_SITE_CODE
,      ACTUAL_START_DATE
,      SCHEDULE_ORIGINATION_TYPE
,      SR_CUSTOMER_ACCT_ID
,      ITEM_TYPE_ID
,      ITEM_TYPE_VALUE
,      CUSTOMER_PRODUCT_ID
,      RO_STATUS_CODE
,      SR_REPAIR_GROUP_ID
,      SR_REPAIR_TYPE_ID
,      RO_CREATION_DATE
,      REPAIR_LEAD_TIME
,      REQ_LINE_ID
,      INTRANSIT_OWNING_ORG_ID
,      CONDITION_TYPE
,      REPAIR_NUMBER
,      DESCRIPTION
,      MAINTENANCE_OBJECT_SOURCE
,      PRODUCES_TO_STOCK
,      ACTIVITY_TYPE
,      CLASS_CODE
,      SHUTDOWN_TYPE
,      TO_BE_EXPLODED
,      OBJECT_TYPE
,      MAINTENANCE_TYPE_CODE
,      ACTIVITY_ITEM_ID
,      VISIT_ID
,      ASSET_NUMBER
,      MAINTENANCE_OBJECT_ID
,      MAINTENANCE_OBJECT_TYPE
,      OPERATING_FLEET
,      MAINTENANCE_REQUIREMENT
,      PRODUCT_CLASSIFICATION
,      COLL_ORDER_TYPE
FROM MSC.MSC_ST_SUPPLIES;

Dependencies

[top of page]

MSC.MSC_ST_SUPPLIES does not reference any database object

MSC.MSC_ST_SUPPLIES is referenced by following:

SchemaMSC
ViewMSC_ST_SUPPLIES#