DBA Data[Home] [Help]

APPS.ICX_REQ_COPY_REQ dependencies on MTL_SYSTEM_ITEMS_KFV

Line 903: FROM mtl_system_items_kfv a

899: END LOOP; /* FOR prec ... */
900:
901: UPDATE icx_shopping_cart_lines b
902: SET item_number = ( SELECT a.concatenated_segments
903: FROM mtl_system_items_kfv a
904: WHERE a.inventory_item_id = b.item_id
905: AND a.organization_id = b.destination_organization_id
906: AND b.cart_id = v_cart_id
907: AND b.item_id IS NOT NULL)