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 ZX_LINES

Line 108: zx_lines ZX

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
111: AND JGREPS.source = JGTRD.extract_source_ledger
112: AND ZX.trx_id = JGTRD.trx_id

Line 251: 'UPDATE zx_lines zxl

247:
248: << continue_loop >>
249:
250: l_update_query_ap :=
251: 'UPDATE zx_lines zxl
252: SET zxl.legal_reporting_status =''000000000000000''
253: ,LAST_UPDATED_BY = -5
254: ,LAST_UPDATE_DATE = sysdate
255: ,OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 374: FROM zx_lines_det_factors zxd

370: l_update_query_ap := l_update_query_ap ||
371: ' AND zxl.application_id = 200
372: AND zxl.trx_id IN
373: (SELECT zxd.trx_id
374: FROM zx_lines_det_factors zxd
375: WHERE zxd.tax_invoice_date > $l_end_date$
376: AND zxd.application_id = zxl.application_id
377: AND zxd.EVENT_CLASS_CODE = zxl.EVENT_CLASS_CODE
378: AND zxd.ENTITY_CODE = zxl.entity_code

Line 387: FROM zx_lines_det_factors zxd

383: l_update_query_ar := l_update_query_ar ||
384: ' AND zxl.application_id = 222
385: AND zxl.trx_id IN
386: (SELECT zxd.trx_id
387: FROM zx_lines_det_factors zxd
388: WHERE zxd.tax_invoice_date > $l_end_date$
389: AND zxd.application_id = zxl.application_id
390: AND zxd.EVENT_CLASS_CODE = zxl.EVENT_CLASS_CODE
391: AND zxd.ENTITY_CODE = zxl.entity_code