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

Line 214: okc_k_headers_b chr

210: hp.party_name party_name
211: FROM okc_statuses_tl stl,
212: hz_parties hp,
213: okc_k_party_roles_b cpl,
214: okc_k_headers_b chr
215: -- BAKUCHIB 2781134 start
216: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))
217: -- BAKUCHIB 2807201 start
218: AND nvl(chr.start_date,to_date('1111','yyyy')) BETWEEN nvl(p_achr_rec.from_start_date,nvl(chr.start_date,to_date('1111','yyyy'))) AND nvl(p_achr_rec.to_start_date,nvl(chr.start_date,to_date('1111','yyyy')))

Line 256: okc_k_headers_b chr

252: hp.party_name party_name
253: FROM okc_statuses_tl stl,
254: hz_parties hp,
255: okc_k_party_roles_b cpl,
256: okc_k_headers_b chr
257: -- BAKUCHIB 2781134 start
258: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))
259: -- BAKUCHIB 2781134 end
260: -- BAKUCHIB 2748110 Start

Line 288: okc_k_headers_b chr

284: AND chr.id IN (SELECT DISTINCT cle_fin.dnz_chr_id chr_id
285: FROM okc_line_styles_b lse_fin,
286: okc_k_lines_tl clet_fin,
287: okc_k_lines_b cle_fin,
288: okc_k_headers_b chr
289: WHERE cle_fin.cle_id IS NULL
290: AND cle_fin.chr_id = cle_fin.dnz_chr_id
291: AND cle_fin.dnz_chr_id = chr.id
292: AND cle_fin.id = clet_fin.id

Line 320: okc_k_headers_b chr

316: hp.party_name party_name
317: FROM okc_statuses_tl stl,
318: hz_parties hp,
319: okc_k_party_roles_b cpl,
320: okc_k_headers_b chr
321: -- BAKUCHIB 2781134 start
322: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))
323: -- BAKUCHIB 2781134 end
324: -- BAKUCHIB 2748110 Start

Line 353: okc_k_headers_b chr

349: FROM csi_item_instances csi,
350: okc_k_items cim_ib,
351: okc_line_styles_b lse_ib,
352: okc_k_lines_b cle_ib,
353: okc_k_headers_b chr
354: WHERE cle_ib.lse_id = lse_ib.id
355: AND lse_ib.lty_code = 'INST_ITEM'
356: AND cim_ib.cle_id = cle_ib.id
357: AND cim_ib.dnz_chr_id = cle_ib.dnz_chr_id

Line 386: okc_k_headers_b chr

382: hp.party_name party_name
383: FROM okc_statuses_tl stl,
384: hz_parties hp,
385: okc_k_party_roles_b cpl,
386: okc_k_headers_b chr
387: -- BAKUCHIB 2781134 start
388: WHERE upper(chr.contract_number) LIKE upper(nvl(p_achr_rec.contract_number,chr.contract_number))
389: -- BAKUCHIB 2781134 end
390: -- BAKUCHIB 2748110 Start

Line 424: okc_k_headers_b chr

420: okc_k_lines_b cle_inst,
421: okc_line_styles_b lse_fin,
422: okc_k_lines_tl clet_fin,
423: okc_k_lines_b cle_fin,
424: okc_k_headers_b chr
425: WHERE cle_fin.cle_id IS NULL
426: AND cle_fin.chr_id = cle_fin.dnz_chr_id
427: AND cle_fin.dnz_chr_id = chr.id
428: -- BAKUCHIB 2748110 Start

Line 1520: FROM OKC_K_HEADERS_B K

1516: -- with okc_k_keaders_b, added sts_code.
1517: -- Cursor to get the khr details for the k passed
1518: CURSOR k_details_for_qte_csr (p_khr_id IN NUMBER) IS
1519: SELECT K.contract_number, K.sts_code, K.start_date, K.end_date -- rmunjulu EDAT
1520: FROM OKC_K_HEADERS_B K
1521: WHERE K.id = p_khr_id;
1522:
1523:
1524: -- Cursor to get the quote details of a quote that is already accepted for

Line 1538: OKC_K_HEADERS_B KHR

1534: -- sts_code of line match with sts_code of contract
1535: CURSOR l_clines_csr (p_kle_id NUMBER ) IS
1536: SELECT KLE.chr_id, KLE.start_date -- rmunjulu EDAT
1537: FROM OKC_K_LINES_B KLE,
1538: OKC_K_HEADERS_B KHR
1539: WHERE KLE.id = p_kle_id
1540: AND KLE.chr_id = KHR.id
1541: AND KLE.sts_code = KHR.sts_code;
1542:

Line 1558: FROM okc_k_headers_b oks_chrb,

1554: CURSOR l_oks_lines_csr ( p_kle_id IN NUMBER) IS
1555: SELECT '1'
1556: FROM dual WHERE EXISTS (
1557: SELECT '1'
1558: FROM okc_k_headers_b oks_chrb,
1559: okc_line_styles_b oks_cov_pd_lse,
1560: okc_k_lines_b oks_cov_pd_cleb,
1561: okc_k_rel_objs krel,
1562: okc_line_styles_b lnk_srv_lse,

Line 1628: l_sts_code okc_k_headers_b.sts_code%TYPE;

1624: -- related to asset level termination
1625: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1626:
1627: -- SECHAWLA 17-FEB-03 Bug 2804703 : new declarations
1628: l_sts_code okc_k_headers_b.sts_code%TYPE;
1629:
1630: -- RMUNJULU 2757312
1631: l_asset_exists VARCHAR2(1);
1632:

Line 3010: -- okc_k_headers_b instead of okc_k_headers_v

3006: x_tqlv_tbl OUT NOCOPY tqlv_tbl_type,
3007: x_assn_tbl OUT NOCOPY assn_tbl_type) AS
3008:
3009: -- SECHAWLA 14-APR-03 2902588 : Added contract_number in the SELECT clause. Changed FROM claue to use
3010: -- okc_k_headers_b instead of okc_k_headers_v
3011: -- Cursor to get the end date of the contract
3012: CURSOR cur_k_end_date ( p_chr_id NUMBER) IS
3013: SELECT contract_number, end_date
3014: FROM OKC_K_HEADERS_B

Line 3014: FROM OKC_K_HEADERS_B

3010: -- okc_k_headers_b instead of okc_k_headers_v
3011: -- Cursor to get the end date of the contract
3012: CURSOR cur_k_end_date ( p_chr_id NUMBER) IS
3013: SELECT contract_number, end_date
3014: FROM OKC_K_HEADERS_B
3015: WHERE id = p_chr_id;
3016:
3017: -- Cursor to get the number of financial assets for the contract
3018: -- Outer join with line styles in UV... but gives error here in calculate quote

Line 3076: l_contract_number okc_k_headers_b.contract_number%TYPE;

3072: l_total_residual_value NUMBER := 0;
3073: lp_empty_quot_rec quot_rec_type;
3074:
3075: -- SECHAWLA 14-APR-03 2902588 : New Declarations
3076: l_contract_number okc_k_headers_b.contract_number%TYPE;
3077:
3078: --rkuttiya 15-SEP-2003 for bug: 2794685
3079: lx_net_gain_loss NUMBER;
3080: