DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on MTL_SYSTEM_ITEMS

Line 305: FROM mtl_system_items

301: l_item_control_rec.bom_item_type,
302: l_item_control_rec.primary_uom_code,
303: l_item_control_rec.model_item_id,
304: l_item_control_rec.pick_components_flag
305: FROM mtl_system_items
306: WHERE inventory_item_id = l_item_control_rec.inventory_item_id
307: AND organization_id = l_item_control_rec.organization_id;
308: EXCEPTION
309: WHEN no_data_found THEN

Line 320: FROM mtl_system_items_b

316:
317: BEGIN
318: SELECT distinct serial_number_control_code
319: INTO l_tmp_id1
320: FROM mtl_system_items_b
321: WHERE inventory_item_id = l_item_control_rec.inventory_item_id;
322: l_item_control_rec.mult_srl_control_flag := 'N';
323: EXCEPTION
324: WHEN too_many_rows THEN