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

TABLE: MSC.MSC_TEMP_SUMM_SD

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


This is a temporary tableused for calculating supply/demand summary data 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 Inventory item ID
DEMAND_CLASS VARCHAR2 (30) Yes Demand class
CUSTOMER_CLASS VARCHAR2 (30)
Customer class
CUSTOMER_ID NUMBER

Customer ID
SHIP_TO_SITE_ID NUMBER

Ship-to site ID
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_SD;

Dependencies

[top of page]

MSC.MSC_TEMP_SUMM_SD does not reference any database object

MSC.MSC_TEMP_SUMM_SD is referenced by following:

SchemaAPPS
SynonymMSC_TEMP_SUMM_SD