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_SUBSIDY_PROCESS_PVT dependencies on OKC_LINE_STYLES_B

Line 124: okc_line_styles_b lseb,

120: cursor l_cle_csr (p_cle_id in number,
121: p_lty_code in varchar2) is
122: select 'Y'
123: from okc_k_lines_b cleb,
124: okc_line_styles_b lseb,
125: okc_k_headers_b chrb,
126: okc_subclasses_b scsb
127: where chrb.id = cleb.dnz_chr_id
128: and scsb.code = chrb.scs_code

Line 283: okc_line_styles_b lseb

279: select 'Y'
280: from dual
281: where exists (select '1'
282: from okc_k_lines_b cleb,
283: okc_line_styles_b lseb
284: where cleb.dnz_chr_id = p_chr_id
285: and cleb.sts_code <> 'ABANDONED'
286: and lseb.id = cleb.lse_id
287: and lseb.lty_code = 'SUBSIDY'

Line 395: okc_line_styles_b lseb

391: select 'Y'
392: from dual
393: where exists (select '1'
394: from okc_k_lines_b cleb,
395: okc_line_styles_b lseb
396: where cleb.cle_id = p_asset_cle_id
397: and cleb.sts_code <> 'ABANDONED'
398: and lseb.id = cleb.lse_id
399: and lseb.lty_code = 'SUBSIDY'

Line 2002: --okc_line_styles_b lseb

1998: --suc.maximum_financed_amount
1999: --from okl_subsidy_criteria suc,
2000: --okc_k_items cim,
2001: --okc_k_lines_b cleb, --modelline
2002: --okc_line_styles_b lseb
2003: --where suc.subsidy_id = p_subsidy_id
2004: --and to_char(suc.organization_id) = cim.object1_id1
2005: --and to_char(suc.inventory_item_id) = cim.object1_id2
2006: --and cim.jtot_object1_code = 'OKX_SYSITEM'

Line 3049: okc_line_styles_b sub_lse

3045: select sub_cle.id
3046: from okl_subsidies_b subb,
3047: okl_k_lines sub_kle,
3048: okc_k_lines_b sub_cle,
3049: okc_line_styles_b sub_lse
3050: where subb.id = sub_kle.subsidy_id
3051: and subb.accounting_method_code = nvl(upper(p_accounting_method),subb.accounting_method_code)
3052: and sub_kle.id = sub_cle.id
3053: and sub_cle.cle_id = p_asset_cle_id

Line 3192: okc_line_styles_b sub_lse

3188: --cursor to fetch all the subsidies attached to financial asset
3189: cursor l_sub_csr(p_asset_cle_id in number) is
3190: select sub_cle.id
3191: from okc_k_lines_b sub_cle,
3192: okc_line_styles_b sub_lse
3193: where sub_cle.cle_id = p_asset_cle_id
3194: and sub_cle.lse_id = sub_lse.id
3195: and sub_lse.lty_code = 'SUBSIDY'
3196: and sub_cle.sts_code <> 'ABANDONED';

Line 3315: okc_line_styles_b sub_lse

3311: --cursor to fetch all the subsidies attached to financial asset
3312: cursor l_sub_csr(p_asset_cle_id in number) is
3313: select sub_cle.id
3314: from okc_k_lines_b sub_cle,
3315: okc_line_styles_b sub_lse
3316: where sub_cle.cle_id = p_asset_cle_id
3317: and sub_cle.lse_id = sub_lse.id
3318: and sub_lse.lty_code = 'SUBSIDY'
3319: and sub_cle.sts_code <> 'ABANDONED';

Line 3441: okc_line_styles_b lseb,

3437: --cursor to get all the financial assets in the contract
3438: cursor l_asst_csr(p_chr_id in number) is
3439: select cleb.id
3440: from okc_k_lines_b cleb,
3441: okc_line_styles_b lseb,
3442: okc_statuses_b stsb
3443: where cleb.chr_id = p_chr_id
3444: and cleb.dnz_chr_id = p_chr_id
3445: and cleb.lse_id = lseb.id

Line 3577: okc_line_styles_b lseb,

3573: --cursor to get all the financial assets in the contract
3574: cursor l_asst_csr(p_chr_id in number) is
3575: select cleb.id
3576: from okc_k_lines_b cleb,
3577: okc_line_styles_b lseb,
3578: okc_statuses_b stsb
3579: where cleb.chr_id = p_chr_id
3580: and cleb.dnz_chr_id = p_chr_id
3581: and cleb.lse_id = lseb.id

Line 3709: okc_line_styles_b lseb,

3705: --cursor to get all the financial assets in the contract
3706: cursor l_asst_csr(p_chr_id in number) is
3707: select cleb.id
3708: from okc_k_lines_b cleb,
3709: okc_line_styles_b lseb,
3710: okc_statuses_b stsb
3711: where cleb.chr_id = p_chr_id
3712: and cleb.dnz_chr_id = p_chr_id
3713: and cleb.lse_id = lseb.id

Line 3842: okc_line_styles_b sub_lse,

3838: select sub_cle.id
3839: from
3840: okl_k_lines sub_kle,
3841: okc_k_lines_b sub_cle,
3842: okc_line_styles_b sub_lse,
3843: okl_subsidies_b subb,
3844: okc_k_party_roles_b sub_vend,
3845: okc_k_party_roles_b asst_vend,
3846: okc_k_lines_b model_cle,

Line 3847: okc_line_styles_b model_lse,

3843: okl_subsidies_b subb,
3844: okc_k_party_roles_b sub_vend,
3845: okc_k_party_roles_b asst_vend,
3846: okc_k_lines_b model_cle,
3847: okc_line_styles_b model_lse,
3848: okc_k_lines_b asst_cle,
3849: okc_statuses_b asst_sts
3850: --subsidy vendor
3851: where sub_vend.dnz_chr_id = sub_cle.dnz_chr_id

Line 3892: select null from OKC_LINE_STYLES_B SUB_LSE,

3888: --veramach bug 5600694 start
3889: cursor is_subsidy( p_chr_id in number, p_asset_cle_id in number) is
3890: select 'Y' from dual where exists
3891: (
3892: select null from OKC_LINE_STYLES_B SUB_LSE,
3893: OKC_K_LINES_B SUB_CLE
3894: where SUB_CLE.dnz_chr_id=p_chr_id
3895: and SUB_LSE.LTY_CODE = 'SUBSIDY'
3896: and SUB_CLE.lse_id= SUB_LSE.id

Line 4064: okc_line_styles_b sub_lse,

4060: select sub_cle.id,
4061: sub_cle.dnz_chr_id
4062: from okl_k_lines sub_kle,
4063: okc_k_lines_b sub_cle,
4064: okc_line_styles_b sub_lse,
4065: okl_subsidies_b subb,
4066: okc_k_party_roles_b sub_vend,
4067: okc_k_party_roles_b asst_vend,
4068: okc_k_lines_b model_cle,

Line 4069: okc_line_styles_b model_lse,

4065: okl_subsidies_b subb,
4066: okc_k_party_roles_b sub_vend,
4067: okc_k_party_roles_b asst_vend,
4068: okc_k_lines_b model_cle,
4069: okc_line_styles_b model_lse,
4070: okc_k_lines_b asst_cle,
4071: okc_statuses_b asst_sts
4072: --subsidy vendor
4073: where sub_vend.dnz_chr_id = sub_cle.dnz_chr_id

Line 4878: okc_line_styles_b lseb

4874: p_chr_id in number) is
4875: Select 'Y'
4876: From okc_k_party_roles_b cplb,
4877: okc_k_lines_b cleb,
4878: okc_line_styles_b lseb
4879: where cplb.cle_id = cleb.id
4880: and cleb.cle_id = p_asset_cle_id
4881: and lseb.id = cleb.lse_id
4882: and lseb.lty_code = 'ITEM'

Line 5282: okc_line_styles_b lseb,

5278: from okl_k_lines kle,
5279: okc_k_lines_tl clet,
5280: okc_k_lines_b cleb,
5281: okc_statuses_b stsb,
5282: okc_line_styles_b lseb,
5283: okc_k_party_roles_b cplb
5284: where kle.id = cleb.id
5285: and clet.id = cleb.id
5286: and clet.language = userenv('LANG')

Line 5316: okc_line_styles_b lseb,

5312: from okl_k_lines kle,
5313: okc_k_lines_tl clet,
5314: okc_k_lines_b cleb,
5315: okc_statuses_b stsb,
5316: okc_line_styles_b lseb,
5317: okc_k_party_roles_b cplb
5318: where kle.id = cleb.id
5319: and clet.id = cleb.id
5320: and clet.language = userenv('LANG')

Line 5370: okc_line_styles_b lseb,

5366: p_rbk_chr_id in number) is
5367: select cleb.id cle_id,
5368: cplb.id cpl_id
5369: from okc_k_lines_b cleb,
5370: okc_line_styles_b lseb,
5371: okc_k_party_roles_b cplb
5372: where cleb.dnz_chr_id = p_orig_chr_id
5373: and lseb.id = cleb.lse_id
5374: and lseb.lty_code = 'SUBSIDY'

Line 5421: okc_line_styles_b lseb,

5417: okc_statuses_b asst_sts,
5418: okc_k_party_roles_b cplb,
5419: okc_k_lines_tl clet,
5420: okl_k_lines kle,
5421: okc_line_styles_b lseb,
5422: okc_k_lines_b cleb
5423:
5424: Where asst_cleb.id = cleb.cle_id
5425: And asst_cleb.dnz_chr_id = cleb.dnz_chr_id

Line 6283: OKC_LINE_STYLES_B LSEB

6279: , p_chr_id IN NUMBER) IS
6280: SELECT CLEB.ID
6281: FROM OKC_K_LINES_B CLEB,
6282: OKC_STATUSES_B STSB,
6283: OKC_LINE_STYLES_B LSEB
6284: WHERE CLEB.ORIG_SYSTEM_ID1 = p_cle_id
6285: AND CLEB.ORIG_SYSTEM_SOURCE_CODE ='OKC_LINE'
6286: AND CLEB.DNZ_CHR_ID = p_chr_id
6287: AND STSB.CODE = CLEB.STS_CODE

Line 7097: okc_line_styles_b lseb

7093: p_chr_id in number) is
7094: Select 'Y'
7095: From okc_k_party_roles_b cplb,
7096: okc_k_lines_b cleb,
7097: okc_line_styles_b lseb
7098: where cplb.cle_id = cleb.id
7099: and cleb.cle_id = p_asset_cle_id
7100: and lseb.id = cleb.lse_id
7101: and lseb.lty_code = 'ITEM'