DBA Data[Home] [Help]

APPS.OKL_CREDIT_MEMO_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 270: okl_txl_ar_inv_lns_b til,

266: tld.til_id_details til_id_details,
267: tld.sel_id sel_id -- 6237730
268: FROM
269: okl_txd_ar_ln_dtls_b tld,
270: okl_txl_ar_inv_lns_b til,
271: okl_trx_ar_invoices_b tai
272: WHERE tai.id = til.tai_id
273: AND til.id = tld.TIL_ID_DETAILS
274: --AND tld.lsm_id = p_tld_id;

Line 296: okl_txl_ar_inv_lns_b til,

292: til.kle_id kle_id,
293: til.sty_id sty_id
294: FROM
295: okl_txd_ar_ln_dtls_b tld,
296: okl_txl_ar_inv_lns_b til,
297: okl_trx_ar_invoices_b tai
298: WHERE tai.id = til.tai_id
299: AND til.id = tld.TIL_ID_DETAILS
300: --AND tld.lsm_id = p_tld_id;

Line 317: okl_txl_ar_inv_lns_b til,

313: AND lsm.id = p_lsm_id;*/ -- Bug 5897792
314: CURSOR c_legal_entity_id IS
315: SELECT trx.legal_entity_id
316: FROM okl_txd_ar_ln_dtls_b tld,
317: okl_txl_ar_inv_lns_b til,
318: okl_trx_ar_invoices_b trx
319: WHERE tld.til_id_details = til.id
320: AND til.tai_id = trx.id
321: AND tld.id = p_tld_id;

Line 636: --l_source_table := 'OKL_TXL_AR_INV_LNS_B';

632: i_tilv_rec.sty_id := l_sty_id;
633: i_tilv_rec.TXL_AR_LINE_NUMBER := 1; -- 6237730
634:
635: --l_source_id := r_tilv_rec.id;
636: --l_source_table := 'OKL_TXL_AR_INV_LNS_B';
637: lp_tilv_tbl(0) := i_tilv_rec;
638:
639: ELSE
640:

Line 863: okl_txl_ar_inv_lns_b til,

859: tld.til_id_details til_id_details,
860: tld.sel_id sel_id
861: FROM
862: okl_txd_ar_ln_dtls_b tld,
863: okl_txl_ar_inv_lns_b til,
864: okl_trx_ar_invoices_b tai
865: WHERE tai.id = til.tai_id
866: AND til.id = tld.TIL_ID_DETAILS
867: AND tld.id = p_tld_id;

Line 887: okl_txl_ar_inv_lns_b til,

883: til.kle_id kle_id,
884: til.sty_id sty_id
885: FROM
886: okl_txd_ar_ln_dtls_b tld,
887: okl_txl_ar_inv_lns_b til,
888: okl_trx_ar_invoices_b tai
889: WHERE tai.id = til.tai_id
890: AND til.id = tld.TIL_ID_DETAILS
891: AND tld.id = p_tld_id;

Line 1195: --l_source_table := 'OKL_TXL_AR_INV_LNS_B';

1191: i_tilv_rec.sty_id := l_sty_id;
1192: i_tilv_rec.TXL_AR_LINE_NUMBER := 1; -- 6237730
1193:
1194: --l_source_id := r_tilv_rec.id;
1195: --l_source_table := 'OKL_TXL_AR_INV_LNS_B';
1196: lp_tilv_tbl(0) := i_tilv_rec;
1197:
1198: ELSE
1199: