[Home] [Help] [Dependency Information]
Object Name: | MSD_DP_SCN_ENTRIES_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MSD |
Subobject Name: | |
Status: | VALID |
This is temporary table used for DP performance improvements
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
FORECAST_DESIGNATOR | VARCHAR2 | (10) | Yes | Forecast Designator |
ORGANIZATION_ID | NUMBER | Yes | Organization Id | |
FORECAST_DATE | DATE | Yes | Forecast Date | |
QUANTITY | NUMBER | Yes | Quantity | |
BUCKET_TYPE | NUMBER | Bucket Type | ||
FORECAST_END_DATE | DATE | Forecast End Date |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, FORECAST_DESIGNATOR
, ORGANIZATION_ID
, FORECAST_DATE
, QUANTITY
, BUCKET_TYPE
, FORECAST_END_DATE
FROM MSD.MSD_DP_SCN_ENTRIES_TEMP;
MSD.MSD_DP_SCN_ENTRIES_TEMP does not reference any database object
MSD.MSD_DP_SCN_ENTRIES_TEMP is referenced by following:
|
|
|