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_UMP_SMRINSTANCE_PVT dependencies on AHL_VISITS_B

Line 197: ahl_visits_b vst1, ahl_simulation_plans_b sim

193: CURSOR ahl_visit_csr(p_ue_id IN NUMBER) IS
194: SELECT vst.start_date_time, vst.visit_number
195: FROM ahl_visit_tasks_b tsk,
196: (select vst1.* from
197: ahl_visits_b vst1, ahl_simulation_plans_b sim
198: where vst1.simulation_plan_id = sim.simulation_plan_id
199: and sim.primary_plan_flag = 'Y'
200: UNION ALL
201: select vst1.* from

Line 202: ahl_visits_b vst1

198: where vst1.simulation_plan_id = sim.simulation_plan_id
199: and sim.primary_plan_flag = 'Y'
200: UNION ALL
201: select vst1.* from
202: ahl_visits_b vst1
203: where simulation_plan_id IS NULL)vst
204: WHERE vst.visit_id = tsk.visit_id
205: AND NVL(vst.status_code,'x') NOT IN ('DELETED','CANCELLED')
206: AND NVL(tsk.status_code,'x') NOT IN ('DELETED','CANCELLED')

Line 214: ahl_visits_b vst1, ahl_simulation_plans_b sim

210: CURSOR ahl_visit_csr(p_ue_id IN NUMBER, p_visit_num IN VARCHAR2, p_visit_org_name IN VARCHAR2, p_visit_dept_name IN VARCHAR2) IS
211: SELECT vst.start_date_time, vst.visit_number, vst.visit_id
212: FROM ahl_visit_tasks_b tsk,
213: (select vst1.* from
214: ahl_visits_b vst1, ahl_simulation_plans_b sim
215: where vst1.simulation_plan_id = sim.simulation_plan_id
216: and sim.primary_plan_flag = 'Y'
217: UNION ALL
218: select vst1.* from

Line 219: ahl_visits_b vst1

215: where vst1.simulation_plan_id = sim.simulation_plan_id
216: and sim.primary_plan_flag = 'Y'
217: UNION ALL
218: select vst1.* from
219: ahl_visits_b vst1
220: where simulation_plan_id IS NULL)vst,
221: hr_all_organization_units hrou,
222: bom_departments bdpt
223: WHERE vst.visit_id = tsk.visit_id

Line 924: l_sql_string := l_sql_string || ' and exists (select ''x'' from ahl_visits_b vst1,ahl_simulation_plans_b sim, ahl_visit_tasks_b tsk where vst1.simulation_plan_id = sim.simulation_plan_id(+) ';

920: --amsriniv Begin
921: --Visit Number
922: --Set when calling for UMP Search when not in PM Mode.
923: IF p_search_mr_instance_rec.visit_number is NOT NULL THEN
924: l_sql_string := l_sql_string || ' and exists (select ''x'' from ahl_visits_b vst1,ahl_simulation_plans_b sim, ahl_visit_tasks_b tsk where vst1.simulation_plan_id = sim.simulation_plan_id(+) ';
925: l_sql_string := l_sql_string || 'and sim.primary_plan_flag(+) = ''Y'' and vst1.visit_number like :VISIT_NUMBER and vst1.visit_id = tsk.visit_id AND NVL(vst1.status_code,''x'') NOT ';
926: l_sql_string := l_sql_string || 'IN (''DELETED'',''CANCELLED'') AND NVL(tsk.status_code,''x'') NOT IN (''DELETED'',''CANCELLED'') AND tsk.unit_effectivity_id = UMP.unit_effectivity_id) ' ;
927: l_bindvar_tbl(l_bind_index) := p_search_mr_instance_rec.visit_number;
928: l_bind_index := l_bind_index + 1;

Line 1911: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

1907: B.MR_HEADER_ID,MRB.TITLE,MTL.CONCATENATED_SEGMENTS concatenated_segments,csib.serial_number,
1908: (select c.name from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id and i.counter_id = c.counter_id) name ,
1909: (select c.uom_code from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id AND I.COUNTER_ID = C.COUNTER_ID) uom_code,
1910: AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) DUE_COUNTER_VALUE, ''View all UOMs'' view_all_uoms, B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,
1911: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
1912: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
1913: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id
1914: and task.status_code <> ''DELETED'' and rownum < 2) visit_name,
1915: null sr_incident_id,null sr_number,b.unit_effectivity_id,

Line 1913: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id

1909: (select c.uom_code from ahl_mr_intervals i,csi_counter_template_vl c where b.mr_interval_id = i.mr_interval_id AND I.COUNTER_ID = C.COUNTER_ID) uom_code,
1910: AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) DUE_COUNTER_VALUE, ''View all UOMs'' view_all_uoms, B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,
1911: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
1912: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
1913: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id
1914: and task.status_code <> ''DELETED'' and rownum < 2) visit_name,
1915: null sr_incident_id,null sr_number,b.unit_effectivity_id,
1916: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,
1917: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

Line 1917: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

1913: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id
1914: and task.status_code <> ''DELETED'' and rownum < 2) visit_name,
1915: null sr_incident_id,null sr_number,b.unit_effectivity_id,
1916: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,
1917: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
1918: and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_id,
1919: (select name from ahl_fleet_headers_b flt where flt.fleet_header_id = b.fleet_header_id) fleet ,
1920: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_id
1921: and flt.fleet_header_id = b.fleet_header_id and rownum < 2) operatingorg ,

Line 1930: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt where vst.visit_id = task.visit_id

1926: (select meaning from fnd_lookup_values where lookup_code = mrb.PROGRAM_SUBTYPE_CODE and lookup_type = ''AHL_FMP_MR_PROGRAM_SUBTYPE'' and language = userenv(''LANG'')) progsubtype ,
1927: (select meaning from fnd_lookup_values where lookup_code = mrb.SPACE_CATEGORY_CODE and lookup_type = ''AHL_LTP_SPACE_CATEGORY'' and language = userenv(''LANG'')) servicecat ,
1928: (select meaning from fnd_lookup_values where lookup_code = mrb.SERVICE_TYPE_CODE and lookup_type = ''AHL_FMP_MR_SERVICE_TYPE'' and language = userenv(''LANG'')) mrServiceType ,
1929: mrb.down_time mrduration , mrb.uom_code MrDurationUOM , to_char(null) primaryvisittype ,
1930: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt where vst.visit_id = task.visit_id
1931: and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED'' and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE''
1932: and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'') and rownum < 2) scheduledvisittype ,
1933: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou
1934: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED''

Line 1933: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou

1929: mrb.down_time mrduration , mrb.uom_code MrDurationUOM , to_char(null) primaryvisittype ,
1930: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt where vst.visit_id = task.visit_id
1931: and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED'' and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE''
1932: and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'') and rownum < 2) scheduledvisittype ,
1933: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou
1934: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and task.status_code <> ''DELETED''
1935: and vst.organization_id = hrou.organization_id and rownum < 2) scheduledVisitOrg
1936: FROM AHL_UNIT_EFFECTIVITIES_B B, ahl_mr_headers_b mrb, CSI_ITEM_INSTANCES CSIB, mtl_system_items_kfv mtl,
1937: (SELECT AUE.unit_effectivity_id, ( CASE WHEN AUE.FLEET_HEADER_ID IS NULL AND AMO.OPERATING_ORG_ID IS NOT NULL

Line 2034: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b vts

2030: END IF;
2031: END IF;
2032: IF(P_SEARCH_UMP_REC.VISIT_NUMBER IS NOT NULL) THEN
2033: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.VISIT_NUMBER;
2034: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b vts
2035: where vst.visit_id = vts.visit_id and vts.unit_effectivity_id = B.unit_effectivity_id
2036: and vst.visit_number like (:' || L_BIND_INDEX || ') and vts.status_code <> ''DELETED''and rownum < 2) ';
2037: L_BIND_INDEX := L_BIND_INDEX+1;
2038: END IF;

Line 2041: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt where vst.visit_id = task.visit_id

2037: L_BIND_INDEX := L_BIND_INDEX+1;
2038: END IF;
2039: IF(P_SEARCH_UMP_REC.SCHEDULED_VISIT_TYPE IS NOT NULL) THEN
2040: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.SCHEDULED_VISIT_TYPE;
2041: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt where vst.visit_id = task.visit_id
2042: and task.unit_effectivity_id = B.unit_effectivity_id and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE''
2043: and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'') and flvt.meaning like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2044: L_BIND_INDEX := L_BIND_INDEX+1;
2045: END IF;

Line 2048: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou

2044: L_BIND_INDEX := L_BIND_INDEX+1;
2045: END IF;
2046: IF(P_SEARCH_UMP_REC.VISIT_ORG_NAME IS NOT NULL) THEN
2047: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.VISIT_ORG_NAME;
2048: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou
2049: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and
2050: vst.organization_id = hrou.organization_id
2051: and hrou.name like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2052: L_BIND_INDEX := L_BIND_INDEX+1;

Line 2201: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

2197: l_mr_search_query := l_mr_search_query || ' and MAINTTORG.MR_MAINTENANCE_ORG_NAME like (:' || l_bind_index || ')';
2198: l_bind_index := l_bind_index+1;
2199: end if;
2200: IF(NVL(P_SEARCH_UMP_REC.SHOW_VISIT_DATE_VIOLATIONS,'N') = 'Y') THEN
2201: L_MR_SEARCH_QUERY := L_MR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2202: and task.unit_effectivity_id = B.unit_effectivity_id
2203: and task.status_code <> ''DELETED'' and B.due_date IS NOT NULL AND TRUNC(B.DUE_DATE) < TRUNC(vst.START_DATE_TIME) ) ';
2204: END IF;
2205: END IF; -- MR searched

Line 2219: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

2215: AND LANGUAGE = USERENV(''LANG'')) prog_type,
2216: null mr_header_id,(CITT.NAME || ''-'' || CSB.INCIDENT_NUMBER) TITLE,MTL.CONCATENATED_SEGMENTS concatenated_segments,
2217: csib.serial_number,null name ,null uom_code,AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) due_counter_value,''View all UOMs'' view_all_uoms,
2218: B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,
2219: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2220: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
2221: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2222: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_name,
2223: B.CS_INCIDENT_ID sr_incident_id,CSB.INCIDENT_NUMBER sr_number,b.unit_effectivity_id,

Line 2221: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

2217: csib.serial_number,null name ,null uom_code,AHL_UMP_SMRINSTANCE_PVT.GET_UOM_REMAIN(b.unit_effectivity_id) due_counter_value,''View all UOMs'' view_all_uoms,
2218: B.EARLIEST_DUE_DATE,B.DUE_DATE,B.LATEST_DUE_DATE,b.date_run,
2219: (select vst.START_DATE_TIME from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2220: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) scheduledDate,
2221: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2222: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_name,
2223: B.CS_INCIDENT_ID sr_incident_id,CSB.INCIDENT_NUMBER sr_number,b.unit_effectivity_id,
2224: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,
2225: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

Line 2225: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

2221: (select visit_number from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2222: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_name,
2223: B.CS_INCIDENT_ID sr_incident_id,CSB.INCIDENT_NUMBER sr_number,b.unit_effectivity_id,
2224: (Select unit_config_header_id from AHL_UNIT_CONFIG_HEADERS where name = ahl_ump_util_pkg.get_unitname(b.csi_item_instance_id)) unit_config_header_id,
2225: (select vst.visit_id from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2226: and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''and rownum < 2) visit_id,
2227: (select name from ahl_fleet_headers_b flt where flt.fleet_header_id = b.fleet_header_id) fleet ,
2228: (SELECT HROU.NAME FROM ahl_fleet_headers_b flt, HR_ALL_ORGANIZATION_UNITS HROU where flt.OPERATING_ORG_ID = hrou.organization_id
2229: and flt.fleet_header_id = b.fleet_header_id and rownum < 2) operatingorg,

Line 2235: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt

2231: (Select position_ref_meaning from ahl_unit_details_v ucd where ucd.csi_item_instance_id = b.csi_item_instance_id and rownum < 2) ucposition,
2232: null eng_org,
2233: null implementstatus ,null progsubtype , null servicecat, null mrServiceType, null mrduration,
2234: null MrDurationUOM , to_char(null) primaryvisittype ,
2235: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt
2236: where vst.visit_id = task.visit_id and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''
2237: and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE'' and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'')
2238: and rownum < 2) scheduledvisittype ,
2239: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou

Line 2239: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou

2235: (select flvt.meaning from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt
2236: where vst.visit_id = task.visit_id and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''
2237: and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE'' and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'')
2238: and rownum < 2) scheduledvisittype ,
2239: (Select hrou.name from ahl_visits_b vst,ahl_visit_tasks_b task,hr_all_organization_units hrou
2240: where vst.visit_id = task.visit_id and task.unit_effectivity_id = b.unit_effectivity_id and task.status_code <> ''DELETED''
2241: and vst.organization_id = hrou.organization_id and rownum < 2) scheduledVisitOrg
2242: FROM AHL_UNIT_EFFECTIVITIES_B B,
2243: CS_INCIDENT_TYPES_B CITB,

Line 2307: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task

2303: END IF;
2304: END IF;
2305: IF(P_SEARCH_UMP_REC.VISIT_NUMBER IS NOT NULL) THEN
2306: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.VISIT_NUMBER;
2307: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task
2308: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and vst.visit_number like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2309: L_BIND_INDEX := L_BIND_INDEX+1;
2310: END IF;
2311: IF(P_SEARCH_UMP_REC.SCHEDULED_VISIT_TYPE IS NOT NULL) THEN

Line 2313: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt

2309: L_BIND_INDEX := L_BIND_INDEX+1;
2310: END IF;
2311: IF(P_SEARCH_UMP_REC.SCHEDULED_VISIT_TYPE IS NOT NULL) THEN
2312: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.SCHEDULED_VISIT_TYPE;
2313: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task,fnd_lookup_values flvt
2314: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and flvt.lookup_type = ''AHL_PLANNING_VISIT_TYPE''
2315: and flvt.lookup_code = vst.visit_type_code and flvt.language = userenv(''LANG'')
2316: and flvt.meaning like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2317: L_BIND_INDEX := L_BIND_INDEX+1;

Line 2321: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou

2317: L_BIND_INDEX := L_BIND_INDEX+1;
2318: END IF;
2319: IF(P_SEARCH_UMP_REC.VISIT_ORG_NAME IS NOT NULL) THEN
2320: X_UMP_BIND_PARAMS(L_BIND_INDEX).BIND_PARAM := P_SEARCH_UMP_REC.VISIT_ORG_NAME;
2321: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task ,hr_all_organization_units hrou
2322: where vst.visit_id = task.visit_id and task.unit_effectivity_id = B.unit_effectivity_id and vst.organization_id = hrou.organization_id
2323: and hrou.name like (:' || L_BIND_INDEX || ') and task.status_code <> ''DELETED''and rownum < 2) ';
2324: L_BIND_INDEX := L_BIND_INDEX+1;
2325: END IF;

Line 2427: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id

2423: and flt.fleet_header_id = b.fleet_header_id and HROU.NAME like (:' || l_bind_index || '))';
2424: l_bind_index := l_bind_index+1;
2425: end if;
2426: IF(NVL(P_SEARCH_UMP_REC.SHOW_VISIT_DATE_VIOLATIONS,'N') = 'Y') THEN
2427: L_NR_SEARCH_QUERY := L_NR_SEARCH_QUERY || ' and EXISTS (select ''x'' from ahl_visits_b vst,ahl_visit_tasks_b task where vst.visit_id = task.visit_id
2428: and task.unit_effectivity_id = B.unit_effectivity_id
2429: and task.status_code <> ''DELETED'' and B.due_date IS NOT NULL AND TRUNC(B.DUE_DATE) < TRUNC(vst.START_DATE_TIME) ) ';
2430: END IF;
2431: IF(P_SEARCH_UMP_REC.NR_TYPE IS NOT NULL) THEN