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 436: FROM okl_k_headers_full_v khr,

432: klet.pay_investor_event,
433: klet.pay_investor_frequency,
434: klet.date_pay_investor_start,
435: klet.pay_investor_remittance_days
436: FROM okl_k_headers_full_v khr,
437: okl_k_lines klet,
438: okc_k_lines_b clet,
439: okc_line_styles_b lset
440: WHERE khr.id = p_ia_id

Line 517: l_ia_id okl_k_headers_full_v.id%type;

513: l_investor_name PO_VENDORS.vendor_name%TYPE;
514: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
515: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
516:
517: l_ia_id okl_k_headers_full_v.id%type;
518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
520: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
521: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;

514: l_investor_site_code PO_VENDOR_SITES.vendor_site_code%TYPE;
515: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
516:
517: l_ia_id okl_k_headers_full_v.id%type;
518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
520: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
521: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
522:

Line 519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

515: l_strm_name OKL_STRM_TYPE_V.name%TYPE;
516:
517: l_ia_id okl_k_headers_full_v.id%type;
518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
520: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
521: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
522:
523: i_tapv_rec Okl_Trx_Ap_Invoices_Pub.tapv_rec_type;

Line 520: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

516:
517: l_ia_id okl_k_headers_full_v.id%type;
518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
520: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
521: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
522:
523: i_tapv_rec Okl_Trx_Ap_Invoices_Pub.tapv_rec_type;
524: i_tplv_rec OKL_TXL_AP_INV_LNS_PUB.tplv_rec_type;

Line 521: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

517: l_ia_id okl_k_headers_full_v.id%type;
518: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
519: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
520: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
521: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
522:
523: i_tapv_rec Okl_Trx_Ap_Invoices_Pub.tapv_rec_type;
524: i_tplv_rec OKL_TXL_AP_INV_LNS_PUB.tplv_rec_type;
525: i_tplv_tbl okl_tpl_pvt.tplv_tbl_type;

Line 781: okl_k_headers_full_v IA,

777: Poc.khr_id
778: -- 02-NOV-2006 ANSETHUR R12B - Legal Entity
779: ,IA.legal_entity_id
780: FROM OKL_POOLS pol,
781: okl_k_headers_full_v IA,
782: okl_pool_contents_v poc,
783: okl_k_headers_full_v LK_KHR
784: WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
785: AND IA.ID = POL.khr_id

Line 783: okl_k_headers_full_v LK_KHR

779: ,IA.legal_entity_id
780: FROM OKL_POOLS pol,
781: okl_k_headers_full_v IA,
782: okl_pool_contents_v poc,
783: okl_k_headers_full_v LK_KHR
784: WHERE IA.Contract_number = NVL( p_inv_agr, IA.Contract_number)
785: AND IA.ID = POL.khr_id
786: AND pol.id = poc.pol_id
787: AND poc.khr_id = LK_KHR.id;

Line 950: FROM OKL_K_HEADERS_FULL_V KHR,

946: KLET.pay_investor_event,
947: KLET.pay_investor_frequency,
948: KLET.date_pay_investor_start,
949: KLET.pay_investor_remittance_days
950: FROM OKL_K_HEADERS_FULL_V KHR,
951: OKL_K_LINES KLET,
952: OKC_K_LINES_B CLET,
953: OKC_LINE_STYLES_B LSET
954: WHERE KHR.ID = p_ia_id

Line 1178: l_currency_code okl_k_headers_full_v.currency_code%TYPE;

1174:
1175: l_payment_basis fnd_lookups.meaning%TYPE;
1176: l_payment_event fnd_lookups.meaning%TYPE;
1177:
1178: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1179: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:

Line 1179: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;

1175: l_payment_basis fnd_lookups.meaning%TYPE;
1176: l_payment_event fnd_lookups.meaning%TYPE;
1177:
1178: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1179: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;

Line 1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

1176: l_payment_event fnd_lookups.meaning%TYPE;
1177:
1178: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1179: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;

Line 1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;

1177:
1178: l_currency_code okl_k_headers_full_v.currency_code%TYPE;
1179: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;