DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 5268: -- Source Table should be OKL_TXD_AR_LN_DTLS_B/OKL_TXL_ADJSTS_LNS_B

5264: END IF;
5265: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
5266: 'Validation 1 Successfull !');
5267: -- Validation 2:
5268: -- Source Table should be OKL_TXD_AR_LN_DTLS_B/OKL_TXL_ADJSTS_LNS_B
5269: -- Comparing with the Upper(Source_table) as billing is passing the value in the
5270: -- lower cases currently, need to knock this upper once billing passes it correctly
5271: IF UPPER(p_rxlv_rec.source_table) NOT IN ( G_TXD_AR_LN_DTLS_B, G_TXL_ADJSTS_LNS_B )
5272: THEN

Line 5767: ,'OKL_TXD_AR_LN_DTLS_B' source_table

5763: -- sty_id, try_id
5764: CURSOR c_trx_ar_inv_lines_csr (p_header_source_id NUMBER)
5765: IS
5766: SELECT tld.id source_id
5767: ,'OKL_TXD_AR_LN_DTLS_B' source_table
5768: ,tld.khr_id khr_id
5769: ,tld.kle_id kle_id
5770: ,tld.sty_id sty_id
5771: ,tai.try_id try_id

Line 5774: ,okl_txd_ar_ln_dtls_b tld

5770: ,tld.sty_id sty_id
5771: ,tai.try_id try_id
5772: FROM okl_trx_ar_invoices_b tai
5773: ,okl_txl_ar_inv_lns_b til
5774: ,okl_txd_ar_ln_dtls_b tld
5775: WHERE tld.til_id_details = til.id
5776: AND til.tai_id = tai.id
5777: AND tai.id = p_header_source_id;
5778: