Results for “product_group”
29 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BIS_CSTMRGPGTT_V is a reporting view in the Oracle EBS Applications BIS (Business Intelligence System) product family. Its documentation metadata describes it as "Retrofitted," indicating that the object was carried forward from an earlier release line into the 12.1.1 / 12.2.2 codebase, and it is listed under the ETRM record as "Not implemented in this database." The latter designation is significant: the view is defined in the repository for reference and upgrade purposes but is not instantiated in every environment.
The object belongs to the Oracle Balanced Scorecard / target-management area of BIS, which stores business plan definitions, target values, and performance ranges. Its suffix "_V" identifies it as a view rather than a base table, and its name contains the string "CSTMRGPGTT", which the view text ties explicitly to a target level short name. Functionally, the view flattens hierarchical target data into a denormalized, report-friendly shape suitable for business reporting and downstream integration.
Underlying Base Objects
The view text is defined over a four-table join:
- BIS_TARGET_VALUES — alias
VAL, the fact-style table holding target values and range boundaries. - BIS_BUSINESS_PLANS — alias
PLAN, supplying plan identity, naming, version, and current-plan status. - BIS_TARGET_LEVELS — alias
LVL, defining the target level and process context. - GL_PERIODS — alias
GL, the General Ledger period reference used in the join.
The ETRM metadata records no referenced base objects separately ("none documented"), so the authoritative source for join structure is the embedded view text. The join predicate links VAL.TARGET_LEVEL_ID = LVL.TARGET_LEVEL_ID, VAL.PLAN_ID = PLAN.PLAN_ID, and filters LVL.SHORT_NAME = 'CSTMRGPGTT', with GL_PERIODS participating in the FROM clause. The hard-coded short name means the view returns only the target level associated with the "CSTMRGPGTT" (customer/product group target) definition.
Key Columns
- WF_PROCESS — the workflow or process context inherited from the target level.
- PLAN_ID, PLAN_SHORT_NAME, VERSION_NO, CURRENT_PLAN_FLAG — plan identity and versioning attributes;
CURRENT_PLAN_FLAGdistinguishes the active plan version from historical ones. - TOTAL_TIME — the time bucket associated with the target value.
- PRODUCT_GROUP — the product group dimension value, which corresponds to the user search term. This is the primary dimensional column for grouping results.
- TARGET, RANGE1_LOW, RANGE1_HIGH, RANGE2_LOW, RANGE2_HIGH, RANGE3_LOW, RANGE3_HIGH — the target figure and up to three performance ranges, commonly used for scorecard banding and threshold analysis.
- ROLE1_ID, ROLE2_ID, ROLE3_ID and ROLE1, ROLE2, ROLE3 — role identifiers and their display names, assigning accountability for each target.
Common Use Cases and Queries
Typical usage is ad hoc reporting over balanced-scorecard targets by product group, filtering to the current plan version and comparing actual performance against the defined ranges.
- Listing current product-group targets:
SELECT product_group, target, range1_low, range1_high FROM bis_cstmrpgtt_v WHERE current_plan_flag = 'Y';
- Reviewing role accountability for a plan:
SELECT plan_short_name, product_group, role1, role2, role3 FROM bis_cstmrpgtt_v WHERE plan_id = :plan_id;
- Examining all versions of a plan:
SELECT plan_short_name, version_no, current_plan_flag, product_group, target FROM bis_cstmrpgtt_v ORDER BY plan_short_name, version_no;
Because the view is documented as not implemented in all databases, queries should first confirm object existence, and consumers should expect the object to appear only in environments where the BIS target-level configuration for "CSTMRGPGTT" has been deployed.
-
View: BIS_CSTMRGPGTT_V 12.1.1
- Retrofitted
APPS.BIS_CSTMRGPGTT_V·↳ BIS_BUSINESS_PLANS·↳ BIS_TARGET_LEVELS·↳ BIS_TARGET_VALUES·Explore BIS module →
-
View: OE_BIS_BACKLOG_V 12.2.2
APPS.OE_BIS_BACKLOG_V·↳ CST_ITEM_COSTS·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore OE module →
-
View: OE_BIS_BILLINGS_V 12.2.2
APPS.OE_BIS_BILLINGS_V·↳ CST_ITEM_COSTS·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore OE module →
-
View: OE_BIS_BACKLOG_V 12.1.1
APPS.OE_BIS_BACKLOG_V·↳ CST_ITEM_COSTS·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore OE module →
-
View: OE_BIS_BILLINGS_V 12.1.1
APPS.OE_BIS_BILLINGS_V·↳ CST_ITEM_COSTS·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore OE module →
-
View: OE_BIS_BOOKINGS_V 12.1.1
APPS.OE_BIS_BOOKINGS_V·↳ CST_ITEM_COSTS·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore OE module →
-
View: OE_BIS_BOOKINGS_V 12.2.2
APPS.OE_BIS_BOOKINGS_V·↳ CST_ITEM_COSTS·↳ FND_GLOBAL·↳ GL_SETS_OF_BOOKS·Explore OE module →
-
Specifies the dimensions that a particular application will use for summarizing into BIX_SUM_INFO
-
VIEW: APPS.OE_BIS_BOOKINGS_V 12.1.1
-
VIEW: APPS.OE_BIS_BOOKINGS_V 12.2.2
-
VIEW: APPS.OE_BIS_BILLINGS_V 12.1.1
-
VIEW: APPS.OE_BIS_BILLINGS_V 12.2.2
-
VIEW: APPS.OE_BIS_BACKLOG_V 12.2.2
-
VIEW: APPS.OE_BIS_BACKLOG_V 12.1.1
-
VIEW: APPS.BIS_CSTMRGPGTT_V 12.1.1
-
View: BIS_CSTMRGPGTT_V 12.2.2
- Retrofitted
Not implemented in this database·Explore BIS module →
-
VIEW: APPS.OE_BIS_BOOKINGS_V 12.1.1
-
VIEW: APPS.OE_BIS_BOOKINGS_V 12.2.2
-
VIEW: APPS.OE_BIS_BILLINGS_V 12.1.1
-
VIEW: APPS.OE_BIS_BILLINGS_V 12.2.2
-
VIEW: APPS.OE_BIS_BACKLOG_V 12.1.1
-
PACKAGE: SYSTEM.AD_DDL 12.2.2
-
VIEW: APPS.OE_BIS_BACKLOG_V 12.2.2
-
PACKAGE: SYSTEM.AD_DDL 12.1.1
-
eTRM - BIX Tables and Views 12.1.1
-
eTRM - OE Tables and Views 12.1.1
Temporary table
-
eTRM - OE Tables and Views 12.2.2
Temporary table
-
eTRM - BIS Tables and Views 12.1.1