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

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

1240: /*
1241: * The following cursor has been added for bug # 4998201.
1242: * While performing Receipt and Receiving Put-Away Drop business flow for
1243: * serial, Lot Serial and Lot Serial revision controlled items, the cost_group_id
1244: * will be populated in mtl_serial_numbers table. Hence the following cursor has been
1245: * added to fetch the cost group details.
1246: */
1247:
1248: CURSOR c_cost_group(p_lpn_id NUMBER

Line 1253: FROM mtl_serial_numbers msn

1249: , p_inventory_item_id NUMBER
1250: , p_lot_number VARCHAR) IS
1251: SELECT msn.cost_group_id
1252: , ccg.cost_group
1253: FROM mtl_serial_numbers msn
1254: , cst_cost_groups ccg
1255: WHERE msn.lpn_id = p_lpn_id
1256: AND msn.inventory_item_id = p_inventory_item_id
1257: AND msn.lot_number = p_lot_number