APPS.WMS_CONTAINER2_PUB dependencies on MTL_SYSTEM_ITEMS

Line 357: FROM mtl_system_items

353: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
354: /* Get the primary UOM for the serialized item */
355: SELECT primary_uom_code
356: INTO l_temp_uom_code
357: FROM mtl_system_items
358: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
359: AND organization_id = v_lpn_serial_content.current_organization_id;
360:
361: l_container_content_rec.parent_lpn_id := v_lpn_serial_content.lpn_id;

Line 430: FROM mtl_system_items

426: FOR v_lpn_serial_content IN lpn_serial_contents_cursor LOOP
427: /* Get the primary UOM for the serialized item */
428: SELECT primary_uom_code
429: INTO l_temp_uom_code
430: FROM mtl_system_items
431: WHERE inventory_item_id = v_lpn_serial_content.inventory_item_id
432: AND organization_id = v_lpn_serial_content.current_organization_id;
433:
434: l_container_content_rec.parent_lpn_id := v_lpn_serial_content.lpn_id;

Line 670: FROM MTL_SYSTEM_ITEMS

666: WHERE master_organization_id = p_organization_id
667: AND load_item_id = p_source_item_id
668: AND container_item_id IN
669: (SELECT inventory_item_id
670: FROM MTL_SYSTEM_ITEMS
671: WHERE mtl_transactions_enabled_flag = 'Y'
672: AND container_item_flag = 'Y'
673: AND organization_id = p_organization_id);
674: