DBA Data[Home] [Help]

APPS.CSI_ML_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 128: FROM mtl_system_items_kfv

124: FORALL i1 in 1 .. inst_intf_id_upd.count
125: UPDATE csi_instance_interface a
126: SET a.inventory_item_id =
127: (SELECT inventory_item_id
128: FROM mtl_system_items_kfv
129: WHERE concatenated_segments =
130: a.inv_concatenated_segments
131: AND ROWNUM=1)
132: WHERE inst_interface_id=inst_intf_id_upd(i1)

Line 443: FROM mtl_system_items_kfv

439: FORALL i1 in 1 .. iea_intf_id_upd.count
440: UPDATE csi_iea_value_interface a
441: SET a.inventory_item_id =
442: (SELECT inventory_item_id
443: FROM mtl_system_items_kfv
444: WHERE concatenated_segments =
445: a.inv_concatenated_segments
446: AND ROWNUM=1)
447: WHERE ieav_interface_id=iea_intf_id_upd(i1)

Line 657: FROM mtl_system_items_kfv

653: FORALL i1 in 1 .. inst_intf_id_upd.count
654: UPDATE csi_instance_interface a
655: SET a.inventory_item_id =
656: (SELECT inventory_item_id
657: FROM mtl_system_items_kfv
658: WHERE concatenated_segments =
659: a.inv_concatenated_segments
660: AND ROWNUM=1)
661: WHERE inst_interface_id=inst_intf_id_upd(i1)

Line 966: FROM mtl_system_items_kfv

962: FORALL i1 in 1 .. iea_intf_id_upd.count
963: UPDATE csi_iea_value_interface a
964: SET a.inventory_item_id =
965: (SELECT inventory_item_id
966: FROM mtl_system_items_kfv
967: WHERE concatenated_segments =
968: a.inv_concatenated_segments
969: AND ROWNUM=1)
970: WHERE ieav_interface_id=iea_intf_id_upd(i1)