DBA Data[Home] [Help]

APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_AR_TRXS

Line 3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;

3469: IS
3470: ln_org_id ra_customer_trx_all.org_id%TYPE;
3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;

Line 3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;

3470: ln_org_id ra_customer_trx_all.org_id%TYPE;
3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;
3478: lv_inv_org_code mtl_parameters.organization_code%TYPE;

Line 3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;

3471: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;
3478: lv_inv_org_code mtl_parameters.organization_code%TYPE;
3479: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;

Line 3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;

3472: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;
3478: lv_inv_org_code mtl_parameters.organization_code%TYPE;
3479: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;
3480: ln_set_of_books_id ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE;

Line 3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;

3473: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
3474: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;
3478: lv_inv_org_code mtl_parameters.organization_code%TYPE;
3479: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;
3480: ln_set_of_books_id ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE;
3481: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;

Line 3541: jai_ar_trxs jat

3537: , lv_currency_code
3538: , ln_inv_org_id
3539: , lv_inv_org_code
3540: FROM
3541: jai_ar_trxs jat
3542: , mtl_parameters mp
3543: WHERE jat.customer_trx_id = pn_customer_trx_id
3544: AND jat.organization_id = mp.organization_id;
3545: