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_LINE_STYLES_B

Line 171: okc_line_styles_b sub_lse

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
175: and sub_cle.cle_id = p_asset_cle_id

Line 592: OKC_LINE_STYLES_B lse,

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
595: AND itm.dnz_chr_id = cle.dnz_chr_id
596: AND itm.cle_id = cle.id

Line 613: OKC_LINE_STYLES_B lse,

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
616: AND itm.dnz_chr_id = cle.dnz_chr_id
617: AND itm.cle_id = cle.id

Line 634: OKC_LINE_STYLES_B lse,

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
637: AND itm.dnz_chr_id = cle.dnz_chr_id
638: AND itm.cle_id = cle.id

Line 769: okc_line_styles_b lse_ib,

765: substr(arp_addr_label_pkg.format_address(null,hl.address1,hl.address2,hl.address3, hl.address4,hl.city,hl.county,hl.state,hl.province,hl.postal_code,null,hl.country,null, null,null,null,null,null,null,'n','n',80,1,1),1,80) location_id
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,

Line 771: okc_line_styles_b lse_inst,

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
775: where cle_fin.cle_id is null

Line 773: okc_line_styles_b lse_fin,

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
777: and lse_fin.id = cle_fin.lse_id

Line 812: okc_line_styles_b lse_ib,

808: --Bug# 3569441 :
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,

Line 814: okc_line_styles_b lse_inst,

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
818: where cle_fin.cle_id is null

Line 816: okc_line_styles_b lse_fin,

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
820: and lse_fin.id = cle_fin.lse_id

Line 857: okc_line_styles_b lse_ib,

853: from hz_locations hl,
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,

Line 859: okc_line_styles_b lse_inst,

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
863: where cle_fin.cle_id is null

Line 861: okc_line_styles_b lse_fin,

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
865: and lse_fin.id = cle_fin.lse_id

Line 1127: OKC_LINE_STYLES_B lse,

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
1130: AND itm.dnz_chr_id = cle.dnz_chr_id
1131: AND itm.cle_id = cle.id

Line 1394: OKC_LINE_STYLES_B lse

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'
1398: and cle_id= oast.parent_line_id

Line 1468: OKC_LINE_STYLES_B lse

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'
1472: and cle_id= oast.parent_line_id

Line 1541: OKC_LINE_STYLES_B lse

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'
1545: and cle_id= oast.parent_line_id

Line 1610: OKC_LINE_STYLES_B lse

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'
1614: and cle_id= oast.parent_line_id

Line 1681: OKC_LINE_STYLES_B lse

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'
1685: and cle_id= nast.parent_line_id

Line 1753: OKC_LINE_STYLES_B lse

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'
1757: and cle_id= nast.parent_line_id

Line 1822: OKC_LINE_STYLES_B lse

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'
1826: and cle_id= nast.parent_line_id

Line 1892: OKC_LINE_STYLES_B lse

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'
1896: and cle_id= nast.parent_line_id