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 3590: l_rxlv_rec.source_table := 'OKL_TXD_AR_LN_DTLS_B';

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

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

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