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_NEG_PKG dependencies on POA_DBI_SUTIL_PKG

Line 58: poa_dbi_sutil_pkg.process_parameters(p_param

54:
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
56: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
57: l_to_date_type := 'XTD';
58: poa_dbi_sutil_pkg.process_parameters(p_param
59: ,l_view_by
60: ,l_view_by_col
61: ,l_view_by_value
62: ,l_comparison_type

Line 147: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

143: */
144:
145: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
146: IS
147: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
148: BEGIN
149: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
150: l_col_tbl.extend;
151: l_col_tbl(1) := 'POA_MEASURE2';

Line 149: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

145: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
146: IS
147: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
148: BEGIN
149: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
150: l_col_tbl.extend;
151: l_col_tbl(1) := 'POA_MEASURE2';
152: l_col_tbl.extend;
153: l_col_tbl(2) := 'POA_PERCENT1';

Line 174: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

170: l_col_tbl(9) := 'POA_MEASURE1';
171: end if;
172:
173:
174: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
175:
176: END;
177:
178: /* Function Name : get_status_sel_clause

Line 191: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

187: l_sel_clause varchar2(8000);
188: --
189: BEGIN
190: --
191: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
192: ,'PO'
193: ,'8.0');
194: --
195: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 350: poa_dbi_sutil_pkg.process_parameters(p_param

346:
347: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
348: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
349: l_to_date_type := 'XTD';
350: poa_dbi_sutil_pkg.process_parameters(p_param
351: ,l_view_by
352: ,l_view_by_col
353: ,l_view_by_value
354: ,l_comparison_type

Line 419: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

415: */
416:
417: FUNCTION get_awd_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
418: IS
419: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
420: BEGIN
421: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
422: l_col_tbl.extend;
423: l_col_tbl(1) := 'POA_MEASURE2';

Line 421: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

417: FUNCTION get_awd_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
418: IS
419: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
420: BEGIN
421: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
422: l_col_tbl.extend;
423: l_col_tbl(1) := 'POA_MEASURE2';
424: l_col_tbl.extend;
425: l_col_tbl(2) := 'POA_PERCENT1';

Line 440: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

436: l_col_tbl.extend;
437: l_col_tbl(7) := 'POA_MEASURE1';
438: end if;
439:
440: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
441:
442: END;
443:
444:

Line 458: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

454: l_sel_clause varchar2(8000);
455: --
456: BEGIN
457: --
458: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
459: ,'NEG'
460: ,'8.0');
461: --
462: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 575: poa_dbi_sutil_pkg.process_parameters(p_param

571:
572: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
573: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
574: l_to_date_type := 'XTD';
575: poa_dbi_sutil_pkg.process_parameters(p_param
576: ,l_view_by
577: ,l_view_by_col
578: ,l_view_by_value
579: ,l_comparison_type

Line 653: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

649: */
650:
651: FUNCTION get_avg_cycle_filter_where(p_view_by in VARCHAR2) return VARCHAR2
652: IS
653: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
654: BEGIN
655: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
656: l_col_tbl.extend;
657: l_col_tbl(1) := 'POA_MEASURE2';

Line 655: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

651: FUNCTION get_avg_cycle_filter_where(p_view_by in VARCHAR2) return VARCHAR2
652: IS
653: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
654: BEGIN
655: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
656: l_col_tbl.extend;
657: l_col_tbl(1) := 'POA_MEASURE2';
658: l_col_tbl.extend;
659: l_col_tbl(2) := 'POA_MEASURE3';

Line 671: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

667: l_col_tbl.extend;
668: l_col_tbl(6) := 'POA_MEASURE1';
669: end if;
670:
671: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
672:
673: END;
674:
675: /* Function Name : get_avg_cycle_time_sel_clause

Line 688: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

684: l_sel_clause varchar2(8000);
685: --
686: BEGIN
687: --
688: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
689: ,'NEG'
690: ,'8.0');
691: --
692: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 805: poa_dbi_sutil_pkg.process_parameters(p_param

801:
802: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
803: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
804: l_to_date_type := 'XTD';
805: poa_dbi_sutil_pkg.process_parameters(p_param
806: ,l_view_by
807: ,l_view_by_col
808: ,l_view_by_value
809: ,l_comparison_type

Line 871: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

867: */
868:
869: FUNCTION get_real_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
870: IS
871: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
872: BEGIN
873: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
874: l_col_tbl.extend;
875: l_col_tbl(1) := 'POA_MEASURE2';

Line 873: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

869: FUNCTION get_real_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
870: IS
871: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
872: BEGIN
873: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
874: l_col_tbl.extend;
875: l_col_tbl(1) := 'POA_MEASURE2';
876: l_col_tbl.extend;
877: l_col_tbl(2) := 'POA_PERCENT1';

Line 899: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

895: l_col_tbl(10) := 'POA_MEASURE1';
896: end if;
897:
898:
899: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
900:
901: END;
902:
903: /* Function Name : get_realized_status_sel_clause

Line 916: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

912: l_sel_clause varchar2(8000);
913: --
914: BEGIN
915: --
916: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
917: ,'PO'
918: ,'8.0');
919: --
920: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 1067: poa_dbi_sutil_pkg.process_parameters(p_param

1063: BEGIN
1064: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1065: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1066: l_to_date_type := 'XTD';
1067: poa_dbi_sutil_pkg.process_parameters(p_param
1068: ,l_view_by
1069: ,l_view_by_col
1070: ,l_view_by_value
1071: ,l_comparison_type

Line 1158: poa_dbi_sutil_pkg.process_parameters(p_param

1154: BEGIN
1155: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1156: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1157: l_to_date_type := 'XTD';
1158: poa_dbi_sutil_pkg.process_parameters(p_param
1159: ,l_view_by
1160: ,l_view_by_col
1161: ,l_view_by_value
1162: ,l_comparison_type

Line 1254: poa_dbi_sutil_pkg.process_parameters(p_param

1250: BEGIN
1251: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1252: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1253: l_to_date_type := 'XTD';
1254: poa_dbi_sutil_pkg.process_parameters(p_param
1255: ,l_view_by
1256: ,l_view_by_col
1257: ,l_view_by_value
1258: ,l_comparison_type

Line 1346: poa_dbi_sutil_pkg.process_parameters(p_param

1342: BEGIN
1343: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1344: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1345: l_to_date_type := 'XTD';
1346: poa_dbi_sutil_pkg.process_parameters(p_param
1347: ,l_view_by
1348: ,l_view_by_col
1349: ,l_view_by_value
1350: ,l_comparison_type

Line 1442: poa_dbi_sutil_pkg.process_parameters(p_param

1438: BEGIN
1439: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1440: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1441: l_to_date_type := 'XTD';
1442: poa_dbi_sutil_pkg.process_parameters(p_param
1443: ,l_view_by
1444: ,l_view_by_col
1445: ,l_view_by_value
1446: ,l_comparison_type

Line 1533: poa_dbi_sutil_pkg.process_parameters(p_param

1529: BEGIN
1530: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1531: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
1532: l_to_date_type := 'XTD';
1533: poa_dbi_sutil_pkg.process_parameters(p_param
1534: ,l_view_by
1535: ,l_view_by_col
1536: ,l_view_by_value
1537: ,l_comparison_type

Line 1622: poa_dbi_sutil_pkg.drill_process_parameters(

1618: l_to_date_type VARCHAR2(10);
1619: BEGIN
1620: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
1621: l_to_date_type := 'XTD';
1622: poa_dbi_sutil_pkg.drill_process_parameters(
1623: p_param,
1624: l_cur_suffix,
1625: l_where_clause,
1626: l_in_join_tbl,

Line 1787: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

1783: */
1784:
1785: FUNCTION get_awd_dtl_filter_clause return VARCHAR2
1786: IS
1787: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1788: BEGIN
1789: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1790: l_col_tbl.extend;
1791: l_col_tbl(1) := 'POA_MEASURE2';

Line 1789: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

1785: FUNCTION get_awd_dtl_filter_clause return VARCHAR2
1786: IS
1787: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1788: BEGIN
1789: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1790: l_col_tbl.extend;
1791: l_col_tbl(1) := 'POA_MEASURE2';
1792: l_col_tbl.extend;
1793: l_col_tbl(2) := 'POA_ATTRIBUTE2';

Line 1796: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

1792: l_col_tbl.extend;
1793: l_col_tbl(2) := 'POA_ATTRIBUTE2';
1794: l_col_tbl.extend;
1795: l_col_tbl(3) := 'POA_MEASURE3';
1796: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1797: END;
1798:
1799: /* Function Name : get_dtl_filter
1800: This function is called by the procedure, dtl_sql, and it has the computations to be done