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_K_LINES_B

Line 123: from okc_k_lines_b cleb,

119: --cursor to find that chr id is valid okl contract header id
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

Line 282: from okc_k_lines_b cleb,

278: cursor l_subexist_csr(p_chr_id in number) is
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

Line 394: from okc_k_lines_b cleb,

390: cursor l_subexist_csr(p_asset_cle_id in number) is
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

Line 1341: from okc_k_lines_b cleb

1337:
1338: cursor l_cleb_csr (p_cle_id in number) is
1339: select cleb.start_date,
1340: cleb.end_date
1341: from okc_k_lines_b cleb
1342: where cleb.id = p_cle_id;
1343:
1344: l_start_date okc_k_lines_b.start_date%TYPE;
1345: l_end_date okc_k_lines_b.end_date%TYPE;

Line 1344: l_start_date okc_k_lines_b.start_date%TYPE;

1340: cleb.end_date
1341: from okc_k_lines_b cleb
1342: where cleb.id = p_cle_id;
1343:
1344: l_start_date okc_k_lines_b.start_date%TYPE;
1345: l_end_date okc_k_lines_b.end_date%TYPE;
1346: i NUMBER;
1347:
1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;

Line 1345: l_end_date okc_k_lines_b.end_date%TYPE;

1341: from okc_k_lines_b cleb
1342: where cleb.id = p_cle_id;
1343:
1344: l_start_date okc_k_lines_b.start_date%TYPE;
1345: l_end_date okc_k_lines_b.end_date%TYPE;
1346: i NUMBER;
1347:
1348: l_stmv_rec_rent okl_streams_pub.stmv_rec_type;
1349: l_selv_tbl_rent okl_streams_pub.selv_tbl_type;

Line 1963: from okc_k_lines_b sub_cle,

1959: sub_cle.currency_code contract_currency,
1960: --Bug# 3313802 :
1961: subb.maximum_financed_amount maximum_financed_amount,
1962: subb.maximum_subsidy_amount maximum_subsidy_amount
1963: from okc_k_lines_b sub_cle,
1964: okl_k_lines sub_kle,
1965: okl_k_lines ast_kle,
1966: okl_subsidies_b subb
1967: where subb.id = sub_kle.subsidy_id

Line 2001: --okc_k_lines_b cleb, --modelline

1997: --select suc.maximum_subsidy_amount,
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

Line 2549: okc_k_lines_b cleb

2545: --------------------------------------------------
2546: cursor l_kle_csr (p_cle_id in number) is
2547: select kle.subsidy_override_amount
2548: from okl_k_lines kle,
2549: okc_k_lines_b cleb
2550: where kle.id = cleb.id
2551: and cleb.sts_code <> 'ABANDONED'
2552: and cleb.id = p_cle_id;
2553:

Line 2722: okc_k_lines_b cleb

2718: --should read override amount if it is specified, else amount
2719: cursor l_cleb_csr (p_cle_id in number) is
2720: select nvl(kle.subsidy_override_amount,nvl(kle.amount,0))
2721: from okl_k_lines kle,
2722: okc_k_lines_b cleb
2723: where kle.id = cleb.id
2724: and cleb.id = p_subsidy_cle_id
2725: and cleb.sts_code <> 'ABANDONED';
2726:

Line 2868: okc_k_lines_b sub_cleb,

2864: ,subb.refund_formula_id refund_formula_id
2865: ,subb.receipt_method_code receipt_method_code
2866: ,subb.customer_visible_yn customer_visible_yn
2867: from okl_subsidies_b subb,
2868: okc_k_lines_b sub_cleb,
2869: okc_k_lines_tl sub_clet,
2870: okl_k_lines sub_kle,
2871: okc_k_party_roles_b cplb,
2872: po_vendors pov,

Line 3048: okc_k_lines_b sub_cle,

3044: cursor l_sub_csr(p_asset_cle_id in number) is
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

Line 3191: from okc_k_lines_b sub_cle,

3187:
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'

Line 3314: from okc_k_lines_b sub_cle,

3310:
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'

Line 3440: from okc_k_lines_b cleb,

3436:
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

Line 3576: from okc_k_lines_b cleb,

3572:
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

Line 3708: from okc_k_lines_b cleb,

3704:
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

Line 3841: okc_k_lines_b sub_cle,

3837: p_vendor_id in number) is
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,

Line 3846: okc_k_lines_b model_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,
3847: okc_line_styles_b model_lse,
3848: okc_k_lines_b asst_cle,
3849: okc_statuses_b asst_sts
3850: --subsidy vendor

Line 3848: okc_k_lines_b asst_cle,

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
3852: and sub_vend.object1_id1 = nvl(to_char(p_vendor_id),sub_vend.object1_id1)

Line 3893: OKC_K_LINES_B SUB_CLE

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
3897: and SUB_CLE.CLE_ID =p_asset_cle_id

Line 4063: okc_k_lines_b sub_cle,

4059: cursor l_vend_sub_csr (p_asset_cle_id in number) is
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,

Line 4068: okc_k_lines_b model_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,
4069: okc_line_styles_b model_lse,
4070: okc_k_lines_b asst_cle,
4071: okc_statuses_b asst_sts
4072: --subsidy vendor

Line 4070: okc_k_lines_b asst_cle,

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
4074: --and sub_vend.object1_id1 = to_char(nvl(p_vendor_id,sub_vend.object1_id1))

Line 4877: okc_k_lines_b cleb,

4873: p_asset_cle_id in number,
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

Line 5280: okc_k_lines_b cleb,

5276: ,cplb.id cpl_id
5277: ,kle.sty_id sty_id
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

Line 5314: okc_k_lines_b cleb,

5310: ,cplb.id cpl_id
5311: ,kle.sty_id sty_id
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

Line 5369: from okc_k_lines_b cleb,

5365: cursor l_del_sub_csr (p_orig_chr_id in number,
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

Line 5380: from okc_k_lines_b cleb2

5376: and cplb.dnz_chr_id = p_orig_chr_id
5377: and cplb.rle_code = 'OKL_VENDOR'
5378: --line was deleted from rebook copy :
5379: and not exists (select '1'
5380: from okc_k_lines_b cleb2
5381: where cleb2.orig_system_id1 = cleb.id
5382: and cleb2.dnz_chr_id = p_rbk_chr_id)
5383: --line is not a new line created during this rebook
5384: and not exists (select '1'

Line 5385: from okc_k_lines_b cleb3

5381: where cleb2.orig_system_id1 = cleb.id
5382: and cleb2.dnz_chr_id = p_rbk_chr_id)
5383: --line is not a new line created during this rebook
5384: and not exists (select '1'
5385: from okc_k_lines_b cleb3
5386: where cleb3.id = cleb.orig_system_id1
5387: and cleb3.dnz_chr_id = p_rbk_chr_id);
5388:
5389: l_del_sub_id number;

Line 5416: okc_k_lines_b asst_cleb,

5412: kle.sty_id sty_id,
5413: asst_cleb.orig_system_id1 orig_asst_cle_id
5414:
5415: from
5416: okc_k_lines_b asst_cleb,
5417: okc_statuses_b asst_sts,
5418: okc_k_party_roles_b cplb,
5419: okc_k_lines_tl clet,
5420: okl_k_lines kle,

Line 5422: okc_k_lines_b cleb

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
5426: And asst_sts.code = asst_cleb.sts_code

Line 5447: from okc_k_lines_b cleb

5443:
5444: --cursor to get asset line id if asset line is new
5445: cursor l_cleb_csr (p_orig_cle_id in number) is
5446: select cleb.id
5447: from okc_k_lines_b cleb
5448: where cleb.orig_system_id1 = p_orig_cle_id;
5449:
5450: l_asset_cle_id okc_k_lines_b.ID%TYPE;
5451:

Line 5450: l_asset_cle_id okc_k_lines_b.ID%TYPE;

5446: select cleb.id
5447: from okc_k_lines_b cleb
5448: where cleb.orig_system_id1 = p_orig_cle_id;
5449:
5450: l_asset_cle_id okc_k_lines_b.ID%TYPE;
5451:
5452: --record structures for update and delete
5453:
5454: l_asst_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6281: FROM OKC_K_LINES_B CLEB,

6277: -- to the subsidy on the original contract
6278: CURSOR c_rbk_subs (p_cle_id IN NUMBER
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'

Line 7096: okc_k_lines_b cleb,

7092: p_asset_cle_id in number,
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