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_QUOTE_TO_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 136: , OKC_K_HEADERS_B CHR

132: SELECT LAB.REFERENCE_NUMBER LSE_APP
133: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
134: FROM OKL_LEASE_APPLICATIONS_B LAB
135: , OKL_LEASE_QUOTES_B QTE
136: , OKC_K_HEADERS_B CHR
137: , OKC_STATUSES_V CSTS
138: WHERE LAB.LEASE_OPPORTUNITY_ID = QTE.PARENT_OBJECT_ID
139: AND QTE.PARENT_OBJECT_CODE = 'LEASEOPP'
140: AND LAB.APPLICATION_STATUS = 'CONV-K'

Line 156: , OKC_K_HEADERS_B CHR

152: , LOP.REFERENCE_NUMBER LSE_OPP
153: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
154: FROM OKL_LEASE_QUOTES_B LSQ
155: , OKL_LEASE_OPPORTUNITIES_B LOP
156: , OKC_K_HEADERS_B CHR
157: , OKC_STATUSES_V CSTS
158: WHERE CHR.ORIG_SYSTEM_ID1 = LOP.ID
159: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'
160: AND CSTS.CODE = CHR.STS_CODE

Line 948: FROM okc_k_headers_b chr,

944: SELECT end_date,
945: term_duration
946: INTO l_contract_end_date,
947: l_term
948: FROM okc_k_headers_b chr,
949: okl_k_headers khr
950: WHERE chr.id = p_chr_id
951: AND chr.id = khr.id;
952: SELECT DECODE(p_payment_frequency, 'A', 12, 'S', 6, 'Q', 3, 'M', 1)

Line 1522: FROM okc_k_headers_b

1518: WHERE id = p_cle_id;
1519:
1520: SELECT currency_code
1521: INTO l_currency_code
1522: FROM okc_k_headers_b
1523: WHERE id = p_chr_id;
1524:
1525: FOR l_fee_srv_asset_rec IN c_fee_srv_asset_dtls(p_qte_fee_srv_id) loop
1526: i:=i+1;

Line 2474: FROM okc_k_headers_b

2470: SELECT start_date,
2471: end_date
2472: INTO l_k_effective_from,
2473: l_k_effective_to
2474: FROM okc_k_headers_b
2475: WHERE id = p_chr_id;
2476: FOR l_quote_fee_rec IN c_get_fee_dtls(p_quote_id)LOOP
2477: -- placeholder recurring expense
2478: IF l_quote_fee_rec.fee_type IN ('ABSORBED' , 'FINANCED') THEN

Line 4558: CURSOR c_chk_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE

4554: AND credreq.source_column1 = cp_lap_id
4555: AND hzp.party_id = gdata.party_id;
4556:
4557: -- Cursor checks if party already exists
4558: CURSOR c_chk_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4559: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE
4560: , p_object1_id1 okc_k_party_roles_b.object1_id1%TYPE) IS
4561: SELECT 1
4562: FROM okc_k_party_roles_b p_role

Line 4568: CURSOR c_get_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE

4564: AND p_role.rle_code = p_rle_code
4565: AND p_role.object1_id1 = p_object1_id1;
4566:
4567: -- Cursor to get specific parties of the contract template
4568: CURSOR c_get_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4569: , p_rle_code okc_k_party_roles_b.RLE_CODE%TYPE) IS
4570: SELECT p_role.ID,
4571: p_role.object1_id1,
4572: p_role.object1_id2,

Line 4581: CURSOR c_get_other_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE

4577: AND p_role.rle_code = p_rle_code;
4578:
4579: -- Cursor to get parties of the contract template - parties other than Lessee, Lessor, Vendor
4580: -- Get Guarantors from contract template and those that are not in case folder of lease app
4581: CURSOR c_get_other_party_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE
4582: ,cp_lap_id IN okl_lease_applications_v.ID%TYPE) IS
4583: SELECT p_role.ID,
4584: p_role.object1_id1,
4585: p_role.object1_id2,

Line 4603: Cursor c_rrd_id (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) is

4599: )
4600: )
4601: );
4602:
4603: Cursor c_rrd_id (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) is
4604: SELECT rgrdfs.id
4605: from okc_k_headers_b chr,
4606: okc_subclass_roles sre,
4607: okc_role_sources rse,

Line 4605: from okc_k_headers_b chr,

4601: );
4602:
4603: Cursor c_rrd_id (cp_chr_id OKC_K_HEADERS_B.ID%TYPE) is
4604: SELECT rgrdfs.id
4605: from okc_k_headers_b chr,
4606: okc_subclass_roles sre,
4607: okc_role_sources rse,
4608: okc_subclass_rg_defs rgdfs,
4609: okc_rg_role_defs rgrdfs

Line 4639: l_chr_tmpl_id OKC_K_HEADERS_B.ID%TYPE;

4635: lp_rmpv_rec OKL_RULE_PUB.rmpv_rec_type;
4636: lx_rmpv_rec OKL_RULE_PUB.rmpv_rec_type;
4637:
4638: c_get_party_rec c_get_party_csr%ROWTYPE;
4639: l_chr_tmpl_id OKC_K_HEADERS_B.ID%TYPE;
4640: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
4641: lx_cpl_id NUMBER;
4642: l_rrd_id NUMBER;
4643: l_create_party_for_lap BOOLEAN;

Line 5336: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;

5332: lp_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5333: lx_mla_gvev_rec OKL_OKC_MIGRATION_PVT.gvev_rec_type;
5334:
5335: -- Added by rravikir (Bug 5142890)
5336: ln_qcl_id OKC_K_HEADERS_B.QCL_ID%TYPE;
5337: CURSOR l_qcl_csr IS
5338: SELECT qcl.id
5339: FROM OKC_QA_CHECK_LISTS_TL qcl,
5340: OKC_QA_CHECK_LISTS_B qclv

Line 5682: FROM okc_k_headers_b

5678: l_contract_number VARCHAR2(240);
5679: --cursor to check existance of contract number
5680: CURSOR chk_cntrct_exists(lc_contract_number IN VARCHAR2 )IS
5681: SELECT 'Y'
5682: FROM okc_k_headers_b
5683: where contract_number = lc_contract_number;
5684: --cursor to count the contract numbers which are like the one we want to create
5685: CURSOR chk_count IS
5686: SELECT count(1)

Line 5687: FROM okc_k_headers_b

5683: where contract_number = lc_contract_number;
5684: --cursor to count the contract numbers which are like the one we want to create
5685: CURSOR chk_count IS
5686: SELECT count(1)
5687: FROM okc_k_headers_b
5688: WHERE contract_number like p_contract_number || '%';
5689:
5690: CURSOR c_get_leaseopp IS
5691: SELECT parent_object_id