DBA Data[Home] [Help]

APPS.EAM_FAILURESETS_PVT dependencies on MTL_SYSTEM_ITEMS

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 171: FROM mtl_system_items

167:
168: -- Validate asset group/rebuildable
169: SELECT count(1)
170: INTO l_item_exists
171: FROM mtl_system_items
172: WHERE inventory_item_id = p_association_rec.inventory_item_id
173: AND eam_item_type IN (1,3)
174: AND rownum < 2;
175:

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