APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR

131: */
132: CURSOR ue_mr_routes_csr (p_item_indtance_id IN NUMBER) IS
133: SELECT UE.unit_effectivity_id, UE.due_date, MR.mr_route_id, R.route_id, R.start_date_active, R.end_date_active
134: -- FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, AHL_MR_ROUTES_V MR
135: FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR
136: WHERE UE.mr_header_id = MR.mr_header_id
137: AND R.route_id = MR.ROUTE_ID
138: --AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))
139: AND UE.APPLICATION_USG_CODE = G_APP_MODULE

Line 637: FROM ahl_unit_effectivities_b

633: FROM ahl_mr_headers_b mr
634: WHERE application_usg_code = appln_usg_code
635: AND mr_status_code = 'COMPLETE'
636: AND EXISTS (SELECT 1
637: FROM ahl_unit_effectivities_b
638: WHERE mr_header_id = mr.mr_header_id
639: AND (status_code IS NULL OR status_code = 'INIT-DUE')
640: );
641:

Line 646: FROM ahl_unit_effectivities_b UE, csi_item_instances II

642: -- get open UE IDs for the MR header.
643: -- check if instance expired to fix bug# 8543402.
644: CURSOR get_ue_csr (p_mr_header_id IN NUMBER) IS
645: SELECT unit_effectivity_id, due_date, csi_item_instance_id
646: FROM ahl_unit_effectivities_b UE, csi_item_instances II
647: WHERE UE.mr_header_id = p_mr_header_id
648: AND UE.csi_item_instance_id = II.instance_id
649: AND nvl(ii.active_end_date, sysdate+1) > sysdate
650: AND UE.due_date IS NOT NULL