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: APPS.BIL_BI_FST_PG_MV

Object Details

Object Name:	BIL_BI_FST_PG_MV
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
I_SNAP$_BIL_BI_FST_PG_MV	FUNCTION-BASED NORMAL	UNIQUE	APPS_TS_SUMMARY	SYS_OP_MAP_NONNULL("TXN_TIME_ID") SYS_OP_MAP_NONNULL("TXN_PERIOD_TYPE_ID") SYS_OP_MAP_NONNULL("EFFECTIVE_TIME_ID") SYS_OP_MAP_NONNULL("EFFECTIVE_PERIOD_TYPE_ID") SYS_OP_MAP_NONNULL("PRODUCT_CATEGORY_ID") SYS_OP_MAP_NONNULL("ASSIGN_TO_CAT") SYS_OP_MAP_NONNULL("CREDIT_TYPE_ID") SYS_OP_MAP_NONNULL("PARENT_SALES_GROUP_ID") SYS_OP_MAP_NONNULL("SALES_GROUP_ID") SYS_OP_MAP_NONNULL("SALESREP_ID")
BIL_BI_FST_PG_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	TXN_TIME_ID TXN_PERIOD_TYPE_ID EFFECTIVE_TIME_ID EFFECTIVE_PERIOD_TYPE_ID PARENT_SALES_GROUP_ID PRODUCT_CATEGORY_ID SALES_GROUP_ID SALESREP_ID

Columns

Name	Datatype	Comments
TXN_TIME_ID	NUMBER	Transaction date is Last update date representing As-of-date.
TXN_PERIOD_TYPE_ID	NUMBER	Period type of txn_time_id. Valid period type in BIS Enterprise calendar.
EFFECTIVE_TIME_ID	NUMBER	Effective date rolled up over week, period, quarter, year.
EFFECTIVE_PERIOD_TYPE_ID	NUMBER	Period type of effective_time_id. Valid period type in BIS Enterprise calendar.
PARENT_SALES_GROUP_ID	NUMBER	Sales group identifier.
SALES_GROUP_ID	NUMBER	Parent sales group identifier .
SALESREP_ID	NUMBER	Salesperson or resource identifier.
PRODUCT_CATEGORY_ID	NUMBER	Identifier of Product Category.
ASSIGN_TO_CAT	NUMBER	IF 1 then the forecast was for this product category.
CREDIT_TYPE_ID	NUMBER	Identifier of Forecast Credit Type.
FORECAST_AMT	NUMBER	My Forecast Amounts in primary currency.
FORECAST_AMT_S	NUMBER	My Forecast Amounts in secondary currency.
FORECAST_AMT_SUB	NUMBER	Forecast Amount for my Subordinates in primary currency.
FORECAST_AMT_SUB_S	NUMBER	Forecast Amount for my Subordinates in secondary currency.
FORECAST_AMT_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.
FORECAST_AMT_XCNT_S	NUMBER	Dummy count columns required to create fast refresh MV .
FORECAST_AMT_SUB_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.
FORECAST_AMT_SUB_XCNT_S	NUMBER	Dummy count columns required to create fast refresh MV.
ALL_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT	NUMBER	Opportunity forecast amount in primary currency.
OPP_FORECAST_AMT_S	NUMBER	Opportunity forecast amount in secondary currency.
OPP_FORECAST_AMT_SUB	NUMBER	Opportunity forecast amount in primary currency for subordinates.
OPP_FORECAST_AMT_SUB_S	NUMBER	Opportunity forecast amount in secondary currency for subordinates.
OPP_FORECAST_AMT_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT_S_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT_SUB_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.
OPP_FORECAST_AMT_SUB_S_XCNT	NUMBER	Dummy count columns required to create fast refresh MV.

Query Text

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


SELECT TXN_TIME_ID
,      TXN_PERIOD_TYPE_ID
,      EFFECTIVE_TIME_ID
,      EFFECTIVE_PERIOD_TYPE_ID
,      PARENT_SALES_GROUP_ID
,      SALES_GROUP_ID
,      SALESREP_ID
,      PRODUCT_CATEGORY_ID
,      ASSIGN_TO_CAT
,      CREDIT_TYPE_ID
,      FORECAST_AMT
,      FORECAST_AMT_S
,      FORECAST_AMT_SUB
,      FORECAST_AMT_SUB_S
,      FORECAST_AMT_XCNT
,      FORECAST_AMT_XCNT_S
,      FORECAST_AMT_SUB_XCNT
,      FORECAST_AMT_SUB_XCNT_S
,      ALL_XCNT
,      OPP_FORECAST_AMT
,      OPP_FORECAST_AMT_S
,      OPP_FORECAST_AMT_SUB
,      OPP_FORECAST_AMT_SUB_S
,      OPP_FORECAST_AMT_XCNT
,      OPP_FORECAST_AMT_S_XCNT
,      OPP_FORECAST_AMT_SUB_XCNT
,      OPP_FORECAST_AMT_SUB_S_XCNT
FROM APPS.BIL_BI_FST_PG_MV;

Dependencies

[top of page]

APPS.BIL_BI_FST_PG_MV does not reference any database object

APPS.BIL_BI_FST_PG_MV is referenced by following:

APPS: BIL_BI_FST_PG_MV