DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 1202: OKL_TXL_AR_INV_LNS_B TIL

1198: FROM OKL_TXD_AR_LN_DTLS_B TLD
1199: WHERE EXISTS
1200: (SELECT 1
1201: FROM OKL_TRX_AR_INVOICES_B TAI,
1202: OKL_TXL_AR_INV_LNS_B TIL
1203: WHERE TLD.TIL_ID_DETAILS = TIL.ID
1204: AND TIL.TAI_ID = TAI.ID
1205: AND TAI.trx_status_code = p_sts
1206: AND TAI.request_id = p_req_id);

Line 1447: okl_txl_ar_inv_lns_b inv

1443: txs.event_class_code,
1444: txs.entity_code,
1445: inv.tax_line_id -- Bug 6619311
1446: FROM okl_tax_sources txs,
1447: okl_txl_ar_inv_lns_b inv
1448: ,okl_txd_ar_ln_dtls_b tld
1449: WHERE txs.trx_id = inv.txs_trx_id
1450: AND trx_line_id = inv.txs_trx_line_id
1451: AND inv.id = tld.til_id_details