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_AUDIT_AR_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 158: FROM jg_zz_vat_trx_gt;

154: -- Record count check
155: CURSOR c_count
156: IS
157: SELECT COUNT(*)
158: FROM jg_zz_vat_trx_gt;
159:
160: l_rec_count NUMBER;
161: lc_curr_code VARCHAR2(50);
162: lc_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;

Line 223: INSERT INTO jg_zz_vat_trx_gt

219: l_rec_count:=0;
220: t_total_amount := 0;
221: FOR r_jgbevat IN c_jgbevat
222: LOOP
223: INSERT INTO jg_zz_vat_trx_gt
224: (jg_info_v1 -- BE_DOC_SEQ_VALUE
225: ,jg_info_v2 -- CUSTOMER_NAME
226: ,jg_info_v3 -- ADDRESS1
227: ,jg_info_v4 -- CUSTOMER_NUMBER

Line 275: INSERT INTO jg_zz_vat_trx_gt

271:
272: l_rec_count:=0;
273: FOR r_jgczvat IN c_jgczvat
274: LOOP
275: INSERT INTO jg_zz_vat_trx_gt
276: (jg_info_v1 -- CZ_DOC_SEQ_VALUE
277: ,jg_info_v2 -- FUNCTIONAL_CURRENCY_CODE
278: ,jg_info_v3 -- VAT_BOX
279: ,jg_info_v4 -- VAT_BOX_DESC

Line 303: INSERT INTO jg_zz_vat_trx_gt

299:
300: l_rec_count:=0;
301: FOR r_jgzzaudar IN c_jgzzaudar
302: LOOP
303: INSERT INTO jg_zz_vat_trx_gt
304: (jg_info_v1 -- AR_DOC_SEQ_VALUE
305: ,jg_info_v2 -- CUSTOMER_NAME
306: ,jg_info_v3 -- ADDRESS1
307: ,jg_info_v4 -- CUSTOMER_NUMBER

Line 398: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1 -- curr_code

394:
395:
396: if gv_debug then fnd_file.put_line(fnd_file.log,'Calling common pack Inserting Header Info'); end if;
397:
398: INSERT INTO jg_zz_vat_trx_gt (jg_info_v1 -- curr_code
399: ,jg_info_v2 -- entity_name
400: ,jg_info_v3 -- taxpayer_id
401: ,jg_info_v4 -- company_name
402: ,jg_info_v5 -- registration_number