APPS.OKL_AM_QUOTES_WF dependencies on OKC_K_LINES_B

Line 178: FROM OKC_K_LINES_B kle,

174: -- nikshah -- Bug # 5484903 Fixed,
175: -- Changed CURSOR get_assets_in_k_csr SQL definition
176: CURSOR get_assets_in_k_csr (p_qte_id IN NUMBER) IS
177: SELECT kle.id asset_id
178: FROM OKC_K_LINES_B kle,
179: OKC_LINE_STYLES_B LSEB,
180: OKL_TRX_QUOTES_B qte
181: WHERE kle.chr_id = qte.khr_id
182: AND kle.STS_CODE <> 'ABANDONED'

Line 198: FROM OKC_K_LINES_B kle,

194: -- nikshah -- Bug # 5484903 Fixed,
195: -- Changed CURSOR get_k_assets_no_csr SQL definition
196: CURSOR get_k_assets_no_csr ( p_qte_id IN NUMBER) IS
197: SELECT COUNT(KLE.id) CONTRACT_ASSETS
198: FROM OKC_K_LINES_B kle,
199: OKC_LINE_STYLES_B LSEB,
200: OKL_TRX_QUOTES_B qte
201: WHERE kle.chr_id = qte.khr_id
202: AND kle.STS_CODE <> 'ABANDONED'

Line 819: FROM okc_k_lines_b cleb,

815: clet.item_description asset_description,
816: clet.name asset_number,
817: oalv.serial_number serial_number,
818: oalv.model_number model_number
819: FROM okc_k_lines_b cleb,
820: okc_k_lines_tl clet,
821: okx_asset_lines_v oalv,
822: okc_k_headers_all_b okhv,
823: okc_line_styles_b lsev,

Line 847: okc_k_lines_b cleb,

843: oalv.serial_number serial_number,
844: oalv.model_number model_number
845: FROM okl_trx_quotes_b otqv,
846: okl_txl_qte_lines_all_b tql,
847: okc_k_lines_b cleb,
848: okc_k_lines_tl clet,
849: okx_asset_lines_v oalv,
850: okc_line_styles_b lsev
851: WHERE otqv.id = p_qte_id

Line 1791: OKC_K_LINES_B OKLB,

1787: p_current_rec_id IN NUMBER) IS
1788: SELECT OKLB.id line_id,
1789: OKPB.object1_id1 party_id
1790: FROM OKC_K_PARTY_ROLES_B OKPB,
1791: OKC_K_LINES_B OKLB,
1792: OKC_LINE_STYLES_B OLSB,
1793: FND_LOOKUPS FNDV
1794: WHERE OKLB.chr_id = p_khr_id
1795: AND OKLB.id > NVL(p_current_rec_id,0)