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

TABLE: MSC.MSC_TEMP_SUMM_SO

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


This is a temporary table used to calculate summary data for sales orders during post plan processing


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 0
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes Plan ID
SR_INSTANCE_ID NUMBER
Yes Source instance ID
ORGANIZATION_ID NUMBER
Yes Organization ID
INVENTORY_ITEM_ID NUMBER
Yes Item ID
DEMAND_CLASS VARCHAR2 (30) Yes Demand class
CUSTOMER_CLASS VARCHAR2 (30)
Customer class (unused)
CUSTOMER_ID NUMBER

Customer ID (unused)
SHIP_TO_SITE_ID NUMBER

Ship-to site (unused)
SD_DATE DATE
Yes Date of Supply/Demand
SD_QTY NUMBER
Yes Supply/Demand quantity. Negative for demands
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
TASK_ID NUMBER

Task ID (unused)
PROJECT_ID NUMBER

Project ID (unused)
PLANNING_GROUP VARCHAR2 (30)
Planning group (unused)
Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DEMAND_CLASS
,      CUSTOMER_CLASS
,      CUSTOMER_ID
,      SHIP_TO_SITE_ID
,      SD_DATE
,      SD_QTY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TASK_ID
,      PROJECT_ID
,      PLANNING_GROUP
FROM MSC.MSC_TEMP_SUMM_SO;

Dependencies

[top of page]

MSC.MSC_TEMP_SUMM_SO does not reference any database object

MSC.MSC_TEMP_SUMM_SO is referenced by following:

SchemaMSC
ViewMSC_TEMP_SUMM_SO#