[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_PROCESSED_FST_ID |
---|---|
Object Type: | TABLE |
Owner: | BIL |
FND Design Data: | BIL.BIL_BI_PROCESSED_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_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIL_BI_PROCESSED_FST_ID_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SALES_GROUP_ID
PRODUCT_CATEGORY_ID PERIOD_NAME CREDIT_TYPE_ID SUBMISSION_DATE SALESREP_ID |
BIL_BI_PROCESSED_FST_ID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORECAST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_ID | NUMBER | Yes | Forecast Identifier | |
CREATED_BY | NUMBER | Yes | Standard Who Column | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who Column | |
SECURITY_GROUP_ID | NUMBER | Obsolete. Standard Who Column | ||
TXN_DAY | NUMBER | Transaction Day | ||
SUBMISSION_DATE | DATE | Forecast Submission Date | ||
PERIOD_NAME | VARCHAR2 | (15) | Forecast Period Name | |
SALES_GROUP_ID | NUMBER | Sales Group Identifier | ||
SALESREP_ID | NUMBER | Sales Rep Identifier | ||
PRODUCT_CATEGORY_ID | NUMBER | Product Category Identifier | ||
CREDIT_TYPE_ID | NUMBER | Credit Type Identifier | ||
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Functional Currency | |
PRIMARY_CONVERSION_RATE | NUMBER | Conversion rate from transaction currency to primary global currency | ||
CONVERSION_RATE_S | NUMBER | Conversion rate from transaction currency to secondary global currency | ||
FORECAST_AMT | NUMBER | Forecast Amount In Primary Global Currency | ||
FORECAST_AMT_S | NUMBER | Forecast Amount In Secondary Global Currency | ||
OPP_FORECAST_AMT | NUMBER | Opportunity forecast amount in primary currency | ||
OPP_FORECAST_AMT_S | NUMBER | Opportunity forecast amount in secondary currency |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, TXN_DAY
, SUBMISSION_DATE
, PERIOD_NAME
, SALES_GROUP_ID
, SALESREP_ID
, PRODUCT_CATEGORY_ID
, CREDIT_TYPE_ID
, FUNCTIONAL_CURRENCY
, PRIMARY_CONVERSION_RATE
, CONVERSION_RATE_S
, FORECAST_AMT
, FORECAST_AMT_S
, OPP_FORECAST_AMT
, OPP_FORECAST_AMT_S
FROM BIL.BIL_BI_PROCESSED_FST_ID;
BIL.BIL_BI_PROCESSED_FST_ID does not reference any database object
BIL.BIL_BI_PROCESSED_FST_ID is referenced by following:
|
|
|