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 837: CURSOR cur_get_doc_det ( cp_cust_trx_type_id RA_CUST_TRX_TYPES_ALL.CUST_TRX_TYPE_ID%TYPE )

833:
834: /*
835: ||Get the trx type of the document
836: */
837: CURSOR cur_get_doc_det ( cp_cust_trx_type_id RA_CUST_TRX_TYPES_ALL.CUST_TRX_TYPE_ID%TYPE )
838: IS
839: SELECT
840: type
841: FROM

Line 842: ra_cust_trx_types_all

838: IS
839: SELECT
840: type
841: FROM
842: ra_cust_trx_types_all
843: WHERE
844: cust_trx_type_id = cp_cust_trx_type_id;
845:
846: /*

Line 923: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;

919: WHERE
920: jrct.customer_trx_id = cp_customer_trx_id
921: AND jrct.customer_trx_id = jrctl.customer_trx_id;
922:
923: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
924: lv_doc_type VARCHAR2(100) ;
925: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
926: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
927: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

Line 2750: ra_cust_trx_types_all trx_types ,

2746: nvl(bill_to_customer_id, ship_to_customer_id) app_to_customer_id , -- Bug 6132484
2747: nvl(bill_to_site_use_id,ship_to_site_use_id) app_to_customer_site_use_id -- Bug 6132484
2748: FROM
2749: ra_customer_trx_all rcta ,
2750: ra_cust_trx_types_all trx_types ,
2751: ra_cust_trx_line_gl_dist_all gl_dist ,
2752: JAI_AR_TRXS jrct ,
2753: JAI_AR_TRX_LINES jrctl ,
2754: JAI_AR_TRX_TAX_LINES jrcttl ,

Line 2804: ra_cust_trx_types_all trx_types

2800: SELECT
2801: trx_types.type
2802: FROM
2803: ra_customer_trx_all ract,
2804: ra_cust_trx_types_all trx_types
2805: WHERE
2806: ract.cust_trx_type_id = trx_types.cust_trx_type_id
2807: AND ract.customer_trx_id = cp_customer_trx_id;
2808:

Line 2854: ra_cust_trx_types_all trx_types ,

2850: nvl( bill_to_customer_id , ship_to_customer_id ) app_to_customer_id ,
2851: nvl( bill_to_site_use_id , ship_to_site_use_id ) app_to_customer_site_use_id
2852: FROM
2853: ra_customer_trx_all rcta ,
2854: ra_cust_trx_types_all trx_types ,
2855: ra_cust_trx_line_gl_dist_all gl_dist ,
2856: JAI_AR_TRXS jrct ,
2857: JAI_AR_TRX_LINES jrctl ,
2858: JAI_AR_TRX_TAX_LINES jrcttl ,

Line 4637: ra_cust_trx_types_all rctt

4633: rctt.gl_id_rec ,
4634: rctt.creation_sign
4635: FROM
4636: ra_batch_sources_all bsa ,
4637: ra_cust_trx_types_all rctt
4638: WHERE
4639: bsa.default_inv_trx_type = rctt.cust_trx_type_id
4640: AND bsa.org_id = rctt.org_id
4641: AND bsa.org_id = cp_org_id

Line 4674: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;

4670: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4671: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4672: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4673: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4674: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE ;
4675: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%type ;
4676: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ;
4677: ln_ccid_tax_type_tcs NUMBER ;
4678: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;