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

1013: /*
1014: * The following cursor has been added for bug # 4998201.
1015: * While performing Receipt and Receiving Put-Away Drop business flow for
1016: * serial, Lot Serial and Lot Serial revision controlled items, the cost_group_id
1017: * will be populated in mtl_serial_numbers table. Hence the following cursor has been
1018: * added to fetch the cost group details.
1019: */
1020:
1021: CURSOR c_cost_group(p_lpn_id NUMBER

Line 1026: FROM mtl_serial_numbers msn

1022: , p_inventory_item_id NUMBER
1023: , p_lot_number VARCHAR) IS
1024: SELECT msn.cost_group_id
1025: , ccg.cost_group
1026: FROM mtl_serial_numbers msn
1027: , cst_cost_groups ccg
1028: WHERE msn.lpn_id = p_lpn_id
1029: AND msn.inventory_item_id = p_inventory_item_id
1030: AND msn.lot_number = p_lot_number