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 176: l_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;

172: l_country_code VARCHAR2(5);
173: l_end_date DATE;
174: l_unpaid_amount NUMBER;
175: l_curr_code VARCHAR2(50);
176: l_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
177: l_legal_entity_id NUMBER;
178: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
179: l_company_name xle_registrations.registered_name%TYPE;
180: l_registration_number xle_registrations.registration_number%TYPE;

Line 178: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;

174: l_unpaid_amount NUMBER;
175: l_curr_code VARCHAR2(50);
176: l_rep_entity_name jg_zz_vat_trx_details.rep_context_entity_name%TYPE;
177: l_legal_entity_id NUMBER;
178: l_taxpayer_id jg_zz_vat_trx_details.taxpayer_id%TYPE;
179: l_company_name xle_registrations.registered_name%TYPE;
180: l_registration_number xle_registrations.registration_number%TYPE;
181: l_country hz_locations.country%TYPE;
182: l_address1 hz_locations.address1%TYPE;

Line 251: FROM jg_zz_vat_trx_details jzvtd

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

Line 336: FROM jg_zz_vat_trx_details jzvtd

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

Line 446: FROM jg_zz_vat_trx_details jzvtd

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

Line 466: FROM jg_zz_vat_trx_details jzvtd

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

Line 477: FROM jg_zz_vat_trx_details jzvtd

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

Line 516: FROM jg_zz_vat_trx_details jzvtd

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

Line 562: FROM jg_zz_vat_trx_details jzvtd

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

Line 614: FROM jg_zz_vat_trx_details jzvtd

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