APPS.WMS_CROSS_DOCK_PVT dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 48: /* Local procedure to insert record in MTL_SERIAL_NUMBERS_TEMP

44: l_mol_criteria_tb( p_move_order_line_id) := p_crossdock_criterion_id ;
45: END insert_xdock_criteria;
46:
47: --bug#9816695,added following function
48: /* Local procedure to insert record in MTL_SERIAL_NUMBERS_TEMP
49: input :
50: lpn_id, serial_numbers(pl/sql table),inventory_item_id,transaction_temp_id
51:
52: output : Success or Failur

Line 85: INSERT INTO mtl_serial_numbers_temp

81: mydebug('insert_xdock_msnt:p_serial_number_table.count():' || p_serial_number_table.count);
82: END IF;
83:
84: FORALL i IN 1 .. p_serial_number_table.COUNT
85: INSERT INTO mtl_serial_numbers_temp
86: (
87: transaction_temp_id ,
88: last_update_date ,
89: last_updated_by ,

Line 1560: FROM mtl_serial_numbers_temp

1556: WHERE lpn_id = l_lpn_id;
1557:
1558: cursor serial_csr IS
1559: SELECT fm_serial_number
1560: FROM mtl_serial_numbers_temp
1561: WHERE transaction_temp_id=l_serial_temp_id ;
1562:
1563: CURSOR parent_lpn_cur ( p_innermost_lpn_id NUMBER ) IS
1564: SELECT lpn_id, license_plate_number, parent_lpn_id, organization_id, subinventory_code, locator_id,