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

Line 14: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

10:
11: /* Cycle Count Accuracy Report */
12: FUNCTION get_cc_rpt_sel_clause (p_view_by_dim IN VARCHAR2,
13: p_join_tbl IN
14: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
15: RETURN VARCHAR2;
16:
17:
18: /* Cycle Count Accuracy Trend Report */

Line 25: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

21:
22: /* Hit/Miss Summary */
23: FUNCTION get_hitmiss_sel_clause (p_view_by_dim IN VARCHAR2,
24: p_join_tbl IN
25: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
26: RETURN VARCHAR2;
27:
28: /* Cycle Count Adjustment Summary Report */
29: FUNCTION get_adj_rpt_sel_clause (p_view_by_dim IN VARCHAR2,

Line 31: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

27:
28: /* Cycle Count Adjustment Summary Report */
29: FUNCTION get_adj_rpt_sel_clause (p_view_by_dim IN VARCHAR2,
30: p_join_tbl IN
31: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
32: RETURN VARCHAR2;
33:
34: /* Cycle Count Adjustment Detail Report */
35: FUNCTION get_adj_dtl_sel_clause (p_view_by_dim IN VARCHAR2,

Line 37: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

33:
34: /* Cycle Count Adjustment Detail Report */
35: FUNCTION get_adj_dtl_sel_clause (p_view_by_dim IN VARCHAR2,
36: p_join_tbl IN
37: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
38: RETURN VARCHAR2;
39:
40: /*----------------------------------------
41: Cycle Count Accuracy Report Function

Line 55: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

51: l_comparison_type VARCHAR2(1);
52: l_cur_suffix VARCHAR2(5);
53: l_custom_sql VARCHAR2 (10000);
54:
55: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
56: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
57:
58: l_where_clause VARCHAR2 (2000);
59: l_mv VARCHAR2 (30);

Line 56: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

52: l_cur_suffix VARCHAR2(5);
53: l_custom_sql VARCHAR2 (10000);
54:
55: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
56: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
57:
58: l_where_clause VARCHAR2 (2000);
59: l_mv VARCHAR2 (30);
60:

Line 72: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

68: l_comparison_type := 'Y';
69: l_aggregation_level_flag := '0';
70:
71: -- clear out the column and Join info tables.
72: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
73: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
74:
75: -- get all the query parameters
76: opi_dbi_rpt_util_pkg.process_parameters (

Line 73: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

69: l_aggregation_level_flag := '0';
70:
71: -- clear out the column and Join info tables.
72: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
73: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
74:
75: -- get all the query parameters
76: opi_dbi_rpt_util_pkg.process_parameters (
77: p_param => p_param,

Line 95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

91: p_mv_set => 'CCAC',
92: p_mv_flag_type => 'CCA_LEVEL');
93:
94: -- Add measure columns that need to be aggregated
95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
96: p_col_name => 'number_of_hits' ,
97: p_alias_name => 'hits',
98: p_grand_total => 'Y',
99: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 99: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

95: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
96: p_col_name => 'number_of_hits' ,
97: p_alias_name => 'hits',
98: p_grand_total => 'Y',
99: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
100: p_to_date_type => 'XTD');
101:
102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
103: p_col_name => 'number_of_exact_matches' ,

Line 102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

98: p_grand_total => 'Y',
99: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
100: p_to_date_type => 'XTD');
101:
102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
103: p_col_name => 'number_of_exact_matches' ,
104: p_alias_name => 'exact_matches',
105: p_grand_total => 'Y',
106: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 106: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

102: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
103: p_col_name => 'number_of_exact_matches' ,
104: p_alias_name => 'exact_matches',
105: p_grand_total => 'Y',
106: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
107: p_to_date_type => 'XTD');
108:
109: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
110: p_col_name => 'number_of_total_entries',

Line 109: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

105: p_grand_total => 'Y',
106: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
107: p_to_date_type => 'XTD');
108:
109: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
110: p_col_name => 'number_of_total_entries',
111: p_alias_name => 'tot_entries',
112: p_grand_total => 'Y',
113: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 113: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

109: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
110: p_col_name => 'number_of_total_entries',
111: p_alias_name => 'tot_entries',
112: p_grand_total => 'Y',
113: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
114: p_to_date_type => 'XTD');
115:
116: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
117: p_col_name => 'system_inventory_val_' || l_cur_suffix,

Line 116: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

112: p_grand_total => 'Y',
113: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
114: p_to_date_type => 'XTD');
115:
116: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
117: p_col_name => 'system_inventory_val_' || l_cur_suffix,
118: p_alias_name => 'system_val',
119: p_grand_total => 'Y',
120: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 120: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

116: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
117: p_col_name => 'system_inventory_val_' || l_cur_suffix,
118: p_alias_name => 'system_val',
119: p_grand_total => 'Y',
120: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
121: p_to_date_type => 'XTD');
122:
123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
124: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,

Line 123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

119: p_grand_total => 'Y',
120: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
121: p_to_date_type => 'XTD');
122:
123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
124: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
125: p_alias_name => 'gross_adj_val',
126: p_grand_total => 'Y',
127: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 127: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

123: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
124: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
125: p_alias_name => 'gross_adj_val',
126: p_grand_total => 'Y',
127: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
128: p_to_date_type => 'XTD');
129:
130: -- construct the query
131: l_query := get_cc_rpt_sel_clause (l_view_by, l_join_tbl)

Line 149: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

145: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
146: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
147:
148: -- set the basic bind variables for the status SQL
149: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
150:
151: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
152: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
153: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 172: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

168: Cycle Count Accuracy Report
169: ---------------------------------------------------*/
170: FUNCTION get_cc_rpt_sel_clause(p_view_by_dim IN VARCHAR2,
171: p_join_tbl IN
172: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
173: RETURN VARCHAR2
174: IS
175:
176: l_sel_clause VARCHAR2(15000);

Line 479: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

475: l_comparison_type VARCHAR2(1);
476: l_cur_suffix VARCHAR2(5);
477: l_custom_sql VARCHAR2 (10000);
478:
479: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
480: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
481:
482: l_where_clause VARCHAR2 (2000);
483: l_mv VARCHAR2 (30);

Line 480: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

476: l_cur_suffix VARCHAR2(5);
477: l_custom_sql VARCHAR2 (10000);
478:
479: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
480: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
481:
482: l_where_clause VARCHAR2 (2000);
483: l_mv VARCHAR2 (30);
484:

Line 496: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

492: l_comparison_type := 'Y';
493: l_aggregation_level_flag := '0';
494:
495: -- clear out the tables.
496: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
497: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
498:
499: -- get all the query parameters
500: opi_dbi_rpt_util_pkg.process_parameters (

Line 497: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

493: l_aggregation_level_flag := '0';
494:
495: -- clear out the tables.
496: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
497: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
498:
499: -- get all the query parameters
500: opi_dbi_rpt_util_pkg.process_parameters (
501: p_param => p_param,

Line 519: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

515: p_mv_set => 'CCAC',
516: p_mv_flag_type => 'CCA_LEVEL');
517: -- Add measure columns that need to be aggregated
518: -- No Grand totals required.
519: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
520: p_col_name => 'number_of_hits' ,
521: p_alias_name => 'hits',
522: p_grand_total => 'N',
523: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 523: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

519: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
520: p_col_name => 'number_of_hits' ,
521: p_alias_name => 'hits',
522: p_grand_total => 'N',
523: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
524: p_to_date_type => 'XTD');
525:
526: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
527: p_col_name => 'number_of_exact_matches' ,

Line 526: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

522: p_grand_total => 'N',
523: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
524: p_to_date_type => 'XTD');
525:
526: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
527: p_col_name => 'number_of_exact_matches' ,
528: p_alias_name => 'exact_matches',
529: p_grand_total => 'N',
530: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 530: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

526: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
527: p_col_name => 'number_of_exact_matches' ,
528: p_alias_name => 'exact_matches',
529: p_grand_total => 'N',
530: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
531: p_to_date_type => 'XTD');
532:
533: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
534: p_col_name => 'number_of_total_entries',

Line 533: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

529: p_grand_total => 'N',
530: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
531: p_to_date_type => 'XTD');
532:
533: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
534: p_col_name => 'number_of_total_entries',
535: p_alias_name => 'tot_entries',
536: p_grand_total => 'N',
537: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 537: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

533: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
534: p_col_name => 'number_of_total_entries',
535: p_alias_name => 'tot_entries',
536: p_grand_total => 'N',
537: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
538: p_to_date_type => 'XTD');
539:
540: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
541: p_col_name => 'system_inventory_val_' || l_cur_suffix,

Line 540: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

536: p_grand_total => 'N',
537: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
538: p_to_date_type => 'XTD');
539:
540: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
541: p_col_name => 'system_inventory_val_' || l_cur_suffix,
542: p_alias_name => 'system_val',
543: p_grand_total => 'N',
544: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 544: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

540: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
541: p_col_name => 'system_inventory_val_' || l_cur_suffix,
542: p_alias_name => 'system_val',
543: p_grand_total => 'N',
544: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
545: p_to_date_type => 'XTD');
546:
547: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
548: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,

Line 547: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

543: p_grand_total => 'N',
544: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
545: p_to_date_type => 'XTD');
546:
547: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
548: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
549: p_alias_name => 'gross_adj_val',
550: p_grand_total => 'N',
551: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 551: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

547: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
548: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
549: p_alias_name => 'gross_adj_val',
550: p_grand_total => 'N',
551: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
552: p_to_date_type => 'XTD');
553:
554: -- Merge Outer and Inner Query
555: l_query := get_cc_trd_sel_clause(l_view_by) ||

Line 573: poa_dbi_util_pkg.get_custom_trend_binds (

569:
570: -- get all the basic binds used by POA queries
571: -- Do this before adding any of our binds, since the procedure
572: -- reinitializes the output table
573: poa_dbi_util_pkg.get_custom_trend_binds (
574: p_xtd => l_xtd,
575: p_comparison_type => l_comparison_type,
576: x_custom_output => x_custom_output);
577:

Line 673: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

669: l_comparison_type VARCHAR2(1);
670: l_cur_suffix VARCHAR2(5);
671: l_custom_sql VARCHAR2 (10000);
672:
673: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
674: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
675:
676: l_where_clause VARCHAR2 (2000);
677: l_mv VARCHAR2 (30);

Line 674: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

670: l_cur_suffix VARCHAR2(5);
671: l_custom_sql VARCHAR2 (10000);
672:
673: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
674: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
675:
676: l_where_clause VARCHAR2 (2000);
677: l_mv VARCHAR2 (30);
678:

Line 689: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

685: l_aggregation_level_flag := '0';
686: l_comparison_type := 'Y';
687:
688: -- clear out the tables.
689: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
690: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
691:
692:
693: -- get all the query parameters

Line 690: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

686: l_comparison_type := 'Y';
687:
688: -- clear out the tables.
689: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
690: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
691:
692:
693: -- get all the query parameters
694: opi_dbi_rpt_util_pkg.process_parameters (

Line 713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

709: p_mv_set => 'CCAC',
710: p_mv_flag_type => 'CCA_LEVEL');
711:
712: -- Add measure columns that need to be aggregated
713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
714: p_col_name => 'number_of_hits' ,
715: p_alias_name => 'hits',
716: p_grand_total => 'Y',
717: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 717: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
714: p_col_name => 'number_of_hits' ,
715: p_alias_name => 'hits',
716: p_grand_total => 'Y',
717: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
718: p_to_date_type => 'XTD');
719:
720: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
721: p_col_name => 'number_of_exact_matches',

Line 720: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

716: p_grand_total => 'Y',
717: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
718: p_to_date_type => 'XTD');
719:
720: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
721: p_col_name => 'number_of_exact_matches',
722: p_alias_name => 'exact_matches',
723: p_grand_total => 'Y',
724: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 724: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

720: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
721: p_col_name => 'number_of_exact_matches',
722: p_alias_name => 'exact_matches',
723: p_grand_total => 'Y',
724: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
725: p_to_date_type => 'XTD');
726:
727: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
728: p_col_name => 'number_of_misses',

Line 727: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

723: p_grand_total => 'Y',
724: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
725: p_to_date_type => 'XTD');
726:
727: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
728: p_col_name => 'number_of_misses',
729: p_alias_name => 'misses',
730: p_grand_total => 'Y',
731: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 731: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

727: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
728: p_col_name => 'number_of_misses',
729: p_alias_name => 'misses',
730: p_grand_total => 'Y',
731: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
732: p_to_date_type => 'XTD');
733:
734: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
735: p_col_name => 'number_of_total_entries',

Line 734: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

730: p_grand_total => 'Y',
731: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
732: p_to_date_type => 'XTD');
733:
734: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
735: p_col_name => 'number_of_total_entries',
736: p_alias_name => 'tot_entries',
737: p_grand_total => 'Y',
738: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 738: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

734: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
735: p_col_name => 'number_of_total_entries',
736: p_alias_name => 'tot_entries',
737: p_grand_total => 'Y',
738: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
739: p_to_date_type => 'XTD');
740:
741:
742: -- construct the query

Line 761: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

757: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
758: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
759:
760: -- set the basic bind variables for the status SQL
761: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
762:
763: -- Passing aggregation level flag to PMV
764: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
765: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 785: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

781: ---------------------------------------------------*/
782:
783: FUNCTION get_hitmiss_sel_clause(p_view_by_dim IN VARCHAR2,
784: p_join_tbl IN
785: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
786: return VARCHAR2
787: IS
788:
789: l_sel_clause varchar2(7000);

Line 985: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

981: l_comparison_type VARCHAR2(1);
982: l_cur_suffix VARCHAR2(5);
983: l_custom_sql VARCHAR2 (10000);
984:
985: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
986: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
987:
988: l_where_clause VARCHAR2 (2000);
989: l_mv VARCHAR2 (30);

Line 986: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

982: l_cur_suffix VARCHAR2(5);
983: l_custom_sql VARCHAR2 (10000);
984:
985: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
986: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
987:
988: l_where_clause VARCHAR2 (2000);
989: l_mv VARCHAR2 (30);
990:

Line 1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

998: l_comparison_type := 'Y';
999: l_aggregation_level_flag := '0';
1000:
1001: -- clear out the column and Join info tables.
1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1003: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1004:
1005: -- get all the query parameters
1006: opi_dbi_rpt_util_pkg.process_parameters (

Line 1003: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

999: l_aggregation_level_flag := '0';
1000:
1001: -- clear out the column and Join info tables.
1002: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1003: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1004:
1005: -- get all the query parameters
1006: opi_dbi_rpt_util_pkg.process_parameters (
1007: p_param => p_param,

Line 1025: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1021: p_mv_set => 'CCAD',
1022: p_mv_flag_type => 'CCA_LEVEL');
1023:
1024: -- Add measure columns that need to be aggregated
1025: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1026: p_col_name => 'system_inventory_qty' ,
1027: p_alias_name => 'system_qty',
1028: p_grand_total => 'N',
1029: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1029: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1025: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1026: p_col_name => 'system_inventory_qty' ,
1027: p_alias_name => 'system_qty',
1028: p_grand_total => 'N',
1029: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1030: p_to_date_type => 'XTD');
1031:
1032: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1033: p_col_name => 'net_adjustment_qty' ,

Line 1032: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1028: p_grand_total => 'N',
1029: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1030: p_to_date_type => 'XTD');
1031:
1032: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1033: p_col_name => 'net_adjustment_qty' ,
1034: p_alias_name => 'net_adj_qty',
1035: p_grand_total => 'N',
1036: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1036: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1032: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1033: p_col_name => 'net_adjustment_qty' ,
1034: p_alias_name => 'net_adj_qty',
1035: p_grand_total => 'N',
1036: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1037: p_to_date_type => 'XTD');
1038:
1039: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1040: p_col_name => 'gross_adjustment_qty' ,

Line 1039: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1035: p_grand_total => 'N',
1036: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1037: p_to_date_type => 'XTD');
1038:
1039: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1040: p_col_name => 'gross_adjustment_qty' ,
1041: p_alias_name => 'gross_adj_qty',
1042: p_grand_total => 'N',
1043: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1043: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1039: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1040: p_col_name => 'gross_adjustment_qty' ,
1041: p_alias_name => 'gross_adj_qty',
1042: p_grand_total => 'N',
1043: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1044: p_to_date_type => 'XTD');
1045:
1046: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1047: p_col_name => 'number_of_adjustments' ,

Line 1046: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1042: p_grand_total => 'N',
1043: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1044: p_to_date_type => 'XTD');
1045:
1046: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1047: p_col_name => 'number_of_adjustments' ,
1048: p_alias_name => 'adjustments',
1049: p_grand_total => 'Y',
1050: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1050: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1046: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1047: p_col_name => 'number_of_adjustments' ,
1048: p_alias_name => 'adjustments',
1049: p_grand_total => 'Y',
1050: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1051: p_to_date_type => 'XTD');
1052:
1053: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1054: p_col_name => 'number_of_total_entries',

Line 1053: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1049: p_grand_total => 'Y',
1050: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1051: p_to_date_type => 'XTD');
1052:
1053: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1054: p_col_name => 'number_of_total_entries',
1055: p_alias_name => 'tot_entries',
1056: p_grand_total => 'Y',
1057: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1057: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1053: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1054: p_col_name => 'number_of_total_entries',
1055: p_alias_name => 'tot_entries',
1056: p_grand_total => 'Y',
1057: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1058: p_to_date_type => 'XTD');
1059:
1060: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1061: p_col_name => 'system_inventory_val_' || l_cur_suffix,

Line 1060: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1056: p_grand_total => 'Y',
1057: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1058: p_to_date_type => 'XTD');
1059:
1060: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1061: p_col_name => 'system_inventory_val_' || l_cur_suffix,
1062: p_alias_name => 'system_val',
1063: p_grand_total => 'Y',
1064: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1064: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1060: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1061: p_col_name => 'system_inventory_val_' || l_cur_suffix,
1062: p_alias_name => 'system_val',
1063: p_grand_total => 'Y',
1064: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1065: p_to_date_type => 'XTD');
1066:
1067: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1068: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,

Line 1067: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1063: p_grand_total => 'Y',
1064: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1065: p_to_date_type => 'XTD');
1066:
1067: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1068: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
1069: p_alias_name => 'gross_adj_val',
1070: p_grand_total => 'Y',
1071: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1071: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1067: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1068: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
1069: p_alias_name => 'gross_adj_val',
1070: p_grand_total => 'Y',
1071: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1072: p_to_date_type => 'XTD');
1073:
1074: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1075: p_col_name => 'net_adjustment_val_' || l_cur_suffix,

Line 1074: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1070: p_grand_total => 'Y',
1071: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1072: p_to_date_type => 'XTD');
1073:
1074: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1075: p_col_name => 'net_adjustment_val_' || l_cur_suffix,
1076: p_alias_name => 'net_adj_val',
1077: p_grand_total => 'Y',
1078: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1078: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1074: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1075: p_col_name => 'net_adjustment_val_' || l_cur_suffix,
1076: p_alias_name => 'net_adj_val',
1077: p_grand_total => 'Y',
1078: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1079: p_to_date_type => 'XTD');
1080:
1081: -- construct the query
1082: l_query := get_adj_rpt_sel_clause (l_view_by, l_join_tbl)

Line 1100: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

1096: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1097: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1098:
1099: -- set the basic bind variables for the status SQL
1100: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1101:
1102: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1103: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
1104: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 1122: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

1118: Cycle Count Adjustment Summary Report
1119: ---------------------------------------------------*/
1120: FUNCTION get_adj_rpt_sel_clause(p_view_by_dim IN VARCHAR2,
1121: p_join_tbl IN
1122: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
1123: RETURN VARCHAR2
1124: IS
1125:
1126: l_sel_clause VARCHAR2(7500);

Line 1326: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

1322: l_comparison_type VARCHAR2(1);
1323: l_cur_suffix VARCHAR2(5);
1324: l_custom_sql VARCHAR2 (10000);
1325:
1326: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1327: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1328:
1329: l_where_clause VARCHAR2 (2000);
1330: l_mv VARCHAR2 (30);

Line 1327: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

1323: l_cur_suffix VARCHAR2(5);
1324: l_custom_sql VARCHAR2 (10000);
1325:
1326: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
1327: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
1328:
1329: l_where_clause VARCHAR2 (2000);
1330: l_mv VARCHAR2 (30);
1331:

Line 1344: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

1340: l_aggregation_level_flag := '0';
1341:
1342:
1343: -- clear out the column and Join info tables.
1344: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1345: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1346:
1347: -- get all the query parameters
1348: opi_dbi_rpt_util_pkg.process_parameters (

Line 1345: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

1341:
1342:
1343: -- clear out the column and Join info tables.
1344: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
1345: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
1346:
1347: -- get all the query parameters
1348: opi_dbi_rpt_util_pkg.process_parameters (
1349: p_param => p_param,

Line 1368: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1364: p_mv_flag_type => 'CCA_LEVEL');
1365:
1366:
1367: -- Add measure columns that need to be aggregated
1368: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1369: p_col_name => 'system_inventory_qty' ,
1370: p_alias_name => 'system_qty',
1371: p_grand_total => 'N',
1372: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1372: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1368: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1369: p_col_name => 'system_inventory_qty' ,
1370: p_alias_name => 'system_qty',
1371: p_grand_total => 'N',
1372: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1373: p_to_date_type => 'XTD');
1374:
1375: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1376: p_col_name => 'positive_adjustment_qty' ,

Line 1375: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1371: p_grand_total => 'N',
1372: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1373: p_to_date_type => 'XTD');
1374:
1375: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1376: p_col_name => 'positive_adjustment_qty' ,
1377: p_alias_name => 'positive_adj_qty',
1378: p_grand_total => 'N',
1379: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1379: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1375: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1376: p_col_name => 'positive_adjustment_qty' ,
1377: p_alias_name => 'positive_adj_qty',
1378: p_grand_total => 'N',
1379: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1380: p_to_date_type => 'XTD');
1381:
1382: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1383: p_col_name => 'negative_adjustment_qty' ,

Line 1382: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1378: p_grand_total => 'N',
1379: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1380: p_to_date_type => 'XTD');
1381:
1382: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1383: p_col_name => 'negative_adjustment_qty' ,
1384: p_alias_name => 'negative_adj_qty',
1385: p_grand_total => 'N',
1386: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1386: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1382: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1383: p_col_name => 'negative_adjustment_qty' ,
1384: p_alias_name => 'negative_adj_qty',
1385: p_grand_total => 'N',
1386: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1387: p_to_date_type => 'XTD');
1388:
1389: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1390: p_col_name => 'number_of_total_entries',

Line 1389: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1385: p_grand_total => 'N',
1386: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1387: p_to_date_type => 'XTD');
1388:
1389: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1390: p_col_name => 'number_of_total_entries',
1391: p_alias_name => 'tot_entries',
1392: p_grand_total => 'Y',
1393: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1393: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1389: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1390: p_col_name => 'number_of_total_entries',
1391: p_alias_name => 'tot_entries',
1392: p_grand_total => 'Y',
1393: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1394: p_to_date_type => 'XTD');
1395:
1396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1397: p_col_name => 'system_inventory_val_' || l_cur_suffix,

Line 1396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1392: p_grand_total => 'Y',
1393: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1394: p_to_date_type => 'XTD');
1395:
1396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1397: p_col_name => 'system_inventory_val_' || l_cur_suffix,
1398: p_alias_name => 'system_val',
1399: p_grand_total => 'Y',
1400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1396: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1397: p_col_name => 'system_inventory_val_' || l_cur_suffix,
1398: p_alias_name => 'system_val',
1399: p_grand_total => 'Y',
1400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1401: p_to_date_type => 'XTD');
1402:
1403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1404: p_col_name => 'positive_adjustment_val_' || l_cur_suffix,

Line 1403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1399: p_grand_total => 'Y',
1400: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1401: p_to_date_type => 'XTD');
1402:
1403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1404: p_col_name => 'positive_adjustment_val_' || l_cur_suffix,
1405: p_alias_name => 'positive_adj_val',
1406: p_grand_total => 'Y',
1407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1403: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1404: p_col_name => 'positive_adjustment_val_' || l_cur_suffix,
1405: p_alias_name => 'positive_adj_val',
1406: p_grand_total => 'Y',
1407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1408: p_to_date_type => 'XTD');
1409:
1410: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1411: p_col_name => 'negative_adjustment_val_' || l_cur_suffix,

Line 1410: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1406: p_grand_total => 'Y',
1407: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1408: p_to_date_type => 'XTD');
1409:
1410: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1411: p_col_name => 'negative_adjustment_val_' || l_cur_suffix,
1412: p_alias_name => 'negative_adj_val',
1413: p_grand_total => 'Y',
1414: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1414: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1410: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1411: p_col_name => 'negative_adjustment_val_' || l_cur_suffix,
1412: p_alias_name => 'negative_adj_val',
1413: p_grand_total => 'Y',
1414: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1415: p_to_date_type => 'XTD');
1416:
1417: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1418: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,

Line 1417: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1413: p_grand_total => 'Y',
1414: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1415: p_to_date_type => 'XTD');
1416:
1417: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1418: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
1419: p_alias_name => 'gross_adj_val',
1420: p_grand_total => 'Y',
1421: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1421: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1417: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1418: p_col_name => 'gross_adjustment_val_' || l_cur_suffix,
1419: p_alias_name => 'gross_adj_val',
1420: p_grand_total => 'Y',
1421: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1422: p_to_date_type => 'XTD');
1423:
1424: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1425: p_col_name => 'net_adjustment_val_' || l_cur_suffix,

Line 1424: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

1420: p_grand_total => 'Y',
1421: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1422: p_to_date_type => 'XTD');
1423:
1424: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1425: p_col_name => 'net_adjustment_val_' || l_cur_suffix,
1426: p_alias_name => 'net_adj_val',
1427: p_grand_total => 'Y',
1428: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 1428: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

1424: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
1425: p_col_name => 'net_adjustment_val_' || l_cur_suffix,
1426: p_alias_name => 'net_adj_val',
1427: p_grand_total => 'Y',
1428: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
1429: p_to_date_type => 'XTD');
1430:
1431: -- construct the query
1432: l_query := get_adj_dtl_sel_clause (l_view_by, l_join_tbl)

Line 1450: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

1446: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1447: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1448:
1449: -- set the basic bind variables for the status SQL
1450: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
1451:
1452: -- Passing OPI_AGGREGATION_LEVEL_FLAG to PMV
1453: l_custom_rec.attribute_name := ':OPI_CCA_LEVEL_FLAG';
1454: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 1471: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

1467: Cycle Count Adjustment Summary Report
1468: ---------------------------------------------------*/
1469: FUNCTION get_adj_dtl_sel_clause(p_view_by_dim IN VARCHAR2,
1470: p_join_tbl IN
1471: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
1472: RETURN VARCHAR2
1473: IS
1474:
1475: l_sel_clause VARCHAR2(7500);