DBA Data[Home] [Help]

APPS.JTF_TTY_CATCHALL_WORKFLOW dependencies on HZ_LOCATIONS

Line 49: , HZ_LOCATIONS LOC

45: , LOC.state state
46: , LOC.postal_code postal_code
47: , PARTY.party_id party_id
48: from HZ_PARTY_SITES SITE
49: , HZ_LOCATIONS LOC
50: , HZ_PARTIES PARTY
51: , as_accesses_all AAA
52: , as_territory_accesses ATA
53: , AS_SALES_LEADS SL

Line 72: , HZ_LOCATIONS LOC

68: , LOC.state state
69: , LOC.postal_code postal_code
70: , PARTY.party_id party_id
71: from HZ_PARTY_SITES SITE
72: , HZ_LOCATIONS LOC
73: , HZ_PARTIES PARTY
74: , AS_LEADS_ALL LEAD
75: , as_accesses_all AAA
76: , as_territory_accesses ATA

Line 95: , HZ_LOCATIONS LOC

91: , LOC.state state
92: , LOC.postal_code postal_code
93: , PARTY.party_id party_id
94: from HZ_PARTY_SITES SITE
95: , HZ_LOCATIONS LOC
96: , HZ_PARTIES PARTY
97: , as_accesses_all AAA
98: , as_territory_accesses ATA
99: where SITE.party_id = PARTY.party_id