APPS.OKL_AM_QUOTES_WF dependencies on OKC_LINE_STYLES_B

Line 179: OKC_LINE_STYLES_B LSEB,

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'
183: AND KLE.LSE_ID = LSEB.ID

Line 199: OKC_LINE_STYLES_B LSEB,

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'
203: AND KLE.LSE_ID = LSEB.ID

Line 823: okc_line_styles_b lsev,

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,
824: okl_trx_quotes_all_b trq
825: WHERE cleb.id = oalv.parent_line_id(+)
826: AND cleb.chr_id = okhv.id
827: AND cleb.lse_id = lsev.id

Line 850: okc_line_styles_b lsev

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
852: AND tql.kle_id = cleb.id
853: AND otqv.id = tql.qte_id
854: AND tql.qlt_code = 'AMCFIA'

Line 1792: OKC_LINE_STYLES_B OLSB,

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)
1796: AND OKPB.dnz_chr_id = OKLB.dnz_chr_id