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 4892: okc_k_lines_b cleb,

4888: p_asset_cle_id in number,
4889: p_chr_id in number) is
4890: Select 'Y'
4891: From okc_k_party_roles_b cplb,
4892: okc_k_lines_b cleb,
4893: okc_line_styles_b lseb
4894: where cplb.cle_id = cleb.id
4895: and cleb.cle_id = p_asset_cle_id
4896: and lseb.id = cleb.lse_id

Line 5297: okc_k_lines_b cleb,

5293: ,cplb.id cpl_id
5294: ,kle.sty_id sty_id
5295: from okl_k_lines kle,
5296: okc_k_lines_tl clet,
5297: okc_k_lines_b cleb,
5298: okc_statuses_b stsb,
5299: okc_line_styles_b lseb,
5300: okc_k_party_roles_b cplb
5301: where kle.id = cleb.id

Line 5331: okc_k_lines_b cleb,

5327: ,cplb.id cpl_id
5328: ,kle.sty_id sty_id
5329: from okl_k_lines kle,
5330: okc_k_lines_tl clet,
5331: okc_k_lines_b cleb,
5332: okc_statuses_b stsb,
5333: okc_line_styles_b lseb,
5334: okc_k_party_roles_b cplb
5335: where kle.id = cleb.id

Line 5386: from okc_k_lines_b cleb,

5382: cursor l_del_sub_csr (p_orig_chr_id in number,
5383: p_rbk_chr_id in number) is
5384: select cleb.id cle_id,
5385: cplb.id cpl_id
5386: from okc_k_lines_b cleb,
5387: okc_line_styles_b lseb,
5388: okc_k_party_roles_b cplb
5389: where cleb.dnz_chr_id = p_orig_chr_id
5390: and lseb.id = cleb.lse_id

Line 5399: from okc_k_lines_b cleb2

5395: --Bug# 8766336
5396: and cleb.sts_code <> 'ABANDONED'
5397: --line was deleted from rebook copy :
5398: and not exists (select '1'
5399: from okc_k_lines_b cleb2
5400: where cleb2.orig_system_id1 = cleb.id
5401: and cleb2.dnz_chr_id = p_rbk_chr_id
5402: --Bug# 8766336
5403: and cleb2.sts_code <> 'ABANDONED')

Line 5406: from okc_k_lines_b cleb3

5402: --Bug# 8766336
5403: and cleb2.sts_code <> 'ABANDONED')
5404: --line is not a new line created during this rebook
5405: and not exists (select '1'
5406: from okc_k_lines_b cleb3
5407: where cleb3.id = cleb.orig_system_id1
5408: and cleb3.dnz_chr_id = p_rbk_chr_id);
5409:
5410: l_del_sub_id number;

Line 5438: okc_k_lines_b asst_cleb,

5434: asst_cleb.orig_system_id1 orig_asst_cle_id,
5435: --Bug# 8677460
5436: kle.orig_contract_line_id orig_contract_line_id
5437: from
5438: okc_k_lines_b asst_cleb,
5439: okc_statuses_b asst_sts,
5440: okc_k_party_roles_b cplb,
5441: okc_k_lines_tl clet,
5442: okl_k_lines kle,

Line 5444: okc_k_lines_b cleb

5440: okc_k_party_roles_b cplb,
5441: okc_k_lines_tl clet,
5442: okl_k_lines kle,
5443: okc_line_styles_b lseb,
5444: okc_k_lines_b cleb
5445:
5446: Where asst_cleb.id = cleb.cle_id
5447: And asst_cleb.dnz_chr_id = cleb.dnz_chr_id
5448: And asst_sts.code = asst_cleb.sts_code

Line 5469: from okc_k_lines_b cleb

5465:
5466: --cursor to get asset line id if asset line is new
5467: cursor l_cleb_csr (p_orig_cle_id in number) is
5468: select cleb.id
5469: from okc_k_lines_b cleb
5470: where cleb.orig_system_id1 = p_orig_cle_id;
5471:
5472: l_asset_cle_id okc_k_lines_b.ID%TYPE;
5473:

Line 5472: l_asset_cle_id okc_k_lines_b.ID%TYPE;

5468: select cleb.id
5469: from okc_k_lines_b cleb
5470: where cleb.orig_system_id1 = p_orig_cle_id;
5471:
5472: l_asset_cle_id okc_k_lines_b.ID%TYPE;
5473:
5474: --record structures for update and delete
5475:
5476: l_asst_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 6306: FROM OKC_K_LINES_B CLEB,

6302: -- to the subsidy on the original contract
6303: CURSOR c_rbk_subs (p_cle_id IN NUMBER
6304: , p_chr_id IN NUMBER) IS
6305: SELECT CLEB.ID
6306: FROM OKC_K_LINES_B CLEB,
6307: OKC_STATUSES_B STSB,
6308: OKC_LINE_STYLES_B LSEB
6309: WHERE CLEB.ORIG_SYSTEM_ID1 = p_cle_id
6310: AND CLEB.ORIG_SYSTEM_SOURCE_CODE ='OKC_LINE'

Line 6321: FROM OKC_K_LINES_B ORIG_CLEB,

6317: --Added by bkatraga for bug 9276449
6318: --Cursor to check whether the asset was created during rebook or not
6319: CURSOR c_rbk_asset(p_cle_id IN NUMBER) IS
6320: SELECT 'Y'
6321: FROM OKC_K_LINES_B ORIG_CLEB,
6322: OKC_K_LINES_B RBK_CLEB
6323: WHERE ORIG_CLEB.ID = p_cle_id
6324: AND ORIG_CLEB.ORIG_SYSTEM_SOURCE_CODE ='OKC_LINE'
6325: AND ORIG_CLEB.ORIG_SYSTEM_ID1 = RBK_CLEB.ID

Line 6322: OKC_K_LINES_B RBK_CLEB

6318: --Cursor to check whether the asset was created during rebook or not
6319: CURSOR c_rbk_asset(p_cle_id IN NUMBER) IS
6320: SELECT 'Y'
6321: FROM OKC_K_LINES_B ORIG_CLEB,
6322: OKC_K_LINES_B RBK_CLEB
6323: WHERE ORIG_CLEB.ID = p_cle_id
6324: AND ORIG_CLEB.ORIG_SYSTEM_SOURCE_CODE ='OKC_LINE'
6325: AND ORIG_CLEB.ORIG_SYSTEM_ID1 = RBK_CLEB.ID
6326: AND RBK_CLEB.DNZ_CHR_ID = p_rbk_chr_id

Line 7271: okc_k_lines_b cleb,

7267: p_asset_cle_id in number,
7268: p_chr_id in number) is
7269: Select 'Y'
7270: From okc_k_party_roles_b cplb,
7271: okc_k_lines_b cleb,
7272: okc_line_styles_b lseb
7273: where cplb.cle_id = cleb.id
7274: and cleb.cle_id = p_asset_cle_id
7275: and lseb.id = cleb.lse_id