DBA Data[Home] [Help]

APPS.CSM_CONTRACT_EVENT_PKG dependencies on OKC_K_ITEMS

Line 65: FROM OKC_K_Items BIT

61: WHERE KSL.Cle_ID = c_contract_service_id
62: AND BPL.Cle_ID = KSL.COVERAGE_ID
63: AND BPL.Lse_Id IN (3,16,21)
64: AND EXISTS (SELECT 'x'
65: FROM OKC_K_Items BIT
66: WHERE BIT.Cle_id = BPL.Id
67: AND Object1_Id1 = c_business_process_id
68: AND Jtot_Object1_Code = 'OKX_BUSIPROC');
69:

Line 493: , Okc_K_Items IT

489: , l.currency_code
490: FROM okc_k_headers_all_b h
491: , okc_k_lines_b l
492: , Okx_System_Items_V s
493: , Okc_K_Items IT
494: , CS_INCIDENTS_ALL_B cs
495: WHERE cs.INCIDENT_ID = b_incident_id
496: AND cs.CONTRACT_SERVICE_ID = l.id
497: AND h.id = l.dnz_chr_id