APPS.OE_OE_FORM_LINE dependencies on HZ_CUST_ACCT_SITES

Line 4270: hz_cust_acct_sites cas

4266: x_line_val_rec.intmed_ship_to_address4,
4267: x_line_val_rec.intmed_ship_to_address5
4268: from hz_locations loc,
4269: hz_party_sites ps,
4270: hz_cust_acct_sites cas
4271: where cas.cust_acct_site_id = l_address_id
4272: and cas.party_site_id = ps.party_site_id
4273: and ps.location_id = loc.location_id;
4274:

Line 4333: hz_cust_acct_sites_all cust_acct_site,

4329: x_line_val_rec.deliver_to_address4,
4330: x_line_val_rec.deliver_to_address5
4331: FROM
4332: hz_cust_site_uses_all cust_site,
4333: hz_cust_acct_sites_all cust_acct_site,
4334: hz_party_sites party_site,
4335: hz_parties party,
4336: hz_cust_accounts cust_acct,
4337: hz_locations location

Line 6042: HZ_CUST_ACCT_SITES_ALL cas

6038:
6039: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
6040: INTO x_ship_to_customer_id
6041: FROM HZ_CUST_SITE_USES_ALL site,
6042: HZ_CUST_ACCT_SITES_ALL cas
6043: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
6044: AND site.site_use_code=l_site_use_code
6045: AND site.site_use_id=p_ship_to_org_id;
6046:

Line 6073: HZ_CUST_ACCT_SITES_ALL cas

6069:
6070: SELECT /* MOAC_SQL_CHANGE */ cas.cust_account_id
6071: INTO x_invoice_to_customer_id
6072: FROM HZ_CUST_SITE_USES_ALL site,
6073: HZ_CUST_ACCT_SITES_ALL cas
6074: WHERE site.cust_acct_site_id = cas.cust_acct_site_id
6075: AND site.site_use_code=l_site_use_code
6076: AND site.site_use_id=p_invoice_to_org_id;
6077:

Line 6277: hz_cust_acct_sites_all cas,

6273: x_customer_name,
6274: x_customer_number
6275: from
6276: hz_cust_site_uses_all site,
6277: hz_cust_acct_sites_all cas,
6278: hz_cust_accounts cust,
6279: hz_parties party
6280: where site.site_use_code = p_site_use_code
6281: and site_use_id = p_site_use_id