DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 4375: hz_cust_acct_sites_all site

4371: p_bill_to_address_id NUMBER,
4372: p_customer_account_id NUMBER) IS
4373: SELECT site_use.id1
4374: FROM okx_cust_site_uses_v site_use,
4375: hz_cust_acct_sites_all site
4376: WHERE site.cust_acct_site_id = site_use.cust_acct_site_id
4377: AND ((site_use.name = p_bill_to_address
4378: AND
4379: p_bill_to_address IS NOT NULL)

Line 18400: hz_cust_acct_sites_all site

18396: p_cust_acct_id NUMBER,
18397: p_org_id NUMBER) IS
18398: SELECT site_use.id1
18399: FROM okx_cust_site_uses_v site_use,
18400: hz_cust_acct_sites_all site
18401: WHERE site.cust_acct_site_id = site_use.cust_acct_site_id
18402: AND site_use.party_site_id = p_party_site_id
18403: AND site_use.org_id = p_org_id
18404: AND site.org_id = p_org_id