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.CSF_RESOURCE_ADDRESS_PVT dependencies on FND_TERRITORIES_VL

Line 26: , fnd_territories_vl t

22: , per_people_f pf
23: , hz_parties p
24: , hz_party_sites s
25: , hz_locations l
26: , fnd_territories_vl t
27: WHERE r.resource_id = :resource_id
28: AND pf.person_id = r.source_id
29: AND pf.party_id = p.party_id (+)
30: AND p.party_id = s.party_id (+)

Line 53: , fnd_territories_vl t

49: , s.end_date_active
50: FROM jtf_rs_resource_extns_vl r
51: , hz_party_sites s
52: , hz_locations l
53: , fnd_territories_vl t
54: WHERE r.resource_id = :resource_id
55: AND r.source_id = s.party_id (+)
56: AND NVL(s.status, ''A'') = ''A''
57: AND s.location_id = l.location_id (+)

Line 78: , fnd_territories_vl t

74: , s.end_date_active
75: FROM hz_parties p
76: , hz_party_sites s
77: , hz_locations l
78: , fnd_territories_vl t
79: WHERE p.person_last_name = :res_type_id_string
80: AND p.person_first_name = :dep_arr_party_name
81: AND s.party_id = p.party_id
82: AND l.location_id = s.location_id

Line 617: , fnd_territories_vl t

613: , a.date_from start_date_active
614: , a.date_to end_date_active
615: FROM per_addresses a
616: , jtf_rs_resource_extns r
617: , fnd_territories_vl t
618: WHERE r.resource_id = b_resource_id
619: AND a.person_id = r.source_id
620: AND a.country = t.territory_code
621: AND TRUNC(a.date_from) <= TRUNC(b_date)