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.ISC_FS_INV_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 113: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

109: )
110: is
111:
112: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
113: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
114: l_custom_output bis_query_attributes_tbl;
115: l_curr_suffix varchar2(3);
116: l_where_clause varchar2(10000);
117: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 118: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

114: l_custom_output bis_query_attributes_tbl;
115: l_curr_suffix varchar2(3);
116: l_where_clause varchar2(10000);
117: l_viewby_select varchar2(400); -- needed to be increased from 200
118: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
119: l_dim_bmap number;
120: l_comparison_type varchar2(200);
121: l_xtd varchar2(200);
122: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

Line 122: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

118: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
119: l_dim_bmap number;
120: l_comparison_type varchar2(200);
121: l_xtd varchar2(200);
122: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
123: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
124: l_mv VARCHAR2 (10000);
125: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
126: l_view_by varchar2(200);

Line 123: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

119: l_dim_bmap number;
120: l_comparison_type varchar2(200);
121: l_xtd varchar2(200);
122: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
123: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
124: l_mv VARCHAR2 (10000);
125: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
126: l_view_by varchar2(200);
127: l_stmt varchar2(32700);

Line 125: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

121: l_xtd varchar2(200);
122: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
123: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
124: l_mv VARCHAR2 (10000);
125: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
126: l_view_by varchar2(200);
127: l_stmt varchar2(32700);
128: l_stmt1 varchar2(5000);
129: l_stmt2 varchar2(5000);

Line 187: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();

183: else
184: l_to_date := to_char(to_date(isc_fs_rpt_util_pkg.get_parameter_value( p_param, 'AS_OF_DATE'),'DD-MM-YYYY') ,'DD/MM/YYYY');
185: end if;
186:
187: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
188: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
189: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
190:
191: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

Line 188: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();

184: l_to_date := to_char(to_date(isc_fs_rpt_util_pkg.get_parameter_value( p_param, 'AS_OF_DATE'),'DD-MM-YYYY') ,'DD/MM/YYYY');
185: end if;
186:
187: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
188: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
189: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
190:
191: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
192: , p_col_name => 'Inv_usg_' || l_curr_suffix

Line 189: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

185: end if;
186:
187: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
188: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
189: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
190:
191: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
192: , p_col_name => 'Inv_usg_' || l_curr_suffix
193: , p_alias_name => 'Inv_usg'

Line 191: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

187: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
188: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
189: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
190:
191: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
192: , p_col_name => 'Inv_usg_' || l_curr_suffix
193: , p_alias_name => 'Inv_usg'
194: , p_grand_total => 'Y'
195: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 195: , p_prior_code => poa_dbi_util_pkg.both_priors

191: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
192: , p_col_name => 'Inv_usg_' || l_curr_suffix
193: , p_alias_name => 'Inv_usg'
194: , p_grand_total => 'Y'
195: , p_prior_code => poa_dbi_util_pkg.both_priors
196: , p_to_date_type => l_to_date_type
197: );
198:
199: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2

Line 199: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2

195: , p_prior_code => poa_dbi_util_pkg.both_priors
196: , p_to_date_type => l_to_date_type
197: );
198:
199: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2
200: , p_col_name => 'uonhand_value_' || l_curr_suffix
201: , p_alias_name => 'uonhand_value'
202: , p_grand_total => 'Y'
203: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 203: , p_prior_code => poa_dbi_util_pkg.both_priors

199: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2
200: , p_col_name => 'uonhand_value_' || l_curr_suffix
201: , p_alias_name => 'uonhand_value'
202: , p_grand_total => 'Y'
203: , p_prior_code => poa_dbi_util_pkg.both_priors
204: , p_to_date_type => 'XTD'
205: );
206:
207: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2

Line 207: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2

203: , p_prior_code => poa_dbi_util_pkg.both_priors
204: , p_to_date_type => 'XTD'
205: );
206:
207: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2
208: , p_col_name => 'donhand_value_' || l_curr_suffix
209: , p_alias_name => 'donhand_value'
210: , p_grand_total => 'Y'
211: , p_prior_code => poa_dbi_util_pkg.no_priors

Line 211: , p_prior_code => poa_dbi_util_pkg.no_priors

207: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2
208: , p_col_name => 'donhand_value_' || l_curr_suffix
209: , p_alias_name => 'donhand_value'
210: , p_grand_total => 'Y'
211: , p_prior_code => poa_dbi_util_pkg.no_priors
212: , p_to_date_type => 'XTD'
213: );
214:
215: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2

Line 215: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2

211: , p_prior_code => poa_dbi_util_pkg.no_priors
212: , p_to_date_type => 'XTD'
213: );
214:
215: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2
216: , p_col_name => 'totalonhand_value_' || l_curr_suffix
217: , p_alias_name => 'totalonhand_value'
218: , p_grand_total => 'Y'
219: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 219: , p_prior_code => poa_dbi_util_pkg.both_priors

215: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl2
216: , p_col_name => 'totalonhand_value_' || l_curr_suffix
217: , p_alias_name => 'totalonhand_value'
218: , p_grand_total => 'Y'
219: , p_prior_code => poa_dbi_util_pkg.both_priors
220: , p_to_date_type => 'XTD'
221: );
222:
223: l_mv_tbl.extend;

Line 372: poa_dbi_util_pkg.get_custom_rolling_binds

368:
369: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
370: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
371:
372: poa_dbi_util_pkg.get_custom_rolling_binds
373: ( p_custom_output => l_custom_output
374: , p_xtd => l_xtd
375: );
376:

Line 477: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;

473: )
474: is
475:
476: l_dimension_tbl isc_fs_rpt_util_pkg.t_dimension_tbl;
477: l_dim_filter_map poa_dbi_util_pkg.poa_dbi_dim_map;
478: l_custom_output bis_query_attributes_tbl;
479: l_curr_suffix varchar2(3);
480: l_where_clause varchar2(10000);
481: l_viewby_select varchar2(400); -- needed to be increased from 200

Line 482: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

478: l_custom_output bis_query_attributes_tbl;
479: l_curr_suffix varchar2(3);
480: l_where_clause varchar2(10000);
481: l_viewby_select varchar2(400); -- needed to be increased from 200
482: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
483: l_dim_bmap number;
484: l_comparison_type varchar2(200);
485: l_xtd varchar2(200);
486: l_mv varchar2(10000);

Line 487: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;

483: l_dim_bmap number;
484: l_comparison_type varchar2(200);
485: l_xtd varchar2(200);
486: l_mv varchar2(10000);
487: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
488: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
489: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
490: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
491: l_stmt varchar2(32767);

Line 488: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;

484: l_comparison_type varchar2(200);
485: l_xtd varchar2(200);
486: l_mv varchar2(10000);
487: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
488: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
489: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
490: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
491: l_stmt varchar2(32767);
492: l_stmt1 varchar2(15000);

Line 489: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;

485: l_xtd varchar2(200);
486: l_mv varchar2(10000);
487: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
488: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
489: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
490: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
491: l_stmt varchar2(32767);
492: l_stmt1 varchar2(15000);
493: l_stmt2 varchar2(15000);

Line 490: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;

486: l_mv varchar2(10000);
487: l_mv_tbl poa_dbi_util_pkg.poa_dbi_mv_tbl;
488: l_col_tbl1 poa_dbi_util_pkg.poa_dbi_col_tbl;
489: l_col_tbl2 poa_dbi_util_pkg.poa_dbi_col_tbl;
490: l_col_tbl3 poa_dbi_util_pkg.poa_dbi_col_tbl;
491: l_stmt varchar2(32767);
492: l_stmt1 varchar2(15000);
493: l_stmt2 varchar2(15000);
494: l_to_date varchar2(20);

Line 547: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();

543: else
544: l_to_date := to_char(to_date(isc_fs_rpt_util_pkg.get_parameter_value( p_param, 'AS_OF_DATE'),'DD-MM-YYYY') ,'DD/MM/YYYY');
545: end if;
546:
547: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
548:
549: if l_xtd like '%TD' then /* Do not need the first leg of the union alls if rolling or day */
550:
551: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();

Line 551: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();

547: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl ();
548:
549: if l_xtd like '%TD' then /* Do not need the first leg of the union alls if rolling or day */
550:
551: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
552:
553: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
554: , p_col_name => 'Period_days'
555: , p_alias_name => 'Period_days'

Line 553: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1

549: if l_xtd like '%TD' then /* Do not need the first leg of the union alls if rolling or day */
550:
551: l_col_tbl1 := poa_dbi_util_pkg.poa_dbi_col_tbl();
552:
553: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
554: , p_col_name => 'Period_days'
555: , p_alias_name => 'Period_days'
556: , p_grand_total => 'N'
557: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 557: , p_prior_code => poa_dbi_util_pkg.both_priors

553: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl1
554: , p_col_name => 'Period_days'
555: , p_alias_name => 'Period_days'
556: , p_grand_total => 'N'
557: , p_prior_code => poa_dbi_util_pkg.both_priors
558: , p_to_date_type => l_to_date_type
559: );
560:
561: l_mv_tbl.extend;

Line 576: l_mv := replace( l_mv, 'PERIOD_TABLE', poa_dbi_util_pkg.get_calendar_table(l_xtd));

572: , l_dim_bmap
573: , l_custom_output
574: );
575:
576: l_mv := replace( l_mv, 'PERIOD_TABLE', poa_dbi_util_pkg.get_calendar_table(l_xtd));
577:
578: end if;
579:
580: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();

Line 580: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();

576: l_mv := replace( l_mv, 'PERIOD_TABLE', poa_dbi_util_pkg.get_calendar_table(l_xtd));
577:
578: end if;
579:
580: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
581: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
582:
583: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
584: , p_col_name => 'Inv_usg_' || l_curr_suffix

Line 581: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();

577:
578: end if;
579:
580: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
581: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
582:
583: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
584: , p_col_name => 'Inv_usg_' || l_curr_suffix
585: , p_alias_name => 'Inv_usg'

Line 583: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2

579:
580: l_col_tbl2 := poa_dbi_util_pkg.poa_dbi_col_tbl();
581: l_col_tbl3 := poa_dbi_util_pkg.poa_dbi_col_tbl();
582:
583: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
584: , p_col_name => 'Inv_usg_' || l_curr_suffix
585: , p_alias_name => 'Inv_usg'
586: , p_grand_total => 'N'
587: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 587: , p_prior_code => poa_dbi_util_pkg.both_priors

583: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl2
584: , p_col_name => 'Inv_usg_' || l_curr_suffix
585: , p_alias_name => 'Inv_usg'
586: , p_grand_total => 'N'
587: , p_prior_code => poa_dbi_util_pkg.both_priors
588: , p_to_date_type => l_to_date_type
589: );
590:
591: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3

Line 591: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3

587: , p_prior_code => poa_dbi_util_pkg.both_priors
588: , p_to_date_type => l_to_date_type
589: );
590:
591: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3
592: , p_col_name => 'uonhand_value_' || l_curr_suffix
593: , p_alias_name => 'uonhand_value'
594: , p_grand_total => 'N'
595: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 595: , p_prior_code => poa_dbi_util_pkg.both_priors

591: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3
592: , p_col_name => 'uonhand_value_' || l_curr_suffix
593: , p_alias_name => 'uonhand_value'
594: , p_grand_total => 'N'
595: , p_prior_code => poa_dbi_util_pkg.both_priors
596: , p_to_date_type => l_to_date_type /* This affects only the select list of columns structure for getting current and prior values */
597: );
598:
599: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3

Line 599: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3

595: , p_prior_code => poa_dbi_util_pkg.both_priors
596: , p_to_date_type => l_to_date_type /* This affects only the select list of columns structure for getting current and prior values */
597: );
598:
599: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3
600: , p_col_name => 'totalonhand_value_' || l_curr_suffix
601: , p_alias_name => 'totalonhand_value'
602: , p_grand_total => 'N'
603: , p_prior_code => poa_dbi_util_pkg.both_priors

Line 603: , p_prior_code => poa_dbi_util_pkg.both_priors

599: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl3
600: , p_col_name => 'totalonhand_value_' || l_curr_suffix
601: , p_alias_name => 'totalonhand_value'
602: , p_grand_total => 'N'
603: , p_prior_code => poa_dbi_util_pkg.both_priors
604: , p_to_date_type => l_to_date_type /* This affects only the select list of columns structure for getting current and prior values */
605: );
606:
607: l_mv_tbl.extend;

Line 707: poa_dbi_util_pkg.get_custom_rolling_binds

703:
704: -- the next line can be used to dump the contents of the PMV parameters as comments into stmt
705: -- l_stmt := l_stmt || isc_fs_rpt_util_pkg.dump_parameters(p_param);
706:
707: poa_dbi_util_pkg.get_custom_rolling_binds
708: ( p_custom_output => l_custom_output
709: , p_xtd => l_xtd
710: );
711:

Line 714: poa_dbi_util_pkg.get_custom_trend_binds

710: );
711:
712: x_custom_output := l_custom_output;
713:
714: poa_dbi_util_pkg.get_custom_trend_binds
715: ( x_custom_output => l_custom_output
716: , p_xtd => l_xtd
717: , p_comparison_type => l_comparison_type
718: );