[Home] [Help]
[Dependency Information]
Object Name: | MSC_TEMP_SALES_ORDERS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
MSC.MSC_TEMP_SALES_ORDERS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_TEMP_SALES_ORDERS_PK | NORMAL | UNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEMAND_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
SR_INSTANCE_ID | NUMBER | Yes | ||
REQUIREMENT_DATE | DATE | Yes | ||
DEMAND_TYPE | NUMBER | |||
PRIMARY_UOM_QUANTITY | NUMBER | Yes | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORG_INSTANCE_ID | NUMBER | |||
SUPPLY_ID | NUMBER | |||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
PLANNING_GROUP | VARCHAR2 | (30) | ||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
DEMAND_PRIORITY | NUMBER | |||
DEMAND_SOURCE_LINE | VARCHAR2 | (30) | ||
SELLING_PRICE | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
SHIP_TO_SITE_USE_ID | NUMBER | |||
BILL_TO_SITE_USE_ID | NUMBER | |||
SALES_ORDER_NUMBER | VARCHAR2 | (122) | ||
REQUEST_DATE | DATE | |||
DEMAND_CLASS | VARCHAR2 | (34) | ||
ORDERED_ITEM_ID | NUMBER | |||
PROMISE_DATE | DATE | |||
ORIGINAL_ITEM_ID | NUMBER | |||
PARENT_ID | NUMBER | |||
ORDER_DATE_TYPE_CODE | NUMBER | |||
ORG_FIRM_FLAG | NUMBER | |||
SCHEDULE_ARRIVAL_DATE | DATE | |||
SHIPPING_METHOD_CODE | VARCHAR2 | (30) | ||
INTRANSIT_LEAD_TIME | NUMBER | |||
LATEST_ACCEPTABLE_DATE | DATE | |||
ATP_OVERRIDE_FLAG | NUMBER | |||
SHIP_SET_ID | NUMBER | |||
ARRIVAL_SET_ID | NUMBER | |||
RESERVATION_QUANTITY | NUMBER | |||
COMPLETED_QUANTITY | NUMBER | Yes | ||
AVAILABLE_TO_MRP | VARCHAR2 | (1) | ||
LINE_NUM | NUMBER | |||
DEMAND_SOURCE_HEADER_ID | NUMBER | |||
DEMAND_VISIBLE | VARCHAR2 | (1) | ||
FORECAST_VISIBLE | VARCHAR2 | (1) | ||
PARENT_DEMAND_ID | NUMBER | |||
LINK_TO_LINE_ID | NUMBER | |||
ATO_LINE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DEMAND_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, SR_INSTANCE_ID
, REQUIREMENT_DATE
, DEMAND_TYPE
, PRIMARY_UOM_QUANTITY
, SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID
, SUPPLY_ID
, PROJECT_ID
, TASK_ID
, PLANNING_GROUP
, END_ITEM_UNIT_NUMBER
, DEMAND_PRIORITY
, DEMAND_SOURCE_LINE
, SELLING_PRICE
, CUSTOMER_ID
, SHIP_TO_SITE_USE_ID
, BILL_TO_SITE_USE_ID
, SALES_ORDER_NUMBER
, REQUEST_DATE
, DEMAND_CLASS
, ORDERED_ITEM_ID
, PROMISE_DATE
, ORIGINAL_ITEM_ID
, PARENT_ID
, ORDER_DATE_TYPE_CODE
, ORG_FIRM_FLAG
, SCHEDULE_ARRIVAL_DATE
, SHIPPING_METHOD_CODE
, INTRANSIT_LEAD_TIME
, LATEST_ACCEPTABLE_DATE
, ATP_OVERRIDE_FLAG
, SHIP_SET_ID
, ARRIVAL_SET_ID
, RESERVATION_QUANTITY
, COMPLETED_QUANTITY
, AVAILABLE_TO_MRP
, LINE_NUM
, DEMAND_SOURCE_HEADER_ID
, DEMAND_VISIBLE
, FORECAST_VISIBLE
, PARENT_DEMAND_ID
, LINK_TO_LINE_ID
, ATO_LINE_ID
FROM MSC.MSC_TEMP_SALES_ORDERS;
MSC.MSC_TEMP_SALES_ORDERS does not reference any database object
MSC.MSC_TEMP_SALES_ORDERS is referenced by following:
|
|
|