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 563: FROM OKC_K_LINES_B cle,

559: SELECT 'x'
560: /* FROM dual
561: WHERE exists
562: (SELECT (1) */
563: FROM OKC_K_LINES_B cle,
564: OKC_K_ITEMS itm,
565: OKC_LINE_STYLES_B lse,
566: OKC_STATUSES_B sts
567: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 584: FROM OKC_K_LINES_B cle,

580: SELECT 'x'
581: /* FROM dual
582: WHERE exists
583: (SELECT (1) */
584: FROM OKC_K_LINES_B cle,
585: OKC_K_ITEMS itm,
586: OKC_LINE_STYLES_B lse,
587: OKC_STATUSES_B sts
588: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 605: FROM OKC_K_LINES_B cle,

601: SELECT 'x'
602: /* FROM dual
603: WHERE exists
604: (SELECT (1) */
605: FROM OKC_K_LINES_B cle,
606: OKC_K_ITEMS itm,
607: OKC_LINE_STYLES_B lse,
608: OKC_STATUSES_B sts
609: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 742: okc_k_lines_b cle_ib,

738: from hz_locations hl,
739: csi_item_instances csi,
740: okc_k_items cim_ib,
741: okc_line_styles_b lse_ib,
742: okc_k_lines_b cle_ib,
743: okc_line_styles_b lse_inst,
744: okc_k_lines_b cle_inst,
745: okc_line_styles_b lse_fin,
746: okc_k_lines_b cle_fin

Line 744: okc_k_lines_b cle_inst,

740: okc_k_items cim_ib,
741: okc_line_styles_b lse_ib,
742: okc_k_lines_b cle_ib,
743: okc_line_styles_b lse_inst,
744: okc_k_lines_b cle_inst,
745: okc_line_styles_b lse_fin,
746: okc_k_lines_b cle_fin
747: where cle_fin.cle_id is null
748: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 746: okc_k_lines_b cle_fin

742: okc_k_lines_b cle_ib,
743: okc_line_styles_b lse_inst,
744: okc_k_lines_b cle_inst,
745: okc_line_styles_b lse_fin,
746: okc_k_lines_b cle_fin
747: where cle_fin.cle_id is null
748: and cle_fin.chr_id = cle_fin.dnz_chr_id
749: and lse_fin.id = cle_fin.lse_id
750: and lse_fin.lty_code = 'FREE_FORM1'

Line 785: okc_k_lines_b cle_ib,

781: --hz_party_site_uses hpsu,
782: csi_item_instances csi,
783: okc_k_items cim_ib,
784: okc_line_styles_b lse_ib,
785: okc_k_lines_b cle_ib,
786: okc_line_styles_b lse_inst,
787: okc_k_lines_b cle_inst,
788: okc_line_styles_b lse_fin,
789: okc_k_lines_b cle_fin

Line 787: okc_k_lines_b cle_inst,

783: okc_k_items cim_ib,
784: okc_line_styles_b lse_ib,
785: okc_k_lines_b cle_ib,
786: okc_line_styles_b lse_inst,
787: okc_k_lines_b cle_inst,
788: okc_line_styles_b lse_fin,
789: okc_k_lines_b cle_fin
790: where cle_fin.cle_id is null
791: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 789: okc_k_lines_b cle_fin

785: okc_k_lines_b cle_ib,
786: okc_line_styles_b lse_inst,
787: okc_k_lines_b cle_inst,
788: okc_line_styles_b lse_fin,
789: okc_k_lines_b cle_fin
790: where cle_fin.cle_id is null
791: and cle_fin.chr_id = cle_fin.dnz_chr_id
792: and lse_fin.id = cle_fin.lse_id
793: and lse_fin.lty_code = 'FREE_FORM1'

Line 830: okc_k_lines_b cle_ib,

826: hz_party_sites hps,
827: hz_party_site_uses hpsu,
828: okl_txl_itm_insts iti,
829: okc_line_styles_b lse_ib,
830: okc_k_lines_b cle_ib,
831: okc_line_styles_b lse_inst,
832: okc_k_lines_b cle_inst,
833: okc_line_styles_b lse_fin,
834: okc_k_lines_b cle_fin

Line 832: okc_k_lines_b cle_inst,

828: okl_txl_itm_insts iti,
829: okc_line_styles_b lse_ib,
830: okc_k_lines_b cle_ib,
831: okc_line_styles_b lse_inst,
832: okc_k_lines_b cle_inst,
833: okc_line_styles_b lse_fin,
834: okc_k_lines_b cle_fin
835: where cle_fin.cle_id is null
836: and cle_fin.chr_id = cle_fin.dnz_chr_id

Line 834: okc_k_lines_b cle_fin

830: okc_k_lines_b cle_ib,
831: okc_line_styles_b lse_inst,
832: okc_k_lines_b cle_inst,
833: okc_line_styles_b lse_fin,
834: okc_k_lines_b cle_fin
835: where cle_fin.cle_id is null
836: and cle_fin.chr_id = cle_fin.dnz_chr_id
837: and lse_fin.id = cle_fin.lse_id
838: and lse_fin.lty_code = 'FREE_FORM1'

Line 1097: FROM OKC_K_LINES_B cle,

1093: SELECT 'x'
1094: /*FROM dual
1095: WHERE exists
1096: (SELECT (1)*/
1097: FROM OKC_K_LINES_B cle,
1098: OKC_K_ITEMS itm,
1099: OKC_LINE_STYLES_B lse,
1100: OKC_STATUSES_B sts
1101: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 1365: FROM OKC_K_LINES_B cle,

1361: and c.tal_id = a.id
1362: and c.split_percent is not null
1363: and a.kle_id =(
1364: SELECT cle.id
1365: FROM OKC_K_LINES_B cle,
1366: OKC_LINE_STYLES_B lse
1367: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1368: AND lse.id = cle.lse_id
1369: AND lse.lty_code = 'FIXED_ASSET'

Line 1439: FROM OKC_K_LINES_B cle,

1435: and c.tal_id = a.id
1436: and c.split_percent is not null
1437: and a.kle_id =(
1438: SELECT cle.id
1439: FROM OKC_K_LINES_B cle,
1440: OKC_LINE_STYLES_B lse
1441: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1442: AND lse.id = cle.lse_id
1443: AND lse.lty_code = 'FIXED_ASSET'

Line 1512: FROM OKC_K_LINES_B cle,

1508: and c.tal_id = a.id
1509: and c.split_percent is not null
1510: and a.kle_id =(
1511: SELECT cle.id
1512: FROM OKC_K_LINES_B cle,
1513: OKC_LINE_STYLES_B lse
1514: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1515: AND lse.id = cle.lse_id
1516: AND lse.lty_code = 'FIXED_ASSET'

Line 1581: FROM OKC_K_LINES_B cle,

1577: and c.tal_id = a.id
1578: and c.split_percent is not null
1579: and a.kle_id =(
1580: SELECT cle.id
1581: FROM OKC_K_LINES_B cle,
1582: OKC_LINE_STYLES_B lse
1583: WHERE cle.dnz_chr_id = oast.dnz_chr_id
1584: AND lse.id = cle.lse_id
1585: AND lse.lty_code = 'FIXED_ASSET'

Line 1652: FROM OKC_K_LINES_B cle,

1648: and c.tal_id = a.id
1649: and c.split_percent is not null
1650: and a.kle_id =(
1651: SELECT cle.id
1652: FROM OKC_K_LINES_B cle,
1653: OKC_LINE_STYLES_B lse
1654: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1655: AND lse.id = cle.lse_id
1656: AND lse.lty_code = 'FIXED_ASSET'

Line 1724: FROM OKC_K_LINES_B cle,

1720: and c.tal_id = a.id
1721: and c.split_percent is not null
1722: and a.kle_id =(
1723: SELECT cle.id
1724: FROM OKC_K_LINES_B cle,
1725: OKC_LINE_STYLES_B lse
1726: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1727: AND lse.id = cle.lse_id
1728: AND lse.lty_code = 'FIXED_ASSET'

Line 1793: FROM OKC_K_LINES_B cle,

1789: and c.tal_id = a.id
1790: and c.split_percent is not null
1791: and a.kle_id =(
1792: SELECT cle.id
1793: FROM OKC_K_LINES_B cle,
1794: OKC_LINE_STYLES_B lse
1795: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1796: AND lse.id = cle.lse_id
1797: AND lse.lty_code = 'FIXED_ASSET'

Line 1863: FROM OKC_K_LINES_B cle,

1859: and c.tal_id = a.id
1860: and c.split_percent is not null
1861: and a.kle_id =(
1862: SELECT cle.id
1863: FROM OKC_K_LINES_B cle,
1864: OKC_LINE_STYLES_B lse
1865: WHERE cle.dnz_chr_id = nast.dnz_chr_id
1866: AND lse.id = cle.lse_id
1867: AND lse.lty_code = 'FIXED_ASSET'