APPS.INV_EXPRESS_PICK_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 917: FROM mtl_serial_numbers_temp WHERE

913: l_InvPCInRecType.transaction_temp_id :=l_staged_rsv_id_tbl(l_res_index).transaction_temp_id;
914:
915: ELSE
916: SELECT fm_serial_number INTO l_serial_number
917: FROM mtl_serial_numbers_temp WHERE
918: transaction_temp_id = l_staged_rsv_id_tbl(l_res_index).transaction_temp_id;
919: print_debug('fm_serial_number '||l_serial_number,'Inv_Express_Pick.Pick_release');
920: l_shipping_attr(1).serial_number :=l_serial_number;
921: END IF;

Line 1086: INSERT INTO mtl_serial_numbers_temp

1082: null;
1083: END;
1084:
1085: l_msnt_tbl_size := l_msnt_tbl_size +1;
1086: INSERT INTO mtl_serial_numbers_temp
1087: (
1088: transaction_temp_id
1089: ,last_update_date
1090: ,last_updated_by

Line 1169: INSERT INTO mtl_serial_numbers_temp

1165: null;
1166: END;
1167:
1168: l_msnt_tbl_size := l_msnt_tbl_size +1;
1169: INSERT INTO mtl_serial_numbers_temp
1170: (
1171: transaction_temp_id
1172: ,last_update_date
1173: ,last_updated_by