APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_SERIAL_NUMBERS

Line 60: from mtl_serial_numbers

56: select 1
57: into count_assigned
58: from dual
59: where exists (select /*+ first_rows(1) */ 1
60: from mtl_serial_numbers
61: where status_id = p_status_id);
62:
63: if count_assigned >0 then
64: return TRUE;

Line 265: FROM MTL_SERIAL_NUMBERS

261: l_to_serial_number varchar2(30):= NULL;
262:
263: cursor cur_serial_number is
264: SELECT serial_number
265: FROM MTL_SERIAL_NUMBERS
266: WHERE current_organization_id = p_status_rec.organization_id
267: AND inventory_item_id = p_status_rec.inventory_item_id
268: AND serial_number > p_status_rec.serial_number
269: AND serial_number <= p_status_rec.to_serial_number;

Line 974: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL

970: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
971: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
972: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
973: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
974: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
975: ) AS
976: CURSOR cur_ms IS SELECT inventory_atp_code
977: ,reservable_type
978: ,availability_type FROM mtl_material_statuses

Line 995: mtl_serial_numbers. Hence commenting the UPDATE statement */

991: AND inventory_item_id = p_inventory_item_id;
992: ELSIF p_serial_number IS NOT NULL THEN
993:
994: /* Bug#4560805 The columns inventory_atp_code,availability_type and reservable_type are not a part of
995: mtl_serial_numbers. Hence commenting the UPDATE statement */
996:
997: /*
998: UPDATE mtl_serial_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,
999: availability_type =rec_ms.reservable_type,

Line 998: UPDATE mtl_serial_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,

994: /* Bug#4560805 The columns inventory_atp_code,availability_type and reservable_type are not a part of
995: mtl_serial_numbers. Hence commenting the UPDATE statement */
996:
997: /*
998: UPDATE mtl_serial_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,
999: availability_type =rec_ms.reservable_type,
1000: reservable_type =rec_ms.availability_type
1001: WHERE current_organization_id = p_org_id
1002: AND serial_number = p_serial_number