eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BIL.BIL_BI_FST_DTL_STG

Object Details

Object Name:	BIL_BI_FST_DTL_STG
Object Type:	TABLE
Owner:	BIL
FND Design Data:	BIL.BIL_BI_FST_DTL_STG
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIL_BI_FST_DTL_STG_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SALES_GROUP_ID PRODUCT_CATEGORY_ID PERIOD_NAME SUBMISSION_DATE CREDIT_TYPE_ID SALESREP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_ID	NUMBER			Forecast Identifier
SUBMISSION_DATE	DATE			Forecast Submission Date
PERIOD_NAME	VARCHAR2	(15)		Forecast Period Name
FORECAST_CATEGORY_ID	NUMBER			Obsolete. Forecast category Identifier. Replaced with product_category_id.
PRODUCT_CATEGORY_ID	NUMBER			Product Category Identifier
CREDIT_TYPE_ID	NUMBER		Yes	Credit Type Identifier
SALES_GROUP_ID	NUMBER		Yes	Sales Group Identifier
SALESREP_ID	NUMBER			Salesrep Identifier
TXN_DAY	NUMBER			Time id of the day corresponding to the forecast submission date
TXN_WEEK	NUMBER			Time id of the week corresponding to the forecast submission date
TXN_PERIOD	NUMBER			Time id of the period (month, etc.) corresponding to the forecast submission date
TXN_QUARTER	NUMBER			Time id of the quarter corresponding to the forecast submission date
TXN_YEAR	NUMBER			Time id of the year corresponding to the forecast submission date
FORECAST_PERIOD_DAY	NUMBER			Time id of the day corresponding to the forecast period
FORECAST_PERIOD_WEEK	NUMBER			Time id of the week corresponding to the forecast period
FORECAST_PERIOD_PERIOD	NUMBER			Time id of the period (month, etc.) corresponding to the forecast period
FORECAST_PERIOD_QUARTER	NUMBER			Time id of the quarter corresponding to the forecast period
FORECAST_PERIOD_YEAR	NUMBER			Time id of the year corresponding to the forecast period
FUNCTIONAL_CURRENCY	VARCHAR2	(15)		Functional currency code
PRIMARY_CONVERSION_RATE	NUMBER			Conversion rate from transaction currency to primary global currency
FORECAST_AMT	NUMBER			Forecast Amount In Primary Global Currency
VALID_FLAG	VARCHAR2	(1)		Flag to indicate whether the row is valid - the time id is in the time dimension
SECURITY_GROUP_ID	NUMBER			Obsolete. Standard who column
CONVERSION_RATE_S	NUMBER			Conversion rate from transaction currency to secondary global currency
FORECAST_AMT_S	NUMBER			Forecast Amount In Secondary Global Currency
FORECAST_AMT_1	NUMBER			Dummy Column For Summary Adjustment In Primary Global Currency
FORECAST_AMT_S_1	NUMBER			Dummy Column For Summary Adjustment 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
OPP_FORECAST_AMT_1	NUMBER			Column used for performing summary adjustments
OPP_FORECAST_AMT_S_1	NUMBER			Column used for performing summary adjustments in secondary currency

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FORECAST_ID
,      SUBMISSION_DATE
,      PERIOD_NAME
,      FORECAST_CATEGORY_ID
,      PRODUCT_CATEGORY_ID
,      CREDIT_TYPE_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      TXN_DAY
,      TXN_WEEK
,      TXN_PERIOD
,      TXN_QUARTER
,      TXN_YEAR
,      FORECAST_PERIOD_DAY
,      FORECAST_PERIOD_WEEK
,      FORECAST_PERIOD_PERIOD
,      FORECAST_PERIOD_QUARTER
,      FORECAST_PERIOD_YEAR
,      FUNCTIONAL_CURRENCY
,      PRIMARY_CONVERSION_RATE
,      FORECAST_AMT
,      VALID_FLAG
,      SECURITY_GROUP_ID
,      CONVERSION_RATE_S
,      FORECAST_AMT_S
,      FORECAST_AMT_1
,      FORECAST_AMT_S_1
,      OPP_FORECAST_AMT
,      OPP_FORECAST_AMT_S
,      OPP_FORECAST_AMT_1
,      OPP_FORECAST_AMT_S_1
FROM BIL.BIL_BI_FST_DTL_STG;

Dependencies

[top of page]

BIL.BIL_BI_FST_DTL_STG does not reference any database object

BIL.BIL_BI_FST_DTL_STG is referenced by following:

APPS: BIL_BI_FST_DTL_STG