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 1152: * will be populated in mtl_serial_numbers table. Hence the following cursor has been

1148: /*
1149: * The following cursor has been added for bug # 4998201.
1150: * While performing Receipt and Receiving Put-Away Drop business flow for
1151: * serial, Lot Serial and Lot Serial revision controlled items, the cost_group_id
1152: * will be populated in mtl_serial_numbers table. Hence the following cursor has been
1153: * added to fetch the cost group details.
1154: */
1155:
1156: CURSOR c_cost_group(p_lpn_id NUMBER

Line 1161: FROM mtl_serial_numbers msn

1157: , p_inventory_item_id NUMBER
1158: , p_lot_number VARCHAR) IS
1159: SELECT msn.cost_group_id
1160: , ccg.cost_group
1161: FROM mtl_serial_numbers msn
1162: , cst_cost_groups ccg
1163: WHERE msn.lpn_id = p_lpn_id
1164: AND msn.inventory_item_id = p_inventory_item_id
1165: AND msn.lot_number = p_lot_number