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 270: jg_zz_vat_trx_details trxd

266: )
267: AND zxl.trx_id NOT IN
268: (SELECT trxd.trx_id
269: FROM jg_zz_vat_rep_Status reps ,
270: jg_zz_vat_trx_details trxd
271: WHERE reps.reporting_status_id = trxd.reporting_status_id
272: AND reps.final_reporting_status_flag IS NOT NULL
273: AND reps.final_reporting_process_id IS NOT NULL
274: AND reps.final_reporting_process_date IS NOT NULL