eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_MATCH_TAX_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 1787: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id

1783: Item_lines_already_accounted EXCEPTION; /* Ramanand for SLA Uptake */
1784: rounding_account_not_defined EXCEPTION;
1785: resource_busy EXCEPTION;
1786:
1787: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1788: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)
1789: IS
1790: SELECT allow_overapplication_flag
1791: FROM ra_cust_trx_types_all

Line 1788: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)

1784: rounding_account_not_defined EXCEPTION;
1785: resource_busy EXCEPTION;
1786:
1787: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1788: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)
1789: IS
1790: SELECT allow_overapplication_flag
1791: FROM ra_cust_trx_types_all
1792: WHERE cust_trx_type_id = cp_cust_trx_type_id;

Line 1791: FROM ra_cust_trx_types_all

1787: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1788: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)
1789: IS
1790: SELECT allow_overapplication_flag
1791: FROM ra_cust_trx_types_all
1792: WHERE cust_trx_type_id = cp_cust_trx_type_id;
1793:
1794: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1795: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

Line 2780: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id

2776: ln_inst_tax_amt_for_inv := ln_tax_amt_cms * ln_apportion_factor;
2777: ln_inst_frt_amt_for_inv := ln_frt_amt_cms * ln_apportion_factor;
2778:
2779:
2780: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
2781: OPEN cur_trx_types(rec_inv_customer_trx.cust_trx_type_id);
2782: FETCH cur_trx_types INTO lv_allow_overappln_flag ;
2783: CLOSE cur_trx_types ;
2784:

Line 4667: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;

4663: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
4664: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;
4665: ln_inv_loc_id jai_ar_trxs.location_id%TYPE; --11652823
4666: lv_inv_org_code mtl_parameters.organization_code%TYPE;
4667: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;
4668: ln_set_of_books_id ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE;
4669: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
4670: ln_tax_account_id NUMBER;
4671: ln_total_inclu_tax_amt NUMBER;

Line 4960: ra_cust_trx_types_all

4956: gl_id_rev -- Modified by Jia for fixed bug#8474445, use gl_id_rev to replace gl_id_rec
4957: INTO
4958: ln_rec_account_id
4959: FROM
4960: ra_cust_trx_types_all
4961: WHERE org_id = ln_org_id
4962: AND cust_trx_type_id = ln_cust_trx_type_id;
4963: *//*commented by vkaranam for bug#9461197*/
4964: