APPS.OKL_ARINTF_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 2155: OKL_TXL_AR_INV_LNS_B TIL

2151: FROM OKL_TXD_AR_LN_DTLS_B TLD
2152: WHERE EXISTS
2153: (SELECT 1
2154: FROM OKL_TRX_AR_INVOICES_B TAI,
2155: OKL_TXL_AR_INV_LNS_B TIL
2156: WHERE TLD.TIL_ID_DETAILS = TIL.ID
2157: AND TIL.TAI_ID = TAI.ID
2158: AND TAI.trx_status_code = p_sts
2159: AND TAI.request_id = p_req_id);

Line 2167: OKL_TXL_AR_INV_LNS_B TIL

2163: FROM OKL_TXD_AR_LN_DTLS_B TLD
2164: WHERE EXISTS
2165: (SELECT 1
2166: FROM OKL_TRX_AR_INVOICES_B TAI,
2167: OKL_TXL_AR_INV_LNS_B TIL
2168: WHERE TLD.TIL_ID_DETAILS = TIL.ID
2169: AND TIL.TAI_ID = TAI.ID
2170: AND TAI.request_id = p_req_id);
2171:

Line 2413: okl_txl_ar_inv_lns_b inv

2409: txs.event_class_code,
2410: txs.entity_code,
2411: inv.tax_line_id -- Bug 6619311
2412: FROM okl_tax_sources txs,
2413: okl_txl_ar_inv_lns_b inv
2414: ,okl_txd_ar_ln_dtls_b tld
2415: WHERE txs.trx_id = inv.txs_trx_id
2416: AND trx_line_id = inv.txs_trx_line_id
2417: AND inv.id = tld.til_id_details

Line 2489: FROM okl_txl_ar_inv_lns_b til,

2485:
2486: --Bug# 12617408
2487: CURSOR rmkt_ship_to_csr(p_til_id IN NUMBER) IS
2488: SELECT hsu.cust_acct_site_id
2489: FROM okl_txl_ar_inv_lns_b til,
2490: oe_order_lines_all oli,
2491: oe_order_headers_all ohe,
2492: hz_cust_site_uses_all hsu
2493: WHERE til.id = p_til_id

Line 4558: , OKL_TXL_AR_INV_LNS_B TIL

4554: DELETE FROM RA_INTERFACE_SALESCREDITS
4555: WHERE interface_line_attribute14 IN
4556: (SELECT TLD.ID
4557: FROM OKL_TXD_AR_LN_DTLS_B TLD
4558: , OKL_TXL_AR_INV_LNS_B TIL
4559: , OKL_TRX_AR_INVOICES_B TAI
4560: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4561: AND TAI.ID = TIL.TAI_ID
4562: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));

Line 4568: , OKL_TXL_AR_INV_LNS_B TIL

4564: DELETE FROM AR_INTERFACE_CONTS
4565: WHERE interface_line_attribute14 IN
4566: (SELECT TLD.ID
4567: FROM OKL_TXD_AR_LN_DTLS_B TLD
4568: , OKL_TXL_AR_INV_LNS_B TIL
4569: , OKL_TRX_AR_INVOICES_B TAI
4570: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4571: AND TAI.ID = TIL.TAI_ID
4572: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));

Line 4578: , OKL_TXL_AR_INV_LNS_B TIL

4574: DELETE FROM RA_INTERFACE_DISTRIBUTIONS
4575: WHERE interface_line_attribute14 IN
4576: (SELECT TLD.ID
4577: FROM OKL_TXD_AR_LN_DTLS_B TLD
4578: , OKL_TXL_AR_INV_LNS_B TIL
4579: , OKL_TRX_AR_INVOICES_B TAI
4580: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4581: AND TAI.ID = TIL.TAI_ID
4582: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));

Line 4588: , OKL_TXL_AR_INV_LNS_B TIL

4584: DELETE FROM RA_INTERFACE_LINES
4585: WHERE interface_line_attribute14 IN
4586: (SELECT TLD.ID
4587: FROM OKL_TXD_AR_LN_DTLS_B TLD
4588: , OKL_TXL_AR_INV_LNS_B TIL
4589: , OKL_TRX_AR_INVOICES_B TAI
4590: WHERE TIL.ID = TLD.TIL_ID_DETAILS
4591: AND TAI.ID = TIL.TAI_ID
4592: AND TAI.ID = l_error_tai_tbl(err_tai_cnt));