[Home] [Help] [Dependency Information]
Object Name: | MSC_EXPLODED_COMP_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
This is a table used in Global Forecast for generating sourcing rule for te items concerned. This table is required as teh DP may be unexploded. This is a temporary table and records will be deleted after snapshot is run. No index.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_EXPLODED_COMP_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
PLAN_ID
SCENARIO_ID SR_INVENTORY_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Plan Id | ||
SCENARIO_ID | NUMBER | Scenario Id | ||
SR_ORGANIZATION_ID | NUMBER | SR ORGANIZTAION ID | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item id | ||
SR_INVENTORY_ITEM_ID | NUMBER | Source Inventory Item Id | ||
SR_INSTANCE_ID | NUMBER | Sr Instance Id | ||
SHIP_TO | NUMBER | Ship To | ||
SR_CUSTOMER_ID | NUMBER | Sr Customer Id | ||
SR_SHIP_TO_LOC_ID | NUMBER | Sr Ship To Loc Id | ||
SR_ZONE_ID | NUMBER | Sr Zone Id | ||
DEMAND_CLASS | VARCHAR2 | (30) | Demand Class | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date | |
LAST_UPDATED_BY | NUMBER | Yes | Last Updated By | |
CREATION_DATE | DATE | Yes | Creation Date | |
CREATED_BY | NUMBER | Yes | Created By | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
NEW_COMBINATION | NUMBER | This column is used to indiate if the item/customer/customer_site combintion is a new one ( Used in DP Scenarios only snapshot mode) | ||
FORECAST_SOURCE_TYPE | NUMBER | Identifies if the record is coming from global demand schedules or from inline global forecast. |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, SCENARIO_ID
, SR_ORGANIZATION_ID
, INVENTORY_ITEM_ID
, SR_INVENTORY_ITEM_ID
, SR_INSTANCE_ID
, SHIP_TO
, SR_CUSTOMER_ID
, SR_SHIP_TO_LOC_ID
, SR_ZONE_ID
, DEMAND_CLASS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NEW_COMBINATION
, FORECAST_SOURCE_TYPE
FROM MSC.MSC_EXPLODED_COMP_TEMP;
MSC.MSC_EXPLODED_COMP_TEMP does not reference any database object
MSC.MSC_EXPLODED_COMP_TEMP is referenced by following:
|
|
|