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 JAI_AR_TRXS

Line 251: JAI_AR_TRXS jrct

247: SELECT rctl.interface_line_attribute3, rctl.interface_line_attribute6
248: FROM ra_customer_trx_all trx,
249: ra_customer_trx_lines_all rctl,
250: jai_ar_trx_lines jrctl,
251: JAI_AR_TRXS jrct
252: WHERE trx.customer_trx_id = rctl.customer_trx_id
253: AND jrct.customer_trx_id = trx.customer_trx_id
254: AND rctl.line_type = 'LINE'
255: AND trx.customer_trx_id =

Line 330: CURSOR c_st_invoice_cur(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)

326: lv_display_flag VARCHAR2(1);
327: ------------------------------------------------------------------------------------------------------------------
328: --Added by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168 ,End
329:
330: CURSOR c_st_invoice_cur(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)
331: IS
332: SELECT
333: st_inv_number
334: FROM JAI_AR_TRXS

Line 334: FROM JAI_AR_TRXS

330: CURSOR c_st_invoice_cur(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)
331: IS
332: SELECT
333: st_inv_number
334: FROM JAI_AR_TRXS
335: WHERE customer_trx_id = pn_customer_trx_id;
336:
337: CURSOR cur_st_taxes_exist(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE,pn_org_id NUMBER)
338: IS

Line 337: CURSOR cur_st_taxes_exist(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE,pn_org_id NUMBER)

333: st_inv_number
334: FROM JAI_AR_TRXS
335: WHERE customer_trx_id = pn_customer_trx_id;
336:
337: CURSOR cur_st_taxes_exist(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE,pn_org_id NUMBER)
338: IS
339: SELECT
340: regime_id ,
341: regime_code

Line 355: CURSOR cur_jai_trx_header(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)

351: jtc.tax_type = jrttv.tax_type AND
352: regime_code = jai_constants.service_regime AND
353: jtc.org_id = pn_org_id ;
354:
355: CURSOR cur_jai_trx_header(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)
356: IS
357: SELECT
358: jat.organization_id,
359: jat.LOCATION_ID,

Line 361: FROM jai_ar_trxs jat

357: SELECT
358: jat.organization_id,
359: jat.LOCATION_ID,
360: jat.BATCH_SOURCE_ID
361: FROM jai_ar_trxs jat
362: where jat.CUSTOMER_TRX_ID = pn_customer_trx_id;
363: CURSOR cur_ar_trx_header(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)
364: IS
365: SELECT

Line 363: CURSOR cur_ar_trx_header(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)

359: jat.LOCATION_ID,
360: jat.BATCH_SOURCE_ID
361: FROM jai_ar_trxs jat
362: where jat.CUSTOMER_TRX_ID = pn_customer_trx_id;
363: CURSOR cur_ar_trx_header(pn_customer_trx_id jai_ar_trxs.CUSTOMER_TRX_ID%TYPE)
364: IS
365: SELECT
366: rcta.SHIP_TO_CUSTOMER_ID,
367: rcta.SHIP_TO_SITE_USE_ID,

Line 381: FROM JAI_AR_TRXS h

377: WHERE l.customer_trx_id = pn_customer_trx_id;
378:
379: CURSOR get_vat_inv_no_cur(pn_customer_trx_id NUMBER) IS
380: SELECT h.vat_invoice_no
381: FROM JAI_AR_TRXS h
382: WHERE h.customer_trx_id = pn_customer_trx_id;
383:
384: lv_st_inv_number jai_ar_trxs.st_inv_number%TYPE;
385: ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE;

Line 384: lv_st_inv_number jai_ar_trxs.st_inv_number%TYPE;

380: SELECT h.vat_invoice_no
381: FROM JAI_AR_TRXS h
382: WHERE h.customer_trx_id = pn_customer_trx_id;
383:
384: lv_st_inv_number jai_ar_trxs.st_inv_number%TYPE;
385: ln_regime_id jai_rgm_definitions.REGIME_ID%TYPE;
386: lv_regime_code jai_rgm_definitions.REGIME_CODE%TYPE;
387: ln_organization_id NUMBER;
388: ln_location_id NUMBER;

Line 859: update jai_ar_trxs set st_inv_number = lv_st_inv_number

855: IF lv_process_status = jai_constants.successful THEN
856: IF lv_st_inv_number IS NOT NULL THEN
857: fnd_file.put_line(FND_FILE.LOG,
858: 'Service Tax Invoice Number has been successfully generated.lv_st_inv_number '||lv_st_inv_number);
859: update jai_ar_trxs set st_inv_number = lv_st_inv_number
860: WHERE customer_trx_id = temp_rec.customer_trx_id;
861: ELSE
862: var_error_invoice := 'Y';
863: END IF;

Line 3497: ln_exchange_rate jai_ar_trxs.exchange_rate%type;

3493: --start additions for bug#9177024
3494:
3495: lv_process_status VARCHAR2(100);
3496: lv_process_message VARCHAR2(1000);
3497: ln_exchange_rate jai_ar_trxs.exchange_rate%type;
3498: lv_account_class_tax VARCHAR2(10) := 'TAX';
3499: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';
3500: lv_account_class_rec VARCHAR2(10) := 'REC';
3501: ln_precision fnd_currencies.precision%TYPE;

Line 4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;

4656: IS
4657: ln_org_id ra_customer_trx_all.org_id%TYPE;
4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
4663: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
4664: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;

Line 4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;

4657: ln_org_id ra_customer_trx_all.org_id%TYPE;
4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%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

Line 4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;

4658: ln_cust_trx_type_id ra_customer_trx_all.cust_trx_type_id%TYPE;
4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%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;

Line 4663: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;

4659: lv_inv_num ra_customer_trx_all.trx_number%TYPE;
4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%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;

Line 4664: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;

4660: ld_cur_conversion_date jai_ar_trxs.exchange_date%TYPE;
4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%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;

Line 4665: ln_inv_loc_id jai_ar_trxs.location_id%TYPE; --11652823

4661: lv_cur_conversion_type jai_ar_trxs.exchange_rate_type%TYPE;
4662: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%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;

Line 4941: jai_ar_trxs jat

4937: , ln_inv_org_id
4938: ,ln_inv_loc_id -- 11652823
4939: , lv_inv_org_code
4940: FROM
4941: jai_ar_trxs jat
4942: , mtl_parameters mp
4943: WHERE jat.customer_trx_id = pn_customer_trx_id
4944: AND jat.organization_id = mp.organization_id;
4945:

Line 5703: FROM JAI_AR_TRXS

5699: IS
5700: /*Added by Qinglei for the Advanced Receipt for Service Tax enhancement Bug 13361952 Begin*/
5701: CURSOR get_st_invoice_cur IS
5702: SELECT st_inv_number
5703: FROM JAI_AR_TRXS
5704: WHERE customer_trx_id = pn_customer_trx_id;
5705: lv_st_inv_number jai_ar_trxs.ST_INV_NUMBER%TYPE;
5706:
5707: BEGIN

Line 5705: lv_st_inv_number jai_ar_trxs.ST_INV_NUMBER%TYPE;

5701: CURSOR get_st_invoice_cur IS
5702: SELECT st_inv_number
5703: FROM JAI_AR_TRXS
5704: WHERE customer_trx_id = pn_customer_trx_id;
5705: lv_st_inv_number jai_ar_trxs.ST_INV_NUMBER%TYPE;
5706:
5707: BEGIN
5708:
5709: OPEN get_st_invoice_cur;