DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on HZ_PARTY_SITES

Line 632: ,hz_party_sites p

628: AND exists
629: (select /*+ FIRST_ROWS(1) leading (su) */ 1
630: from hz_cust_site_uses su
631: ,hz_cust_acct_sites ad
632: ,hz_party_sites p
633: ,hz_locations lc
634: ,hz_geographies lv
635: ,ar_system_parameters sp
636: WHERE su.site_use_id = cp_site_use_id

Line 662: ,hz_party_sites p

658: AND exists (select 1
659: from hz_geographies lv
660: ,hz_cust_acct_sites ad
661: ,hz_cust_site_uses su
662: ,hz_party_sites p
663: ,hz_locations loc
664: ,ar_system_parameters sp
665: ,hr_locations_all hrl
666: WHERE hrl.location_id = p_warehouse_location_id

Line 693: ,hz_party_sites p

689: AND exists (select 1
690: from hz_geographies lv
691: ,hz_cust_acct_sites ad
692: ,hz_cust_site_uses su
693: ,hz_party_sites p
694: ,hz_locations loc
695: ,ar_system_parameters sp
696: ,hr_locations_all hrl
697: WHERE hrl.location_id = p_warehouse_location_id