DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_WF dependencies on HZ_CUST_SITE_USES_ALL

Line 954: From hz_cust_acct_sites_all a, hz_cust_site_uses_all b, hz_cust_accounts c

950: END IF;
951: l_org_id := MO_GLOBAL.Get_Current_Org_Id;
952: SELECT /* MOAC_SQL_CHANGE */ a.cust_acct_site_id, a.party_site_id, c.party_id
953: Into l_cust_acct_site_id, l_party_site_id, l_party_id
954: From hz_cust_acct_sites_all a, hz_cust_site_uses_all b, hz_cust_accounts c
955: Where a.cust_acct_site_id = b.cust_acct_site_id
956: And a.cust_account_id = l_party_id
957: And a.cust_account_id = c.cust_account_id
958: /* And NVL(a.org_id,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),