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.

APPS.BIM_DBI_BGT_MGMT_PVT dependencies on BIM_PMV_DBI_UTL_PKG

Line 1091: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,

1087:
1088: BEGIN
1089: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1090: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1091: bim_pmv_dbi_utl_pkg.get_bim_page_params(p_page_parameter_tbl,
1092: l_as_of_date,
1093: l_period_type,
1094: l_record_type_id,
1095: l_comp_type,

Line 1146: l_view_disp:=' DECODE(viewbyid,-999,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'DASS'||''''||')'||',viewby) viewby,';

1142:
1143: /*** to display Directly assigned **/
1144:
1145: IF (l_view_by = 'ITEM+ENI_ITEM_VBH_CAT') AND l_cat_id is not null THEN
1146: l_view_disp:=' DECODE(viewbyid,-999,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'DASS'||''''||')'||',viewby) viewby,';
1147: ELSE
1148: l_view_disp:='viewby,';
1149: END IF;
1150:

Line 1570: decode(d.name,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.name) name,

1566: l_from := l_from ||l_pc_from;
1567: l_where := l_where||l_pc_where;
1568: END IF;
1569: l_col:=' SELECT
1570: decode(d.name,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.name) name,
1571: a.object_country viewbyid,
1572: null meaning ';
1573: l_groupby := ' GROUP BY a.object_country,decode(d.name,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.name) ';
1574: l_from:=' FROM bis_countries_v d '||l_from;

Line 1573: l_groupby := ' GROUP BY a.object_country,decode(d.name,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.name) ';

1569: l_col:=' SELECT
1570: decode(d.name,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.name) name,
1571: a.object_country viewbyid,
1572: null meaning ';
1573: l_groupby := ' GROUP BY a.object_country,decode(d.name,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.name) ';
1574: l_from:=' FROM bis_countries_v d '||l_from;
1575: IF l_campaign_id is null then
1576: IF l_admin_status ='Y' THEN
1577: l_from:=l_from||' , '||l_table||' a ';

Line 1608: decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) name,

1604: l_from := l_from ||l_pc_from;
1605: l_where := l_where||l_pc_where;
1606: END IF;
1607: l_col:=' SELECT
1608: decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) name,
1609: null viewbyid,
1610: null meaning ';
1611: l_groupby := ' GROUP BY decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) ';
1612: l_from:=' FROM bim_dimv_media d '||l_from;

Line 1611: l_groupby := ' GROUP BY decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) ';

1607: l_col:=' SELECT
1608: decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) name,
1609: null viewbyid,
1610: null meaning ';
1611: l_groupby := ' GROUP BY decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) ';
1612: l_from:=' FROM bim_dimv_media d '||l_from;
1613: IF l_campaign_id is null then
1614: IF l_admin_status ='Y' THEN
1615: l_from:=l_from||' ,bim_mkt_chnl_mv a ';

Line 1641: decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) name,

1637: l_from := l_from ||l_pc_from;
1638: l_where := l_where||l_pc_where;
1639: END IF;
1640: l_col:=' SELECT
1641: decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) name,
1642: null viewbyid,
1643: null meaning ';
1644: l_groupby := ' GROUP BY decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) ';
1645: l_from:=' FROM bis_areas_v d '||l_from;

Line 1644: l_groupby := ' GROUP BY decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) ';

1640: l_col:=' SELECT
1641: decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) name,
1642: null viewbyid,
1643: null meaning ';
1644: l_groupby := ' GROUP BY decode(d.value,null,bim_pmv_dbi_utl_pkg.get_lookup_value('||''''||'UNA'||''''||')'||',d.value) ';
1645: l_from:=' FROM bis_areas_v d '||l_from;
1646: IF l_campaign_id is null then
1647: IF l_admin_status ='Y' THEN
1648: l_from:=l_from||' ,bim_mkt_regn_mv a ';