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

Line 65: ,jg_zz_vat_rep_status JZVRS

61: +NVL(JZVTD.tax_amt_funcl_curr, tax_amt), l_precision) TOTAL_AMOUNT
62: ,ROUND(NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt), l_precision) TAXABLE_AMOUNT
63: ,ROUND(NVL(JZVTD.tax_amt_funcl_curr, tax_amt), l_precision) TAX_AMOUNT
64: FROM jg_zz_vat_trx_details JZVTD
65: ,jg_zz_vat_rep_status JZVRS
66: ,hz_cust_acct_sites_all HZCAS
67: ,hz_party_sites HPS
68: ,hz_locations HZL
69: ,ra_customer_trx_all RCTA

Line 105: ,jg_zz_vat_rep_status JZVRS

101: ,JZVTD.tax_invoice_date TAX_DATE
102: ,JZVTD.accounting_date GL_DATE
103: ,NVL(JZVTD.taxable_amt_funcl_curr,taxable_amt) TAXABLE_AMOUNT
104: FROM jg_zz_vat_trx_details JZVTD
105: ,jg_zz_vat_rep_status JZVRS
106: ,ra_customer_trx_all RCTA
107: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
108: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
109: AND JZVRS.tax_calendar_period = p_period

Line 144: ,jg_zz_vat_rep_status JZVRS

140: +NVL(JZVTD.tax_amt_funcl_curr, tax_amt)) TOTAL_AMOUNT
141: ,NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt) TAXABLE_AMOUNT
142: ,NVL(JZVTD.tax_amt_funcl_curr, tax_amt) TAX_AMOUNT
143: FROM jg_zz_vat_trx_details JZVTD
144: ,jg_zz_vat_rep_status JZVRS
145: ,hz_locations HZ
146: ,hz_party_sites HPS
147: ,ra_customer_trx_all RCTA
148: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 187: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;

183: l_comm_num VARCHAR2(30);
184: l_vat_reg_num VARCHAR2(50);
185:
186:
187: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;
188: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;
189: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;
190: lc_status VARCHAR2(25);
191:

Line 188: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;

184: l_vat_reg_num VARCHAR2(50);
185:
186:
187: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;
188: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;
189: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;
190: lc_status VARCHAR2(25);
191:
192: t_total_amount NUMBER := 0;

Line 189: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;

185:
186:
187: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;
188: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;
189: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;
190: lc_status VARCHAR2(25);
191:
192: t_total_amount NUMBER := 0;
193: