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 645: FROM AHL_ROUTE_EFFECTIVITIES RE

641: x_disp_req_list OUT NOCOPY Route_Mtl_Req_Tbl_Type) IS
642:
643: CURSOR get_mc_route_eff_id_csr IS
644: SELECT RE.route_effectivity_id
645: FROM AHL_ROUTE_EFFECTIVITIES RE
646: WHERE RE.route_id = p_route_id
647: AND (RE.mc_header_id = NVL(p_mc_header_id, -1) -- Match MC Header Id first
648: OR (RE.mc_id = NVL(p_mc_id, -1) -- Match MC Id next
649: AND RE.mc_header_id IS NULL -- Added on 10/28/03 since Version specific also has stores the MC Id

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

646: WHERE RE.route_id = p_route_id
647: AND (RE.mc_header_id = NVL(p_mc_header_id, -1) -- Match MC Header Id first
648: OR (RE.mc_id = NVL(p_mc_id, -1) -- Match MC Id next
649: AND RE.mc_header_id IS NULL -- Added on 10/28/03 since Version specific also has stores the MC Id
650: AND NOT EXISTS (SELECT 'x' FROM AHL_ROUTE_EFFECTIVITIES RE1
651: WHERE RE1.route_id = p_route_id
652: AND RE1.mc_header_id = NVL(p_mc_header_id, -1))
653: )
654: );

Line 658: FROM AHL_ROUTE_EFFECTIVITIES RE

654: );
655:
656: CURSOR get_item_route_eff_id_csr IS
657: SELECT RE.route_effectivity_id
658: FROM AHL_ROUTE_EFFECTIVITIES RE
659: WHERE RE.route_id = p_route_id
660: AND RE.inventory_item_id = p_inst_item_id; -- Match the inventory item id
661:
662: CURSOR get_disp_req_dtls_csr(c_mc_route_eff_id IN NUMBER,