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_IMPORT_SYNC_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 993: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type)

989: WHERE
990: customer_trx_id = pr_new.customer_trx_id ;
991:
992:
993: CURSOR cur_get_gl_date(cp_account_class ra_cust_trx_line_gl_dist_all.account_class%type)
994: IS
995: SELECT
996: gl_date
997: FROM

Line 998: ra_cust_trx_line_gl_dist_all

994: IS
995: SELECT
996: gl_date
997: FROM
998: ra_cust_trx_line_gl_dist_all
999: WHERE
1000: customer_trx_id = pr_new.customer_trx_id AND
1001: account_class = cp_account_class AND
1002: latest_rec_flag = 'Y';

Line 1017: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;

1013: lv_pla_cess_avlbl VARCHAR2(10);
1014: lv_vat_invoice_number JAI_AR_TRXS.VAT_INVOICE_NO%TYPE;
1015: lv_vat_taxes_exist VARCHAR2(1);
1016: lv_vat_no_same_exc_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1017: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE;
1018: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
1019: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1020:
1021:

Line 2141: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;

2137: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
2138: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ;
2139: lv_process_flag VARCHAR2(10) ;
2140: lv_process_message VARCHAR2(4000) ;
2141: ld_gl_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
2142: ld_vat_invoice_date JAI_AR_TRXS.VAT_INVOICE_DATE%TYPE ;
2143:
2144: ln_rma_flag NUMBER;
2145: ln_order_line_id NUMBER;

Line 2239: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)

2235: AND regime_code = jai_constants.vat_regime
2236: AND jtc.org_id = pr_new.org_id ;
2237:
2238:
2239: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)
2240: IS
2241: SELECT gl_date
2242: FROM ra_cust_trx_line_gl_dist_all
2243: WHERE customer_trx_id = pr_new.customer_trx_id

Line 2242: FROM ra_cust_trx_line_gl_dist_all

2238:
2239: CURSOR cur_get_gl_date(cp_acct_class ra_cust_trx_line_gl_dist_all.account_class%type)
2240: IS
2241: SELECT gl_date
2242: FROM ra_cust_trx_line_gl_dist_all
2243: WHERE customer_trx_id = pr_new.customer_trx_id
2244: AND account_class = cp_acct_class
2245: AND latest_rec_flag = 'Y';
2246: