APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 4572: FROM HZ_CUST_SITE_USES_ALL u, --moac

4568: SELECT /* MOAC_SQL_CHANGE */ u.cust_acct_site_id,
4569: s.cust_account_id
4570: INTO l_address_id
4571: ,l_cust_id
4572: FROM HZ_CUST_SITE_USES_ALL u, --moac
4573: HZ_CUST_ACCT_SITES s
4574: WHERE u.cust_acct_site_id = s.cust_acct_site_id
4575: AND u.org_id = s.org_id
4576: AND u.site_use_id = p_x_line_tbl(I).ship_to_org_id