[Home] [Help] [Dependency Information]
Object Name: | EDW_MRP_FCDM_FCS_LSTG |
---|---|
Object Type: | TABLE |
Owner: | ISC |
FND Design Data: | ISC.EDW_MRP_FCDM_FCS_LSTG |
Subobject Name: | |
Status: | VALID |
This is the interface table for the Forecast 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_FCS_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | FORECAST_PK |
EDW_MRP_FCDM_FCS_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_PK | VARCHAR2 | (40) | Unique identifier | |
FORECAST_SET_FK | VARCHAR2 | (40) | Foreign key to the Forecast Set level | |
FORECAST_SET_FK_KEY | NUMBER | System generated foreign key to the Forecast Set level | ||
COLLECTION_STATUS | VARCHAR2 | (30) | Collection status code for the record | |
DESCRIPTION | VARCHAR2 | (240) | Forecast description | |
DISABLE_DATE | DATE | Date on which that Forecast was disabled | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
FORECAST_DP | VARCHAR2 | (240) | Unique Forecast name | |
FORECAST_NAME | VARCHAR2 | (80) | Forecast name | |
INSTANCE_CODE | VARCHAR2 | (40) | Instance code refering to the source application | |
NAME | VARCHAR2 | (2000) | Alternate Forecast 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_PK
, FORECAST_SET_FK
, FORECAST_SET_FK_KEY
, COLLECTION_STATUS
, DESCRIPTION
, DISABLE_DATE
, ERROR_CODE
, FORECAST_DP
, FORECAST_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_FCS_LSTG;
ISC.EDW_MRP_FCDM_FCS_LSTG does not reference any database object
ISC.EDW_MRP_FCDM_FCS_LSTG is referenced by following:
|
|
|