APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 4575: FROM HZ_CUST_SITE_USES_ALL u, --moac

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