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 187: TYPE t_rep_status_id IS TABLE OF JG_ZZ_VAT_REP_STATUS.REPORTING_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;

183: l_cur_period_end_date DATE;
184:
185: l_count NUMBER := 1;
186:
187: TYPE t_rep_status_id IS TABLE OF JG_ZZ_VAT_REP_STATUS.REPORTING_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;
188: TYPE t_trx_number IS TABLE OF JG_ZZ_VAT_TRX_DETAILS.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;
189: TYPE t_trx_date IS TABLE OF JG_ZZ_VAT_TRX_DETAILS.TRX_DATE%TYPE INDEX BY BINARY_INTEGER;
190: TYPE t_il_rep_status IS TABLE OF JG_ZZ_VAT_TRX_DETAILS.IL_VAT_REP_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;
191:

Line 285: ,jg_zz_vat_rep_status jzvrs

281: ,jzvtd.offset_tax_rate_code
282: ,jzvtd.chk_vat_amount_paid CHK_VAT_AMOUNT_PAID
283: ,jzvrs.period_end_date
284: FROM jg_zz_vat_trx_details jzvtd
285: ,jg_zz_vat_rep_status jzvrs
286: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
287: -- AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD --bug5867390
288: AND jzvtd.tax_invoice_date <= (SELECT period_end_date
289: FROM jg_zz_vat_rep_status jzvrs

Line 289: FROM jg_zz_vat_rep_status jzvrs

285: ,jg_zz_vat_rep_status jzvrs
286: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
287: -- AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD --bug5867390
288: AND jzvtd.tax_invoice_date <= (SELECT period_end_date
289: FROM jg_zz_vat_rep_status jzvrs
290: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
291: AND jzvrs.source = 'AP'
292: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD)
293: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id

Line 375: ,jg_zz_vat_rep_status jzvrs

371: ,jzvtd.offset_tax_rate_code
372: ,jzvtd.chk_vat_amount_paid chk_vat_amount_paid
373: ,jzvrs.period_end_date
374: FROM jg_zz_vat_trx_details jzvtd
375: ,jg_zz_vat_rep_status jzvrs
376: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
377: -- AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD --bug5867390
378: AND jzvtd.tax_invoice_date <= (SELECT period_end_date
379: FROM jg_zz_vat_rep_status jzvrs

Line 379: FROM jg_zz_vat_rep_status jzvrs

375: ,jg_zz_vat_rep_status jzvrs
376: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
377: -- AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD --bug5867390
378: AND jzvtd.tax_invoice_date <= (SELECT period_end_date
379: FROM jg_zz_vat_rep_status jzvrs
380: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
381: AND jzvrs.source = 'AP'
382: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD)
383: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id

Line 435: jg_zz_vat_rep_status JZVRS

431: jg_info_n5 trx_id,
432: jg_info_v15 reporting_code
433: FROM JG_ZZ_VAT_TRX_GT tmp,
434: gl_periods glp,
435: jg_zz_vat_rep_status JZVRS
436: WHERE jg_info_v9 = 'M'
437: AND JZVRS.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
438: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
439: AND jg_info_v16 = jzvrs.tax_calendar_period --bug5867390

Line 491: ,jg_zz_vat_rep_status jzvrs

487: ,jzvtd.chk_vat_amount_paid chk_vat_amount_paid
488: ,jzvrs.period_end_date
489: ,jzvtd.reporting_code
490: FROM jg_zz_vat_trx_details jzvtd
491: ,jg_zz_vat_rep_status jzvrs
492: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
493: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
494: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id
495: AND jzvrs.source = 'AP'

Line 511: ,jg_zz_vat_rep_status jzvrs

507: IS
508: SELECT jzvtd.rep_context_entity_name company_name
509: ,jzvtd.functional_currency_code functional_currency_code
510: FROM jg_zz_vat_trx_details jzvtd
511: ,jg_zz_vat_rep_status jzvrs
512: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
513: AND jzvrs.source = 'AP'
514: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD
515: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id

Line 522: ,jg_zz_vat_rep_status jzvrs

518: CURSOR c_vat_or_offset (p_tax_rate_code VARCHAR2)
519: IS
520: SELECT MIN(-9999) vat_or_offset
521: FROM jg_zz_vat_trx_details jzvtd
522: ,jg_zz_vat_rep_status jzvrs
523: WHERE jzvtd.tax_rate_code = p_tax_rate_code
524: AND jzvrs.reporting_status_id = jzvtd.reporting_status_id
525: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
526: AND jzvrs.source = 'AP'

Line 533: FROM jg_zz_vat_rep_status jzvrs

529:
530: CURSOR c_period_end_date
531: IS
532: SELECT period_end_date
533: FROM jg_zz_vat_rep_status jzvrs
534: WHERE jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
535: AND jzvrs.source = 'AP'
536: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD;
537:

Line 549: JG_ZZ_VAT_REP_STATUS JZVRS

545: limit.min_recoverable_amt,
546: limit.period_set_name
547: FROM
548: je_il_vat_limits limit,
549: JG_ZZ_VAT_REP_STATUS JZVRS
550: WHERE
551: JZVRS.VAT_REPORTING_ENTITY_ID = P_VAT_REPORTING_ENTITY_ID
552: AND JZVRS.TAX_CALENDAR_PERIOD = P_TAX_CALENDAR_PERIOD
553: AND JZVRS.TAX_CALENDAR_NAME = limit.PERIOD_SET_NAME

Line 565: jg_zz_vat_rep_status jzvrs

561: sum(decode(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),0))
562: total_vat_amt
563: FROM
564: jg_zz_vat_trx_details jzvtd,
565: jg_zz_vat_rep_status jzvrs
566: WHERE jzvrs.source='AP'
567: and jzvrs.vat_reporting_entity_id = p_vat_reporting_entity_id
568: and jzvrs.tax_calendar_period = p_tax_calendar_period
569: and (p_vat_trx_type is null or jzvtd.tax_rate_vat_trx_type_code = p_vat_trx_type)

Line 582: jg_zz_vat_rep_status jzvrs

578: sum(decode(tax_recoverable_flag,'Y', abs(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt)),0))
579: total_vatks_amt
580: FROM
581: jg_zz_vat_trx_details jzvtd,
582: jg_zz_vat_rep_status jzvrs
583: WHERE jzvrs.source='AP'
584: and jzvrs.vat_reporting_entity_id = p_vat_reporting_entity_id
585: and jzvrs.tax_calendar_period <> p_tax_calendar_period
586: and jzvrs.reporting_status_id = jzvtd.reporting_status_id

Line 596: jg_zz_vat_rep_status jzvrs

592: sum(decode(tax_recoverable_flag,'Y', abs(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt)),0))
593: total_vatks_amt
594: FROM
595: jg_zz_vat_trx_details jzvtd,
596: jg_zz_vat_rep_status jzvrs
597: WHERE jzvrs.source='AP'
598: and jzvrs.vat_reporting_entity_id = p_vat_reporting_entity_id
599: and jzvrs.tax_calendar_period = p_tax_calendar_period
600: and jzvrs.reporting_status_id = jzvtd.reporting_status_id

Line 610: jg_zz_vat_rep_status jzvrs

606: SELECT
607: jzvrs.reporting_status_id,
608: jzvrs.period_end_date
609: FROM
610: jg_zz_vat_rep_status jzvrs
611: WHERE
612: jzvrs.source='AP'
613: and jzvrs.vat_reporting_entity_id = p_vat_reporting_entity_id
614: and jzvrs.tax_calendar_period = p_tax_calendar_period;

Line 643: jg_zz_vat_rep_status jzvrs

639: jzvrs.reporting_status_id,
640: SUM(DECODE(jzvtd.tax_recoverable_flag,'Y', NVL(jzvtd.tax_amt_funcl_curr,NVL(jzvtd.tax_amt,0)),0)) total_vat_amt
641: FROM
642: jg_zz_vat_trx_details jzvtd,
643: jg_zz_vat_rep_status jzvrs
644: WHERE
645: jzvrs.source='AP'
646: and jzvrs.vat_reporting_entity_id = p_vat_reporting_entity_id
647: and (jzvtd.il_vat_rep_status_id = -999 OR jzvtd.il_vat_rep_status_id = l_rep_status_id)

Line 670: jg_zz_vat_rep_status jzvrs

666: jzvrs.reporting_status_id,
667: SUM(DECODE(jzvtd.tax_recoverable_flag,'Y', NVL(jzvtd.tax_amt_funcl_curr,NVL(jzvtd.tax_amt,0)),0)) total_vat_amt
668: FROM
669: jg_zz_vat_trx_details jzvtd,
670: jg_zz_vat_rep_status jzvrs
671: WHERE
672: jzvrs.source='AP'
673: and jzvrs.vat_reporting_entity_id = p_vat_reporting_entity_id
674: and jzvrs.tax_calendar_period = p_tax_calendar_period

Line 730: ,jg_zz_vat_rep_status jzvrs

726: ELSE 'T'
727: END) class
728: ,0 mark_trx_flag
729: FROM jg_zz_vat_trx_details jzvtd
730: ,jg_zz_vat_rep_status jzvrs
731: ,ap_invoices_all apinv
732: WHERE jzvrs.source='AP'
733: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
734: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD

Line 779: ,jg_zz_vat_rep_status jzvrs

775: ,SUM(DECODE(jzvtd.reporting_code,'VAT-RS',DECODE(tax_recoverable_flag,'Y',nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),0),0)) vat_on_other_trxs
776: , 'R' class
777: ,0 mark_trx_flag
778: FROM jg_zz_vat_trx_details jzvtd
779: ,jg_zz_vat_rep_status jzvrs
780: ,ap_invoices_all apinv
781: ,ap_invoice_lines_all apinvl
782: ,zx_lines zxl
783: WHERE jzvrs.source='AP'

Line 830: ,jg_zz_vat_rep_status jzvrs

826: ,sum(DECODE(jzvtd.reporting_code,'VAT-KS',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_other_trxs
827: ,'K' class
828: ,0 mark_trx_flag
829: FROM jg_zz_vat_trx_details jzvtd
830: ,jg_zz_vat_rep_status jzvrs
831: ,ap_invoices_all apinv
832: WHERE jzvrs.source='AP'
833: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
834: AND JZVTD.IL_VAT_REP_STATUS_ID = l_rep_status_id

Line 872: ,jg_zz_vat_rep_status jzvrs

868: ,sum(DECODE(jzvtd.reporting_code,'VAT-KS',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_other_trxs
869: ,'K' class
870: ,1 mark_trx_flag
871: FROM jg_zz_vat_trx_details jzvtd
872: ,jg_zz_vat_rep_status jzvrs
873: ,ap_invoices_all apinv
874: WHERE jzvrs.source='AP'
875: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
876: --AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD ( Other periods also possible)

Line 923: ,jg_zz_vat_rep_status jzvrs

919: ,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
920: ,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
921: ,'S' class
922: FROM jg_zz_vat_trx_details jzvtd
923: ,jg_zz_vat_rep_status jzvrs
924: ,ap_invoices_all apinv
925: WHERE jzvrs.source='AP'
926: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
927: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD

Line 969: ,jg_zz_vat_rep_status jzvrs

965: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,
966: 'VAT-KS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
967: ,'P' class
968: FROM jg_zz_vat_trx_details jzvtd
969: ,jg_zz_vat_rep_status jzvrs
970: ,ap_invoices_all apinv
971: WHERE jzvrs.source='AP'
972: AND jzvrs.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
973: AND jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD

Line 1020: ,jg_zz_vat_rep_status jzvrs

1016: ,sum(DECODE(tax_recoverable_flag,'Y',decode(jzvtd.reporting_code,
1017: 'VAT-RS',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_other_trx
1018: , 'I' class
1019: FROM jg_zz_vat_trx_details jzvtd
1020: ,jg_zz_vat_rep_status jzvrs
1021: ,ap_invoices_all apinv
1022: ,ap_invoice_lines_all apinvl
1023: ,zx_lines zxl
1024: WHERE jzvrs.source='AP'

Line 2064: FROM JG_ZZ_VAT_REP_STATUS JZVRS

2060:
2061: CURSOR c_get_trn
2062: IS
2063: SELECT JZVRS.TAX_REGISTRATION_NUMBER
2064: FROM JG_ZZ_VAT_REP_STATUS JZVRS
2065: WHERE JZVRS.VAT_REPORTING_ENTITY_ID = P_VAT_REPORTING_ENTITY_ID
2066: /* added during UT */
2067: AND (P_TAX_CALENDAR_PERIOD is null and jzvrs.tax_calendar_period = P_TAX_CALENDAR_PERIOD)
2068: AND jzvrs.source = 'AP'