DBA Data[Home] [Help]

APPS.OKL_ARFETCH_PUB dependencies on OKL_CNSLD_AR_STRMS_B

Line 49: okl_cnsld_ar_strms_b lsm,

45: cnr.consolidated_invoice_number,
46: sty.name sty_name,
47: lsm.amount lsm_amount
48: FROM ra_customer_trx_lines_all trx,
49: okl_cnsld_ar_strms_b lsm,
50: okl_cnsld_ar_lines_b lln,
51: okl_cnsld_ar_hdrs_b cnr,
52: okl_xtl_sell_invs_b xls,
53: okl_ext_sell_invs_b xsi,

Line 246: update okl_cnsld_ar_strms_b

242: end if;
243:
244: forall indx in tax_amount_tbl.first..tax_amount_tbl.last
245: save exceptions
246: update okl_cnsld_ar_strms_b
247: set tax_amount = nvl(tax_amount_tbl(indx),0),
248: last_update_date = sysdate,
249: last_updated_by = lx_last_updated_by,
250: last_update_login = lx_last_update_login,

Line 412: update okl_cnsld_ar_strms_b

408: -- Populate customer_trx_id in lsm.receivables_invoice_id
409: -- ------------------------------------------------------
410: FORALL indx IN lsm_id_tbl.FIRST..lsm_id_tbl.LAST
411: save exceptions
412: update okl_cnsld_ar_strms_b
413: set receivables_invoice_id = customer_trx_id_tbl(indx),
414: last_update_date = sysdate,
415: last_updated_by = lx_last_updated_by,
416: last_update_login = lx_last_update_login,