APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 364: FROM AHL_ITEM_COMP_DETAILS

360: --AMSRINIV. Bug 4913141. Query for cursor below tuned.
361: CURSOR get_item_comp_detail_id( p_route_effecitivity_id IN NUMBER,
362: p_item_group_id IN NUMBER ) IS
363: SELECT ITEM_COMP_DETAIL_ID
364: FROM AHL_ITEM_COMP_DETAILS
365: WHERE ITEM_GROUP_ID = P_ITEM_GROUP_ID AND
366: ITEM_COMPOSITION_ID = (
367: SELECT IC.ITEM_COMPOSITION_ID FROM
368: AHL_ROUTE_EFFECTIVITIES RE, AHL_ITEM_COMPOSITIONS IC

Line 376: FROM AHL_ITEM_COMP_DETAILS

372: ROUTE_EFFECTIVITY_ID = P_ROUTE_EFFECITIVITY_ID ) AND
373: EFFECTIVE_END_DATE IS NULL;
374:
375: /*SELECT item_comp_detail_id
376: FROM AHL_ITEM_COMP_DETAILS
377: WHERE item_group_id = p_item_group_id AND
378: item_composition_id = (
379: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V
380: WHERE route_effectivity_id = p_route_effecitivity_id

Line 1915: FROM ahl_item_comp_details

1911: ROMV.object_id = c_object_id AND
1912: ROMV.association_type_code = c_association_type AND
1913: NOT EXISTS
1914: (SELECT item_comp_detail_id
1915: FROM ahl_item_comp_details
1916: WHERE item_comp_detail_id = ROMV.item_comp_detail_id
1917: AND
1918: effective_end_date is not null)
1919: GROUP BY