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_CMN_ST_FORMS_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1100: v_invoice_id ra_customer_trx_all.customer_trx_id%type;

1096: )
1097: is
1098: v_errbuf varchar2(255);
1099: v_ret_code varchar2(255);
1100: v_invoice_id ra_customer_trx_all.customer_trx_id%type;
1101: v_sp_org_id number; -- used to indicate whether to run concurrent program for a particular org id or all org ids
1102:
1103:
1104: -- trace generation logic

Line 1796: from ra_customer_Trx_all trx ,

1792: cursor c_fetch_records is
1793: select trx.customer_trx_id , trx.org_id , trx.trx_number , trx.cust_trx_type_id , trx.created_from,
1794: nvl(trx.bill_to_customer_id,trx.ship_to_customer_id) customer_id, nvl(trx.bill_to_site_use_id,trx.ship_to_site_use_id) customer_site_id,
1795: decode( trx_types.TYPE ,'INV','Invoice','CM','Credit Memo','DM','Debit Memo',trx_types.TYPE ) document_type /*JMEENA for bug#4932256( FP 4913641)*/
1796: from ra_customer_Trx_all trx ,
1797: ra_cust_trx_types_all trx_types ,
1798: jai_ar_trxs jtrx /* Added for bug#5376622 */
1799: where
1800: trx.customer_trx_id = jtrx.customer_trx_id AND

Line 1895: v_created_from ra_customer_trx_all.created_from%type;

1891: v_record_exists number;
1892: v_ret_code number;
1893: v_errbuf varchar2(255);
1894: v_sqlerrm varchar2(255);
1895: v_created_from ra_customer_trx_all.created_from%type;
1896: const_manual constant ra_customer_trx_all.created_from%type := 'ARXTWMAI';
1897: const_autoinv constant ra_customer_trx_all.created_from%type := 'RAXTRX';
1898: v_some_errors char(1); -- := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1899: v_orgn_id number;

Line 1896: const_manual constant ra_customer_trx_all.created_from%type := 'ARXTWMAI';

1892: v_ret_code number;
1893: v_errbuf varchar2(255);
1894: v_sqlerrm varchar2(255);
1895: v_created_from ra_customer_trx_all.created_from%type;
1896: const_manual constant ra_customer_trx_all.created_from%type := 'ARXTWMAI';
1897: const_autoinv constant ra_customer_trx_all.created_from%type := 'RAXTRX';
1898: v_some_errors char(1); -- := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1899: v_orgn_id number;
1900: v_locn_id number;

Line 1897: const_autoinv constant ra_customer_trx_all.created_from%type := 'RAXTRX';

1893: v_errbuf varchar2(255);
1894: v_sqlerrm varchar2(255);
1895: v_created_from ra_customer_trx_all.created_from%type;
1896: const_manual constant ra_customer_trx_all.created_from%type := 'ARXTWMAI';
1897: const_autoinv constant ra_customer_trx_all.created_from%type := 'RAXTRX';
1898: v_some_errors char(1); -- := '0'; -- used to identify if all was successful --Ramananda for File.Sql.35
1899: v_orgn_id number;
1900: v_locn_id number;
1901: v_trx_type ra_cust_trx_types_all.type%type;