APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_ITEM_LOCATIONS

Line 32: from mtl_item_locations

28: select 1
29: into count_assigned
30: from dual
31: where exists (select 1
32: from mtl_item_locations
33: where status_id = p_status_id);
34:
35: if count_assigned >0 then
36: return TRUE;

Line 770: ,p_inventory_location_id MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE DEFAULT NULL

766: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
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

Line 804: UPDATE MTL_ITEM_LOCATIONS SET inventory_atp_code =rec_ms.inventory_atp_code,

800: AND inventory_item_id = p_inventory_item_id;
801: */
802: NULL;
803: ELSIF p_inventory_location_id IS NOT NULL THEN
804: UPDATE MTL_ITEM_LOCATIONS SET inventory_atp_code =rec_ms.inventory_atp_code,
805: availability_type =rec_ms.reservable_type,
806: reservable_type =rec_ms.availability_type
807: WHERE organization_id = p_org_id
808: AND inventory_location_id = p_inventory_location_id;