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 751: FROM OKL_K_LINES_FULL_V b

747: BEGIN
748: FORALL indx IN l_asset_num.FIRST..l_asset_num.LAST SAVE EXCEPTIONS
749: UPDATE okl_ext_billing_interface a
750: SET asset_id = (SELECT id
751: FROM OKL_K_LINES_FULL_V b
752: -- NVL is for imported contracts where
753: -- Service Name is NULL in OKC_K_LINES_TL
754: WHERE NVL(b.name, a.ASSET_NUMBER) = a.ASSET_NUMBER
755: AND b.ID = NVL(A.ASSET_ID, b.ID)

Line 951: FROM OKL_K_LINES_FULL_V LNS

947: ERROR_MESSAGE = ERROR_MESSAGE||'Invalid Line name or Line Id.'
948: WHERE rowid = l_rowid_tbl(indx)
949: AND (a.ASSET_NUMBER IS NOT NULL OR a.ASSET_ID IS NOT NULL)
950: AND NOT EXISTS ( SELECT 1
951: FROM OKL_K_LINES_FULL_V LNS
952: WHERE LNS.ID = a.ASSET_ID
953: -- IS NULL condition is useful for imported contracts
954: -- where Service Name is NULL in OKC_K_LINES_TL
955: AND ( LNS.NAME IS NULL OR LNS.NAME = NVL(a.ASSET_NUMBER, LNS.NAME))