DBA Data[Home] [Help]

APPS.INVPULI3 dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 93: FROM mtl_system_items_b_kfv mskfv

89: FOR I IN base_item_num_table.FIRST .. base_item_num_table.LAST LOOP
90: UPDATE mtl_system_items_interface msii
91: SET msii.copy_item_id =
92: ( SELECT mskfv.inventory_item_id
93: FROM mtl_system_items_b_kfv mskfv
94: WHERE mskfv.concatenated_segments = base_item_num_table(i)
95: AND rownum = 1 )
96: WHERE msii.copy_item_number = base_item_num_table(i)
97: AND msii.set_process_id = xset_id