DBA Data[Home] [Help]

APPS.ARP_ETAX_SERVICES_PKG dependencies on HZ_LOCATIONS

Line 903: HZ_LOCATIONS BILL_LOC,

899: HZ_PARTIES BILL_PARTY,
900: HZ_CUST_ACCT_SITES BILL_AS,
901: HZ_CUST_SITE_USES BILL_SU,
902: HZ_PARTY_SITES BILL_PS,
903: HZ_LOCATIONS BILL_LOC,
904: RA_CUSTOMER_TRX INV,
905: RA_CUST_TRX_TYPES INV_TT,
906: HR_ALL_ORGANIZATION_UNITS HR,
907: HR_ORGANIZATION_UNITS HRL,

Line 1140: hz_locations LOC

1136: hz_parties PARTY,
1137: hz_cust_acct_sites ACCT_SITE,
1138: hz_cust_site_uses SITE_USES,
1139: hz_party_sites PARTY_SITE,
1140: hz_locations LOC
1141: WHERE
1142: CUST_ACCT.cust_account_id = l_cust_id AND
1143: CUST_ACCT.party_id = PARTY.party_id AND
1144: CUST_ACCT.cust_account_id = ACCT_SITE.cust_account_id AND

Line 2279: HZ_LOCATIONS BILL_LOC

2275: HZ_PARTIES BILL_PARTY,
2276: HZ_CUST_ACCT_SITES BILL_AS,
2277: HZ_CUST_SITE_USES BILL_SU,
2278: HZ_PARTY_SITES BILL_PS,
2279: HZ_LOCATIONS BILL_LOC
2280: WHERE
2281: TRX.customer_trx_id = p_customer_trx_id and
2282: TRX.invoice_currency_code = CURR.currency_code and
2283: TRX.org_id = AR.org_id and

Line 2347: hz_locations LOC

2343: hz_parties PARTY,
2344: hz_cust_acct_sites ACCT_SITE,
2345: hz_cust_site_uses SITE_USES,
2346: hz_party_sites PARTY_SITE,
2347: hz_locations LOC
2348: WHERE
2349: CUST_ACCT.cust_account_id = l_hdr_ship_to_cust_id AND
2350: CUST_ACCT.party_id = PARTY.party_id AND
2351: CUST_ACCT.cust_account_id = ACCT_SITE.cust_account_id AND