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_LA_ASSET_PVT dependencies on OKC_K_LINES_B

Line 51: start_date OKC_K_LINES_B.START_DATE%TYPE,

47: current_units NUMBER := OKL_API.G_MISS_NUM,
48: oec NUMBER := OKL_API.G_MISS_NUM,
49: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
50: residual_value NUMBER := OKL_API.G_MISS_NUM,
51: start_date OKC_K_LINES_B.START_DATE%TYPE,
52: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
53: end_date OKC_K_LINES_B.END_DATE%TYPE,
54: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
55: location_id VARCHAR(1995),

Line 52: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,

48: oec NUMBER := OKL_API.G_MISS_NUM,
49: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
50: residual_value NUMBER := OKL_API.G_MISS_NUM,
51: start_date OKC_K_LINES_B.START_DATE%TYPE,
52: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
53: end_date OKC_K_LINES_B.END_DATE%TYPE,
54: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
55: location_id VARCHAR(1995),
56: parent_line_id NUMBER := OKL_API.G_MISS_NUM,

Line 53: end_date OKC_K_LINES_B.END_DATE%TYPE,

49: vendor_name PO_VENDORS.VENDOR_NAME%TYPE,
50: residual_value NUMBER := OKL_API.G_MISS_NUM,
51: start_date OKC_K_LINES_B.START_DATE%TYPE,
52: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
53: end_date OKC_K_LINES_B.END_DATE%TYPE,
54: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
55: location_id VARCHAR(1995),
56: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
57: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM);

Line 54: sts_code OKC_K_LINES_B.STS_CODE%TYPE,

50: residual_value NUMBER := OKL_API.G_MISS_NUM,
51: start_date OKC_K_LINES_B.START_DATE%TYPE,
52: date_terminated OKC_K_LINES_B.DATE_TERMINATED%TYPE,
53: end_date OKC_K_LINES_B.END_DATE%TYPE,
54: sts_code OKC_K_LINES_B.STS_CODE%TYPE,
55: location_id VARCHAR(1995),
56: parent_line_id NUMBER := OKL_API.G_MISS_NUM,
57: dnz_chr_id NUMBER := OKL_API.G_MISS_NUM);
58:

Line 170: okc_k_lines_b sub_cle,

166: cursor l_sub_tot_csr(p_asset_cle_id in number) is
167: select nvl(sum(nvl(sub_kle.subsidy_override_amount,nvl(sub_kle.amount,0))),0)
168: from okl_subsidies_b subb,
169: okl_k_lines sub_kle,
170: okc_k_lines_b sub_cle,
171: okc_line_styles_b sub_lse
172: where subb.id = sub_kle.subsidy_id
173: and subb.accounting_method_code = 'NET'
174: and sub_kle.id = sub_cle.id

Line 521: FROM okc_k_lines_b CLEB

517: FROM okc_k_headers_b CHR
518: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
519: AND chr.ID = p_chr_id
520: AND exists (SELECT '1'
521: FROM okc_k_lines_b CLEB
522: ,okl_k_lines KLE
523: WHERE CLEB.id = KLE.id
524: AND CLEB.dnz_chr_id = p_chr_id
525: AND CLEB.chr_id = p_chr_id

Line 529: FROM okc_k_lines_b CLEB

525: AND CLEB.chr_id = p_chr_id
526: AND CLEB.LSE_ID = 33 --for asset line
527: AND NVL(KLE.re_lease_yn,'N')= 'Y')
528: AND NOT EXISTS (SELECT '1'
529: FROM okc_k_lines_b CLEB
530: ,okl_k_lines KLE
531: WHERE CLEB.id = KLE.id
532: AND CLEB.dnz_chr_id = p_chr_id
533: AND CLEB.chr_id = p_chr_id

Line 590: FROM OKC_K_LINES_B cle,

586: SELECT 'x'
587: /* FROM dual
588: WHERE exists
589: (SELECT (1) */
590: FROM OKC_K_LINES_B cle,
591: OKC_K_ITEMS itm,
592: OKC_LINE_STYLES_B lse,
593: OKC_STATUSES_B sts
594: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 611: FROM OKC_K_LINES_B cle,

607: SELECT 'x'
608: /* FROM dual
609: WHERE exists
610: (SELECT (1) */
611: FROM OKC_K_LINES_B cle,
612: OKC_K_ITEMS itm,
613: OKC_LINE_STYLES_B lse,
614: OKC_STATUSES_B sts
615: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 632: FROM OKC_K_LINES_B cle,

628: SELECT 'x'
629: /* FROM dual
630: WHERE exists
631: (SELECT (1) */
632: FROM OKC_K_LINES_B cle,
633: OKC_K_ITEMS itm,
634: OKC_LINE_STYLES_B lse,
635: OKC_STATUSES_B sts
636: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 770: okc_k_lines_b cle_ib,

766: from hz_locations hl,
767: csi_item_instances csi,
768: okc_k_items cim_ib,
769: okc_line_styles_b lse_ib,
770: okc_k_lines_b cle_ib,
771: okc_line_styles_b lse_inst,
772: okc_k_lines_b cle_inst,
773: okc_line_styles_b lse_fin,
774: okc_k_lines_b cle_fin

Line 772: okc_k_lines_b cle_inst,

768: okc_k_items cim_ib,
769: okc_line_styles_b lse_ib,
770: okc_k_lines_b cle_ib,
771: okc_line_styles_b lse_inst,
772: okc_k_lines_b cle_inst,
773: okc_line_styles_b lse_fin,
774: okc_k_lines_b cle_fin
775: where cle_fin.cle_id is null
776: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 774: okc_k_lines_b cle_fin

770: okc_k_lines_b cle_ib,
771: okc_line_styles_b lse_inst,
772: okc_k_lines_b cle_inst,
773: okc_line_styles_b lse_fin,
774: okc_k_lines_b cle_fin
775: where cle_fin.cle_id is null
776: and cle_fin.chr_id = cle_fin.dnz_chr_id
777: and lse_fin.id = cle_fin.lse_id
778: and lse_fin.lty_code = 'FREE_FORM1'

Line 813: okc_k_lines_b cle_ib,

809: --hz_party_site_uses hpsu,
810: csi_item_instances csi,
811: okc_k_items cim_ib,
812: okc_line_styles_b lse_ib,
813: okc_k_lines_b cle_ib,
814: okc_line_styles_b lse_inst,
815: okc_k_lines_b cle_inst,
816: okc_line_styles_b lse_fin,
817: okc_k_lines_b cle_fin

Line 815: okc_k_lines_b cle_inst,

811: okc_k_items cim_ib,
812: okc_line_styles_b lse_ib,
813: okc_k_lines_b cle_ib,
814: okc_line_styles_b lse_inst,
815: okc_k_lines_b cle_inst,
816: okc_line_styles_b lse_fin,
817: okc_k_lines_b cle_fin
818: where cle_fin.cle_id is null
819: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 817: okc_k_lines_b cle_fin

813: okc_k_lines_b cle_ib,
814: okc_line_styles_b lse_inst,
815: okc_k_lines_b cle_inst,
816: okc_line_styles_b lse_fin,
817: okc_k_lines_b cle_fin
818: where cle_fin.cle_id is null
819: and cle_fin.chr_id = cle_fin.dnz_chr_id
820: and lse_fin.id = cle_fin.lse_id
821: and lse_fin.lty_code = 'FREE_FORM1'

Line 858: okc_k_lines_b cle_ib,

854: hz_party_sites hps,
855: hz_party_site_uses hpsu,
856: okl_txl_itm_insts iti,
857: okc_line_styles_b lse_ib,
858: okc_k_lines_b cle_ib,
859: okc_line_styles_b lse_inst,
860: okc_k_lines_b cle_inst,
861: okc_line_styles_b lse_fin,
862: okc_k_lines_b cle_fin

Line 860: okc_k_lines_b cle_inst,

856: okl_txl_itm_insts iti,
857: okc_line_styles_b lse_ib,
858: okc_k_lines_b cle_ib,
859: okc_line_styles_b lse_inst,
860: okc_k_lines_b cle_inst,
861: okc_line_styles_b lse_fin,
862: okc_k_lines_b cle_fin
863: where cle_fin.cle_id is null
864: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 862: okc_k_lines_b cle_fin

858: okc_k_lines_b cle_ib,
859: okc_line_styles_b lse_inst,
860: okc_k_lines_b cle_inst,
861: okc_line_styles_b lse_fin,
862: okc_k_lines_b cle_fin
863: where cle_fin.cle_id is null
864: and cle_fin.chr_id = cle_fin.dnz_chr_id
865: and lse_fin.id = cle_fin.lse_id
866: and lse_fin.lty_code = 'FREE_FORM1'

Line 1125: FROM OKC_K_LINES_B cle,

1121: SELECT 'x'
1122: /*FROM dual
1123: WHERE exists
1124: (SELECT (1)*/
1125: FROM OKC_K_LINES_B cle,
1126: OKC_K_ITEMS itm,
1127: OKC_LINE_STYLES_B lse,
1128: OKC_STATUSES_B sts
1129: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 1393: FROM OKC_K_LINES_B cle,

1389: and c.tal_id = a.id
1390: and c.split_percent is not null
1391: and a.kle_id =(
1392: SELECT cle.id
1393: FROM OKC_K_LINES_B cle,
1394: OKC_LINE_STYLES_B lse
1395: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1396: AND lse.id = cle.lse_id
1397: AND lse.lty_code = 'FIXED_ASSET'

Line 1467: FROM OKC_K_LINES_B cle,

1463: and c.tal_id = a.id
1464: and c.split_percent is not null
1465: and a.kle_id =(
1466: SELECT cle.id
1467: FROM OKC_K_LINES_B cle,
1468: OKC_LINE_STYLES_B lse
1469: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1470: AND lse.id = cle.lse_id
1471: AND lse.lty_code = 'FIXED_ASSET'

Line 1540: FROM OKC_K_LINES_B cle,

1536: and c.tal_id = a.id
1537: and c.split_percent is not null
1538: and a.kle_id =(
1539: SELECT cle.id
1540: FROM OKC_K_LINES_B cle,
1541: OKC_LINE_STYLES_B lse
1542: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1543: AND lse.id = cle.lse_id
1544: AND lse.lty_code = 'FIXED_ASSET'

Line 1609: FROM OKC_K_LINES_B cle,

1605: and c.tal_id = a.id
1606: and c.split_percent is not null
1607: and a.kle_id =(
1608: SELECT cle.id
1609: FROM OKC_K_LINES_B cle,
1610: OKC_LINE_STYLES_B lse
1611: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1612: AND lse.id = cle.lse_id
1613: AND lse.lty_code = 'FIXED_ASSET'

Line 1680: FROM OKC_K_LINES_B cle,

1676: and c.tal_id = a.id
1677: and c.split_percent is not null
1678: and a.kle_id =(
1679: SELECT cle.id
1680: FROM OKC_K_LINES_B cle,
1681: OKC_LINE_STYLES_B lse
1682: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1683: AND lse.id = cle.lse_id
1684: AND lse.lty_code = 'FIXED_ASSET'

Line 1752: FROM OKC_K_LINES_B cle,

1748: and c.tal_id = a.id
1749: and c.split_percent is not null
1750: and a.kle_id =(
1751: SELECT cle.id
1752: FROM OKC_K_LINES_B cle,
1753: OKC_LINE_STYLES_B lse
1754: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1755: AND lse.id = cle.lse_id
1756: AND lse.lty_code = 'FIXED_ASSET'

Line 1821: FROM OKC_K_LINES_B cle,

1817: and c.tal_id = a.id
1818: and c.split_percent is not null
1819: and a.kle_id =(
1820: SELECT cle.id
1821: FROM OKC_K_LINES_B cle,
1822: OKC_LINE_STYLES_B lse
1823: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1824: AND lse.id = cle.lse_id
1825: AND lse.lty_code = 'FIXED_ASSET'

Line 1891: FROM OKC_K_LINES_B cle,

1887: and c.tal_id = a.id
1888: and c.split_percent is not null
1889: and a.kle_id =(
1890: SELECT cle.id
1891: FROM OKC_K_LINES_B cle,
1892: OKC_LINE_STYLES_B lse
1893: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1894: AND lse.id = cle.lse_id
1895: AND lse.lty_code = 'FIXED_ASSET'