eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_K_LINES_FULL_V

Line 3301: FROM okl_k_lines_full_v cle, okc_line_styles_v lse

3297: --2. Check the disb amt not exceed line payment amt --
3298: -- Find out lines for a contract
3299: CURSOR lines_csr(p_chr_id IN NUMBER) IS
3300: SELECT cle.id,cle.name,lse.lty_code
3301: FROM okl_k_lines_full_v cle, okc_line_styles_v lse
3302: WHERE cle.dnz_chr_id = p_chr_id
3303: AND cle.lse_id = lse.id
3304: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
3305:

Line 3454: FROM okl_k_lines_full_v line,

3450: pph.id payment_hdr_id,
3451: pph.passthru_start_date,
3452: pph.passthru_term,
3453: pph.passthru_stream_type_id
3454: FROM okl_k_lines_full_v line,
3455: okc_line_styles_v style,
3456: okc_statuses_v sts,
3457: okl_party_payment_hdr pph
3458: WHERE line.lse_id = style.id

Line 3492: FROM okl_k_lines_full_v line,

3488: nvl(line.name,line.item_description) name,
3489: line.fee_type,
3490: rule.object1_id1,
3491: style.name line_style
3492: FROM okl_k_lines_full_v line,
3493: okc_line_styles_v style,
3494: okc_statuses_v sts,
3495: okc_rule_groups_b rgp,
3496: okc_rules_b rule

Line 5787: FROM okl_k_lines_full_v l,

5783: l.name,
5784: l.amount,
5785: l.capital_amount,
5786: l.fee_type
5787: FROM okl_k_lines_full_v l,
5788: okc_line_styles_v sty,
5789: okc_statuses_v sts
5790: WHERE l.lse_id = sty.id
5791: AND l.sts_code = sts.code

Line 7023: FROM OKL_K_LINES_FULL_V kle,

7019: SELECT ls.lty_code,
7020: ls.name line_type,
7021: kle.id,
7022: kle.name
7023: FROM OKL_K_LINES_FULL_V kle,
7024: OKC_LINE_STYLES_V ls,
7025: OKC_STATUSES_B sts
7026: WHERE kle.lse_id = ls.id
7027: AND ls.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE')

Line 7393: FROM okl_k_lines_full_v kle

7389: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
7390:
7391: CURSOR get_line_amt (p_id IN NUMBER) IS
7392: SELECT nvl(capital_amount,0) capital_amount, kle.name name
7393: FROM okl_k_lines_full_v kle
7394: WHERE kle.id = p_id;
7395:
7396: CURSOR get_payment_line_amt (p_rgp_id IN NUMBER, p_chr_id IN NUMBER) IS
7397: select nvl(sum(tot_amt),0)

Line 7426: l_ast_name okl_k_lines_full_v.name%type := null;

7422:
7423: l_cle_id NUMBER;
7424: l_chr_id NUMBER;
7425: l_capital_amount okl_k_lines.capital_amount%type;
7426: l_ast_name okl_k_lines_full_v.name%type := null;
7427: l_payment_amount okl_k_lines.capital_amount%type;
7428: l_deal_type_yn varchar2(1) := 'N';
7429: BEGIN
7430: -- initialize return status

Line 8125: FROM okl_k_lines_full_v line,

8121: p_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
8122: SELECT line.id,
8123: line.line_number,
8124: line.amount
8125: FROM okl_k_lines_full_v line,
8126: okc_line_styles_v style,
8127: okc_statuses_b sts
8128: WHERE line.lse_id = style.id
8129: AND style.lty_code = p_lty_code

Line 8136: FROM okl_k_lines_full_v line

8132: AND line.dnz_chr_id = p_chr_id;
8133:
8134: CURSOR sub_line_amt_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
8135: SELECT SUM(NVL(capital_amount,0))
8136: FROM okl_k_lines_full_v line
8137: WHERE line.cle_id = p_line_id;
8138:
8139: CURSOR txd_csr1 (Kleid NUMBER) IS
8140: SELECT

Line 8241: FROM OKL_K_LINES_FULL_V kle,

8237: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
8238: SELECT NVL(kle.name,kle.item_description) name,
8239: kle.id,
8240: ls.name line_style
8241: FROM OKL_K_LINES_FULL_V kle,
8242: OKC_LINE_STYLES_v ls,
8243: OKC_STATUSES_B sts
8244: WHERE kle.lse_id = ls.id
8245: AND ls.lty_code = ltycode

Line 8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS

8256: l_oec number;
8257:
8258: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
8259: -- cursor to fecth link line id for top line id
8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
8261: SELECT kle.id
8262: FROM OKL_K_LINES_FULL_V kle,
8263: OKC_LINE_STYLES_v ls,
8264: OKC_STATUSES_B sts

Line 8262: FROM OKL_K_LINES_FULL_V kle,

8258: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
8259: -- cursor to fecth link line id for top line id
8260: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
8261: SELECT kle.id
8262: FROM OKL_K_LINES_FULL_V kle,
8263: OKC_LINE_STYLES_v ls,
8264: OKC_STATUSES_B sts
8265: WHERE kle.lse_id = ls.id
8266: AND ls.lty_code = ltycode

Line 8272: l_link_cle_id OKL_K_LINES_FULL_V.ID%TYPE;

8268: AND sts.code = kle.sts_code
8269: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
8270: and kle.cle_id = cleid;
8271:
8272: l_link_cle_id OKL_K_LINES_FULL_V.ID%TYPE;
8273: -- Bug 5216135 : kbbhavsa : 29-May-06 : End
8274:
8275: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
8276: SELECT A.ASST_ADD_BOOK_TYPE_CODE,

Line 9587: OKL_K_LINES_FULL_V kle,

9583:
9584: CURSOR l_inst_csr( chrId NUMBER ) IS
9585: SELECT inst.object_id1_new
9586: FROM OKL_TXL_ITM_INSTS inst,
9587: OKL_K_LINES_FULL_V kle,
9588: OKC_LINE_STYLES_B lse
9589: WHERE inst.kle_id = kle.id
9590: AND lse.id = kle.lse_id
9591: AND lse.lty_code = 'INST_ITEM'

Line 9599: OKL_K_LINES_FULL_V kle,

9595:
9596: CURSOR l_shipto_csr( chrId NUMBER ) IS
9597: SELECT inv.shipping_address_id1
9598: FROM OKL_SUPP_INVOICE_DTLS inv,
9599: OKL_K_LINES_FULL_V kle,
9600: OKC_LINE_STYLES_B lse
9601: WHERE inv.cle_id = kle.id
9602: AND lse.id = kle.lse_id
9603: AND lse.lty_code = 'ITEM'

Line 11031: FROM okl_k_lines_full_v line,

11027: SELECT line.id,
11028: NVL(line.capital_amount,0) capital_amount,
11029: line.start_date,
11030: strm.code strm_type
11031: FROM okl_k_lines_full_v line,
11032: okc_k_items item,
11033: okl_strmtyp_source_v strm,
11034: okc_line_styles_v style,
11035: okc_statuses_b sts

Line 11052: FROM okl_k_lines_full_v line,

11048:
11049: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
11050: SELECT id,
11051: NVL(capital_amount,0) capital_amount
11052: FROM okl_k_lines_full_v line,
11053: okc_statuses_b sts
11054: WHERE line.cle_id = p_cle_id
11055: AND line.sts_code = sts.code
11056: --Bug# 4959361: Include Terminated lines when fetching sub-line amount

Line 11282: FROM OKL_K_LINES_FULL_V kle,

11278: kle.residual_code,
11279: kle.residual_grnty_amount,
11280: kle.start_date,
11281: kle.end_date
11282: FROM OKL_K_LINES_FULL_V kle,
11283: OKC_LINE_STYLES_B ls,
11284: OKC_STATUSES_B sts
11285: WHERE kle.lse_id = ls.id
11286: AND ls.lty_code = ltycode

Line 11441: FROM okl_k_lines_full_v line,

11437:
11438: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11439: SELECT line.id,
11440: line.name
11441: FROM okl_k_lines_full_v line,
11442: okc_line_styles_v style,
11443: okc_statuses_b sts
11444: WHERE line. dnz_chr_id = p_chr_id
11445: AND line.lse_id = style.id