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_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 451: FROM okl_k_headers_full_v khr,

447: klet.pay_investor_event,
448: klet.pay_investor_frequency,
449: klet.date_pay_investor_start,
450: klet.pay_investor_remittance_days
451: FROM okl_k_headers_full_v khr,
452: okl_k_lines klet,
453: okc_k_lines_b clet,
454: okc_line_styles_b lset
455: WHERE khr.id = p_ia_id

Line 532: l_ia_id okl_k_headers_full_v.id%type;

528: l_investor_name PO_VENDORS.vendor_name%TYPE;
529: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
530: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
531:
532: l_ia_id okl_k_headers_full_v.id%type;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
535: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
536: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;

529: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
530: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
531:
532: l_ia_id okl_k_headers_full_v.id%type;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
535: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
536: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
537:

Line 534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

530: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
531:
532: l_ia_id okl_k_headers_full_v.id%type;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
535: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
536: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
537:
538: i_tapv_rec Okl_Trx_Ap_Invoices_Pub.tapv_rec_type;

Line 535: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

531:
532: l_ia_id okl_k_headers_full_v.id%type;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
535: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
536: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
537:
538: i_tapv_rec Okl_Trx_Ap_Invoices_Pub.tapv_rec_type;
539: i_tplv_rec OKL_TXL_AP_INV_LNS_PUB.tplv_rec_type;

Line 536: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

532: l_ia_id okl_k_headers_full_v.id%type;
533: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
534: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
535: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
536: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
537:
538: i_tapv_rec Okl_Trx_Ap_Invoices_Pub.tapv_rec_type;
539: i_tplv_rec OKL_TXL_AP_INV_LNS_PUB.tplv_rec_type;
540: i_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

Line 796: okl_k_headers_full_v IA,

792: Poc.khr_id
793: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
794: ,IA.legal_entity_id
795: FROM OKL_POOLS pol,
796: okl_k_headers_full_v IA,
797: okl_pool_contents_v poc,
798: okl_k_headers_full_v LK_KHR
799: WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
800: AND IA.ID = POL.khr_id

Line 798: okl_k_headers_full_v LK_KHR

794: ,IA.legal_entity_id
795: FROM OKL_POOLS pol,
796: okl_k_headers_full_v IA,
797: okl_pool_contents_v poc,
798: okl_k_headers_full_v LK_KHR
799: WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
800: AND IA.ID = POL.khr_id
801: AND pol.id = poc.pol_id
802: AND poc.khr_id = LK_KHR.id;

Line 965: FROM OKL_K_HEADERS_FULL_V KHR,

961: KLET.pay_investor_event,
962: KLET.pay_investor_frequency,
963: KLET.date_pay_investor_start,
964: KLET.pay_investor_remittance_days
965: FROM OKL_K_HEADERS_FULL_V KHR,
966: OKL_K_LINES KLET,
967: OKC_K_LINES_B CLET,
968: OKC_LINE_STYLES_B LSET
969: WHERE KHR.ID = p_ia_id

Line 1248: l_currency_code okl_k_headers_full_v.currency_code%TYPE;

1244:
1245: l_payment_basis fnd_lookups.meaning%TYPE;
1246: l_payment_event fnd_lookups.meaning%TYPE;
1247:
1248: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1249: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:

Line 1249: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1245: l_payment_basis fnd_lookups.meaning%TYPE;
1246: l_payment_event fnd_lookups.meaning%TYPE;
1247:
1248: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1249: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;

Line 1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1246: l_payment_event fnd_lookups.meaning%TYPE;
1247:
1248: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1249: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;

Line 1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1247:
1248: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1249: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;