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_LABEL_PVT5 dependencies on MTL_SERIAL_NUMBERS

Line 1300: * will be populated in mtl_serial_numbers table. Hence the following cursor has been

1296: /*
1297: * The following cursor has been added for bug # 4998201.
1298: * While performing Receipt and Receiving Put-Away Drop business flow for
1299: * serial, Lot Serial and Lot Serial revision controlled items, the cost_group_id
1300: * will be populated in mtl_serial_numbers table. Hence the following cursor has been
1301: * added to fetch the cost group details.
1302: */
1303:
1304: CURSOR c_cost_group(p_lpn_id NUMBER

Line 1309: FROM mtl_serial_numbers msn

1305: , p_inventory_item_id NUMBER
1306: , p_lot_number VARCHAR) IS
1307: SELECT msn.cost_group_id
1308: , ccg.cost_group
1309: FROM mtl_serial_numbers msn
1310: , cst_cost_groups ccg
1311: WHERE msn.lpn_id = p_lpn_id
1312: AND msn.inventory_item_id = p_inventory_item_id
1313: AND msn.lot_number = p_lot_number