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

Line 119: AND stm.source_table = 'OKL_K_HEADERS'

115: OKL_STRM_TYPE_V STY
116: WHERE STM.KHR_ID = p_rbk_khr_id
117: AND NVL(STM.KLE_ID,-99) = NVL ( p_rbk_kle_id,-99 )
118: AND STM.STY_ID = STY.ID
119: AND stm.source_table = 'OKL_K_HEADERS'
120: AND stm.source_id = p_ia_id
121: AND STM.SAY_CODE = 'CURR'
122: AND (STY.STREAM_TYPE_SUBCLASS = 'INVESTOR_DISBURSEMENT'
123: OR STY.stream_type_purpose in ( 'INVESTOR_RENT_DISB_BASIS','INVESTOR_PRINCIPAL_DISB_BASIS','INVESTOR_INTEREST_DISB_BASIS','INVESTOR_PPD_DISB_BASIS'))

Line 435: okl_k_headers ia_okl

431: ia_okl.currency_conversion_rate,
432: ia_okl.currency_conversion_date,
433: ia_okl.legal_entity_id
434: FROM okc_k_headers_b ia,
435: okl_k_headers ia_okl
436: WHERE ia.contract_number = p_investor_agreement
437: AND ia_okl.id = ia.id;
438:
439: ia_info_rec ia_info_csr%rowtype;

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 846: okl_k_headers oklh

842: okl_strm_elements ste,
843: okl_streams stm,
844: okl_strm_type_v sty,
845: okc_k_headers_b khr,
846: okl_k_headers oklh
847: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
848: AND ste.amount <> 0
849: AND stm.id = ste.stm_id
850: AND sty.stream_type_subclass IN ('INVESTOR_DISBURSEMENT','LATE_CHARGE')

Line 859: AND stm.source_table = 'OKL_K_HEADERS'

855: AND stm.active_yn = 'Y'
856: AND stm.say_code = 'CURR'
857: -- New Criteria added for further refining the
858: -- search criteria
859: AND stm.source_table = 'OKL_K_HEADERS'
860: AND stm.source_id = p_ia_id
861: -- End new criteria
862: AND sty.id = stm.sty_id
863: AND khr.id = stm.khr_id

Line 903: okl_k_headers khl,

899: -- End Bug 4550607
900: okl_streams stm,
901: okl_strm_type_v sty,
902: okc_k_headers_b khr,
903: okl_k_headers khl,
904: okc_statuses_b khs ,
905: --Added by bkatraga for bug 6983321
906: okl_pools pl,
907: okl_pool_contents plcont

Line 917: AND stm.source_table = 'OKL_K_HEADERS'

913: AND sty.stream_type_purpose in ( 'INVESTOR_RENT_DISB_BASIS','INVESTOR_PRINCIPAL_DISB_BASIS','INVESTOR_INTEREST_DISB_BASIS','INVESTOR_PPD_DISB_BASIS')
914: AND ste.date_billed IS NULL
915: -- New Criteria added for further refining the
916: -- search criteria
917: AND stm.source_table = 'OKL_K_HEADERS'
918: AND stm.source_id = p_ia_id
919: -- End new criteria
920: AND sty.id = stm.sty_id
921: AND sty.billable_yn = 'N'

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;