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 420: okl_k_headers ia_okl

416: ia_okl.currency_conversion_rate,
417: ia_okl.currency_conversion_date,
418: ia_okl.legal_entity_id
419: FROM okc_k_headers_b ia,
420: okl_k_headers ia_okl
421: WHERE ia.contract_number = p_investor_agreement
422: AND ia_okl.id = ia.id;
423:
424: ia_info_rec ia_info_csr%rowtype;

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

827: okl_strm_elements ste,
828: okl_streams stm,
829: okl_strm_type_v sty,
830: okc_k_headers_b khr,
831: okl_k_headers oklh
832: WHERE trunc(ste.stream_element_date) <= trunc(NVL(p_date_to, SYSDATE))
833: AND ste.amount <> 0
834: AND stm.id = ste.stm_id
835: AND sty.stream_type_subclass IN ('INVESTOR_DISBURSEMENT','LATE_CHARGE')

Line 844: AND stm.source_table = 'OKL_K_HEADERS'

840: AND stm.active_yn = 'Y'
841: AND stm.say_code = 'CURR'
842: -- New Criteria added for further refining the
843: -- search criteria
844: AND stm.source_table = 'OKL_K_HEADERS'
845: AND stm.source_id = p_ia_id
846: -- End new criteria
847: AND sty.id = stm.sty_id
848: AND khr.id = stm.khr_id

Line 888: okl_k_headers khl,

884: -- End Bug 4550607
885: okl_streams stm,
886: okl_strm_type_v sty,
887: okc_k_headers_b khr,
888: okl_k_headers khl,
889: okc_statuses_b khs ,
890: --Added by bkatraga for bug 6983321
891: okl_pools pl,
892: okl_pool_contents plcont

Line 902: AND stm.source_table = 'OKL_K_HEADERS'

898: AND sty.stream_type_purpose in ( 'INVESTOR_RENT_DISB_BASIS','INVESTOR_PRINCIPAL_DISB_BASIS','INVESTOR_INTEREST_DISB_BASIS','INVESTOR_PPD_DISB_BASIS')
899: AND ste.date_billed IS NULL
900: -- New Criteria added for further refining the
901: -- search criteria
902: AND stm.source_table = 'OKL_K_HEADERS'
903: AND stm.source_id = p_ia_id
904: -- End new criteria
905: AND sty.id = stm.sty_id
906: AND sty.billable_yn = 'N'

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;