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

TABLE: MSC.MSC_TEMP_SALES_ORDERS

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

Temporary Table Details

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.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Primary Key: MSC_TEMP_SALES_ORDERS_PK
  1. ColumnDEMAND_ID
  2. ColumnSR_INSTANCE_ID
Indexes
Index Type Uniqueness Tablespace Column
MSC_TEMP_SALES_ORDERS_PK NORMAL UNIQUE Tablespace ColumnDEMAND_ID
ColumnSR_INSTANCE_ID
Columns
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

Query Text

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;

Dependencies

[top of page]

MSC.MSC_TEMP_SALES_ORDERS does not reference any database object

MSC.MSC_TEMP_SALES_ORDERS is referenced by following:

SchemaAPPS
SynonymMSC_TEMP_SALES_ORDERS