APPS.OE_OE_FORM_LINE dependencies on HZ_CUST_SITE_USES_ALL

Line 4254: from hz_cust_site_uses_all

4250: BEGIN
4251: select location,cust_acct_site_id
4252: into x_line_val_rec.intmed_ship_to,
4253: l_address_id
4254: from hz_cust_site_uses_all
4255: where site_use_id=p_line_rec.intermed_ship_to_org_id;
4256: x_line_val_rec.intmed_ship_to_location := x_line_val_rec.intmed_ship_to;
4257: /*1621182*/
4258: select loc.address1,loc.address2,loc.address3,loc.address4,

Line 4332: hz_cust_site_uses_all cust_site,

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

Line 6041: FROM HZ_CUST_SITE_USES_ALL site,

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

Line 6072: FROM HZ_CUST_SITE_USES_ALL site,

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

Line 6276: hz_cust_site_uses_all site,

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