APPS.OKL_CREDIT_MEMO_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 269: okl_txd_ar_ln_dtls_b tld,

265: tld.sty_id sty_id,
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

Line 295: okl_txd_ar_ln_dtls_b tld,

291: til.id til_id_reverses,
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

Line 316: FROM okl_txd_ar_ln_dtls_b tld,

312: AND lln.cnr_id = cnr.id
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

Line 549: -- l_source_table := 'OKL_TXD_AR_LN_DTLS_B';

545: i_tldv_rec.sty_id := l_sty_id;
546: i_tldv_rec.sel_id := v_3LevelInvoiceRec.sel_id; -- 6237730
547:
548: -- l_source_id := r_tldv_rec.id;
549: -- l_source_table := 'OKL_TXD_AR_LN_DTLS_B';
550:
551: lp_tldv_tbl(0) := i_tldv_rec;
552:
553:

Line 862: okl_txd_ar_ln_dtls_b tld,

858: tld.sty_id sty_id,
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

Line 886: okl_txd_ar_ln_dtls_b tld,

882: til.id til_id_reverses,
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

Line 1109: -- l_source_table := 'OKL_TXD_AR_LN_DTLS_B';

1105: i_tldv_rec.sel_id := v_3LevelInvoiceRec.sel_id;
1106: i_tldv_rec.TXL_AR_LINE_NUMBER := 1; -- 6237730
1107:
1108: -- l_source_id := r_tldv_rec.id;
1109: -- l_source_table := 'OKL_TXD_AR_LN_DTLS_B';
1110:
1111: lp_tldv_tbl(0) := i_tldv_rec;
1112:
1113: