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.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on HZ_PARTIES

Line 99: ,hz_parties HZP

95:
96: cursor c_NA_for_DUNS is
97: select distinct named_account_id
98: from jtf_tty_named_accts NA
99: ,hz_parties HZP
100: where HZP.party_id = NA.party_id
101: and HZP.duns_number_c = p_DUNS;
102:
103: J NUMBER;

Line 358: ,hz_parties HZP

354: , l_TG20
355: , l_PARENT20
356: from
357: jtf_tty_named_Accts NA
358: ,hz_parties HZP
359: ,fnd_lookups LKP
360: where NA.named_account_id = NA_rec.named_Account_id
361: and NA.party_id = HZP.party_id
362: and NA.site_type_code = LKP.lookup_code

Line 650: ,hz_parties HZP

646: , l_TG20
647: , l_PARENT20
648: from
649: jtf_tty_named_Accts NA
650: ,hz_parties HZP
651: ,fnd_lookups LKP
652: where NA.named_account_id = p_named_account_id
653: and NA.party_id = HZP.party_id
654: and NA.site_type_code = LKP.lookup_code

Line 904: ,hz_parties HZP

900: , l_PARENT20
901:
902: from
903: jtf_tty_named_Accts NA
904: ,hz_parties HZP
905: ,fnd_lookups LKP
906: where NA.named_account_id = DUNS_NA_rec.named_account_id
907: and NA.party_id = HZP.party_id
908: and NA.site_type_code = LKP.lookup_code