APPS.JTF_TERR_JSP_LOV_RECS_PUB dependencies on JTF_TERR_RESOURCES_V

Line 379: from jtf_terr_resources_v jtrv

375:
376: -- Get the total count for display
377: SELECT distinct count(*)
378: INTO l_total_count
379: from jtf_terr_resources_v jtrv
380: where UPPER(resource_name) like NVL(l_column1, '%') || '%'
381: -- ARPATEL09/08/2003 bug#2966686 fix
382: or l_column1 = '%';
383:

Line 390: from jtf_terr_resources_v jtrv

386: resource_type, null, null,
387: null, null, null, null, null,
388: null, null, null, null, null,
389: null, null, null, null, null
390: from jtf_terr_resources_v jtrv
391: where (UPPER(resource_name) like NVL(l_column1, '%') || '%'
392: -- ARPATEL09/08/2003 bug#2966686 fix
393: or l_column1 = '%')
394: AND EXISTS ( SELECT NULL

Line 493: from JTF_TERR_RESOURCES_V

489:
490: -- Get the total count for display
491: SELECT count(*)
492: INTO l_total_count
493: from JTF_TERR_RESOURCES_V
494: where (end_date_active is null or end_date_active >= sysdate)
495: and group_id is not null;
496:
497: OPEN lov_output_cur FOR

Line 502: from JTF_TERR_RESOURCES_V jtr

498: Select distinct jtr.group_name, jtr.group_id, null, null, null,
499: null, null, null, null, null,
500: null, null, null, null, null,
501: null, null, null, null, null
502: from JTF_TERR_RESOURCES_V jtr
503: where (jtr.end_date_active is null or jtr.end_date_active >= sysdate)
504: and jtr.group_id is not null
505: AND EXISTS ( SELECT NULL
506: FROM jtf_terr_denorm_rules_all jtdr