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_TRX_DETAILS

Line 188: TYPE t_trx_number IS TABLE OF JG_ZZ_VAT_TRX_DETAILS.TRX_NUMBER%TYPE INDEX BY BINARY_INTEGER;

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:
192: rep_status_id_rec_tab t_rep_status_id;

Line 189: TYPE t_trx_date IS TABLE OF JG_ZZ_VAT_TRX_DETAILS.TRX_DATE%TYPE INDEX BY BINARY_INTEGER;

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:
192: rep_status_id_rec_tab t_rep_status_id;
193: trx_number_rec_tab t_trx_number;

Line 190: TYPE t_il_rep_status IS TABLE OF JG_ZZ_VAT_TRX_DETAILS.IL_VAT_REP_STATUS_ID%TYPE INDEX BY BINARY_INTEGER;

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:
192: rep_status_id_rec_tab t_rep_status_id;
193: trx_number_rec_tab t_trx_number;
194: trx_date_rec_tab t_trx_date;

Line 208: l_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;

204: l_country_code VARCHAR2(5);
205: l_end_date DATE;
206: l_unpaid_amount NUMBER;
207: l_curr_code VARCHAR2(50);
208: l_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
209: l_legal_entity_id NUMBER;
210: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
211: l_company_name xle_registrations.registered_name%TYPE;
212: l_registration_number xle_registrations.registration_number%TYPE;

Line 210: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;

206: l_unpaid_amount NUMBER;
207: l_curr_code VARCHAR2(50);
208: l_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
209: l_legal_entity_id NUMBER;
210: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
211: l_company_name xle_registrations.registered_name%TYPE;
212: l_registration_number xle_registrations.registration_number%TYPE;
213: l_country hz_locations.country%TYPE;
214: l_address1 hz_locations.address1%TYPE;

Line 284: FROM jg_zz_vat_trx_details jzvtd

280: ,jzvtd.offset_flag
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

Line 374: FROM jg_zz_vat_trx_details jzvtd

370: ,jzvtd.offset_flag
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

Line 490: FROM jg_zz_vat_trx_details jzvtd

486: ,jzvtd.offset_tax_rate_code
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

Line 510: FROM jg_zz_vat_trx_details jzvtd

506: CURSOR c_company_details
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

Line 521: FROM jg_zz_vat_trx_details jzvtd

517:
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

Line 564: jg_zz_vat_trx_details jzvtd,

560: SELECT
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

Line 581: jg_zz_vat_trx_details jzvtd,

577: (SELECT
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

Line 595: jg_zz_vat_trx_details jzvtd,

591: SELECT
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

Line 642: jg_zz_vat_trx_details jzvtd,

638: jzvtd.trx_number,
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

Line 669: jg_zz_vat_trx_details jzvtd,

665: jzvtd.trx_number,
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

Line 729: FROM jg_zz_vat_trx_details jzvtd

725: WHEN jzvtd.reporting_code = 'VAT-H' THEN 'H'
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

Line 778: FROM jg_zz_vat_trx_details jzvtd

774: ,SUM(DECODE(jzvtd.reporting_code,'VAT-RA',DECODE(tax_recoverable_flag,'Y',nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),0),0)) vat_on_fixed_assets
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

Line 829: FROM jg_zz_vat_trx_details jzvtd

825: ,sum(DECODE(jzvtd.reporting_code,'VAT-KA',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_fixed_assets
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

Line 871: FROM jg_zz_vat_trx_details jzvtd

867: ,sum(DECODE(jzvtd.reporting_code,'VAT-KA',DECODE(tax_recoverable_flag,'Y', nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt), 0),0)) vat_on_fixed_assets
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

Line 922: FROM jg_zz_vat_trx_details jzvtd

918: ,0 i_vat_on_other_trx
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

Line 968: FROM jg_zz_vat_trx_details jzvtd

964: 'VAT-KA',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_fixed_assets
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

Line 1019: FROM jg_zz_vat_trx_details jzvtd

1015: 'VAT-RA',Round(nvl(jzvtd.tax_amt_funcl_curr,jzvtd.tax_amt),G_PRECISION),0),0)) vat_fixed_assets
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

Line 1366: -- Stamp the petty cash transactions. Update the IL_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table.

1362: END IF;
1363: l_count := l_count + 1;
1364: END LOOP;
1365:
1366: -- Stamp the petty cash transactions. Update the IL_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table.
1367: IF l_count > 1 THEN
1368: BEGIN
1369: FORALL i_index IN 1 .. l_count-1
1370: UPDATE JG_ZZ_VAT_TRX_DETAILS

Line 1370: UPDATE JG_ZZ_VAT_TRX_DETAILS

1366: -- Stamp the petty cash transactions. Update the IL_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table.
1367: IF l_count > 1 THEN
1368: BEGIN
1369: FORALL i_index IN 1 .. l_count-1
1370: UPDATE JG_ZZ_VAT_TRX_DETAILS
1371: SET IL_VAT_REP_STATUS_ID = il_rep_status_rec_tab(i_index)
1372: WHERE REPORTING_STATUS_ID = rep_status_id_rec_tab(i_index)
1373: AND TRX_NUMBER = trx_number_rec_tab(i_index)
1374: AND TRX_DATE = trx_date_rec_tab(i_index);

Line 1378: fnd_file.put_line(fnd_file.log,' Failed while Updating IL_VAT_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table. Error : ' || SUBSTR(SQLERRM,1,200));

1374: AND TRX_DATE = trx_date_rec_tab(i_index);
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: if g_debug = true then
1378: fnd_file.put_line(fnd_file.log,' Failed while Updating IL_VAT_REP_STATUS_ID column in JG_ZZ_VAT_TRX_DETAILS table. Error : ' || SUBSTR(SQLERRM,1,200));
1379: end if;
1380: RETURN (FALSE);
1381: END;
1382: if g_debug = true then