DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER dependencies on HZ_CUST_ACCOUNTS

Line 2355: hz_cust_accounts cust,

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

Line 2846: hz_cust_accounts acct

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

Line 3399: hz_cust_accounts cust,

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