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_JOURNAL_AR_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 23: jg_zz_vat_rep_status vrs

19: BEGIN
20: SELECT max(vrs.period_start_date)
21: INTO l_period_start_date
22: FROM jg_zz_vat_final_reports vfr,
23: jg_zz_vat_rep_status vrs
24: WHERE vfr.report_name = p_report_name
25: AND vfr.vat_register_id = p_vat_register_id
26: AND vrs.reporting_status_id = vfr.reporting_status_id;
27:

Line 31: jg_zz_vat_rep_status vrs

27:
28: SELECT start_sequence_num
29: INTO l_start_seq
30: FROM jg_zz_vat_final_reports vfr,
31: jg_zz_vat_rep_status vrs
32: WHERE vfr.report_name = p_report_name
33: AND vfr.vat_register_id = p_vat_register_id
34: AND vrs.reporting_status_id = vfr.reporting_status_id
35: AND vrs.period_start_date = l_period_start_date;

Line 224: jg_zz_vat_rep_status vrs

220: IF l_reporting_status = 'COPY' THEN
221: SELECT last_start_sequence_num
222: INTO l_start_seq
223: FROM jg_zz_vat_final_reports vfr,
224: jg_zz_vat_rep_status vrs
225: WHERE vfr.report_name = p_report_name
226: AND vfr.vat_register_id = p_vat_register_id
227: AND vrs.reporting_status_id = vfr.reporting_status_id
228: AND vrs.tax_calendar_period = p_period;

Line 287: ,jg_zz_vat_rep_status JZVRS

283:
284: SELECT count ( distinct JZVTD.trx_id )
285: INTO l_sequence_start
286: FROM jg_zz_vat_trx_details JZVTD
287: ,jg_zz_vat_rep_status JZVRS
288:
289: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
290: FROM jg_zz_vat_rep_status JZRS
291: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 290: FROM jg_zz_vat_rep_status JZRS

286: FROM jg_zz_vat_trx_details JZVTD
287: ,jg_zz_vat_rep_status JZVRS
288:
289: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
290: FROM jg_zz_vat_rep_status JZRS
291: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
292: AND JZRS.source = 'AR')
293: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
294: AND JZVRS.source = 'AR'

Line 300: AND JZVRS.reporting_status_id in ( SELECT reporting_status_id FROM jg_zz_vat_rep_status

296: OR (JZVTD.tax_rate_register_type_code = 'INTERIM' AND P_TAX_REGISTER_TYPE = 'INTERIM')
297: OR (JZVTD.tax_rate_register_type_code = 'NON-RECOVERABLE' AND P_TAX_REGISTER_TYPE = 'NON-RECOVERABLE'))
298: AND ( JZVTD.trx_tax_balancing_segment = P_BALANCING_SEGMENT OR P_BALANCING_SEGMENT is NULL )
299: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
300: AND JZVRS.reporting_status_id in ( SELECT reporting_status_id FROM jg_zz_vat_rep_status
301: WHERE period_start_date < l_period_start_date
302: AND vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
303: AND source='AR')
304: AND trunc(l_period_start_date,'YYYY') <= all

Line 543: ,jg_zz_vat_rep_status JZVRS

539: ,jzvar.tax_non_rec_sign_flag
540: )||'1'
541: ) TAX_AMT_FUN_CURR
542: FROM jg_zz_vat_trx_details JZVTD
543: ,jg_zz_vat_rep_status JZVRS
544: ,jg_zz_vat_box_allocs JZVBA
545: ,ra_cust_trx_types RCTT
546: ,jg_zz_vat_alloc_rules jzvar
547: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 686: ,jg_zz_vat_rep_status JZVRS

682: ,JZVTD.TRX_DUE_DATE TRX_DUE_DATE
683: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE
684: FROM jg_zz_vat_trx_details JZVTD
685: ,jg_zz_vat_registers_vl JZVRV
686: ,jg_zz_vat_rep_status JZVRS
687: ,jg_zz_vat_doc_sequences JZVDS
688: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
689: AND JZVRV.vat_reporting_entity_id = JZVRS.mapping_vat_rep_entity_id
690: AND JZVDS.doc_sequence_id = JZVTD.doc_seq_id

Line 801: FROM jg_zz_vat_rep_status

797: last_start_sequence_num = lv_start_seq
798: WHERE report_name = p_report_name
799: AND vat_register_id = p_vat_register_id
800: AND reporting_status_id = (SELECT reporting_status_id
801: FROM jg_zz_vat_rep_status
802: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
803: AND source = 'AR'
804: AND tax_calendar_period = p_period);
805:

Line 863: ,jg_zz_vat_rep_status JZVRS

859: ,SUBSTR(JZVTD.billing_tp_name,1,22) VAT_REGISTER_NAME
860: ,JZVTD.posted_flag POSTED_FLAG
861: FROM jg_zz_vat_trx_details JZVTD
862: ,jg_zz_vat_registers_vl JZVRV
863: ,jg_zz_vat_rep_status JZVRS
864: ,ar_lookups LK
865: ,jg_zz_vat_doc_sequences JZVDS
866: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
867: AND JZVRS.tax_calendar_period = P_PERIOD

Line 980: FROM jg_zz_vat_rep_status

976: last_start_sequence_num = lv_start_seq
977: WHERE report_name = p_report_name
978: AND vat_register_id = p_vat_register_id
979: AND reporting_status_id = (SELECT reporting_status_id
980: FROM jg_zz_vat_rep_status
981: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
982: AND source = 'AR'
983: AND tax_calendar_period = p_period);
984:

Line 1033: ,jg_zz_vat_rep_status JZVRS

1029: ,JZVTD.REPORTING_CODE REPORTING_CODE
1030: ,TAX_RATE_REGISTER_TYPE_CODE REGISTER_TYPE
1031: ,JZVTD.trx_line_id TRX_LINE_ID
1032: FROM jg_zz_vat_trx_details JZVTD
1033: ,jg_zz_vat_rep_status JZVRS
1034: -- ,fnd_lookup_values LK
1035: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1036: FROM jg_zz_vat_rep_status JZRS
1037: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 1036: FROM jg_zz_vat_rep_status JZRS

1032: FROM jg_zz_vat_trx_details JZVTD
1033: ,jg_zz_vat_rep_status JZVRS
1034: -- ,fnd_lookup_values LK
1035: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1036: FROM jg_zz_vat_rep_status JZRS
1037: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1038: AND JZRS.source = 'AR')
1039: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
1040: -- JZVTD.reporting_status_id = JZVRS.reporting_status_id