DBA Data[Home] [Help]

APPS.POA_DBI_CUT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 99: ' || poa_dbi_template_pkg.status_sql(

95: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
96: end if;
97:
98: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
99: ' || poa_dbi_template_pkg.status_sql(
100: p_fact_name => l_mv,
101: p_where_clause => l_where_clause,
102: p_join_tables => l_join_tbl,
103: p_use_windowing => 'Y',

Line 190: ' || poa_dbi_template_pkg.union_all_status_sql(

186: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
187: l_mv_tbl(2).use_grp_id := 'N';
188:
189: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from (
190: ' || poa_dbi_template_pkg.union_all_status_sql(
191: p_mv => l_mv_tbl,
192: p_join_tables => l_join_tbl,
193: p_use_windowing => 'Y',
194: p_paren_count => 3,

Line 200: ' || poa_dbi_template_pkg.status_sql(

196: p_generate_viewby => 'Y',
197: p_diff_measures => 'N');
198: else
199: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
200: ' || poa_dbi_template_pkg.status_sql(
201: p_fact_name => l_mv,
202: p_where_clause => l_where_clause,
203: p_join_tables => l_join_tbl,
204: p_use_windowing => 'Y',

Line 442: ' ||poa_dbi_template_pkg.status_sql(

438: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
439: end if;
440:
441: l_query := get_con_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
442: ' ||poa_dbi_template_pkg.status_sql(
443: p_fact_name => l_mv,
444: p_where_clause => l_where_clause,
445: p_join_tables => l_join_tbl,
446: p_use_windowing => 'Y',

Line 531: ' ||poa_dbi_template_pkg.union_all_status_sql(

527: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
528: l_mv_tbl(2).use_grp_id := 'N';
529:
530: l_query := get_con_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from (
531: ' ||poa_dbi_template_pkg.union_all_status_sql(
532: p_mv => l_mv_tbl,
533: p_join_tables => l_join_tbl,
534: p_use_windowing => 'Y',
535: p_paren_count => 3,

Line 542: ' ||poa_dbi_template_pkg.status_sql(

538: p_diff_measures => 'N');
539:
540: else
541: l_query := get_con_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
542: ' ||poa_dbi_template_pkg.status_sql(
543: p_fact_name => l_mv,
544: p_where_clause => l_where_clause,
545: p_join_tables => l_join_tbl,
546: p_use_windowing => 'Y',

Line 737: ' || poa_dbi_template_pkg.status_sql(

733: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
734: end if;
735:
736: l_query := get_ncp_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
737: ' || poa_dbi_template_pkg.status_sql(
738: p_fact_name => l_mv,
739: p_where_clause => l_where_clause,
740: p_join_tables => l_join_tbl,
741: p_use_windowing => 'Y',

Line 825: ' || poa_dbi_template_pkg.union_all_status_sql(

821: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
822: l_mv_tbl(2).use_grp_id := 'N';
823:
824: l_query := get_ncp_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from (
825: ' || poa_dbi_template_pkg.union_all_status_sql(
826: p_mv => l_mv_tbl,
827: p_join_tables => l_join_tbl,
828: p_use_windowing => 'Y',
829: p_paren_count => 3,

Line 835: ' || poa_dbi_template_pkg.status_sql(

831: p_generate_viewby => 'Y',
832: p_diff_measures => 'N');
833: else
834: l_query := get_ncp_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
835: ' || poa_dbi_template_pkg.status_sql(
836: p_fact_name => l_mv,
837: p_where_clause => l_where_clause,
838: p_join_tables => l_join_tbl,
839: p_use_windowing => 'Y',

Line 1049: ' || poa_dbi_template_pkg.status_sql(

1045: poa_dbi_util_pkg.add_column(l_col_tbl, 'quantity', 'quantity');
1046: end if;
1047:
1048: l_query := get_pcl_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
1049: ' || poa_dbi_template_pkg.status_sql(
1050: p_fact_name => l_mv,
1051: p_where_clause => l_where_clause,
1052: p_join_tables => l_join_tbl,
1053: p_use_windowing => 'Y',

Line 1141: ' || poa_dbi_template_pkg.union_all_status_sql(

1137: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
1138: l_mv_tbl(2).use_grp_id := 'N';
1139:
1140: l_query := get_pcl_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from (
1141: ' || poa_dbi_template_pkg.union_all_status_sql(
1142: p_mv => l_mv_tbl,
1143: p_join_tables => l_join_tbl,
1144: p_use_windowing => 'Y',
1145: p_paren_count => 3,

Line 1151: ' || poa_dbi_template_pkg.status_sql(

1147: p_generate_viewby => 'Y',
1148: p_diff_measures => 'N');
1149: else
1150: l_query := get_pcl_rpt_sel_clause(l_view_by, l_view_by_col, l_sec_context) || ' from
1151: ' || poa_dbi_template_pkg.status_sql(
1152: p_fact_name => l_mv,
1153: p_where_clause => l_where_clause,
1154: p_join_tables => l_join_tbl,
1155: p_use_windowing => 'Y',

Line 1358: '|| poa_dbi_template_pkg.trend_sql(

1354:
1355: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'N');
1356:
1357: l_query := get_pop_trend_sel_clause || ' from
1358: '|| poa_dbi_template_pkg.trend_sql(
1359: p_xtd => l_xtd,
1360: p_comparison_type => l_comparison_type,
1361: p_fact_name => l_mv,
1362: p_where_clause => l_where_clause,

Line 1443: '|| poa_dbi_template_pkg.union_all_trend_sql(

1439: l_mv_tbl(2).use_grp_id := 'N';
1440: l_mv_tbl(2).mv_xtd := l_xtd;
1441:
1442: l_query := get_pop_trend_sel_clause('union') || ' from
1443: '|| poa_dbi_template_pkg.union_all_trend_sql(
1444: p_mv => l_mv_tbl
1445: ,p_comparison_type => l_comparison_type
1446: ,p_diff_measures => 'N');
1447:

Line 1450: '|| poa_dbi_template_pkg.trend_sql(

1446: ,p_diff_measures => 'N');
1447:
1448: else
1449: l_query := get_pop_trend_sel_clause || ' from
1450: '|| poa_dbi_template_pkg.trend_sql(
1451: p_xtd => l_xtd,
1452: p_comparison_type => l_comparison_type,
1453: p_fact_name => l_mv,
1454: p_where_clause => l_where_clause,

Line 1540: '|| poa_dbi_template_pkg.trend_sql(

1536: poa_dbi_util_pkg.add_column(l_col_tbl, 'contract_amt_' || l_cur_suffix, 'contract_amt', 'N');
1537: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'N');
1538:
1539: l_query := get_trend_sel_clause || ' from
1540: '|| poa_dbi_template_pkg.trend_sql(
1541: p_xtd => l_xtd,
1542: p_comparison_type => l_comparison_type,
1543: p_fact_name => l_mv,
1544: p_where_clause => l_where_clause,

Line 1628: '|| poa_dbi_template_pkg.union_all_trend_sql(

1624: l_mv_tbl(2).use_grp_id := 'N';
1625: l_mv_tbl(2).mv_xtd := l_xtd;
1626:
1627: l_query := get_trend_sel_clause('union') || ' from
1628: '|| poa_dbi_template_pkg.union_all_trend_sql(
1629: p_mv => l_mv_tbl,
1630: p_comparison_type => l_comparison_type,
1631: p_diff_measures => 'N');
1632: else

Line 1634: '|| poa_dbi_template_pkg.trend_sql(

1630: p_comparison_type => l_comparison_type,
1631: p_diff_measures => 'N');
1632: else
1633: l_query := get_trend_sel_clause || ' from
1634: '|| poa_dbi_template_pkg.trend_sql(
1635: p_xtd => l_xtd,
1636: p_comparison_type => l_comparison_type,
1637: p_fact_name => l_mv,
1638: p_where_clause => l_where_clause,

Line 1762: ' || poa_dbi_template_pkg.status_sql(

1758: ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE7,
1759: ' || poa_dbi_util_pkg.rate_clause('p_p_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE8,
1760: ' || poa_dbi_util_pkg.rate_clause('c_p_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE9
1761: from
1762: ' || poa_dbi_template_pkg.status_sql(
1763: p_fact_name => l_mv,
1764: p_where_clause => l_where_clause,
1765: p_join_tables => l_join_tbl,
1766: p_use_windowing => 'N',

Line 1877: ' || poa_dbi_template_pkg.union_all_status_sql(

1873: ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE7,
1874: ' || poa_dbi_util_pkg.rate_clause('p_p_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE8,
1875: ' || poa_dbi_util_pkg.rate_clause('c_p_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE9
1876: from (
1877: ' || poa_dbi_template_pkg.union_all_status_sql(
1878: p_mv => l_mv_tbl,
1879: p_join_tables => l_join_tbl,
1880: p_use_windowing => 'N',
1881: p_paren_count => 3,

Line 1915: ' || poa_dbi_template_pkg.status_sql(

1911: ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE7,
1912: ' || poa_dbi_util_pkg.rate_clause('p_p_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE8,
1913: ' || poa_dbi_util_pkg.rate_clause('c_p_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE9
1914: from
1915: ' || poa_dbi_template_pkg.status_sql(
1916: p_fact_name => l_mv,
1917: p_where_clause => l_where_clause,
1918: p_join_tables => l_join_tbl,
1919: p_use_windowing => 'N',

Line 2296: poa_dbi_template_pkg.status_sql(

2292:
2293: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt');
2294:
2295: l_query := get_doctype_sel_clause(l_view_by,l_view_by_col) || ' from ' ||
2296: poa_dbi_template_pkg.status_sql(
2297: p_fact_name => l_mv,
2298: p_where_clause => l_where_clause || ' and (contract_type is not null) ',
2299: p_join_tables => l_join_tbl,
2300: p_use_windowing => 'N',

Line 2381: poa_dbi_template_pkg.union_all_status_sql(

2377: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
2378: l_mv_tbl(2).use_grp_id := 'N';
2379:
2380: l_query := get_doctype_sel_clause(l_view_by,l_view_by_col) || ' from (' ||
2381: poa_dbi_template_pkg.union_all_status_sql(
2382: p_mv => l_mv_tbl,
2383: p_join_tables => l_join_tbl,
2384: p_use_windowing => 'N',
2385: p_paren_count => 2,

Line 2391: poa_dbi_template_pkg.status_sql(

2387: p_generate_viewby => 'Y',
2388: p_diff_measures => 'N');
2389: else
2390: l_query := get_doctype_sel_clause(l_view_by,l_view_by_col) || ' from ' ||
2391: poa_dbi_template_pkg.status_sql(
2392: p_fact_name => l_mv,
2393: p_where_clause => l_where_clause || ' and (contract_type is not null) ',
2394: p_join_tables => l_join_tbl,
2395: p_use_windowing => 'N',