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 1
60: from mtl_serial_numbers
61: where status_id = p_status_id);
62:
63: if count_assigned >0 then
64: return TRUE;

Line 254: FROM MTL_SERIAL_NUMBERS

250: l_to_serial_number varchar2(30):= NULL;
251:
252: cursor cur_serial_number is
253: SELECT serial_number
254: FROM MTL_SERIAL_NUMBERS
255: WHERE current_organization_id = p_status_rec.organization_id
256: AND inventory_item_id = p_status_rec.inventory_item_id
257: AND serial_number > p_status_rec.serial_number
258: AND serial_number <= p_status_rec.to_serial_number;

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

767: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
768: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
769: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL
770: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL
771: ,p_serial_number MTL_SERIAL_NUMBERS.SERIAL_NUMBER%TYPE DEFAULT NULL
772: ) AS
773: CURSOR cur_ms IS SELECT inventory_atp_code
774: ,reservable_type
775: ,availability_type FROM mtl_material_statuses

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

788: AND inventory_item_id = p_inventory_item_id;
789: ELSIF p_serial_number IS NOT NULL THEN
790:
791: /* Bug#4560805 The columns inventory_atp_code,availability_type and reservable_type are not a part of
792: mtl_serial_numbers. Hence commenting the UPDATE statement */
793:
794: /*
795: UPDATE mtl_serial_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,
796: availability_type =rec_ms.reservable_type,

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

791: /* Bug#4560805 The columns inventory_atp_code,availability_type and reservable_type are not a part of
792: mtl_serial_numbers. Hence commenting the UPDATE statement */
793:
794: /*
795: UPDATE mtl_serial_numbers SET inventory_atp_code =rec_ms.inventory_atp_code,
796: availability_type =rec_ms.reservable_type,
797: reservable_type =rec_ms.availability_type
798: WHERE current_organization_id = p_org_id
799: AND serial_number = p_serial_number