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_TREE dependencies on INV_TRX_UTIL_PUB

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

1360: END IF;
1361: END IF;
1362:
1363: -- Enable this during debugging
1364: inv_trx_util_pub.trace(query_str, 'Add-Orgs - Material Workbench', 9);
1365: --trace1(query_str, 'add_orgs', 9);
1366:
1367: query_hdl := DBMS_SQL.open_cursor;
1368: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

2458:
2459: END IF;
2460:
2461: -- Enable this during debugging
2462: inv_trx_util_pub.trace(query_str, 'Add-Status Material Workbench', 9);
2463: --trace1('Add_Statuses - ' || query_str);
2464:
2465: query_hdl := DBMS_SQL.open_cursor;
2466: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

3496:
3497: query_str := query_str || ' ORDER BY subinventory_code ';
3498: END IF;
3499: END IF;
3500: inv_trx_util_pub.trace( query_str, 'Add_subs Material Workbench', 9);
3501: --trace1(query_str, 'add_subs', 9);
3502: query_hdl := DBMS_SQL.open_cursor;
3503: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);
3504:

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

4491: query_str := query_str || 'ORDER BY locator ';
4492: END IF;
4493: END IF;
4494:
4495: inv_trx_util_pub.trace(query_str, 'Add Loc :- Material Workbench', 9);
4496: --trace1(query_str, 'add_locs', 9);
4497:
4498: query_hdl := DBMS_SQL.open_cursor;
4499: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

5702:
5703: END IF;
5704:
5705: -- Enable this during debugging
5706: inv_trx_util_pub.trace(query_str, 'Add- Cgs Material Workbench', 9);
5707: --trace1(query_str, 'add_cgs', 9);
5708:
5709: query_hdl := DBMS_SQL.open_cursor;
5710: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

6454: AND p_prepacked <> 999 THEN
6455: query_str := query_str || 'AND lpn_context = :prepacked ';
6456: END IF;
6457:
6458: inv_trx_util_pub.trace(query_str, 'Material Workbench :- ADD LPNs', 9);
6459: --trace1('QUERY STR ' || query_str, 'add_lpns', 9);
6460:
6461: query_hdl := DBMS_SQL.open_cursor;
6462: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

6473: END IF;
6474:
6475: IF (is_bind_required = TRUE) THEN
6476: -- Enable this during debugging
6477: inv_trx_util_pub.trace(query_str, 'ADD LPNs Material Workbench :', 9);
6478: --trace1(query_str, 'add_lpns', 9);
6479:
6480: query_hdl := DBMS_SQL.open_cursor;
6481: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

7937:
7938: END IF;
7939:
7940: -- Enable this during debugging
7941: inv_trx_util_pub.trace(query_str, 'Material Workbench - Add Items : ', 9);
7942: --trace1(query_str, 'add_items', 9);
7943:
7944: query_hdl := DBMS_SQL.open_cursor;
7945: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

Line 9099: inv_trx_util_pub.trace(query_str, 'Add_revs :- Material Workbench', 9);

9095:
9096: query_str := query_str || 'GROUP BY item, revision ';
9097: query_str := query_str || 'ORDER BY revision ';
9098: END IF;
9099: inv_trx_util_pub.trace(query_str, 'Add_revs :- Material Workbench', 9);
9100: --trace1(query_str, 'add_revs', 9);
9101:
9102: query_hdl := DBMS_SQL.open_cursor;
9103: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

10245: query_str := query_str || 'ORDER BY lot_number ';
10246: END IF;
10247:
10248: -- Enable this during debugging
10249: inv_trx_util_pub.trace(query_str, 'Add_lot :- Material Workbench', 9);
10250: --trace1(query_str, 'add_lots', 9);
10251:
10252: query_hdl := DBMS_SQL.open_cursor;
10253: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);

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

10941: query_str := query_str || 'GROUP BY serial_number ';
10942: query_str := query_str || 'ORDER BY serial_number ';
10943: END IF;
10944:
10945: inv_trx_util_pub.trace(query_str, 'Add Serails :- Material Workbench', 9);
10946: --trace1(query_str, 'add_serials', 9);
10947:
10948:
10949: query_hdl := DBMS_SQL.open_cursor;

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

11502: query_str := query_str || ' GROUP BY grade_code ';
11503:
11504: END IF ;
11505:
11506: inv_trx_util_pub.trace( query_str, 'Add-Grades Material Workbench', 9);
11507: -- execute the query and populate the node table
11508: query_hdl := DBMS_SQL.open_cursor;
11509: DBMS_SQL.parse(query_hdl, query_str, DBMS_SQL.native);
11510:

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

11598: END IF;
11599: DBMS_SQL.define_column(query_hdl, 1, grade, 150);
11600: rows_processed := DBMS_SQL.EXECUTE(query_hdl);
11601:
11602: --inv_trx_util_pub.trace( 'Material Workbench rows processed ' || rows_processed, 'Material Workbench', 9);
11603:
11604: LOOP
11605: -- fetch a row
11606: IF DBMS_SQL.fetch_rows(query_hdl) > 0 THEN