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_RGM_PROCESSING_PKG dependencies on JAI_AR_CASH_RECEIPTS_ALL

Line 924: jai_ar_cash_receipts_all jcra,

920: jdt.tax_amt tax_amount,
921: jdt.func_tax_amt,
922: acra.amount receipt_amount
923: FROM ar_cash_receipts_all acra,
924: jai_ar_cash_receipts_all jcra,
925: jai_cmn_document_taxes jdt ,
926: JAI_CMN_TAXES_ALL jtc ,
927: jai_regime_tax_types_v jrttv
928: WHERE acra.cash_receipt_id = jcra.cash_receipt_id

Line 3612: jai_ar_cash_receipts_all jcra

3608: , jcra.service_type_code
3609: , jcra.exchange_rate
3610: , jcra.exchange_rate_type
3611: FROM
3612: jai_ar_cash_receipts_all jcra
3613: , ar_cash_receipts_all acra
3614: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3615: AND jcra.confirm_flag = 'Y'
3616: AND jcra.document_type = 'Service'

Line 3640: , jai_ar_cash_receipts_all jacr

3636: jdt.tax_type,
3637: jdt.tax_amt,
3638: jdt.func_tax_amt
3639: FROM jai_cmn_document_taxes jdt
3640: , jai_ar_cash_receipts_all jacr
3641: , jai_cmn_taxes_all jcta
3642: , jai_regime_tax_types_v jrttv
3643: WHERE jacr.cash_receipt_id = cn_cash_receipt_id
3644: AND jdt.source_doc_id = jacr.cash_receipt_id

Line 3671: jai_ar_cash_receipts_all jcra

3667: , jcra.service_type_code
3668: , jcra.exchange_rate
3669: , jcra.exchange_rate_type
3670: FROM
3671: jai_ar_cash_receipts_all jcra
3672: , ar_cash_receipts_all acra
3673: , ar_cash_receipt_history_all acrh --Added by Qiong for bug13555753
3674: WHERE jcra.cash_receipt_id = acra.cash_receipt_id
3675: AND jcra.confirm_flag = 'Y'

Line 3737: , jai_ar_cash_receipts_all jcra

3733: --Added by Qinglei on 05-Jan-2012 for bug#13556198
3734: FROM
3735: ar_receivable_applications_all araa
3736: , ar_cash_receipts_all acra
3737: , jai_ar_cash_receipts_all jcra
3738: , ra_customer_trx_all trx
3739: WHERE araa.applied_customer_trx_id = trx.customer_trx_id
3740: AND araa.cash_receipt_id = acra.cash_receipt_id
3741: AND jcra.cash_receipt_id = acra.cash_receipt_id

Line 3797: jai_ar_cash_receipts_all jcra

3793: nvl(araa.unearned_discount_taken, 0))) discount_amount
3794: , acra.set_of_books_id
3795: --Added by Qinglei on 05-Jan-2012 for bug#13556198
3796: FROM
3797: jai_ar_cash_receipts_all jcra
3798: , ar_cash_receipts_all acra
3799: , ar_receivable_applications_all araa
3800: , ra_customer_trx_all trx
3801: WHERE araa.applied_customer_trx_id = trx.customer_trx_id

Line 5076: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

5072: IS
5073: /*****
5074: || Get the details of the cash_receipts
5075: *****/
5076: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
5077: IS
5078: SELECT *
5079: FROM
5080: jai_ar_cash_receipts_all jcra

Line 5080: jai_ar_cash_receipts_all jcra

5076: CURSOR cur_get_cr_details ( cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
5077: IS
5078: SELECT *
5079: FROM
5080: jai_ar_cash_receipts_all jcra
5081: WHERE
5082: jcra.cash_receipt_id = cp_cash_receipt_id ;
5083:
5084: /*****

Line 5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;

5197: ln_user_id ra_interface_lines_all.CREATED_BY%TYPE;
5198: ln_login_id ra_interface_lines_all.LAST_UPDATE_LOGIN%TYPE;
5199: lv_process_message VARCHAR2(4000);
5200:
5201: rec_cur_get_cr_details JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE;
5202: rec_cur_get_rcpt_taxes cur_get_rcpt_taxes%ROWTYPE;
5203: rec_ra_interface_lines ra_interface_lines_all%ROWTYPE;
5204: rec_ra_interface_dist ra_interface_distributions_all%ROWTYPE;
5205: ln_rcpt_amount NUMBER;

Line 5745: -- PARAMETERS: p_jacr rowtype of jai_ar_cash_receipts_all

5741: END generate_cm_dm;
5742:
5743: --========================================================================
5744: -- PROCEDURE : generate_gl_entry PUBLIC
5745: -- PARAMETERS: p_jacr rowtype of jai_ar_cash_receipts_all
5746: -- : p_acra rowtype of ar_cash_receipts_all
5747: -- : p_araa rowtype of ar_receivable_applications_all
5748: -- : p_document_type
5749: -- : p_regime_id

Line 5763: ( p_jacr IN JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE

5759: -- EXCEPTIONS:
5760: --
5761: --========================================================================
5762: PROCEDURE generate_gl_entry
5763: ( p_jacr IN JAI_AR_CASH_RECEIPTS_ALL%ROWTYPE
5764: ,p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE
5765: ,p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL
5766: ,p_document_type IN VARCHAR2
5767: ,pn_regime_id IN NUMBER

Line 6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

6010:
6011: /*
6012: || Check that the document has has Service tax.
6013: */
6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6015: IS
6016: SELECT 1
6017: FROM jai_ar_cash_receipts_all jcra,
6018: jai_cmn_document_taxes jdt,

Line 6017: FROM jai_ar_cash_receipts_all jcra,

6013: */
6014: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6015: IS
6016: SELECT 1
6017: FROM jai_ar_cash_receipts_all jcra,
6018: jai_cmn_document_taxes jdt,
6019: jai_regime_tax_types_v jrttv
6020: WHERE jcra.cash_receipt_id = cp_cash_receipt_id
6021: AND jcra.cash_receipt_id = jdt.source_doc_id

Line 6066: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

6062: IS
6063: /*
6064: ||Get the sign of the Cash receipt document
6065: */
6066: CURSOR cur_get_cr_sign (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6067: IS
6068: SELECT
6069: sign (nvl(amount,0)) app_fr_sign
6070: FROM

Line 6086: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )

6082:
6083: /*
6084: || Check that the document has has Service tax.
6085: */
6086: CURSOR cur_chk_st_applicable (cp_cash_receipt_id JAI_AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE )
6087: IS
6088: SELECT
6089: 1
6090: FROM

Line 6091: jai_ar_cash_receipts_all jcra ,

6087: IS
6088: SELECT
6089: 1
6090: FROM
6091: jai_ar_cash_receipts_all jcra ,
6092: jai_cmn_document_taxes jdt ,
6093: jai_regime_tax_types_v jrttv
6094: WHERE
6095: jcra.cash_receipt_id = cp_cash_receipt_id