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_SELECT_INVENTORY_PKG dependencies on GMI_RESERVATION_UTIL

Line 127: gmi_reservation_util.println('PROCEDURE get availabe inventory');

123: l_msg_count NUMBER;
124: l_msg_data VARCHAR2(250);
125:
126: BEGIN
127: gmi_reservation_util.println('PROCEDURE get availabe inventory');
128: wms_engine_pvt.create_suggestions
129: ( p_api_version => 1.0
130: ,x_return_status => l_return_status
131: ,x_msg_count => l_msg_count

Line 138: gmi_reservation_util.println('Get Avail: rows back '

134: ,p_reservations => l_reservations
135: ,p_simulation_mode => 10
136: );
137:
138: gmi_reservation_util.println('Get Avail: rows back '
139: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
140: gmi_reservation_util.println('Get Avail: inserting the data into the temp');
141: --FOR ALL i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
142: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT

Line 140: gmi_reservation_util.println('Get Avail: inserting the data into the temp');

136: );
137:
138: gmi_reservation_util.println('Get Avail: rows back '
139: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT);
140: gmi_reservation_util.println('Get Avail: inserting the data into the temp');
141: --FOR ALL i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
142: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
143: LOOP
144: gmi_reservation_util.println('fetch the rows, 2nd qty '

Line 144: gmi_reservation_util.println('fetch the rows, 2nd qty '

140: gmi_reservation_util.println('Get Avail: inserting the data into the temp');
141: --FOR ALL i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
142: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
143: LOOP
144: gmi_reservation_util.println('fetch the rows, 2nd qty '
145: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
146: gmi_reservation_util.println('fetch the rows, grade_code '
147: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code);
148: INSERT INTO mtl_available_inventory_temp

Line 146: gmi_reservation_util.println('fetch the rows, grade_code '

142: FOR i IN 1..WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl.COUNT
143: LOOP
144: gmi_reservation_util.println('fetch the rows, 2nd qty '
145: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).secondary_onhand_qty);
146: gmi_reservation_util.println('fetch the rows, grade_code '
147: ||WMS_SEARCH_ORDER_GLOBALS_PVT.g_available_inv_tbl(i).grade_code);
148: INSERT INTO mtl_available_inventory_temp
149: ( revision
150: , lot_number