DBA Data[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 21: FROM jtf_rs_resource_extns_vl r

17: , t.territory_short_name
18: , l.geometry
19: , s.start_date_active
20: , s.end_date_active
21: FROM jtf_rs_resource_extns_vl r
22: , per_people_f pf
23: , hz_parties p
24: , hz_party_sites s
25: , hz_locations l

Line 50: FROM jtf_rs_resource_extns_vl r

46: , t.territory_short_name
47: , l.geometry
48: , s.start_date_active
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

Line 616: , jtf_rs_resource_extns r

612: , t.territory_short_name
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