APPS.OKL_AM_QUOTES_WF dependencies on OKC_LINE_STYLES_V

Line 1554: OKC_LINE_STYLES_V OLSV

1550: -- Get the total number of service lines
1551: CURSOR get_service_lines_csr ( p_khr_id IN NUMBER) IS
1552: SELECT COUNT(OKLV.id)
1553: FROM OKC_K_LINES_V OKLV,
1554: OKC_LINE_STYLES_V OLSV
1555: WHERE OKLV.chr_id = p_khr_id
1556: AND OKLV.lse_id = OLSV.id
1557: AND OLSV.lty_code = 'SOLD_SERVICE'
1558: AND OKLV.end_date > SYSDATE;

Line 2791: OKC_LINE_STYLES_V OLSV

2787: CURSOR get_asset_for_k_csr ( p_khr_id IN NUMBER,
2788: p_current_asset_id IN NUMBER) IS
2789: SELECT OKLV.id cle_id
2790: FROM OKC_K_LINES_V OKLV,
2791: OKC_LINE_STYLES_V OLSV
2792: WHERE OKLV.chr_id = p_khr_id
2793: AND OKLV.id > NVL(p_current_asset_id , 0)
2794: AND OKLV.lse_id = OLSV.id
2795: AND OLSV.lty_code = 'FREE_FORM1'

Line 4397: OKC_LINE_STYLES_V LSEV,

4393: OALV.MODEL_NUMBER MODEL_NUMBER
4394: FROM OKL_K_LINES_FULL_V CLEV,
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