DBA Data[Home] [Help]

APPS.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_AR_TRX_LINES

Line 302: jai_ar_trx_lines jatl1

298: FROM
299: ra_customer_trx_all rt1,
300: ra_cust_trx_line_gl_dist_all rctgl,
301: jai_ar_trxs jict1,
302: jai_ar_trx_lines jatl1
303: WHERE
304: rt1.customer_trx_id = jict1.customer_trx_id
305: AND jatl1.customer_trx_id = jict1.customer_trx_id
306: AND rctgl.customer_trx_line_id = jatl1.customer_trx_line_id

Line 472: jai_ar_trx_lines jatl,

468:
469: CURSOR c_ar_rc_st_amount(cp_invoice_id NUMBER, cp_line_num NUMBER, cd_reversal_date DATE) IS
470: SELECT jcta.mod_cr_percentage, jrtf.tax_amount
471: FROM jai_ar_trx_tax_lines jrtf,
472: jai_ar_trx_lines jatl,
473: jai_cmn_taxes_all jcta,
474: ra_cust_trx_line_gl_dist_all rctgl
475: WHERE jatl.customer_trx_id = cp_invoice_id
476: AND jatl.customer_trx_line_id = jrtf.link_to_cust_trx_line_id