DBA Data[Home] [Help]

APPS.OKL_GL_TRANSFER_PVT dependencies on OKL_TRX_CONTRACTS

Line 119: FROM okl_trx_contracts tcn,

115: SELECT tcn.trx_number,
116: khr.contract_number,
117: tcn.date_transaction_occurred,
118: tcl.line_number
119: FROM okl_trx_contracts tcn,
120: okl_trx_types_v try,
121: okc_k_headers_b khr,
122: okl_txl_cntrct_lns tcl
123: WHERE tcn.id = tcl.tcn_id AND

Line 153: okl_trx_contracts tcn

149: FROM okl_Ae_headers aeh,
150: okl_ae_lines ael,
151: okl_trx_types_v try,
152: okl_txl_cntrct_lns tcl,
153: okl_trx_contracts tcn
154: WHERE aeh.ae_header_id=ael.ae_header_id
155: AND aeh.accounting_error_code IS NULL
156: AND ael.accounting_error_code IS NULL
157: AND aeh.request_id = p_request_id

Line 205: okl_trx_contracts tcn

201: ael.currency_code
202: FROM okl_ae_headers aeh,
203: okl_ae_lines ael,
204: okl_txl_cntrct_lns tcl,
205: okl_trx_contracts tcn
206: WHERE ael.ae_header_id = aeh.ae_header_id
207: AND ael.gl_transfer_error_code is null
208: AND aeh.request_id = p_request_id
209: AND aeh.ae_category=p_category