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 3144: FROM okl_k_lines_full_v cle, okc_line_styles_v lse

3140: --2. Check the disb amt not exceed line payment amt --
3141: -- Find out lines for a contract
3142: CURSOR lines_csr(p_chr_id IN NUMBER) IS
3143: SELECT cle.id,cle.name,lse.lty_code
3144: FROM okl_k_lines_full_v cle, okc_line_styles_v lse
3145: WHERE cle.dnz_chr_id = p_chr_id
3146: AND cle.lse_id = lse.id
3147: AND lse.lty_code IN ('FREE_FORM1','FEE','SOLD_SERVICE');
3148:

Line 3269: FROM okl_k_lines_full_v line,

3265: pph.id payment_hdr_id,
3266: pph.passthru_start_date,
3267: pph.passthru_term,
3268: pph.passthru_stream_type_id
3269: FROM okl_k_lines_full_v line,
3270: okc_line_styles_v style,
3271: okc_statuses_v sts,
3272: okl_party_payment_hdr pph
3273: WHERE line.lse_id = style.id

Line 3307: FROM okl_k_lines_full_v line,

3303: nvl(line.name,line.item_description) name,
3304: line.fee_type,
3305: rule.object1_id1,
3306: style.name line_style
3307: FROM okl_k_lines_full_v line,
3308: okc_line_styles_v style,
3309: okc_statuses_v sts,
3310: okc_rule_groups_b rgp,
3311: okc_rules_b rule

Line 5400: FROM okl_k_lines_full_v l,

5396: l.name,
5397: l.amount,
5398: l.capital_amount,
5399: l.fee_type
5400: FROM okl_k_lines_full_v l,
5401: okc_line_styles_v sty,
5402: okc_statuses_v sts
5403: WHERE l.lse_id = sty.id
5404: AND l.sts_code = sts.code

Line 6636: FROM OKL_K_LINES_FULL_V kle,

6632: SELECT ls.lty_code,
6633: ls.name line_type,
6634: kle.id,
6635: kle.name
6636: FROM OKL_K_LINES_FULL_V kle,
6637: OKC_LINE_STYLES_V ls,
6638: OKC_STATUSES_B sts
6639: WHERE kle.lse_id = ls.id
6640: AND ls.lty_code IN ('FREE_FORM1', 'FEE', 'SOLD_SERVICE')

Line 7006: FROM okl_k_lines_full_v kle

7002: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
7003:
7004: CURSOR get_line_amt (p_id IN NUMBER) IS
7005: SELECT nvl(capital_amount,0) capital_amount, kle.name name
7006: FROM okl_k_lines_full_v kle
7007: WHERE kle.id = p_id;
7008:
7009: CURSOR get_payment_line_amt (p_rgp_id IN NUMBER, p_chr_id IN NUMBER) IS
7010: select nvl(sum(tot_amt),0)

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

7035:
7036: l_cle_id NUMBER;
7037: l_chr_id NUMBER;
7038: l_capital_amount okl_k_lines.capital_amount%type;
7039: l_ast_name okl_k_lines_full_v.name%type := null;
7040: l_payment_amount okl_k_lines.capital_amount%type;
7041: l_deal_type_yn varchar2(1) := 'N';
7042: BEGIN
7043: -- initialize return status

Line 7708: FROM okl_k_lines_full_v line,

7704: p_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
7705: SELECT line.id,
7706: line.line_number,
7707: line.amount
7708: FROM okl_k_lines_full_v line,
7709: okc_line_styles_v style,
7710: okc_statuses_b sts
7711: WHERE line.lse_id = style.id
7712: AND style.lty_code = p_lty_code

Line 7719: FROM okl_k_lines_full_v line

7715: AND line.dnz_chr_id = p_chr_id;
7716:
7717: CURSOR sub_line_amt_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
7718: SELECT SUM(NVL(capital_amount,0))
7719: FROM okl_k_lines_full_v line
7720: WHERE line.cle_id = p_line_id;
7721:
7722: CURSOR txd_csr1 (Kleid NUMBER) IS
7723: SELECT

Line 7824: FROM OKL_K_LINES_FULL_V kle,

7820: CURSOR l_kle_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
7821: SELECT NVL(kle.name,kle.item_description) name,
7822: kle.id,
7823: ls.name line_style
7824: FROM OKL_K_LINES_FULL_V kle,
7825: OKC_LINE_STYLES_v ls,
7826: OKC_STATUSES_B sts
7827: WHERE kle.lse_id = ls.id
7828: AND ls.lty_code = ltycode

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

7839: l_oec number;
7840:
7841: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
7842: -- cursor to fecth link line id for top line id
7843: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
7844: SELECT kle.id
7845: FROM OKL_K_LINES_FULL_V kle,
7846: OKC_LINE_STYLES_v ls,
7847: OKC_STATUSES_B sts

Line 7845: FROM OKL_K_LINES_FULL_V kle,

7841: -- Bug 5216135 : kbbhavsa : 29-May-06 : start
7842: -- cursor to fecth link line id for top line id
7843: CURSOR l_kle_link_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE, cleid OKL_K_LINES_FULL_V.CLE_ID%TYPE) IS
7844: SELECT kle.id
7845: FROM OKL_K_LINES_FULL_V kle,
7846: OKC_LINE_STYLES_v ls,
7847: OKC_STATUSES_B sts
7848: WHERE kle.lse_id = ls.id
7849: AND ls.lty_code = ltycode

Line 7855: l_link_cle_id OKL_K_LINES_FULL_V.ID%TYPE;

7851: AND sts.code = kle.sts_code
7852: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
7853: and kle.cle_id = cleid;
7854:
7855: l_link_cle_id OKL_K_LINES_FULL_V.ID%TYPE;
7856: -- Bug 5216135 : kbbhavsa : 29-May-06 : End
7857:
7858: CURSOR system_corp_book_csr(p_chr_id NUMBER) IS
7859: SELECT A.ASST_ADD_BOOK_TYPE_CODE,

Line 9166: OKL_K_LINES_FULL_V kle,

9162:
9163: CURSOR l_inst_csr( chrId NUMBER ) IS
9164: SELECT inst.object_id1_new
9165: FROM OKL_TXL_ITM_INSTS inst,
9166: OKL_K_LINES_FULL_V kle,
9167: OKC_LINE_STYLES_B lse
9168: WHERE inst.kle_id = kle.id
9169: AND lse.id = kle.lse_id
9170: AND lse.lty_code = 'INST_ITEM'

Line 9178: OKL_K_LINES_FULL_V kle,

9174:
9175: CURSOR l_shipto_csr( chrId NUMBER ) IS
9176: SELECT inv.shipping_address_id1
9177: FROM OKL_SUPP_INVOICE_DTLS inv,
9178: OKL_K_LINES_FULL_V kle,
9179: OKC_LINE_STYLES_B lse
9180: WHERE inv.cle_id = kle.id
9181: AND lse.id = kle.lse_id
9182: AND lse.lty_code = 'ITEM'

Line 10608: FROM okl_k_lines_full_v line,

10604: SELECT line.id,
10605: NVL(line.capital_amount,0) capital_amount,
10606: line.start_date,
10607: strm.code strm_type
10608: FROM okl_k_lines_full_v line,
10609: okc_k_items item,
10610: okl_strmtyp_source_v strm,
10611: okc_line_styles_v style,
10612: okc_statuses_b sts

Line 10629: FROM okl_k_lines_full_v line,

10625:
10626: CURSOR fee_subline_csr (p_cle_id OKC_K_LINES_V.ID%TYPE) IS
10627: SELECT id,
10628: NVL(capital_amount,0) capital_amount
10629: FROM okl_k_lines_full_v line,
10630: okc_statuses_b sts
10631: WHERE line.cle_id = p_cle_id
10632: AND line.sts_code = sts.code
10633: --Bug# 4959361: Include Terminated lines when fetching sub-line amount

Line 10859: FROM OKL_K_LINES_FULL_V kle,

10855: kle.residual_code,
10856: kle.residual_grnty_amount,
10857: kle.start_date,
10858: kle.end_date
10859: FROM OKL_K_LINES_FULL_V kle,
10860: OKC_LINE_STYLES_B ls,
10861: OKC_STATUSES_B sts
10862: WHERE kle.lse_id = ls.id
10863: AND ls.lty_code = ltycode

Line 11018: FROM okl_k_lines_full_v line,

11014:
11015: CURSOR asset_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
11016: SELECT line.id,
11017: line.name
11018: FROM okl_k_lines_full_v line,
11019: okc_line_styles_v style,
11020: okc_statuses_b sts
11021: WHERE line. dnz_chr_id = p_chr_id
11022: AND line.lse_id = style.id