APPS.PO_ASL_API_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 1423: FROM mtl_system_items_kfv msi

1419:
1420: UPDATE po_approved_supplier_list_gt past
1421: SET past.item_id =
1422: (SELECT msi.inventory_item_id
1423: FROM mtl_system_items_kfv msi
1424: WHERE msi.concatenated_segments = past.item_dsp
1425: AND msi.organization_id = past.owning_organization_id
1426: AND ROWNUM < 2)
1427: WHERE past.item_dsp IS NOT NULL;

Line 1754: FROM mtl_system_items_kfv msi

1750:
1751: UPDATE po_asl_attributes_gt paa
1752: SET paa.item_id =
1753: (SELECT msi.inventory_item_id
1754: FROM mtl_system_items_kfv msi
1755: WHERE msi.concatenated_segments= paa.item_dsp
1756: AND ROWNUM < 2)
1757: WHERE paa.item_dsp IS NOT NULL;
1758: l_progress := 70;