APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKL_K_LINES_FULL_V

Line 179: FROM okl_k_lines_full_v

175: WHERE name = p_sty_name;
176:
177: CURSOR get_kle_id_csr ( p_asset_number VARCHAR2 ) IS
178: SELECT ID
179: FROM okl_k_lines_full_v
180: WHERE name = p_asset_number;
181:
182: CURSOR curr_code_csr ( p_currency_code VARCHAR2) IS
183: SELECT currency_code

Line 737: FROM OKL_K_LINES_FULL_V b

733: BEGIN
734: FORALL indx IN l_asset_num.FIRST..l_asset_num.LAST SAVE EXCEPTIONS
735: UPDATE okl_ext_billing_interface a
736: SET asset_id = (SELECT id
737: FROM OKL_K_LINES_FULL_V b
738: -- NVL is for imported contracts where
739: -- Service Name is NULL in OKC_K_LINES_TL
740: WHERE NVL(b.name, a.ASSET_NUMBER) = a.ASSET_NUMBER
741: AND b.ID = NVL(A.ASSET_ID, b.ID)

Line 879: FROM OKL_K_LINES_FULL_V LNS

875: ERROR_MESSAGE = ERROR_MESSAGE||'Invalid Line name or Line Id.'
876: WHERE rowid = l_rowid_tbl(indx)
877: AND (a.ASSET_NUMBER IS NOT NULL OR a.ASSET_ID IS NOT NULL)
878: AND NOT EXISTS ( SELECT 1
879: FROM OKL_K_LINES_FULL_V LNS
880: WHERE LNS.ID = a.ASSET_ID
881: -- IS NULL condition is useful for imported contracts
882: -- where Service Name is NULL in OKC_K_LINES_TL
883: AND ( LNS.NAME IS NULL OR LNS.NAME = NVL(a.ASSET_NUMBER, LNS.NAME))