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_UBB_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;

72: l_amount OKS_BILL_CONT_LINES_V.AMOUNT%TYPE;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;
76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;
77: l_sty_id okl_strm_type_v.id%TYPE;
78: l_first_line CONSTANT NUMBER := 1;
79: l_line_step CONSTANT NUMBER := 1;
80: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;

Line 167: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id

163: AND ITEMS.OBJECT1_ID1 = CNTR.KLE_ID(+)
164: AND OKS_LNS.amount > 0
165: AND rel.chr_id = chr.id
166: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
167: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
168: and tai.description = 'OKS Usage')
169: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
170: where tai.khr_id = rel.chr_id
171: and CNTR.clg_id = tai.clg_id);

Line 169: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR

165: AND rel.chr_id = chr.id
166: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
167: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
168: and tai.description = 'OKS Usage')
169: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
170: where tai.khr_id = rel.chr_id
171: and CNTR.clg_id = tai.clg_id);
172:
173: -- Below Cursor distinct_khr_cur is added by Venkatho as part of Bug# 14119181

Line 195: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id

191: AND ITEMS.OBJECT1_ID1 = CNTR.KLE_ID(+)
192: AND OKS_LNS.amount > 0
193: AND rel.chr_id = chr.id
194: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
195: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
196: and tai.description = 'OKS Usage')
197: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
198: where tai.khr_id = rel.chr_id
199: and CNTR.clg_id = tai.clg_id);

Line 197: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR

193: AND rel.chr_id = chr.id
194: AND OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
195: from okl_trx_ar_invoices_v tai where tai.khr_id = rel.chr_id
196: and tai.description = 'OKS Usage')
197: AND not exists(select 'x' from okl_trx_ar_invoices_v tai, OKL_CNTR_LVLNG_LNS_V CNTR
198: where tai.khr_id = rel.chr_id
199: and CNTR.clg_id = tai.clg_id);
200:
201:

Line 671: okl_trx_ar_invoices_v tai,

667: select max(AR.DUE_DATE) last_bill_date, tai.description transaction_type
668: from okl_cnsld_ar_strms_b cnsld,
669: AR_PAYMENT_SCHEDULES_ALL AR,
670: OKL_XTL_SELL_INVS_V XTL,
671: okl_trx_ar_invoices_v tai,
672: okl_txl_ar_inv_lns_v til,
673: okl_txd_ar_ln_dtls_v tld
674: where cnsld.receivables_invoice_id = AR.customer_trx_id
675: and cnsld.khr_id = c_khr_id

Line 1009: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;

1005: ------------------------------------------------------------
1006: -- Declare local variables used in the program
1007: ------------------------------------------------------------
1008:
1009: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
1010: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1011: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1012: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1013:

Line 1010: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;

1006: -- Declare local variables used in the program
1007: ------------------------------------------------------------
1008:
1009: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
1010: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1011: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1012: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1013:
1014: l_curr_code okc_k_headers_b.currency_code%TYPE;

Line 1011: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;

1007: ------------------------------------------------------------
1008:
1009: l_khr_id okl_trx_ar_invoices_v.khr_id%TYPE;
1010: l_bill_date okl_trx_ar_invoices_v.date_invoiced%TYPE;
1011: l_trx_type okl_trx_ar_invoices_v.try_id%TYPE;
1012: l_kle_id okl_txl_ar_inv_lns_v.kle_id%TYPE;
1013:
1014: l_curr_code okc_k_headers_b.currency_code%TYPE;
1015: l_ste_amount okl_strm_elements.amount%type;

Line 1021: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;

1017:
1018: l_line_number okl_txl_ar_inv_lns_v.line_number%TYPE;
1019: l_detail_number okl_txd_ar_ln_dtls_v.line_detail_number%TYPE;
1020:
1021: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1022: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1023:
1024: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1025: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;

Line 1024: l_header_id okl_trx_ar_invoices_v.id%TYPE;

1020:
1021: l_header_amount okl_trx_ar_invoices_v.amount%TYPE;
1022: l_line_amount okl_txl_ar_inv_lns_v.amount%TYPE;
1023:
1024: l_header_id okl_trx_ar_invoices_v.id%TYPE;
1025: l_line_id okl_txl_ar_inv_lns_v.id%TYPE;
1026:
1027: ------------------------------------------------------------
1028: -- Declare variables required by APIs

Line 1077: from okl_trx_ar_invoices_v tai where tai.khr_id = hdr.id

1073: and OKS_LNS.CLE_ID = rel.object1_id1
1074: and OKS_CONT.ID = OKS_LNS.BCL_ID
1075: --and OKS_LNS.DATE_BILLED_TO <= sysdate
1076: and OKS_LNS.DATE_BILLED_FROM > (select NVL(max(tai.date_invoiced),add_months(sysdate,-1000))
1077: from okl_trx_ar_invoices_v tai where tai.khr_id = hdr.id
1078: and tai.description = 'OKS Billing')
1079: order by chr.contract_number, OKS_LNS.date_billed_from, lns.id;
1080: /*
1081: CURSOR l_sty_id_cur IS