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_TCS_REP_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 1327: CURSOR cur_get_doc_det ( cp_cust_trx_type_id RA_CUST_TRX_TYPES_ALL.CUST_TRX_TYPE_ID%TYPE )

1323:
1324: /*
1325: ||Get the trx type of the document
1326: */
1327: CURSOR cur_get_doc_det ( cp_cust_trx_type_id RA_CUST_TRX_TYPES_ALL.CUST_TRX_TYPE_ID%TYPE )
1328: IS
1329: SELECT
1330: type
1331: FROM

Line 1332: ra_cust_trx_types_all

1328: IS
1329: SELECT
1330: type
1331: FROM
1332: ra_cust_trx_types_all
1333: WHERE
1334: cust_trx_type_id = cp_cust_trx_type_id;
1335:
1336: /*

Line 1417: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;

1413: WHERE
1414: jrct.customer_trx_id = cp_customer_trx_id
1415: AND jrct.customer_trx_id = jrctl.customer_trx_id;
1416:
1417: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
1418: lv_doc_type VARCHAR2(100) ;
1419: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
1420: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
1421: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

Line 3271: ra_cust_trx_types_all trx_types ,

3267: --Modify by Zhiwei for bug#14040855 end
3268: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end
3269: FROM
3270: ra_customer_trx_all rcta ,
3271: ra_cust_trx_types_all trx_types ,
3272: ra_cust_trx_line_gl_dist_all gl_dist ,
3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,
3275: JAI_AR_TRX_TAX_LINES jrcttl ,

Line 3325: ra_cust_trx_types_all trx_types

3321: SELECT
3322: trx_types.type
3323: FROM
3324: ra_customer_trx_all ract,
3325: ra_cust_trx_types_all trx_types
3326: WHERE
3327: ract.cust_trx_type_id = trx_types.cust_trx_type_id
3328: AND ract.customer_trx_id = cp_customer_trx_id;
3329:

Line 3379: ra_cust_trx_types_all trx_types ,

3375: nvl( bill_to_site_use_id , rcta.ship_to_site_use_id ) app_to_customer_site_use_id
3376: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
3377: FROM
3378: ra_customer_trx_all rcta ,
3379: ra_cust_trx_types_all trx_types ,
3380: ra_cust_trx_line_gl_dist_all gl_dist ,
3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,
3383: JAI_AR_TRX_TAX_LINES jrcttl ,

Line 5208: ra_cust_trx_types_all rctt

5204: rctt.gl_id_rec ,
5205: rctt.creation_sign
5206: FROM
5207: ra_batch_sources_all bsa ,
5208: ra_cust_trx_types_all rctt
5209: WHERE
5210: bsa.default_inv_trx_type = rctt.cust_trx_type_id
5211: AND bsa.org_id = rctt.org_id
5212: AND bsa.org_id = cp_org_id

Line 5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;

5250: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5251: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5252: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
5253: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
5254: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
5255: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
5256: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
5257: ln_ccid_tax_type_tcs NUMBER ;
5258: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;