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 RA_CUSTOMER_TRX_ALL

Line 752: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

748: procedure populate_inv_cm_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
749: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
750: p_from_date IN DATE ,
751: p_to_date IN DATE ,
752: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
753: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
754: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
755: p_process_flag OUT NOCOPY VARCHAR2 ,
756: p_process_message OUT NOCOPY VARCHAR2,

Line 804: ra_customer_trx_all trx ,

800: decode(upper(trx_types.type),cp_invoice_type,nvl(jtc.mod_cr_percentage,0),100) mod_cr_percentage ,
801: jtrxtl.link_to_cust_trx_line_id,
802: nvl(jtc.reverse_charge_flag,'N') reverse_charge_flag --Added by Qiong for reverse charge bug#16001407
803: FROM
804: ra_customer_trx_all trx ,
805: JAI_AR_TRXS jtrx ,
806: ra_cust_trx_types_all trx_types ,
807: JAI_AR_TRX_LINES jtrxl ,
808: JAI_AR_TRX_TAX_LINES jtrxtl ,

Line 1187: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

1183: procedure delete_non_existant_cm ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1184: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1185: p_from_date IN DATE ,
1186: p_to_date IN DATE ,
1187: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1188: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1189: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1190: p_process_flag OUT NOCOPY VARCHAR2 ,
1191: p_process_message OUT NOCOPY VARCHAR2

Line 1214: || in the ra_customer_trx_all table.

1210:
1211: /*
1212: || Get all the cm's which exist in the reference table jai_rgm_trx_refs and have been incompleted/incompleted and deleted from AR base table
1213: || IF a CM has been incompleted then it would exist with complete_flag = 'N' . if a CM has been incompleted and deleted then it would not exist
1214: || in the ra_customer_trx_all table.
1215: */
1216: CURSOR c_get_incompleted_cm
1217: IS
1218: SELECT

Line 1232: ra_customer_trx_all trx ,

1228: nvl(rgtr.recovered_amount,0) <> 0 AND
1229: NOT EXISTS ( SELECT
1230: 1
1231: FROM
1232: ra_customer_trx_all trx ,
1233: ra_cust_trx_types_all trx_types
1234: WHERE
1235: trx.customer_trx_id = rgtr.invoice_id AND
1236: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND

Line 1686: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

1682: procedure populate_cm_app ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
1683: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
1684: p_from_date IN DATE ,
1685: p_to_date IN DATE ,
1686: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
1687: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1688: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
1689: p_process_flag OUT NOCOPY VARCHAR2 ,
1690: p_process_message OUT NOCOPY VARCHAR2

Line 1765: ra_customer_trx_all cm_trx ,

1761: inv_trx.exchange_rate_type invoice_exchange_rate_type
1762: -- Added for Bug 8294236 - End
1763: FROM
1764: ar_receivable_applications_all aral ,
1765: ra_customer_trx_all cm_trx ,
1766: ra_customer_trx_all inv_trx ,
1767: ra_cust_trx_types_all trx_types ,
1768: JAI_AR_TRXS inv_jtrx ,
1769: JAI_AR_TRXS cm_jtrx

Line 1766: ra_customer_trx_all inv_trx ,

1762: -- Added for Bug 8294236 - End
1763: FROM
1764: ar_receivable_applications_all aral ,
1765: ra_customer_trx_all cm_trx ,
1766: ra_customer_trx_all inv_trx ,
1767: ra_cust_trx_types_all trx_types ,
1768: JAI_AR_TRXS inv_jtrx ,
1769: JAI_AR_TRXS cm_jtrx
1770: WHERE

Line 1883: cp_inv_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1879: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -
1880:
1881: */
1882: CURSOR c_get_refinvrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1883: cp_inv_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1884: )
1885: IS
1886: SELECT
1887: reference_id ,

Line 1906: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1902: FOR UPDATE NOWAIT ;
1903:
1904:
1905: CURSOR c_get_refcmrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1906: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1907: )
1908: IS
1909: SELECT
1910: reference_id ,

Line 1929: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

1925: /*
1926: || Get the total effective CM amount from the CM lines in reference table against which a CM application has to be recovered.
1927: */
1928: CURSOR c_get_cmref_totrd_amt ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
1929: cp_cm_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
1930: )
1931: IS
1932: SELECT
1933: nvl(sum(recoverable_amount),0) tot_effcm_rb_amt /*bug 9432780*/

Line 2556: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

2552: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
2553: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
2554: p_from_date IN DATE ,
2555: p_to_date IN DATE ,
2556: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
2557: p_source IN varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
2558: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
2559: p_process_flag OUT NOCOPY VARCHAR2 ,
2560: p_process_message OUT NOCOPY VARCHAR2

Line 2630: ra_customer_trx_all trx ,

2626: -- Added for Bug 8294236
2627: FROM
2628: ar_receivable_applications_all aral ,
2629: ar_cash_receipts_all acrl ,
2630: ra_customer_trx_all trx ,
2631: ra_cust_trx_types_all trx_types ,
2632: JAI_AR_TRXS jtrx
2633: WHERE
2634: aral.cash_receipt_id = acrl.cash_receipt_id AND

Line 2749: cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE

2745: /*
2746: || Get the ref tax lines pertaining to the invoice against which the cash receipt has been applied : -
2747: */
2748: CURSOR c_get_refrec_for_upd ( cp_source_ar varchar2, --File.Sql.35 Cbabu jai_constants.SOURCE_AR%TYPE ,
2749: cp_customer_trx_id RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE
2750: )
2751: IS
2752: SELECT
2753: reference_id ,

Line 3387: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

3383: PROCEDURE populate_repository (p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
3384: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
3385: p_from_date IN DATE ,
3386: p_to_date IN DATE ,
3387: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
3388: p_source IN varchar2 ,
3389: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
3390: p_process_flag OUT NOCOPY VARCHAR2 ,
3391: p_process_message OUT NOCOPY VARCHAR2 ,

Line 3407: ra_customer_trx_all trx ,

3403: SELECT trx.customer_trx_id ,
3404: trx.trx_date
3405:
3406: FROM
3407: ra_customer_trx_all trx ,
3408: ra_cust_trx_types_all trx_types ,
3409: JAI_AR_TRXS jtrx
3410: WHERE
3411: trx_types.cust_trx_type_id = trx.cust_trx_type_id AND

Line 3448: , ra_customer_trx_all trx

3444: , jattl.link_to_cust_trx_line_id
3445: , jtrx.st_inv_number --Added by Qiong for Advanced Receipts
3446: FROM jai_ar_trx_tax_lines jattl
3447: , ra_customer_trx_lines_all trxl
3448: , ra_customer_trx_all trx
3449: , ra_cust_trx_types_all trx_types
3450: , jai_ar_trxs jtrx
3451: , ra_cust_trx_line_gl_dist_all gd --Added by Qiong for bug13540741
3452: WHERE jattl.link_to_cust_trx_line_id = trxl.customer_trx_line_id

Line 3514: , ra_customer_trx_all trx

3510: CURSOR get_reversal_entries_cur (pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
3511: SELECT jcta.tax_type, jattl.customer_trx_line_id, trx.trx_date,
3512: jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100 tax_amt
3513: FROM jai_ar_trx_tax_lines jattl
3514: , ra_customer_trx_all trx
3515: , jai_cmn_taxes_all jcta
3516: WHERE trx.customer_trx_id = pn_invoice_id
3517: AND jattl.link_to_cust_trx_line_id = pn_line_number
3518: AND jattl.tax_id = jcta.tax_id

Line 3552: , ra_customer_trx_all trx

3548: CURSOR get_claim_entries_cur(pn_invoice_id IN NUMBER, pn_line_number IN NUMBER) IS
3549: SELECT jcta.tax_type, (jattl.tax_amount * nvl(jcta.mod_cr_percentage,0)/100) tax_amt,
3550: jattl.customer_trx_line_id, trx.trx_date
3551: FROM jai_ar_trx_tax_lines jattl
3552: , ra_customer_trx_all trx
3553: , jai_cmn_taxes_all jcta
3554: WHERE trx.customer_trx_id = pn_invoice_id
3555: AND jattl.link_to_cust_trx_line_id = pn_line_number
3556: AND jattl.tax_id = jcta.tax_id

Line 3738: , ra_customer_trx_all trx

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
3742: AND trx.complete_flag = 'Y'

Line 3800: , ra_customer_trx_all trx

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
3802: AND araa.cash_receipt_id = acra.cash_receipt_id
3803: AND jcra.cash_receipt_id = acra.cash_receipt_id
3804: AND trx.complete_flag = 'Y'

Line 4630: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,

4626: procedure process_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
4627: p_organization_type IN JAI_RGM_PARTIES.ORGANIZATION_TYPE%TYPE ,
4628: p_from_date IN DATE ,
4629: p_to_date IN DATE ,
4630: p_org_id IN RA_CUSTOMER_TRX_ALL.ORG_ID%TYPE ,
4631: p_batch_id IN JAI_RGM_TRX_REFS.BATCH_ID%TYPE ,
4632: p_process_flag OUT NOCOPY VARCHAR2 ,
4633: p_process_message OUT NOCOPY VARCHAR2 ,
4634: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL /*5879769*/

Line 5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;

5187: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE;
5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5192: lv_trx_number_prefix RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5193: ln_ccid_tax_type NUMBER;
5194: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE;
5195: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;

Line 5192: lv_trx_number_prefix RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;

5188: lv_batch_src_name JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5189: ln_term_id RA_CUST_TRX_TYPES_ALL.DEFAULT_TERM%TYPE;
5190: ln_bill_to_address_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
5191: lv_trx_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5192: lv_trx_number_prefix RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE;
5193: ln_ccid_tax_type NUMBER;
5194: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE;
5195: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
5196: ln_amount NUMBER;