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 OKC_LINE_STYLES_V

Line 1546: OKC_LINE_STYLES_V C,

1542: oec,
1543: e.ste_code ste_code -- 5264170
1544: FROM OKL_K_LINES a,
1545: OKC_K_LINES_TL b,
1546: OKC_LINE_STYLES_V C,
1547: OKC_K_LINES_B d,
1548: OKC_STATUSES_B e
1549: WHERE a.ID = p_id
1550: AND a.ID = b.ID

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 3455: okc_line_styles_v style,

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
3459: AND line.sts_code = sts.code

Line 3493: okc_line_styles_v style,

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
3497: WHERE rgp.id = rule.rgp_id

Line 4404: okc_line_styles_v style,

4400: 'Y' stub_only
4401: FROM okc_rules_b rule,
4402: okc_rule_groups_b rgp,
4403: okc_k_lines_b line,
4404: okc_line_styles_v style,
4405: okc_statuses_b sts
4406: WHERE rgp.id = rule.rgp_id
4407: AND rgp.rgd_code = 'LALEVL'
4408: AND rgp.dnz_chr_id = p_chr_id

Line 5788: okc_line_styles_v sty,

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
5792: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 7024: OKC_LINE_STYLES_V ls,

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')
7028: AND kle.dnz_chr_id = chrid

Line 8121: p_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS

8117: AND status = 'A'
8118: AND TRUNC(SYSDATE) >= NVL(TRUNC(start_date_active), TRUNC(SYSDATE));
8119:
8120: CURSOR line_amt_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE,
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,

Line 8126: okc_line_styles_v style,

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
8130: AND sts.code = line.sts_code

Line 8242: OKC_LINE_STYLES_v ls,

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
8246: AND kle.dnz_chr_id = chrid

Line 8263: OKC_LINE_STYLES_v ls,

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
8267: AND kle.dnz_chr_id = chrid

Line 11034: okc_line_styles_v style,

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
11036: WHERE line.dnz_chr_id = p_chr_id
11037: AND line.lse_id = style.id
11038: AND line.sts_code = sts.code

Line 11442: okc_line_styles_v style,

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
11446: AND style.lty_code = 'FREE_FORM1'

Line 12231: okc_line_styles_v style

12227: CURSOR l_lne_csr (p_chr_id NUMBER) IS
12228: SELECT lne.id id,
12229: style.name line_type
12230: FROM okc_k_lines_b lne,
12231: okc_line_styles_v style
12232: WHERE dnz_chr_id = p_chr_id
12233: AND style.id = lne.lse_id;
12234:
12235: -- R12B Authoring OA Migration

Line 12244: okc_line_styles_v style

12240: SELECT cle.id,
12241: style.name line_type
12242: FROM okl_k_lines kle,
12243: okc_k_lines_b cle,
12244: okc_line_styles_v style
12245: WHERE cle.dnz_chr_id = p_chr_id
12246: AND cle.id = kle.id
12247: AND cle.lse_id = style.id
12248: AND kle.fee_type = 'FINANCED'