APPS.OE_OE_FORM_LINE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 4611: hz_cust_acct_sites_all cust_acct_site,

4607: x_line_val_rec.deliver_to_address4,
4608: x_line_val_rec.deliver_to_address5
4609: FROM
4610: hz_cust_site_uses_all cust_site,
4611: hz_cust_acct_sites_all cust_acct_site,
4612: hz_party_sites party_site,
4613: hz_parties party,
4614: hz_cust_accounts cust_acct,
4615: hz_locations location

Line 6409: HZ_CUST_ACCT_SITES_ALL cas

6405:
6406: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
6407: INTO x_ship_to_customer_id
6408: FROM HZ_CUST_SITE_USES_ALL site,
6409: HZ_CUST_ACCT_SITES_ALL cas
6410: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
6411: AND site.site_use_code=l_site_use_code
6412: AND site.site_use_id=p_ship_to_org_id;
6413:

Line 6440: HZ_CUST_ACCT_SITES_ALL cas

6436:
6437: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
6438: INTO x_invoice_to_customer_id
6439: FROM HZ_CUST_SITE_USES_ALL site,
6440: HZ_CUST_ACCT_SITES_ALL cas
6441: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
6442: AND site.site_use_code=l_site_use_code
6443: AND site.site_use_id=p_invoice_to_org_id;
6444:

Line 6669: hz_cust_acct_sites_all cas,

6665: x_customer_name,
6666: x_customer_number
6667: from
6668: hz_cust_site_uses_all site,
6669: hz_cust_acct_sites_all cas,
6670: hz_cust_accounts cust,
6671: hz_parties party
6672: where site.site_use_code = p_site_use_code
6673: and site_use_id = p_site_use_id