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 565: OKC_LINE_STYLES_B lse,

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

Line 586: OKC_LINE_STYLES_B lse,

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

Line 607: OKC_LINE_STYLES_B lse,

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

Line 741: okc_line_styles_b lse_ib,

737: 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
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,

Line 743: okc_line_styles_b lse_inst,

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

Line 745: okc_line_styles_b lse_fin,

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

Line 784: okc_line_styles_b lse_ib,

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

Line 786: okc_line_styles_b lse_inst,

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

Line 788: okc_line_styles_b lse_fin,

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

Line 829: okc_line_styles_b lse_ib,

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

Line 831: okc_line_styles_b lse_inst,

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

Line 833: okc_line_styles_b lse_fin,

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

Line 1099: OKC_LINE_STYLES_B lse,

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

Line 1366: OKC_LINE_STYLES_B lse

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

Line 1440: OKC_LINE_STYLES_B lse

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

Line 1513: OKC_LINE_STYLES_B lse

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

Line 1582: OKC_LINE_STYLES_B lse

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

Line 1653: OKC_LINE_STYLES_B lse

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

Line 1725: OKC_LINE_STYLES_B lse

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

Line 1794: OKC_LINE_STYLES_B lse

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

Line 1864: OKC_LINE_STYLES_B lse

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