DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on HZ_CUST_SITE_USES

Line 1335: FROM hz_cust_site_uses

1331:
1332: -- Cursor to select site use code
1333: CURSOR site_name_csr IS
1334: SELECT location
1335: FROM hz_cust_site_uses
1336: WHERE site_use_id = p_site_use_id;
1337: -- Cursor to select item category
1338: CURSOR item_category_csr IS
1339: SELECT description

Line 3966: , HZ_cust_site_uses su

3962: , ca.party_id --------------new (FPI)
3963: INTO l_own_customer_id
3964: , l_party_id --------------new (FPI)
3965: FROM HZ_cust_acct_sites_all cas
3966: , HZ_cust_site_uses su
3967: , hz_cust_accounts_all ca --------------new (FPI)
3968: WHERE su.site_use_id = c_site.site_use_id
3969: AND cas.cust_acct_site_id = su.cust_acct_site_id
3970: AND cas.cust_account_id=ca.cust_account_id; ---------new (FPI)