DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER dependencies on HZ_CUST_ACCOUNTS

Line 2356: hz_cust_accounts cust,

2352: x_header_val_rec.deliver_to_address5
2353:
2354: FROM HZ_CUST_SITE_USES_ALL site,
2355: HZ_CUST_ACCT_SITES_ALL cas,
2356: hz_cust_accounts cust,
2357: hz_parties party,
2358: hz_party_sites ps,
2359: hz_locations addr
2360: WHERE site.cust_acct_site_id = cas.cust_acct_site_id

Line 2847: hz_cust_accounts acct

2843:
2844: SELECT nvl(gsa_indicator_flag,'N')
2845: INTO x_gsa_indicator
2846: FROM hz_parties party,
2847: hz_cust_accounts acct
2848: WHERE acct.cust_account_id=p_sold_to_org_id
2849: AND party.party_id = acct.party_id;
2850:
2851: EXCEPTION

Line 3402: hz_cust_accounts cust,

3398: x_customer_number
3399: from
3400: hz_cust_site_uses_all site,
3401: hz_cust_acct_sites_all cas,
3402: hz_cust_accounts cust,
3403: hz_parties party
3404: where site.site_use_code = p_site_use_code
3405: and site_use_id = p_site_use_id
3406: and site.cust_acct_site_id = cas.cust_acct_site_id