[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_FST_PG_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
Name | Datatype | Length | Mandatory | 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. |
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;
APPS.BIL_BI_FST_PG_MV does not reference any database object
APPS.BIL_BI_FST_PG_MV is referenced by following:
|
|
|