[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_FCDM_SET_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_FCDM_SET_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Forecast Set level table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_MRP_FCDM_SET_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | FORECAST_SET_PK |
EDW_MRP_FCDM_SET_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_SET_PK | VARCHAR2 | (40) | Unique identifier | |
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
CONSUMPTION_LEVEL | VARCHAR2 | (80) | Consumption Level for the Forecast Set. This determines how forecasts in the set are defined and consumed; for example, Consumption Level can bet set at the Item level, or at the Item and Customer level, or at the Item, Customer and Ship-to level, etc. | |
DESCRIPTION | VARCHAR2 | (240) | Forecast Set description | |
DISABLE_DATE | DATE | Date on which that Forecast Set was disabled | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
FORECAST_SET_DP | VARCHAR2 | (240) | Unique Forecast Set name | |
FORECAST_SET_NAME | VARCHAR2 | (80) | Forecast Set name | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance code refering to the source application | |
NAME | VARCHAR2 | (2000) | Alternate Forecast Set name | |
OPERATION_CODE | VARCHAR2 | (30) | Code used by the collection program to determine whether to insert/update/delete this record | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ROW_ID | ROWID | (10) | Row Id | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User attribute |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_SET_PK
, COLLECTION_STATUS
, CONSUMPTION_LEVEL
, DESCRIPTION
, DISABLE_DATE
, ERROR_CODE
, FORECAST_SET_DP
, FORECAST_SET_NAME
, INSTANCE_CODE
, NAME
, OPERATION_CODE
, REQUEST_ID
, ROW_ID
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM ISC.EDW_MRP_FCDM_SET_LSTG;
ISC.EDW_MRP_FCDM_SET_LSTG does not reference any database object
ISC.EDW_MRP_FCDM_SET_LSTG is referenced by following:
|
|
|