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.POA_DBI_TEMPLATE_PKG dependencies on FND_GLOBAL

Line 115: || fnd_global.newline;

111: || l_col_calc_tbl(i).calc_end
112: || ' '
113: || l_col_calc_tbl(i).alias_begin
114: || l_col_calc_tbl(i).alias_end
115: || fnd_global.newline;
116: END LOOP;
117:
118:
119: -- 0 (0 0 0) = neither XTD or XED

Line 198: || fnd_global.newline

194: if( bitand(l_inlist_bmap, g_inlist_rlx) = g_inlist_rlx) then
195: l_join_tables := ', fii_time_structures cal '|| l_in_join_tables;
196: l_full_where_clause := ' where fact.time_id = cal.time_id '
197: || 'and fact.period_type_id = cal.period_type_id '
198: || fnd_global.newline
199: || p_where_clause
200: || fnd_global.newline
201: || 'and cal.report_date in '
202: || l_inlist

Line 200: || fnd_global.newline

196: l_full_where_clause := ' where fact.time_id = cal.time_id '
197: || 'and fact.period_type_id = cal.period_type_id '
198: || fnd_global.newline
199: || p_where_clause
200: || fnd_global.newline
201: || 'and cal.report_date in '
202: || l_inlist
203: -- &RLX_NESTED_PATTERN should be replaced with some
204: -- &BIS bind substitution when available from fii/bis team.

Line 205: || fnd_global.newline

201: || 'and cal.report_date in '
202: || l_inlist
203: -- &RLX_NESTED_PATTERN should be replaced with some
204: -- &BIS bind substitution when available from fii/bis team.
205: || fnd_global.newline
206: || 'and bitand(cal.record_type_id, &RLX_NESTED_PATTERN) = '
207: || '&RLX_NESTED_PATTERN ';
208: elsif( bitand(l_inlist_bmap, g_inlist_bal) = g_inlist_bal) then
209: l_join_tables := '';

Line 220: || fnd_global.newline

216: l_full_where_clause := ' where ' || p_where_clause;
217: end if;
218: else
219: l_join_tables := ', fii_time_rpt_struct_v cal'
220: || fnd_global.newline
221: || l_in_join_tables;
222: l_full_where_clause :=' where fact.time_id = cal.time_id '
223: || p_where_clause
224: || fnd_global.newline

Line 224: || fnd_global.newline

220: || fnd_global.newline
221: || l_in_join_tables;
222: l_full_where_clause :=' where fact.time_id = cal.time_id '
223: || p_where_clause
224: || fnd_global.newline
225: || ' and cal.report_date in '
226: || l_inlist
227: || fnd_global.newline
228: || ' and bitand(cal.record_type_id, '

Line 227: || fnd_global.newline

223: || p_where_clause
224: || fnd_global.newline
225: || ' and cal.report_date in '
226: || l_inlist
227: || fnd_global.newline
228: || ' and bitand(cal.record_type_id, '
229: || CASE -- if one or more columns = YTD then use nested pattern
230: WHEN BITAND (l_inlist_bmap, g_inlist_ytd) = g_inlist_ytd
231: THEN '&YTD_NESTED_PATTERN'

Line 239: || fnd_global.newline||' from '

235: end if;
236: l_query := '(select '
237: || l_group_and_sel_clause
238: || l_col_names
239: || fnd_global.newline||' from '
240: || p_fact_name
241: || ' fact'
242: || l_join_tables
243: || l_full_where_clause

Line 245: || fnd_global.newline||' group by '

241: || ' fact'
242: || l_join_tables
243: || l_full_where_clause
244: || l_grpid_clause
245: || fnd_global.newline||' group by '
246: || l_group_and_sel_clause
247: || l_paren_str;
248:
249:

Line 257: ',' || fnd_global.newline;

253: l_viewby_rank_where :='';
254:
255: if(p_use_windowing <> 'P') then
256: l_viewby_rank_where := l_viewby_rank_where ||
257: ',' || fnd_global.newline;
258: end if;
259: l_viewby_rank_where := l_viewby_rank_where ||
260: get_viewby_rank_clause (
261: p_join_tables => p_join_tables

Line 532: || fnd_global.newline

528: l_query_tbl := poa_dbi_util_pkg.poa_dbi_union_query_tbl();
529: for m in 1 .. p_mv.count loop
530: l_query_tbl.extend;
531: l_query_tbl(l_query_tbl.count).in_union_sel := 'cal.name cal_name'
532: || fnd_global.newline
533: || ', cal.start_date cal_start_date'
534: || fnd_global.newline;
535: end loop;
536:

Line 534: || fnd_global.newline;

530: l_query_tbl.extend;
531: l_query_tbl(l_query_tbl.count).in_union_sel := 'cal.name cal_name'
532: || fnd_global.newline
533: || ', cal.start_date cal_start_date'
534: || fnd_global.newline;
535: end loop;
536:
537: l_union_sel := 'cal_name'
538: || fnd_global.newline

Line 538: || fnd_global.newline

534: || fnd_global.newline;
535: end loop;
536:
537: l_union_sel := 'cal_name'
538: || fnd_global.newline
539: || ', cal_start_date'
540: || fnd_global.newline;
541:
542:

Line 540: || fnd_global.newline;

536:
537: l_union_sel := 'cal_name'
538: || fnd_global.newline
539: || ', cal_start_date'
540: || fnd_global.newline;
541:
542:
543: for i in 1 ..p_mv.count loop -- main loop
544: l_query_tbl(i).template_sql :=

Line 573: || fnd_global.newline;

569: l_query_tbl(k).in_union_sel :=
570: l_query_tbl(k).in_union_sel
571: || ', '
572: || l_col_list(j)
573: || fnd_global.newline;
574: else
575: l_query_tbl(k).in_union_sel :=
576: l_query_tbl(k).in_union_sel
577: || ', 0 '

Line 579: || fnd_global.newline;

575: l_query_tbl(k).in_union_sel :=
576: l_query_tbl(k).in_union_sel
577: || ', 0 '
578: || l_col_list(j)
579: || fnd_global.newline;
580: end if;
581: end loop; -- k loop
582: l_union_sel := l_union_sel
583: || ', sum('

Line 587: || fnd_global.newline;

583: || ', sum('
584: || l_col_list(j)
585: || ') '
586: || l_col_list(j)
587: || fnd_global.newline;
588: end loop; -- j loop
589: else
590: for j in 1 .. l_col_list.count loop
591: l_query_tbl(i).in_union_sel :=

Line 595: || fnd_global.newline;

591: l_query_tbl(i).in_union_sel :=
592: l_query_tbl(i).in_union_sel
593: || ', '
594: || l_col_list(j)
595: || fnd_global.newline;
596: if(i=1) then /*outer select clause needs to be built only once */
597: l_union_sel := l_union_sel
598: || ', sum('
599: || l_col_list(j)

Line 602: || fnd_global.newline;

598: || ', sum('
599: || l_col_list(j)
600: || ') '
601: || l_col_list(j)
602: || fnd_global.newline;
603: end if;
604: end loop;
605: end if;
606: end loop ; -- i loop

Line 610: poa_dbi_util_pkg.get_rolling_inline_view || ' select' || fnd_global.newline

606: end loop ; -- i loop
607:
608: ---Begin Changes for spend trend graph
609: l_query := case when p_mv(1).mv_xtd like 'RL%' then
610: poa_dbi_util_pkg.get_rolling_inline_view || ' select' || fnd_global.newline
611: else ' ( select' || fnd_global.newline end
612: ---End Changes for spend trend graph
613: || l_union_sel
614: || 'from (' || fnd_global.newline;

Line 611: else ' ( select' || fnd_global.newline end

607:
608: ---Begin Changes for spend trend graph
609: l_query := case when p_mv(1).mv_xtd like 'RL%' then
610: poa_dbi_util_pkg.get_rolling_inline_view || ' select' || fnd_global.newline
611: else ' ( select' || fnd_global.newline end
612: ---End Changes for spend trend graph
613: || l_union_sel
614: || 'from (' || fnd_global.newline;
615:

Line 614: || 'from (' || fnd_global.newline;

610: poa_dbi_util_pkg.get_rolling_inline_view || ' select' || fnd_global.newline
611: else ' ( select' || fnd_global.newline end
612: ---End Changes for spend trend graph
613: || l_union_sel
614: || 'from (' || fnd_global.newline;
615:
616: FOR m IN 1 .. l_query_tbl.COUNT LOOP
617: l_query := l_query
618: || '(select' || fnd_global.newline

Line 618: || '(select' || fnd_global.newline

614: || 'from (' || fnd_global.newline;
615:
616: FOR m IN 1 .. l_query_tbl.COUNT LOOP
617: l_query := l_query
618: || '(select' || fnd_global.newline
619: || l_query_tbl(m).in_union_sel
620: || 'from ' || fnd_global.newline
621: || replace(l_query_tbl(m).template_sql,'order by cal.start_date','')
622: || fnd_global.newline;

Line 620: || 'from ' || fnd_global.newline

616: FOR m IN 1 .. l_query_tbl.COUNT LOOP
617: l_query := l_query
618: || '(select' || fnd_global.newline
619: || l_query_tbl(m).in_union_sel
620: || 'from ' || fnd_global.newline
621: || replace(l_query_tbl(m).template_sql,'order by cal.start_date','')
622: || fnd_global.newline;
623: IF(m <> l_query_tbl.COUNT) THEN
624: l_query := l_query || ') UNION ALL ' || fnd_global.newline;

Line 622: || fnd_global.newline;

618: || '(select' || fnd_global.newline
619: || l_query_tbl(m).in_union_sel
620: || 'from ' || fnd_global.newline
621: || replace(l_query_tbl(m).template_sql,'order by cal.start_date','')
622: || fnd_global.newline;
623: IF(m <> l_query_tbl.COUNT) THEN
624: l_query := l_query || ') UNION ALL ' || fnd_global.newline;
625: END IF;
626: END LOOP;

Line 624: l_query := l_query || ') UNION ALL ' || fnd_global.newline;

620: || 'from ' || fnd_global.newline
621: || replace(l_query_tbl(m).template_sql,'order by cal.start_date','')
622: || fnd_global.newline;
623: IF(m <> l_query_tbl.COUNT) THEN
624: l_query := l_query || ') UNION ALL ' || fnd_global.newline;
625: END IF;
626: END LOOP;
627:
628: l_query := l_query

Line 630: || fnd_global.newline

626: END LOOP;
627:
628: l_query := l_query
629: || ')) group by cal_name, cal_start_date '
630: || fnd_global.newline
631: || ') uset ' || fnd_global.newline
632: || 'order by cal_start_date' || fnd_global.newline;
633:
634: return l_query;

Line 631: || ') uset ' || fnd_global.newline

627:
628: l_query := l_query
629: || ')) group by cal_name, cal_start_date '
630: || fnd_global.newline
631: || ') uset ' || fnd_global.newline
632: || 'order by cal_start_date' || fnd_global.newline;
633:
634: return l_query;
635: END union_all_trend_sql;

Line 632: || 'order by cal_start_date' || fnd_global.newline;

628: l_query := l_query
629: || ')) group by cal_name, cal_start_date '
630: || fnd_global.newline
631: || ') uset ' || fnd_global.newline
632: || 'order by cal_start_date' || fnd_global.newline;
633:
634: return l_query;
635: END union_all_trend_sql;
636:

Line 711: || fnd_global.newline;

707: -- measure needs to be put down
708: l_query_tbl(l).in_union_sel := l_query_tbl(l).in_union_sel
709: || ', '
710: || l_col_calc(k).alias_begin
711: || fnd_global.newline;
712: else -- measure needs to be forced to 0
713: l_query_tbl(l).in_union_sel := l_query_tbl(l).in_union_sel
714: || ', 0 '
715: || l_col_calc(k).alias_begin

Line 716: || fnd_global.newline;

712: else -- measure needs to be forced to 0
713: l_query_tbl(l).in_union_sel := l_query_tbl(l).in_union_sel
714: || ', 0 '
715: || l_col_calc(k).alias_begin
716: || fnd_global.newline;
717: end if;
718: end loop; -- loop 3
719: end if;
720:

Line 729: || fnd_global.newline;

725: || l_col_calc(k).calc_end
726: || ' '
727: || l_col_calc(k).alias_begin
728: || l_col_calc(k).alias_end
729: || fnd_global.newline;
730:
731: end loop; -- loop 2
732: else
733: for k in 1 .. l_col_calc.count loop

Line 740: || fnd_global.newline;

736: else
737: l_query_tbl(i).in_union_sel := l_query_tbl(i).in_union_sel
738: || ', '
739: || l_col_calc(k).alias_begin
740: || fnd_global.newline;
741: end if;
742:
743: if(i = 1) then
744: /*need to calculate outer sel clause only once*/

Line 753: || fnd_global.newline;

749: || l_col_calc(k).calc_end
750: || ' '
751: || l_col_calc(k).alias_begin
752: || l_col_calc(k).alias_end
753: || fnd_global.newline;
754: end if;
755: end loop;
756: end if;
757: end loop; -- main loop

Line 767: || fnd_global.newline

763: end if;
764:
765: l_query := 'select '
766: || l_sel_clause
767: || fnd_global.newline
768: || l_out_union_sel
769: || 'from (' || fnd_global.newline;
770:
771: for m in 1 .. l_query_tbl.count loop

Line 769: || 'from (' || fnd_global.newline;

765: l_query := 'select '
766: || l_sel_clause
767: || fnd_global.newline
768: || l_out_union_sel
769: || 'from (' || fnd_global.newline;
770:
771: for m in 1 .. l_query_tbl.count loop
772: l_query := l_query || 'select '
773: || l_sel_clause || fnd_global.newline

Line 773: || l_sel_clause || fnd_global.newline

769: || 'from (' || fnd_global.newline;
770:
771: for m in 1 .. l_query_tbl.count loop
772: l_query := l_query || 'select '
773: || l_sel_clause || fnd_global.newline
774: || l_query_tbl(m).in_union_sel
775: || 'from ' || fnd_global.newline
776: || '(('
777: || l_query_tbl(m).template_sql;

Line 775: || 'from ' || fnd_global.newline

771: for m in 1 .. l_query_tbl.count loop
772: l_query := l_query || 'select '
773: || l_sel_clause || fnd_global.newline
774: || l_query_tbl(m).in_union_sel
775: || 'from ' || fnd_global.newline
776: || '(('
777: || l_query_tbl(m).template_sql;
778:
779: if(m <> l_query_tbl.count) then

Line 780: l_query := l_query || ' UNION ALL ' || fnd_global.newline;

776: || '(('
777: || l_query_tbl(m).template_sql;
778:
779: if(m <> l_query_tbl.count) then
780: l_query := l_query || ' UNION ALL ' || fnd_global.newline;
781: end if;
782: end loop;
783:
784: l_query := l_query

Line 786: || l_sel_clause || fnd_global.newline

782: end loop;
783:
784: l_query := l_query
785: || ') group by '
786: || l_sel_clause || fnd_global.newline
787: || get_paren_str(p_paren_count, l_filter_where);
788:
789: if(p_generate_viewby = 'Y') then
790: if(p_use_windowing <> 'P') then

Line 792: ',' || fnd_global.newline;

788:
789: if(p_generate_viewby = 'Y') then
790: if(p_use_windowing <> 'P') then
791: l_query := l_query ||
792: ',' || fnd_global.newline;
793: end if;
794: l_query := l_query ||
795: get_viewby_rank_clause (
796: p_join_tables => p_join_tables

Line 1145: || fnd_global.newline;

1141: || ') then '
1142: || p_col_name (i).column_alias
1143: || ' else null end) c_'
1144: || p_col_name (i).column_alias
1145: || fnd_global.newline;
1146: x_inner_col_names :=
1147: x_inner_col_names
1148: || ', sum(' || p_col_name(i).column_name || ') ' || p_col_name(i).column_alias;
1149:

Line 1471: || fnd_global.newline;

1467:
1468: l_query := l_query ||
1469: ' where (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1))'
1470: || ' oset2 '||l_rownum_where||' ) oset, '
1471: || fnd_global.newline;
1472: END IF;
1473:
1474:
1475: l_from_clause := p_join_tables (1).table_name || ' ' || p_join_tables (1).table_alias;

Line 1544: l_query := l_query || fnd_global.newline || 'ORDER BY rnk';

1540: and (rnk between &START_INDEX and &END_INDEX or &END_INDEX = -1)';
1541: END IF;
1542:
1543: IF (p_use_windowing = 'Y' or p_use_windowing = 'P') THEN
1544: l_query := l_query || fnd_global.newline || 'ORDER BY rnk';
1545: ELSE
1546: l_query := l_query ||
1547: fnd_global.newline || '&ORDER_BY_CLAUSE nulls last';
1548: END IF;

Line 1547: fnd_global.newline || '&ORDER_BY_CLAUSE nulls last';

1543: IF (p_use_windowing = 'Y' or p_use_windowing = 'P') THEN
1544: l_query := l_query || fnd_global.newline || 'ORDER BY rnk';
1545: ELSE
1546: l_query := l_query ||
1547: fnd_global.newline || '&ORDER_BY_CLAUSE nulls last';
1548: END IF;
1549:
1550: RETURN l_query;
1551: