DBA Data[Home] [Help]

APPS.JTF_TTY_CATCHALL_WORKFLOW dependencies on HZ_PARTIES

Line 50: , HZ_PARTIES PARTY

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
54: where SITE.party_id = PARTY.party_id

Line 73: , HZ_PARTIES PARTY

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
77: where SITE.party_id = PARTY.party_id

Line 96: , HZ_PARTIES PARTY

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
100: and LOC.location_id = SITE.location_id