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 249: jg_zz_vat_rep_status vrs

245: IF l_reporting_status = 'COPY' THEN
246: SELECT last_start_sequence_num
247: INTO l_start_seq
248: FROM jg_zz_vat_final_reports vfr,
249: jg_zz_vat_rep_status vrs
250: WHERE vfr.report_name = p_report_name
251: AND vfr.vat_register_id = p_vat_register_id
252: AND vrs.reporting_status_id = vfr.reporting_status_id
253: AND vrs.tax_calendar_period = p_period;

Line 314: ,jg_zz_vat_rep_status JZVRS

310:
311: SELECT count ( distinct JZVTD.trx_id )
312: INTO l_sequence_start
313: FROM jg_zz_vat_trx_details JZVTD
314: ,jg_zz_vat_rep_status JZVRS
315:
316: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
317: FROM jg_zz_vat_rep_status JZRS
318: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 317: FROM jg_zz_vat_rep_status JZRS

313: FROM jg_zz_vat_trx_details JZVTD
314: ,jg_zz_vat_rep_status JZVRS
315:
316: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
317: FROM jg_zz_vat_rep_status JZRS
318: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
319: AND JZRS.source = 'AR')
320: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
321: AND JZVRS.source = 'AR'

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

323: OR (JZVTD.tax_rate_register_type_code = 'INTERIM' AND P_TAX_REGISTER_TYPE = 'INTERIM')
324: OR (JZVTD.tax_rate_register_type_code = 'NON-RECOVERABLE' AND P_TAX_REGISTER_TYPE = 'NON-RECOVERABLE'))
325: AND ( JZVTD.trx_tax_balancing_segment = P_BALANCING_SEGMENT OR P_BALANCING_SEGMENT is NULL )
326: AND JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
327: AND JZVRS.reporting_status_id in ( SELECT reporting_status_id FROM jg_zz_vat_rep_status
328: WHERE period_start_date < l_period_start_date
329: AND vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
330: AND source='AR')
331: AND trunc(l_period_start_date,'YYYY') <= all

Line 523: ,jg_zz_vat_rep_status JZVRS

519: ,NVL(JZVTD.taxable_amt_funcl_curr,0) * to_number(jzvar.taxable_rec_sign_flag ||'1') TAXABLE_AMOUNT --bug10103169
520: ,NVL(JZVTD.taxable_amt_funcl_curr,0) * to_number(jzvar.taxable_rec_sign_flag ||'1') TAXABLE_AMT_FUN_CURR --bug10103169
521: ,NVL(JZVTD.tax_amt_funcl_curr,0) * to_number(jzvar.tax_rec_sign_flag ||'1') TAX_AMT_FUN_CURR --bug10103169
522: FROM jg_zz_vat_trx_details JZVTD
523: ,jg_zz_vat_rep_status JZVRS
524: ,jg_zz_vat_box_allocs JZVBA
525: ,ra_cust_trx_types RCTT
526: ,jg_zz_vat_alloc_rules jzvar
527: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 667: ,jg_zz_vat_rep_status JZVRS

663: ,JZVTD.TRX_DUE_DATE TRX_DUE_DATE
664: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE
665: FROM jg_zz_vat_trx_details JZVTD
666: ,jg_zz_vat_registers_vl JZVRV
667: ,jg_zz_vat_rep_status JZVRS
668: ,jg_zz_vat_doc_sequences JZVDS
669: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
670: AND JZVRV.vat_reporting_entity_id = JZVRS.mapping_vat_rep_entity_id
671: AND JZVDS.doc_sequence_id = JZVTD.doc_seq_id

Line 782: FROM jg_zz_vat_rep_status

778: last_start_sequence_num = lv_start_seq
779: WHERE report_name = p_report_name
780: AND vat_register_id = p_vat_register_id
781: AND reporting_status_id = (SELECT reporting_status_id
782: FROM jg_zz_vat_rep_status
783: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
784: AND source = 'AR'
785: AND tax_calendar_period = p_period);
786:

Line 845: ,jg_zz_vat_rep_status JZVRS

841: ,JZVTD.posted_flag POSTED_FLAG
842: ,JZVTD.ACCOUNTING_DATE ACCOUNTING_DATE -- bug9872998
843: FROM jg_zz_vat_trx_details JZVTD
844: ,jg_zz_vat_registers_vl JZVRV
845: ,jg_zz_vat_rep_status JZVRS
846: ,ar_lookups LK
847: ,jg_zz_vat_doc_sequences JZVDS
848: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
849: AND JZVRS.tax_calendar_period = P_PERIOD

Line 964: FROM jg_zz_vat_rep_status

960: last_start_sequence_num = lv_start_seq
961: WHERE report_name = p_report_name
962: AND vat_register_id = p_vat_register_id
963: AND reporting_status_id = (SELECT reporting_status_id
964: FROM jg_zz_vat_rep_status
965: WHERE vat_reporting_entity_id = p_vat_rep_entity_id
966: AND source = 'AR'
967: AND tax_calendar_period = p_period);
968:

Line 1018: ,jg_zz_vat_rep_status JZVRS

1014: ,JZVTD.REPORTING_CODE REPORTING_CODE
1015: ,TAX_RATE_REGISTER_TYPE_CODE REGISTER_TYPE
1016: ,JZVTD.trx_line_id TRX_LINE_ID
1017: FROM jg_zz_vat_trx_details JZVTD
1018: ,jg_zz_vat_rep_status JZVRS
1019: -- ,fnd_lookup_values LK
1020: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1021: FROM jg_zz_vat_rep_status JZRS
1022: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID

Line 1021: FROM jg_zz_vat_rep_status JZRS

1017: FROM jg_zz_vat_trx_details JZVTD
1018: ,jg_zz_vat_rep_status JZVRS
1019: -- ,fnd_lookup_values LK
1020: WHERE JZVTD.reporting_status_id in (SELECT DISTINCT JZRS.reporting_status_id JZRS
1021: FROM jg_zz_vat_rep_status JZRS
1022: WHERE JZRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1023: AND JZRS.source = 'AR')
1024: AND JZVTD.gl_date BETWEEN JZVRS.period_start_date and JZVRS.period_end_date
1025: -- JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 1036: FROM JG_ZZ_VAT_REP_STATUS RPS1,

1032: OR (JZVTD.tax_rate_register_type_code = 'NON-RECOVERABLE' AND P_TAX_REGISTER_TYPE = 'NON-RECOVERABLE'))
1033: AND JZVTD.reporting_code = P_TAX_TYPE --BUG:9223611
1034: -- Bug8267272 Start
1035: AND JZVRS.tax_calendar_period IN (SELECT RPS1.tax_calendar_period
1036: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1037: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1038: min(period_start_date) period_start_date
1039: From JG_ZZ_VAT_REP_STATUS
1040: Where vat_reporting_entity_id = p_vat_rep_entity_id

Line 1039: From JG_ZZ_VAT_REP_STATUS

1035: AND JZVRS.tax_calendar_period IN (SELECT RPS1.tax_calendar_period
1036: FROM JG_ZZ_VAT_REP_STATUS RPS1,
1037: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1038: min(period_start_date) period_start_date
1039: From JG_ZZ_VAT_REP_STATUS
1040: Where vat_reporting_entity_id = p_vat_rep_entity_id
1041: And tax_calendar_period =p_period) RPS2,
1042: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1043: min(period_end_date) period_end_date

Line 1044: From JG_ZZ_VAT_REP_STATUS

1040: Where vat_reporting_entity_id = p_vat_rep_entity_id
1041: And tax_calendar_period =p_period) RPS2,
1042: (Select min(vat_reporting_entity_id) vat_reporting_entity_id,
1043: min(period_end_date) period_end_date
1044: From JG_ZZ_VAT_REP_STATUS
1045: Where vat_reporting_entity_id = p_vat_rep_entity_id
1046: And tax_calendar_period = p_period_to) RPS3
1047: WHERE RPS1.vat_reporting_entity_id = p_vat_rep_entity_id
1048: AND RPS2.vat_reporting_entity_id = RPS1.vat_reporting_entity_id