DBA Data[Home] [Help]

APPS.OKL_CREDIT_MEMO_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 271: okl_trx_ar_invoices_b tai

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;
275: AND ( tld.lsm_id = p_tld_id

Line 297: okl_trx_ar_invoices_b tai

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;
301: AND ( tld.lsm_id = p_tld_id

Line 318: okl_trx_ar_invoices_b trx

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;
322:

Line 864: okl_trx_ar_invoices_b tai

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;
868:

Line 888: okl_trx_ar_invoices_b tai

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;
892: