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.FTE_LANE_SEARCH_QUERY_GEN dependencies on FND_LOOKUP_VALUES_VL

Line 190: select lookup_code from fnd_lookup_values_vl

186: from hz_parties, wsh_carriers
187: where party_name = p_carrier_name and party_id = carrier_id;
188:
189: CURSOR c_get_lookup_code(p_lookup_type VARCHAR2, p_meaning VARCHAR2) IS
190: select lookup_code from fnd_lookup_values_vl
191: where lookup_type = p_lookup_type
192: and upper(meaning) like upper(p_meaning)||'%';
193:
194: --

Line 257: ' wsh_zone_regions pd, fnd_lookup_values_vl lv2, wsh_regions r';

253:
254: l_query_select := 'select wc.carrier_name, l.carrier_id, l.origin_id, l.destination_id, lv2.meaning, l.mode_of_transportation_code, r.region_type, min(l.lane_id) lane_id ';
255:
256: l_query_from_regions :=' from fte_lanes l, wsh_carriers_v wc, wsh_zone_regions zr,' ||
257: ' wsh_zone_regions pd, fnd_lookup_values_vl lv2, wsh_regions r';
258:
259: l_query_common_join := ' where l.carrier_id = wc.carrier_id and' ||
260: ' wc.active = ''A'' AND' ||
261: ' lv2.lookup_type = ''WSH_MODE_OF_TRANSPORT'' AND' ||

Line 289: ' wsh_zone_regions pd, fnd_lookup_values_vl lv1,' ||

285: 'l.schedules_flag, ls.lane_service_id, l.tariff_name, l.lane_type';
286:
287: -- from clauses
288: l_query_from_regions := ' from fte_lanes l, wsh_carriers_v wc, wsh_zone_regions zr,' ||
289: ' wsh_zone_regions pd, fnd_lookup_values_vl lv1,' ||
290: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
292: ' wsh_regions ro, wsh_regions rd,' ||
293: ' fte_lane_services ls ';

Line 290: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||

286:
287: -- from clauses
288: l_query_from_regions := ' from fte_lanes l, wsh_carriers_v wc, wsh_zone_regions zr,' ||
289: ' wsh_zone_regions pd, fnd_lookup_values_vl lv1,' ||
290: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
292: ' wsh_regions ro, wsh_regions rd,' ||
293: ' fte_lane_services ls ';
294:

Line 291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||

287: -- from clauses
288: l_query_from_regions := ' from fte_lanes l, wsh_carriers_v wc, wsh_zone_regions zr,' ||
289: ' wsh_zone_regions pd, fnd_lookup_values_vl lv1,' ||
290: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
292: ' wsh_regions ro, wsh_regions rd,' ||
293: ' fte_lane_services ls ';
294:
295: l_query_from_lane_num := ' from fte_lanes l, wsh_carriers_v wc, fnd_lookup_values_vl lv1,' ||

Line 295: l_query_from_lane_num := ' from fte_lanes l, wsh_carriers_v wc, fnd_lookup_values_vl lv1,' ||

291: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
292: ' wsh_regions ro, wsh_regions rd,' ||
293: ' fte_lane_services ls ';
294:
295: l_query_from_lane_num := ' from fte_lanes l, wsh_carriers_v wc, fnd_lookup_values_vl lv1,' ||
296: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
297: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
298: ' wsh_regions ro, wsh_regions rd, ' ||
299: ' fte_lane_services ls ';

Line 296: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||

292: ' wsh_regions ro, wsh_regions rd,' ||
293: ' fte_lane_services ls ';
294:
295: l_query_from_lane_num := ' from fte_lanes l, wsh_carriers_v wc, fnd_lookup_values_vl lv1,' ||
296: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
297: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
298: ' wsh_regions ro, wsh_regions rd, ' ||
299: ' fte_lane_services ls ';
300:

Line 297: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||

293: ' fte_lane_services ls ';
294:
295: l_query_from_lane_num := ' from fte_lanes l, wsh_carriers_v wc, fnd_lookup_values_vl lv1,' ||
296: ' qp_list_headers_tl lh, fnd_lookup_values_vl lv2,' ||
297: ' fnd_lookup_values_vl lv3, mtl_categories m,' ||
298: ' wsh_regions ro, wsh_regions rd, ' ||
299: ' fte_lane_services ls ';
300:
301: -- common join clauses

Line 934: 'FROM FTE_SCHEDULES S, FTE_LANES L, FND_LOOKUP_VALUES_VL LV1, ' ||

930: 'DECODE(L.SERVICE_DETAIL_FLAG, ''Y'', DECODE(L.SERVICE_TYPE_CODE, null, ''multiple'', LV3.MEANING), null) AS SERVICE_TYPE_MEANING, ' ||
931: 'S.FREQUENCY_TYPE AS FREQUENCY_TYPE, ' ||
932: --'S.FREQUENCY AS ORIG_FREQUENCY, ' ||
933: 'NVL((SELECT ''Y'' FROM FTE_SCHEDULES S1 WHERE S1.SCHEDULES_ID = S.SCHEDULES_ID AND SYSDATE BETWEEN NVL(S.EFFECTIVE_DATE, SYSDATE) AND NVL(S.EXPIRY_DATE, SYSDATE)), ''N'') AS ACTIVE_FLAG ' ||
934: 'FROM FTE_SCHEDULES S, FTE_LANES L, FND_LOOKUP_VALUES_VL LV1, ' ||
935: 'FND_LOOKUP_VALUES_VL LV2, HZ_PARTIES H, FND_LOOKUP_VALUES_VL LV3 ' ||
936: 'WHERE S.LANE_ID = L.LANE_ID ' ||
937: 'AND NVL(S.EDITABLE_FLAG, ''Y'') = ''Y'' ' ||
938: 'AND NVL(S.FREQUENCY_TYPE, ''NULL'') = LV1.LOOKUP_CODE ' ||

Line 935: 'FND_LOOKUP_VALUES_VL LV2, HZ_PARTIES H, FND_LOOKUP_VALUES_VL LV3 ' ||

931: 'S.FREQUENCY_TYPE AS FREQUENCY_TYPE, ' ||
932: --'S.FREQUENCY AS ORIG_FREQUENCY, ' ||
933: 'NVL((SELECT ''Y'' FROM FTE_SCHEDULES S1 WHERE S1.SCHEDULES_ID = S.SCHEDULES_ID AND SYSDATE BETWEEN NVL(S.EFFECTIVE_DATE, SYSDATE) AND NVL(S.EXPIRY_DATE, SYSDATE)), ''N'') AS ACTIVE_FLAG ' ||
934: 'FROM FTE_SCHEDULES S, FTE_LANES L, FND_LOOKUP_VALUES_VL LV1, ' ||
935: 'FND_LOOKUP_VALUES_VL LV2, HZ_PARTIES H, FND_LOOKUP_VALUES_VL LV3 ' ||
936: 'WHERE S.LANE_ID = L.LANE_ID ' ||
937: 'AND NVL(S.EDITABLE_FLAG, ''Y'') = ''Y'' ' ||
938: 'AND NVL(S.FREQUENCY_TYPE, ''NULL'') = LV1.LOOKUP_CODE ' ||
939: 'AND LV1.LOOKUP_TYPE = ''FTE_FREQUENCY_TYPE'' ' ||