[Home] [Help]
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,
2873: okl_party_payment_dtls ppyd
2874: where ppyd.cpl_id(+) = cplb.id --payment details may not be mandatory
2875: and ppyd.vendor_id(+) = cplb.object1_id1
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,
3847: okc_line_styles_b model_lse,
3848: okc_k_lines_b asst_cle,
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,
3847: okc_line_styles_b model_lse,
3848: okc_k_lines_b asst_cle,
3849: okc_statuses_b asst_sts
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,
4069: okc_line_styles_b model_lse,
4070: okc_k_lines_b asst_cle,
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,
4069: okc_line_styles_b model_lse,
4070: okc_k_lines_b asst_cle,
4071: okc_statuses_b asst_sts
4271: l_rgd_id NUMBER;
4272: l_party_name VARCHAR2(1000);
4273:
4274: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4275: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4276: l_party_role FND_LOOKUPS.meaning%TYPE;
4277:
4278: ----------------------------------------------------------------------------
4279: -- Get bill to site of OKL_VENDOR party on the contract
4310: cPl.cUst_acct_Id cUst_acct_Id
4311: FROM Okl_k_Headers khr,
4312: Okc_k_Headers_b Par,
4313: Okc_Rule_Groups_v rgd,
4314: Okc_k_Party_Roles_b cPl
4315: WHERE khr.Id = cp_khr_Id
4316: AND Par.Id = khr.khr_Id
4317: AND Par.scs_Code = 'PROGRAM'
4318: AND rgd.chr_Id = Par.Id
4872: cursor l_samevend_csr(p_vendor_id in number,
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
4911: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4912:
4913: --Varangan - Billing Enhancement changes - Bug#5874824 - End
4914: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4915: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4916: l_payment_method_id Number;
4917: l_bank_account_id Number;
4918: l_inv_reason_for_review Varchar2(450);
4919: l_inv_review_until_date Date;
4927: --cursor to get vendor cpl_id at header level
4928: cursor l_chrcpl_csr (p_vendor_id in number,
4929: p_chr_id in number) is
4930: select cplb.id
4931: from okc_k_party_roles_b cplb
4932: where cplb.chr_id = p_chr_id
4933: and cplb.dnz_chr_id = p_chr_id
4934: and cplb.cle_id is null
4935: and cplb.object1_id1 = to_char(p_vendor_id)
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')
5287: and cleb.dnz_chr_id = p_chr_id
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')
5321: and cleb.id = p_cle_id
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'
5375: and cplb.cle_id = cleb.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,
5421: okc_line_styles_b lseb,
5422: okc_k_lines_b cleb
6040:
6041:
6042: --Bug# 4558486: Changed call to okl_k_party_roles_pvt api
6043: -- to create records in tables
6044: -- okc_k_party_roles_b and okl_k_party_roles
6045: /*
6046: okl_okc_migration_pvt.create_k_party_role
6047: (p_api_version => p_api_version,
6048: p_init_msg_list => p_init_msg_list,
7091: cursor l_samevend_csr(p_vendor_id in number,
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
7115: lx_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
7116: lx_bpd_acc_rec okl_acc_call_pub.bpd_acc_rec_type;
7117:
7118: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
7119: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
7120: l_payment_method_id Number;
7121: l_bank_account_id Number;
7122: l_inv_reason_for_review Varchar2(450);
7123: l_inv_review_until_date Date;
7131: --cursor to get vendor cpl_id at header level
7132: cursor l_chrcpl_csr (p_vendor_id in number,
7133: p_chr_id in number) is
7134: select cplb.id
7135: from okc_k_party_roles_b cplb
7136: where cplb.chr_id = p_chr_id
7137: and cplb.dnz_chr_id = p_chr_id
7138: and cplb.cle_id is null
7139: and cplb.object1_id1 = to_char(p_vendor_id)