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_OPEN_API_PKG dependencies on JAI_AR_TRXS

Line 3821: FROM JAI_AR_TRXS

3817:
3818: CURSOR organization_cur(cn_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE)
3819: IS
3820: SELECT organization_id, location_id
3821: FROM JAI_AR_TRXS
3822: WHERE customer_trx_id = cn_customer_trx_id;
3823:
3824: Cursor address_cur(cn_ship_to_site_use_id IN Number) IS
3825: SELECT cust_acct_site_id address_id

Line 5454: FROM jai_ar_trxs

5450: --------------------------------------------------------------
5451: /*CURSOR c_get_org_loc
5452: IS
5453: SELECT organization_id, location_id
5454: FROM jai_ar_trxs
5455: WHERE customer_trx_id IN(SELECT customer_trx_id
5456: FROM ra_customer_trx_lines
5457: WHERE customer_trx_line_id IN pn_customer_trx_line_id);*/
5458: --------------------------------------------------------------

Line 5464: FROM jai_ar_trxs

5460:
5461: CURSOR c_get_org_loc
5462: IS
5463: SELECT organization_id, location_id
5464: FROM jai_ar_trxs
5465: WHERE customer_trx_id IN(
5466: SELECT customer_trx_id
5467: FROM ra_customer_trx_lines
5468: WHERE customer_trx_line_id IN

Line 5606: FROM JAI_AR_TRXS

5602: invoice_currency_code,
5603: exchange_rate_type,
5604: exchange_date,
5605: exchange_rate
5606: FROM JAI_AR_TRXS
5607: WHERE customer_trx_id = v_customer_trx_id;
5608:
5609: CURSOR ORG_CUR IS
5610: SELECT ORG_ID

Line 5632: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636

5628: WHERE CUSTOMER_TRX_LINE_ID = pn_customer_trx_line_id;
5629:
5630: CURSOR CREATED_FROM_CUR IS
5631: SELECT created_from
5632: FROM JAI_AR_TRXS -- table reference was previously RA_CUSTOMER_TRX_ALL - using JA_IN_RA_CUSTOMER_TRX instead - bug# 2728636
5633: WHERE customer_trx_id = v_customer_trx_id;
5634:
5635: CURSOR Insert_Update_Cur(p_customer_trx_line_id IN NUMBER) IS
5636: SELECT INSERT_UPDATE_FLAG

Line 5644: FROM JAI_AR_TRXS

5640: ORDER BY CUSTOMER_TRX_LINE_ID;
5641:
5642: CURSOR SO_AR_HDR_INFO IS
5643: SELECT organization_id, location_id, batch_source_id
5644: FROM JAI_AR_TRXS
5645: WHERE Customer_Trx_ID = v_customer_trx_id;
5646:
5647: CURSOR register_code_cur(p_org_id IN NUMBER, p_loc_id IN NUMBER, p_batch_source_id IN NUMBER) IS
5648: SELECT register_code

Line 6475: FROM jai_ar_trxs

6471: IS
6472: CURSOR get_jai_ar_detail_cur
6473: IS
6474: SELECT *
6475: FROM jai_ar_trxs
6476: WHERE CUSTOMER_TRX_ID = pn_customer_trx_id;
6477:
6478: CURSOR get_item_info_cur
6479: IS

Line 6494: rec_jai_ar_detail jai_ar_trxs%ROWTYPE;

6490:
6491: lv_action VARCHAR2(20) := jai_constants.updating;
6492: lv_return_message VARCHAR2(2000);
6493: lv_return_code VARCHAR2(100) ;
6494: rec_jai_ar_detail jai_ar_trxs%ROWTYPE;
6495: ln_item_id NUMBER;
6496: ln_org_id NUMBER;
6497: v_item_class VARCHAR2(20);
6498: v_payment_register Varchar2(30) ;

Line 6554: FROM jai_ar_trxs

6550: IS
6551: CURSOR organization_id_check(cn_customer_trx_id number) IS
6552: SELECT
6553: NVL(organization_id,-1) organization_id
6554: FROM jai_ar_trxs
6555: WHERE customer_trx_id = cn_customer_trx_id;
6556:
6557: CURSOR get_ar_org_id_cur
6558: IS

Line 6757: FROM JAI_AR_TRXS

6753:
6754:
6755: CURSOR SO_AR_HDR_INFO IS
6756: SELECT organization_id, location_id, batch_source_id
6757: FROM JAI_AR_TRXS
6758: WHERE Customer_Trx_ID = pn_customer_trx_id;
6759:
6760: CURSOR ORG_CUR IS
6761: SELECT ORG_ID, CREATED_FROM

Line 6996: FROM JAI_AR_TRXS

6992: invoice_currency_code,
6993: exchange_rate_type,
6994: exchange_date,
6995: exchange_rate
6996: FROM JAI_AR_TRXS
6997: WHERE customer_trx_id = pn_customer_trx_id;
6998: -- end of modification by subbu and Jagdish on 10-jun-01 for discount issue.
6999: ------------------------------------------------------------------------------------------------
7000: --05-Apr-2002

Line 7035: ln_exchange_rate jai_ar_trxs.exchange_rate%type;

7031: --start additions for bug#9177024
7032:
7033: lv_process_status VARCHAR2(100);
7034: lv_process_message VARCHAR2(2000);
7035: ln_exchange_rate jai_ar_trxs.exchange_rate%type;
7036: lv_account_class_tax VARCHAR2(10) := 'TAX';
7037: lv_account_class_freight VARCHAR2(10) := 'FREIGHT';
7038: lv_account_class_rec VARCHAR2(10) := 'REC';
7039: ln_precision fnd_currencies.precision%TYPE;

Line 8024: ln_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE;

8020:
8021: --VARIABLE DEFINITION AS BELOW
8022: lv_return_code VARCHAR2(100);
8023: lv_return_mess VARCHAR2(2000);
8024: ln_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE;
8025: ln_interface_line_id JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE;
8026: ln_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE;
8027: lv_taxable_event JAI_INTERFACE_LINES_ALL.TAXABLE_EVENT%TYPE;
8028:

Line 8230: UPDATE jai_ar_trxs

8226:
8227: IF nvl(lv_st_tax_exists,'N') = 'N' THEN
8228: lv_st_invoice_num := NULL;
8229: ELSE
8230: UPDATE jai_ar_trxs
8231: SET
8232: st_inv_number = lv_st_invoice_num
8233: WHERE customer_trx_id = ln_customer_trx_id;
8234: END IF;

Line 8244: UPDATE JAI_AR_TRXS

8240: ln_vat_invoice_no := NULL;
8241: --Added by zhiwei for bug#12564566 begin
8242: ------------------------------------------------
8243: ELSE
8244: UPDATE JAI_AR_TRXS
8245: SET
8246: VAT_INVOICE_NO = ln_vat_invoice_no
8247: WHERE CUSTOMER_TRX_ID = ln_customer_trx_id;
8248: ------------------------------------------------

Line 8267: UPDATE JAI_AR_TRXS

8263: END IF;
8264:
8265:
8266: /*--Commented by zhiwei for bug#12564566 begin
8267: UPDATE JAI_AR_TRXS
8268: SET
8269: VAT_INVOICE_NO = ln_vat_invoice_no
8270: WHERE CUSTOMER_TRX_ID = ln_customer_trx_id;
8271: */--Commented by zhiwei for bug#12564566 end

Line 8406: ln_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE;

8402:
8403: --VARIABLE DEFINITION AS BELOW
8404: lv_return_code VARCHAR2(100);
8405: lv_return_message VARCHAR2(2000);
8406: ln_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE;
8407: ln_interface_line_id JAI_INTERFACE_LINES_ALL.INTERFACE_LINE_ID%TYPE;
8408: ln_customer_trx_line_id JAI_AR_TRX_LINES.CUSTOMER_TRX_LINE_ID%TYPE;
8409: lv_taxable_event JAI_INTERFACE_LINES_ALL.TAXABLE_EVENT%TYPE;
8410:

Line 8742: FROM JAI_AR_TRXS

8738: v_batch_source_id NUMBER;
8739:
8740: CURSOR get_header_info_cur IS
8741: SELECT organization_id, location_id, batch_source_id
8742: FROM JAI_AR_TRXS
8743: WHERE customer_trx_id = p_header_id;
8744:
8745: v_debug boolean := true; -- Vijay Shankar for Bug# 2837970
8746: v_line_num number:=1 ;--added by rchandan for bug#6030615

Line 10499: FROM JAI_AR_TRXS

10495: invoice_currency_code,
10496: exchange_rate_type,
10497: exchange_date,
10498: exchange_rate
10499: FROM JAI_AR_TRXS
10500: WHERE customer_trx_id = cn_customer_trx_id;
10501:
10502: c_from_currency_code VARCHAR2(15);
10503: c_conversion_type VARCHAR2(30);