[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_NEW_FST_ID |
---|---|
Object Type: | TABLE |
Owner: | BIL |
FND Design Data: | BIL.BIL_BI_NEW_FST_ID |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIL_BI_NEW_FST_ID_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | FORECAST_ID |
BIL_BI_NEW_FST_ID_U2 | NORMAL | UNIQUE | APPS_TS_INTERFACE | RECORD_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_ID | NUMBER | Obsolete column, do not use.Record identifier | ||
FORECAST_ID | NUMBER | Yes | Forecast identifier | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard who column | ||
CURRENCY_CODE | VARCHAR2 | (15) | Transactional Currency Code | |
SUBMISSION_DATE | DATE | Forecast Submission Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Forecasted Period Name | |
COLLECT_MODE | VARCHAR2 | (15) | Collectection Mode - INITIAL or INCREMENTAL |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_ID
, FORECAST_ID
, SECURITY_GROUP_ID
, CURRENCY_CODE
, SUBMISSION_DATE
, PERIOD_NAME
, COLLECT_MODE
FROM BIL.BIL_BI_NEW_FST_ID;
BIL.BIL_BI_NEW_FST_ID does not reference any database object
BIL.BIL_BI_NEW_FST_ID is referenced by following:
|
|
|