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.JG_ZZ_VAT_PRE_REP_PROC_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 106: FROM jg_zz_vat_trx_details JGTRD,

102:
103: CURSOR c_is_mgr_trx_exist(pn_vat_rep_entity_id number)
104: IS
105: SELECT JGTRD.trx_id
106: FROM jg_zz_vat_trx_details JGTRD,
107: jg_zz_vat_rep_status JGREPS,
108: zx_lines ZX
109: WHERE JGREPS.vat_reporting_entity_id = pn_vat_rep_entity_id
110: AND JGREPS.reporting_status_id = JGTRD.reporting_status_id

Line 291: jg_zz_vat_trx_details trxd

287: )
288: AND zxl.trx_id NOT IN
289: (SELECT trxd.trx_id
290: FROM jg_zz_vat_rep_Status reps ,
291: jg_zz_vat_trx_details trxd
292: WHERE reps.reporting_status_id = trxd.reporting_status_id
293: AND reps.final_reporting_status_flag IS NOT NULL
294: AND reps.final_reporting_process_id IS NOT NULL
295: AND reps.final_reporting_process_date IS NOT NULL