DBA Data[Home] [Help]

APPS.BOM_IMPORT_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4127: FROM mtl_system_items_kfv

4123: IF l_head_item_id_table(i) IS NULL
4124: THEN
4125: SELECT inventory_item_id
4126: INTO l_head_item_id_table(i)
4127: FROM mtl_system_items_kfv
4128: WHERE concatenated_segments = l_head_name_table(i)
4129: AND organization_id = l_org_id_table(i);
4130: END IF;
4131:

Line 4198: FROM mtl_system_items_kfv

4194: IF l_comp_item_id_table(i) IS NULL
4195: THEN
4196: SELECT inventory_item_id
4197: INTO l_comp_item_id_table(i)
4198: FROM mtl_system_items_kfv
4199: WHERE concatenated_segments = l_comp_name_table(i)
4200: AND organization_id = l_org_id_table(i);
4201: END IF;
4202:

Line 4216: FROM mtl_system_items_kfv

4212: IF l_head_item_id_table(i) IS NULL
4213: THEN
4214: SELECT inventory_item_id
4215: INTO l_head_item_id_table(i)
4216: FROM mtl_system_items_kfv
4217: WHERE concatenated_segments = l_head_name_table(i)
4218: AND organization_id = l_org_id_table(i);
4219: END IF;
4220: