eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_ROUTE_EFFECTIVITIES

Line 702: FROM AHL_ROUTE_EFFECTIVITIES RE

698: x_disp_req_list OUT NOCOPY Route_Mtl_Req_Tbl_Type) IS
699:
700: CURSOR get_mc_route_eff_id_csr IS
701: SELECT RE.route_effectivity_id
702: FROM AHL_ROUTE_EFFECTIVITIES RE
703: WHERE RE.route_id = p_route_id
704: AND (RE.mc_header_id = NVL(p_mc_header_id, -1) -- Match MC Header Id first
705: OR (RE.mc_id = NVL(p_mc_id, -1) -- Match MC Id next
706: AND RE.mc_header_id IS NULL -- Added on 10/28/03 since Version specific also has stores the MC Id

Line 707: AND NOT EXISTS (SELECT 'x' FROM AHL_ROUTE_EFFECTIVITIES RE1

703: WHERE RE.route_id = p_route_id
704: AND (RE.mc_header_id = NVL(p_mc_header_id, -1) -- Match MC Header Id first
705: OR (RE.mc_id = NVL(p_mc_id, -1) -- Match MC Id next
706: AND RE.mc_header_id IS NULL -- Added on 10/28/03 since Version specific also has stores the MC Id
707: AND NOT EXISTS (SELECT 'x' FROM AHL_ROUTE_EFFECTIVITIES RE1
708: WHERE RE1.route_id = p_route_id
709: AND RE1.mc_header_id = NVL(p_mc_header_id, -1))
710: )
711: );

Line 715: FROM AHL_ROUTE_EFFECTIVITIES RE

711: );
712:
713: CURSOR get_item_route_eff_id_csr IS
714: SELECT RE.route_effectivity_id
715: FROM AHL_ROUTE_EFFECTIVITIES RE
716: WHERE RE.route_id = p_route_id
717: AND RE.inventory_item_id = p_inst_item_id; -- Match the inventory item id
718:
719: CURSOR get_disp_req_dtls_csr(c_mc_route_eff_id IN NUMBER,