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

Line 252: ,jg_zz_vat_rep_status jzvrs

248: ,jzvtd.offset_tax_rate_code
249: ,jzvtd.chk_vat_amount_paid CHK_VAT_AMOUNT_PAID
250: ,jzvrs.period_end_date
251: FROM jg_zz_vat_trx_details jzvtd
252: ,jg_zz_vat_rep_status jzvrs
253: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
254: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
255: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id
256: AND jzvtd.tax_rate_register_type_code = 'TAX'

Line 337: ,jg_zz_vat_rep_status jzvrs

333: ,jzvtd.offset_tax_rate_code
334: ,jzvtd.chk_vat_amount_paid chk_vat_amount_paid
335: ,jzvrs.period_end_date
336: FROM jg_zz_vat_trx_details jzvtd
337: ,jg_zz_vat_rep_status jzvrs
338: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
339: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
340: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id
341: -- AND jzvtd.tax_rate_register_type_code = 'TAX'

Line 392: jg_zz_vat_rep_status JZVRS

388: jg_info_n5 trx_id,
389: jg_info_v15 reporting_code
390: FROM JG_ZZ_VAT_TRX_GT tmp,
391: gl_periods glp,
392: jg_zz_vat_rep_status JZVRS
393: WHERE jg_info_v9 = 'M'
394: AND JZVRS.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
395: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
396: AND GLP.period_set_name = jzvrs.tax_calendar_name

Line 447: ,jg_zz_vat_rep_status jzvrs

443: ,jzvtd.chk_vat_amount_paid chk_vat_amount_paid
444: ,jzvrs.period_end_date
445: ,jzvtd.reporting_code
446: FROM jg_zz_vat_trx_details jzvtd
447: ,jg_zz_vat_rep_status jzvrs
448: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
449: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
450: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id
451: AND jzvrs.source = 'AP'

Line 467: ,jg_zz_vat_rep_status jzvrs

463: IS
464: SELECT jzvtd.rep_context_entity_name company_name
465: ,jzvtd.functional_currency_code functional_currency_code
466: FROM jg_zz_vat_trx_details jzvtd
467: ,jg_zz_vat_rep_status jzvrs
468: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
469: AND jzvrs.source = 'AP'
470: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
471: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id

Line 478: ,jg_zz_vat_rep_status jzvrs

474: CURSOR c_vat_or_offset (p_tax_rate_code VARCHAR2)
475: IS
476: SELECT MIN(-9999) vat_or_offset
477: FROM jg_zz_vat_trx_details jzvtd
478: ,jg_zz_vat_rep_status jzvrs
479: WHERE jzvtd.tax_rate_code = p_tax_rate_code
480: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id
481: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
482: AND jzvrs.source = 'AP'

Line 489: FROM jg_zz_vat_rep_status jzvrs

485:
486: CURSOR c_period_end_date
487: IS
488: SELECT period_end_date
489: FROM jg_zz_vat_rep_status jzvrs
490: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
491: AND jzvrs.source = 'AP'
492: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD;
493:

Line 517: ,jg_zz_vat_rep_status jzvrs

513: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-A',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_fixed_assets
514: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,'VAT-S',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
515: ,'S' class
516: FROM jg_zz_vat_trx_details jzvtd
517: ,jg_zz_vat_rep_status jzvrs
518: ,ap_invoices_all apinv
519: WHERE jzvrs.source='AP'
520: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
521: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD

Line 563: ,jg_zz_vat_rep_status jzvrs

559: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,
560: 'VAT-KS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
561: ,'P' class
562: FROM jg_zz_vat_trx_details jzvtd
563: ,jg_zz_vat_rep_status jzvrs
564: ,ap_invoices_all apinv
565: WHERE jzvrs.source='AP'
566: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
567: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD

Line 615: ,jg_zz_vat_rep_status jzvrs

611: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,
612: 'VAT-RS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
613: , 'I' class
614: FROM jg_zz_vat_trx_details jzvtd
615: ,jg_zz_vat_rep_status jzvrs
616: ,ap_invoices_all apinv
617: ,ap_invoice_lines_all apinvl
618: ,zx_lines zxl
619: WHERE jzvrs.source='AP'

Line 1465: FROM JG_ZZ_VAT_REP_STATUS JZVRS

1461:
1462: CURSOR c_get_trn
1463: IS
1464: SELECT JZVRS.TAX_REGISTRATION_NUMBER
1465: FROM JG_ZZ_VAT_REP_STATUS JZVRS
1466: WHERE JZVRS.VAT_REPORTING_ENTITY_ID = P_VAT_REPORTING_ENTITY_ID
1467: /* added during UT */
1468: AND (P_TAX_CALENDAR_PERIOD is null and jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD)
1469: AND jzvrs.source = 'AP'