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.INV_MWB_TREE1 dependencies on INV_TRX_UTIL_PUB

Line 7156: inv_trx_util_pub.trace(query_str, 'Add-Status Material Workbench', 9);

7152:
7153: END IF;
7154:
7155: -- Enable this during debugging
7156: inv_trx_util_pub.trace(query_str, 'Add-Status Material Workbench', 9);
7157: --trace1('Add_Statuses - ' || query_str);
7158: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
7159:
7160: inv_mwb_globals.g_last_query := query_str;

Line 8738: -- inv_trx_util_pub.trace( query_str, 'Add_subs Material Workbench', 9);

8734:
8735: query_str := query_str || ' ORDER BY subinventory_code ';
8736: END IF;
8737: END IF;
8738: -- inv_trx_util_pub.trace( query_str, 'Add_subs Material Workbench', 9);
8739: --trace1(query_str, 'add_subs', 9);
8740:
8741: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
8742:

Line 10237: inv_trx_util_pub.trace(query_str, 'Add Loc :- Material Workbench', 9);

10233: query_str := query_str || 'ORDER BY locator ';
10234: END IF;
10235: END IF;
10236:
10237: inv_trx_util_pub.trace(query_str, 'Add Loc :- Material Workbench', 9);
10238: --trace1(query_str, 'add_locs', 9);
10239: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
10240:
10241: inv_mwb_globals.g_last_query := query_str;

Line 11841: inv_trx_util_pub.trace(query_str, 'Add- Cgs Material Workbench', 9);

11837:
11838: END IF;
11839:
11840: -- Enable this during debugging
11841: inv_trx_util_pub.trace(query_str, 'Add- Cgs Material Workbench', 9);
11842: --trace1(query_str, 'add_cgs', 9);
11843:
11844: --RS
11845: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );

Line 13042: inv_trx_util_pub.trace(query_str, 'Material Workbench :- ADD LPNs', 9);

13038: AND inv_mwb_globals.g_prepacked <> 999 THEN
13039: query_str := query_str || 'AND lpn_context = :prepacked ';
13040: END IF;
13041:
13042: inv_trx_util_pub.trace(query_str, 'Material Workbench :- ADD LPNs', 9);
13043: --trace1('QUERY STR ' || query_str, 'add_lpns', 9);
13044: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
13045: inv_mwb_globals.g_last_query := query_str;
13046: query_hdl := DBMS_SQL.open_cursor;

Line 13062: -- inv_trx_util_pub.trace(query_str, 'ADD LPNs Material Workbench :', 9);

13058: END IF;
13059:
13060: IF (is_bind_required = TRUE) THEN
13061: -- Enable this during debugging
13062: -- inv_trx_util_pub.trace(query_str, 'ADD LPNs Material Workbench :', 9);
13063: --trace1(query_str, 'add_lpns', 9);
13064:
13065: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
13066: inv_mwb_globals.g_last_query := query_str;

Line 16157: inv_trx_util_pub.trace(query_str, 'Material Workbench - Add Items : ', 9);

16153: END IF;
16154:
16155:
16156: -- Enable this during debugging
16157: inv_trx_util_pub.trace(query_str, 'Material Workbench - Add Items : ', 9);
16158: --trace1(query_str, 'add_items', 9);
16159: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
16160: inv_mwb_globals.g_last_query := query_str;
16161: query_hdl := DBMS_SQL.open_cursor;

Line 19997: inv_trx_util_pub.trace(query_str, 'Add_lot :- Material Workbench', 9);

19993: query_str := query_str || 'ORDER BY lot_number ';
19994: END IF;
19995:
19996: -- Enable this during debugging
19997: inv_trx_util_pub.trace(query_str, 'Add_lot :- Material Workbench', 9);
19998: --trace1(query_str, 'add_lots', 9);
19999: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
20000: inv_mwb_globals.g_last_query := query_str;
20001: query_hdl := DBMS_SQL.open_cursor;

Line 21270: inv_trx_util_pub.trace(query_str, 'Add Serails :- Material Workbench', 9);

21266: query_str := query_str || 'GROUP BY serial_number ';
21267: query_str := query_str || 'ORDER BY serial_number ';
21268: END IF;
21269:
21270: inv_trx_util_pub.trace(query_str, 'Add Serails :- Material Workbench', 9);
21271: --trace1(query_str, 'add_serials', 9);
21272:
21273: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
21274:

Line 21972: inv_trx_util_pub.trace( query_str, 'Add-Grades Material Workbench', 9);

21968: query_str := query_str || ' GROUP BY grade_code ';
21969:
21970: END IF ;
21971:
21972: inv_trx_util_pub.trace( query_str, 'Add-Grades Material Workbench', 9);
21973: -- execute the query and populate the node table
21974: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, query_str );
21975: inv_mwb_globals.g_last_query := query_str;
21976: query_hdl := DBMS_SQL.open_cursor;

Line 22110: --inv_trx_util_pub.trace( 'Material Workbench rows processed ' || rows_processed, 'Material Workbench', 9);

22106:
22107: DBMS_SQL.define_column(query_hdl, 1, grade, 150);
22108: rows_processed := DBMS_SQL.EXECUTE(query_hdl);
22109:
22110: --inv_trx_util_pub.trace( 'Material Workbench rows processed ' || rows_processed, 'Material Workbench', 9);
22111:
22112: LOOP
22113: -- fetch a row
22114: IF DBMS_SQL.fetch_rows(query_hdl) > 0 THEN