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_AP_TCS_PROCESSING_PKG dependencies on JAI_RGM_SETTLEMENTS

Line 44: Added jai_rgm_settlements.status='SETTLED' condition in the cursor

40: TCS Certificates are generated without the TCS invoice is been paid and settled.
41: Fix:
42: TCS certificates will be generated only if the TCS invoice is been settled.
43: Changes:
44: Added jai_rgm_settlements.status='SETTLED' condition in the cursor
45: c_group_for_certificate.
46:
47: 5. 27-Oct-2010 Bug 10201267
48: Description: A single certificate is generated for Traansactions with

Line 104: JAI_RGM_SETTLEMENTS jrs

100: jrs.tax_authority_id,
101: jrs.tax_authority_site_id,
102: jrr.item_classification
103: FROM JAI_RGM_REFS_ALL jrr,
104: JAI_RGM_SETTLEMENTS jrs
105: WHERE jrr.settlement_id = jrs.settlement_id
106: AND jrr.source_document_date BETWEEN pd_rgm_from_date and pd_rgm_to_date
107: AND jrr.certificate_id IS NULL
108: AND jrs.status='SETTLED' --added for bug#8679068

Line 214: jai_rgm_settlements jrs

210: , last_update_date = sysdate
211: , last_update_login = ln_last_update_login
212: where trx_ref_id in ( SELECT jrr.trx_ref_id
213: FROM jai_rgm_refs_all jrr,
214: jai_rgm_settlements jrs
215: WHERE jrr.settlement_id = jrs.settlement_id
216: AND jrr.source_document_date BETWEEN ld_from_date and ld_to_date
217: AND jrr.certificate_id IS NULL
218: AND jrs.tax_authority_id = cur_rec.tax_authority_id