DBA Data[Home] [Help]

APPS.CSF_RESOURCE_ADDRESS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 27: FROM jtf_rs_resource_extns_vl r

23: , t.territory_short_name
24: , l.geometry
25: , s.start_date_active
26: , s.end_date_active
27: FROM jtf_rs_resource_extns_vl r
28: , per_people_f pf
29: , hz_parties p
30: , hz_party_sites s
31: , hz_locations l

Line 56: FROM jtf_rs_resource_extns_vl r

52: , t.territory_short_name
53: , l.geometry
54: , s.start_date_active
55: , s.end_date_active
56: FROM jtf_rs_resource_extns_vl r
57: , hz_party_sites s
58: , hz_locations l
59: , fnd_territories_vl t
60: WHERE r.resource_id = :resource_id

Line 752: , jtf_rs_resource_extns r

748: , t.territory_short_name
749: , a.date_from start_date_active
750: , a.date_to end_date_active
751: FROM per_addresses a
752: , jtf_rs_resource_extns r
753: , fnd_territories_vl t
754: WHERE r.resource_id = b_resource_id
755: AND a.person_id = r.source_id
756: AND a.country = t.territory_code