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_AVF_PRIM_VSTS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 144: FROM ahl_ue_relationships uer, ahl_visit_tasks_b vtk, ahl_unit_effectivities_b uet

140: CURSOR check_parent_mr(c_ue_id in NUMBER,
141: c_instance_id in NUMBER,
142: c_visit_id in NUMBER)IS
143: SELECT 'X'
144: FROM ahl_ue_relationships uer, ahl_visit_tasks_b vtk, ahl_unit_effectivities_b uet
145: WHERE uer.ue_id = c_ue_id
146: AND vtk.instance_id = c_instance_id
147: AND vtk.visit_id = c_visit_id
148: AND uer.ue_id = uet.unit_effectivity_id

Line 156: FROM ahl_unit_effectivities_b une, ahl_mr_headers_b mrh

152: CURSOR get_ue_details_visit(c_instance_id in NUMBER,
153: c_start_date in DATE,
154: c_end_date in DATE) IS
155: SELECT une.unit_effectivity_id, nvl(mrh.service_category_rank,0)
156: FROM ahl_unit_effectivities_b une, ahl_mr_headers_b mrh
157: WHERE une.csi_item_instance_id = c_instance_id
158: AND (une.status_code ='INIT-DUE' OR une.status_code IS NULL)
159: AND une.due_date is NOT NULL
160: AND (une.due_date between c_start_date AND c_end_date or (une.earliest_due_date between c_start_date AND c_end_date OR une.latest_due_date between c_start_date AND c_end_date))

Line 186: FROM ahl_unit_effectivities_b une, ahl_mr_headers_b mrh, ahl_unit_config_headers uch,ahl_mc_headers_b mc

182: CURSOR get_ue_details(c_mc_id in NUMBER,
183: c_start_date in DATE,
184: c_end_date in DATE) IS
185: SELECT une.unit_effectivity_id, une.due_date, une.latest_due_date, une.csi_item_instance_id, nvl(mrh.service_category_rank,0)
186: FROM ahl_unit_effectivities_b une, ahl_mr_headers_b mrh, ahl_unit_config_headers uch,ahl_mc_headers_b mc
187: WHERE mc.mc_id = c_mc_id
188: AND uch.master_config_id = mc.mc_header_id --tchimira :: 21 May 2012 :: compare correct columns
189: AND une.csi_item_instance_id = uch.csi_item_instance_id
190: AND (une.status_code ='INIT-DUE' OR une.status_code IS NULL)

Line 1144: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr, ahl_mr_visit_types_app_v mr_vtyp, ahl_visit_types_b vtyp,

1140: c_start_date IN DATE,
1141: c_end_date IN DATE) is
1142: SELECT ue.unit_effectivity_id, ue.due_date, ue.csi_item_instance_id, mr.mr_header_id,
1143: mr_vtyp.mr_visit_type_code, vtyp.estimated_duration
1144: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr, ahl_mr_visit_types_app_v mr_vtyp, ahl_visit_types_b vtyp,
1145: AHL_UNIT_CONFIG_HEADERS unit, ahl_mc_headers_b mc
1146: WHERE ue.csi_item_instance_id = unit.csi_item_instance_id
1147: AND unit.master_config_id = mc.mc_header_id
1148: AND unit.unit_config_status_code NOT IN ('QUARANTINE', 'EXPIRED')

Line 1169: FROM ahl_fleet_headers_b fleet, ahl_unit_effectivities_b ue

1165: l_primary_ue_rec get_primary_ues%ROWTYPE;
1166:
1167: Cursor get_ue_operating_org (c_ue_id IN NUMBER) IS
1168: SELECT fleet.operating_org_id
1169: FROM ahl_fleet_headers_b fleet, ahl_unit_effectivities_b ue
1170: WHERE fleet.fleet_header_id = ue.fleet_header_id
1171: and ue.unit_effectivity_id = c_ue_id;
1172:
1173: