APPS.OE_OE_FORM_LINE dependencies on HZ_CUST_SITE_USES_ALL

Line 4532: from hz_cust_site_uses_all

4528: BEGIN
4529: select location,cust_acct_site_id
4530: into x_line_val_rec.intmed_ship_to,
4531: l_address_id
4532: from hz_cust_site_uses_all
4533: where site_use_id=p_line_rec.intermed_ship_to_org_id;
4534: x_line_val_rec.intmed_ship_to_location := x_line_val_rec.intmed_ship_to;
4535: /*1621182*/
4536: select loc.address1,loc.address2,loc.address3,loc.address4,

Line 4610: hz_cust_site_uses_all cust_site,

4606: x_line_val_rec.deliver_to_address3,
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,

Line 6408: FROM HZ_CUST_SITE_USES_ALL site,

6404: l_site_use_code := 'SHIP_TO';
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;

Line 6439: FROM HZ_CUST_SITE_USES_ALL site,

6435: l_site_use_code := 'BILL_TO';
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;

Line 6668: hz_cust_site_uses_all site,

6664: INTO x_customer_id,
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