[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_SALES_ORDER_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| Subobject Name: | |
| Status: | VALID |
Interface table for releasing Sales Orders changes
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_SO_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 BATCH_ID
SR_INSTANCE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | batch ID | ||
| SR_INSTANCE_ID | NUMBER | Source Instance ID | ||
| SCHEDULE_SHIP_DATE | DATE | Schedule Ship Date | ||
| EARLIEST_SHIP_DATE | DATE | Earliest Schedule Ship Date | ||
| SCHEDULE_ARRIVAL_DATE | DATE | Schedule Arrival Date | ||
| HEADER_ID | NUMBER | Sales Orders Header ID | ||
| LINE_ID | NUMBER | Sales Orders Line ID | ||
| SHIP_METHOD | VARCHAR2 | (240) | Sales Orders Shipping Method Code | |
| ORG_ID | NUMBER | Sales Orders Organization ID | ||
| OPERATING_UNIT | NUMBER | Sales Orders Operating Unit | ||
| DELIVERY_LEAD_TIME | NUMBER | Sales Orders Intransit Lead Time | ||
| 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 | ||
| PLAN_ID | NUMBER | Plan ID | ||
| DEMAND_ID | NUMBER | Sales Order Demand ID | ||
| RETURN_STATUS | NUMBER | Return status of releasing result | ||
| FIRM_FLAG | NUMBER | Sales Order Releasing Firm Flag | ||
| LINE_NUMBER | NUMBER | Sales Orders Line Number | ||
| ORIG_SCHEDULE_SHIP_DATE | DATE | Original Schedule Ship Date for the Sales Orders | ||
| ORIG_SCHEDULE_ARRIVAL_DATE | DATE | Original Schedule Arrival Date for the Sales Orders | ||
| ORIG_ORG_ID | NUMBER | Original Organization ID for the Sales Orders | ||
| ORIG_SHIP_METHOD | VARCHAR2 | (30) | Original Shipping Method Code for the Sales Orders | |
| ORIG_LEAD_TIME | NUMBER | Original Intransit Lead Time for the Sales Orders | ||
| QUANTITY | NUMBER | Sales Order Quantity | ||
| SOURCE_TYPE | NUMBER | source type of sales orders | ||
| ORDER_NUMBER | VARCHAR2 | (100) | Order Number | |
| INVENTORY_ITEM_ID | NUMBER | |||
| ORIG_ITEM_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, SR_INSTANCE_ID
, SCHEDULE_SHIP_DATE
, EARLIEST_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE
, HEADER_ID
, LINE_ID
, SHIP_METHOD
, ORG_ID
, OPERATING_UNIT
, DELIVERY_LEAD_TIME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, PLAN_ID
, DEMAND_ID
, RETURN_STATUS
, FIRM_FLAG
, LINE_NUMBER
, ORIG_SCHEDULE_SHIP_DATE
, ORIG_SCHEDULE_ARRIVAL_DATE
, ORIG_ORG_ID
, ORIG_SHIP_METHOD
, ORIG_LEAD_TIME
, QUANTITY
, SOURCE_TYPE
, ORDER_NUMBER
, INVENTORY_ITEM_ID
, ORIG_ITEM_ID
FROM MSC.MSC_SALES_ORDER_INTERFACE;
MSC.MSC_SALES_ORDER_INTERFACE does not reference any database object
MSC.MSC_SALES_ORDER_INTERFACE is referenced by following:
MSC
MSC_SALES_ORDER_INTERFACE#
|
|
|
|