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_IAP_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 121: '|| poa_dbi_template_pkg.status_sql(

117:
118: l_query := get_status_sel_clause(l_view_by_col) ;
119:
120: l_query := l_query || ' from
121: '|| poa_dbi_template_pkg.status_sql(
122: l_mv,
123: l_where_clause,
124: l_join_tbl,
125: p_use_windowing => 'Y',

Line 467: poa_dbi_template_pkg.trend_sql(

463: ' and nvl(fact.base_uom ,''-1'') = ''' || l_uom || '''' ;
464:
465:
466: l_query := get_trend_sel_clause || ' from '|| fnd_global.newline ||
467: poa_dbi_template_pkg.trend_sql(
468: p_xtd => l_xtd,
469: p_comparison_type => l_comparison_type,
470: p_fact_name => l_mv,
471: p_where_clause => l_where_clause,

Line 692: poa_dbi_template_pkg.get_status_col_calc( p_col_name

688: l_in_join_tables := l_in_join_tables || ', ' || p_in_join_tables(i).table_name || ' ' || p_in_join_tables(i).table_alias;
689: END LOOP;
690: END IF;
691:
692: poa_dbi_template_pkg.get_status_col_calc( p_col_name
693: , l_col_calc_tbl
694: , l_inlist_bmap
695: , l_compute_prior
696: , l_compute_prev_prev

Line 731: , poa_dbi_template_pkg.g_inlist_xed) = poa_dbi_template_pkg.g_inlist_xed

727: '('
728: || CASE
729: WHEN -- if one or more columns had XED
730: BITAND (l_inlist_bmap
731: , poa_dbi_template_pkg.g_inlist_xed) = poa_dbi_template_pkg.g_inlist_xed
732: THEN -- alway append current
733: poa_dbi_template_pkg.g_c_period_end_date
734: || CASE -- append prev date if needed
735: WHEN l_compute_prior = 'Y'

Line 733: poa_dbi_template_pkg.g_c_period_end_date

729: WHEN -- if one or more columns had XED
730: BITAND (l_inlist_bmap
731: , poa_dbi_template_pkg.g_inlist_xed) = poa_dbi_template_pkg.g_inlist_xed
732: THEN -- alway append current
733: poa_dbi_template_pkg.g_c_period_end_date
734: || CASE -- append prev date if needed
735: WHEN l_compute_prior = 'Y'
736: THEN ',' || poa_dbi_template_pkg.g_p_period_end_date
737: END

Line 736: THEN ',' || poa_dbi_template_pkg.g_p_period_end_date

732: THEN -- alway append current
733: poa_dbi_template_pkg.g_c_period_end_date
734: || CASE -- append prev date if needed
735: WHEN l_compute_prior = 'Y'
736: THEN ',' || poa_dbi_template_pkg.g_p_period_end_date
737: END
738: END
739: || CASE -- when XED and (XTD or YTD) exist
740: WHEN l_inlist_bmap IN (3, 5, 7)

Line 745: , poa_dbi_template_pkg.g_inlist_xtd) = poa_dbi_template_pkg.g_inlist_xtd

741: THEN ','
742: END
743: || CASE -- if one or more columns had XTD
744: WHEN ( BITAND (l_inlist_bmap
745: , poa_dbi_template_pkg.g_inlist_xtd) = poa_dbi_template_pkg.g_inlist_xtd
746: OR BITAND (l_inlist_bmap
747: , poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd)
748: THEN -- alway append current
749: poa_dbi_template_pkg.g_c_as_of_date

Line 747: , poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd)

743: || CASE -- if one or more columns had XTD
744: WHEN ( BITAND (l_inlist_bmap
745: , poa_dbi_template_pkg.g_inlist_xtd) = poa_dbi_template_pkg.g_inlist_xtd
746: OR BITAND (l_inlist_bmap
747: , poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd)
748: THEN -- alway append current
749: poa_dbi_template_pkg.g_c_as_of_date
750: || CASE -- append prev date if needed
751: WHEN l_compute_prior = 'Y'

Line 749: poa_dbi_template_pkg.g_c_as_of_date

745: , poa_dbi_template_pkg.g_inlist_xtd) = poa_dbi_template_pkg.g_inlist_xtd
746: OR BITAND (l_inlist_bmap
747: , poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd)
748: THEN -- alway append current
749: poa_dbi_template_pkg.g_c_as_of_date
750: || CASE -- append prev date if needed
751: WHEN l_compute_prior = 'Y'
752: THEN ',' || poa_dbi_template_pkg.g_p_as_of_date
753: END

Line 752: THEN ',' || poa_dbi_template_pkg.g_p_as_of_date

748: THEN -- alway append current
749: poa_dbi_template_pkg.g_c_as_of_date
750: || CASE -- append prev date if needed
751: WHEN l_compute_prior = 'Y'
752: THEN ',' || poa_dbi_template_pkg.g_p_as_of_date
753: END
754: END
755: || case
756: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx then

Line 756: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx then

752: THEN ',' || poa_dbi_template_pkg.g_p_as_of_date
753: END
754: END
755: || case
756: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx then
757: poa_dbi_template_pkg.g_c_period_end_date
758: || case -- append prev date if needed
759: when l_compute_prior = 'Y' then
760: ',' || poa_dbi_template_pkg.g_p_period_end_date

Line 757: poa_dbi_template_pkg.g_c_period_end_date

753: END
754: END
755: || case
756: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx then
757: poa_dbi_template_pkg.g_c_period_end_date
758: || case -- append prev date if needed
759: when l_compute_prior = 'Y' then
760: ',' || poa_dbi_template_pkg.g_p_period_end_date
761: end

Line 760: ',' || poa_dbi_template_pkg.g_p_period_end_date

756: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx then
757: poa_dbi_template_pkg.g_c_period_end_date
758: || case -- append prev date if needed
759: when l_compute_prior = 'Y' then
760: ',' || poa_dbi_template_pkg.g_p_period_end_date
761: end
762: end
763: || case
764: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal then

Line 764: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal then

760: ',' || poa_dbi_template_pkg.g_p_period_end_date
761: end
762: end
763: || case
764: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal then
765: poa_dbi_template_pkg.g_c_as_of_date_balance
766: || case -- append prev date if needed
767: when l_compute_prior = 'Y' then
768: ',' || poa_dbi_template_pkg.g_p_as_of_date_balance

Line 765: poa_dbi_template_pkg.g_c_as_of_date_balance

761: end
762: end
763: || case
764: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal then
765: poa_dbi_template_pkg.g_c_as_of_date_balance
766: || case -- append prev date if needed
767: when l_compute_prior = 'Y' then
768: ',' || poa_dbi_template_pkg.g_p_as_of_date_balance
769: end

Line 768: ',' || poa_dbi_template_pkg.g_p_as_of_date_balance

764: when bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal then
765: poa_dbi_template_pkg.g_c_as_of_date_balance
766: || case -- append prev date if needed
767: when l_compute_prior = 'Y' then
768: ',' || poa_dbi_template_pkg.g_p_as_of_date_balance
769: end
770: || case
771: when l_compute_opening_bal = 'Y' then
772: ',' || poa_dbi_template_pkg.g_c_as_of_date_o_balance

Line 772: ',' || poa_dbi_template_pkg.g_c_as_of_date_o_balance

768: ',' || poa_dbi_template_pkg.g_p_as_of_date_balance
769: end
770: || case
771: when l_compute_opening_bal = 'Y' then
772: ',' || poa_dbi_template_pkg.g_c_as_of_date_o_balance
773: end
774: end
775: || CASE
776: WHEN l_compute_prev_prev = 'Y'

Line 791: if( bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx) then

787: -- Determine how many closing parens we need
788: l_paren_str := get_paren_str(p_paren_count,
789: l_filter_where);
790:
791: if( bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_rlx) = poa_dbi_template_pkg.g_inlist_rlx) then
792: l_join_tables := ', fii_time_structures cal '|| l_in_join_tables;
793: l_full_where_clause := ' where fact.time_id = cal.time_id '
794: || 'and fact.period_type_id = cal.period_type_id '
795: || fnd_global.newline

Line 805: elsif( bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal) then

801: -- &BIS bind substitution when available from fii/bis team.
802: || fnd_global.newline
803: || 'and bitand(cal.record_type_id, &RLX_NESTED_PATTERN) = '
804: || '&RLX_NESTED_PATTERN ';
805: elsif( bitand(l_inlist_bmap, poa_dbi_template_pkg.g_inlist_bal) = poa_dbi_template_pkg.g_inlist_bal) then
806: l_join_tables := '';
807: l_full_where_clause := ' where fact.report_date in '
808: || l_inlist
809: || p_where_clause;

Line 827: WHEN BITAND (l_inlist_bmap, poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd

823: || l_inlist
824: || fnd_global.newline
825: || ' and bitand(cal.record_type_id, '
826: || CASE -- if one or more columns = YTD then use nested pattern
827: WHEN BITAND (l_inlist_bmap, poa_dbi_template_pkg.g_inlist_ytd) = poa_dbi_template_pkg.g_inlist_ytd
828: THEN '&YTD_NESTED_PATTERN'
829: ELSE '&BIS_NESTED_PATTERN'
830: END
831: || ') = cal.record_type_id ';

Line 883: poa_dbi_template_pkg.get_viewby_rank_clause (

879: l_join_tbl(l_join_tbl.count) := l_join_rec;
880: END IF ;
881:
882: l_viewby_rank_where := l_viewby_rank_where ||
883: poa_dbi_template_pkg.get_viewby_rank_clause (
884: p_join_tables => l_join_tbl
885: , p_use_windowing => p_use_windowing);
886: END IF;
887: