DBA Data[Home] [Help]

APPS.OKL_ACCOUNT_DIST_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 2513: OKL_TXD_AR_LN_DTLS_B TXD

2509: CURSOR get_tai_id_csr(p_source_id IN NUMBER)
2510: IS
2511: SELECT TXL.TAI_ID
2512: FROM OKL_TXL_AR_INV_LNS_B TXL,
2513: OKL_TXD_AR_LN_DTLS_B TXD
2514: WHERE TXD.TIL_ID_DETAILS = TXL.ID
2515: AND TXD.ID = p_source_id;
2516:
2517: --Bug 6316320 dpsingh start

Line 2535: ,okl_txd_ar_ln_dtls_b tld

2531: ,tai.try_id try_id
2532: ,tll.description trans_line_description
2533: FROM okl_trx_ar_invoices_b tai
2534: ,okl_txl_ar_inv_lns_b til
2535: ,okl_txd_ar_ln_dtls_b tld
2536: ,okl_txd_ar_ln_dtls_tl tll
2537: WHERE tll.id = tld.id
2538: AND tld.til_id_details = til.id
2539: AND til.tai_id = tai.id

Line 3592: l_rxlv_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

3588: --Line sources need to be captured for the current line
3589:
3590: --Make the call to Capture line sources
3591: l_rxlv_rec.source_id := p_dist_info_rec.source_id;
3592: l_rxlv_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';
3593: l_rxlv_rec.kle_id := get_tai_details_rec.kle_id;
3594: l_rxlv_rec.sty_id := get_tai_details_rec.sty_id;
3595: l_rxlv_rec.trans_line_description := get_tai_details_rec.trans_line_description;
3596:

Line 3709: l_rxlv_adj_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

3705: --Line sources need to be captured for the current line
3706:
3707: --Make the call to Capture line sources
3708: l_rxlv_adj_rec.source_id := p_dist_info_rec.source_id;
3709: l_rxlv_adj_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';
3710: l_rxlv_adj_rec.kle_id := get_adj_details_rec.kle_id;
3711: l_rxlv_adj_rec.sty_id := get_adj_details_rec.sty_id;
3712:
3713: --Make the call to capture account header source