APPS.OKC_OPPORTUNITY_PVT dependencies on OKX_CUST_SITE_USES_V

Line 183: FROM okx_cust_site_uses_v

179: --
180:
181: cursor c6 (b_id1 NUMBER, p_use_code VARCHAR2) IS
182: SELECT party_site_id
183: FROM okx_cust_site_uses_v
184: WHERE id1 = b_id1
185: AND site_use_code = p_use_code -- ship..to_party_site_id
186: AND status = 'A' -- Active Status
187: AND nvl(ORG_ID,-99) = SYS_CONTEXT('OKC_CONTEXT', 'ORG_ID');