APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 322: FROM AHL_ITEM_COMP_DETAILS

318: --AMSRINIV. Bug 4913141. Query for cursor below tuned.
319: CURSOR get_item_comp_detail_id( p_route_effecitivity_id IN NUMBER,
320: p_item_group_id IN NUMBER ) IS
321: SELECT ITEM_COMP_DETAIL_ID
322: FROM AHL_ITEM_COMP_DETAILS
323: WHERE ITEM_GROUP_ID = P_ITEM_GROUP_ID AND
324: ITEM_COMPOSITION_ID = (
325: SELECT IC.ITEM_COMPOSITION_ID FROM
326: AHL_ROUTE_EFFECTIVITIES RE, AHL_ITEM_COMPOSITIONS IC

Line 333: FROM AHL_ITEM_COMP_DETAILS

329: IC.APPROVAL_STATUS_CODE(+)='COMPLETE' AND
330: ROUTE_EFFECTIVITY_ID = P_ROUTE_EFFECITIVITY_ID ) AND
331: EFFECTIVE_END_DATE IS NULL;
332: /*SELECT item_comp_detail_id
333: FROM AHL_ITEM_COMP_DETAILS
334: WHERE item_group_id = p_item_group_id AND
335: item_composition_id = (
336: SELECT item_composition_id FROM AHL_ROUTE_EFFECTIVITIES_V
337: WHERE route_effectivity_id = p_route_effecitivity_id

Line 1862: FROM ahl_item_comp_details

1858: ROMV.object_id = c_object_id AND
1859: ROMV.association_type_code = c_association_type AND
1860: NOT EXISTS
1861: (SELECT item_comp_detail_id
1862: FROM ahl_item_comp_details
1863: WHERE item_comp_detail_id = ROMV.item_comp_detail_id
1864: AND
1865: effective_end_date is not null)
1866: GROUP BY