APPS.INV_EXPRESS_PICK_PUB dependencies on MTL_SERIAL_NUMBERS

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 1017: FROM mtl_serial_numbers msn

1013: , x_serial_number OUT NOCOPY VARCHAR2 -- Bug 5517498
1014: ) IS
1015: cursor msnc IS
1016: SELECT msn.serial_number
1017: FROM mtl_serial_numbers msn
1018: WHERE msn.inventory_item_id = p_inventory_item_id
1019: AND msn.current_organization_id = p_organization_id
1020: AND nvl(msn.revision,'@@@') = nvl(p_revision,'@@@')
1021: AND nvl(msn.lot_number, '@@@') = nvl(p_lot_number,'@@@')

Line 1031: FROM mtl_serial_numbers msn

1027: ORDER BY msn.serial_number;
1028: -- Added cursor for bug 5517498
1029: cursor msn_reserved IS
1030: SELECT msn.serial_number
1031: FROM mtl_serial_numbers msn
1032: WHERE msn.reservation_id = p_reservation_id
1033: ORDER BY msn.serial_number;
1034:
1035: l_msnt_tbl_size NUMBER:=0;

Line 1076: FROM mtl_serial_numbers

1072: 'INV_Express_pick.Pick_release');
1073:
1074: BEGIN
1075: SELECT serial_number into l_serial_number
1076: FROM mtl_serial_numbers
1077: WHERE inventory_item_id = p_inventory_item_id
1078: AND serial_number = msn_rec.serial_number
1079: FOR UPDATE nowait;
1080: EXCEPTION

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 1132: UPDATE mtl_serial_numbers

1128: ,null
1129: );
1130:
1131:
1132: UPDATE mtl_serial_numbers
1133: SET group_mark_id = g_transaction_temp_id
1134: WHERE inventory_item_id = p_inventory_item_id
1135: AND serial_number =msn_rec.serial_number;
1136:

Line 1159: FROM mtl_serial_numbers

1155: 'INV_Express_pick.Pick_release');
1156:
1157: BEGIN
1158: SELECT serial_number into l_serial_number
1159: FROM mtl_serial_numbers
1160: WHERE inventory_item_id = p_inventory_item_id
1161: AND serial_number = msn_rec.serial_number
1162: FOR UPDATE nowait;
1163: EXCEPTION

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

Line 1215: UPDATE mtl_serial_numbers

1211: ,null
1212: );
1213:
1214:
1215: UPDATE mtl_serial_numbers
1216: SET group_mark_id = g_transaction_temp_id,
1217: reservation_id = p_reservation_id
1218: WHERE inventory_item_id = p_inventory_item_id
1219: AND serial_number =msn_rec.serial_number;