APPS.OKL_AM_QUOTES_WF dependencies on OKL_AM_ASSET_LINES_UV

Line 190: FROM OKL_AM_ASSET_LINES_UV kle

186:
187: -- get the assets in the quote
188: CURSOR get_assets_in_qte_csr ( p_qte_id IN NUMBER) IS
189: SELECT kle.id kle_id
190: FROM OKL_AM_ASSET_LINES_UV kle
191: WHERE kle.qte_id = p_qte_id;
192:
193: -- Get the number of assets for the contract
194: -- nikshah -- Bug # 5484903 Fixed,

Line 210: FROM OKL_AM_ASSET_LINES_UV kle

206:
207: -- get the number of assets in the quote
208: CURSOR get_q_assets_no_csr ( p_qte_id IN NUMBER) IS
209: SELECT COUNT(KLE.id) QUOTE_ASSETS
210: FROM OKL_AM_ASSET_LINES_UV kle
211: WHERE kle.qte_id = p_qte_id;
212:
213: l_trx_id VARCHAR2(2000);
214: l_assets_match VARCHAR2(1);

Line 4399: OKL_AM_ASSET_LINES_UV AL

4395: OKX_ASSET_LINES_V OALV,
4396: OKC_K_HEADERS_V OKHV,
4397: OKC_LINE_STYLES_V LSEV,
4398: FA_CATEGORIES_VL FAC ,
4399: OKL_AM_ASSET_LINES_UV AL
4400: WHERE CLEV.ID = OALV.PARENT_LINE_ID
4401: AND CLEV.CHR_ID = OKHV.ID
4402: AND CLEV.LSE_ID = LSEV.ID
4403: AND LSEV.LTY_CODE = 'FREE_FORM1'