DBA Data[Home] [Help]

APPS.EAM_FAILURESETS_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 96: mtl_system_items_kfv msik

92: BEGIN
93: SELECT efsa.inventory_item_id, msik.concatenated_segments
94: INTO l_inventory_item_id, l_item
95: FROM eam_failure_set_associations efsa,
96: mtl_system_items_kfv msik
97: WHERE efsa.set_id = l_set_id
98: AND msik.inventory_item_id = efsa.inventory_item_id
99: AND EXISTS
100: (SELECT 1

Line 179: FROM mtl_system_items_kfv

175:
176: BEGIN
177: SELECT concatenated_segments
178: INTO l_maintained_group
179: FROM mtl_system_items_kfv
180: WHERE inventory_item_id = p_association_rec.inventory_item_id
181: AND ROWNUM < 2;
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN