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 63: ,jg_zz_vat_rep_status JZVRS

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

Line 103: ,jg_zz_vat_rep_status JZVRS

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

Line 139: ,jg_zz_vat_rep_status JZVRS

135: +NVL(JZVTD.tax_amt_funcl_curr, tax_amt)) TOTAL_AMOUNT
136: ,NVL(JZVTD.taxable_amt_funcl_curr, taxable_amt) TAXABLE_AMOUNT
137: ,NVL(JZVTD.tax_amt_funcl_curr, tax_amt) TAX_AMOUNT
138: FROM jg_zz_vat_trx_details JZVTD
139: ,jg_zz_vat_rep_status JZVRS
140: ,hz_locations HZ
141: ,hz_party_sites HPS
142: ,ra_customer_trx_all RCTA
143: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 182: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;

178: l_comm_num VARCHAR2(30);
179: l_vat_reg_num VARCHAR2(50);
180:
181:
182: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;
183: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;
184: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;
185: lc_status VARCHAR2(25);
186:

Line 183: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;

179: l_vat_reg_num VARCHAR2(50);
180:
181:
182: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;
183: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;
184: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;
185: lc_status VARCHAR2(25);
186:
187: t_total_amount NUMBER := 0;

Line 184: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;

180:
181:
182: lc_tax_registration jg_zz_vat_rep_status.tax_registration_number%TYPE;
183: ld_period_start_date jg_zz_vat_rep_status.period_start_date%TYPE ;
184: ld_period_end_date jg_zz_vat_rep_status.period_end_date%TYPE ;
185: lc_status VARCHAR2(25);
186:
187: t_total_amount NUMBER := 0;
188: