DBA Data[Home] [Help]

APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 87: FROM jg_zz_vat_trx_details JZVTD

83: ,SUM(ROUND(NVL(JZVTD.taxable_amt_funcl_curr,0),l_precision))) AMOUNT
84: ,DECODE(P_REPORT_NAME,
85: 'JEBEVA24',SUM(ROUND(NVL(JZVTD.tax_amt_funcl_curr,0),l_precision)*l_curr_factor)
86: ,SUM(ROUND(NVL(JZVTD.tax_amt_funcl_curr,0),l_precision))) TAX_AMOUNT
87: FROM jg_zz_vat_trx_details JZVTD
88: ,jg_zz_vat_rep_status JZVRS
89: ,ra_cust_trx_types RTT
90: ,ra_customer_trx RCT
91: ,hz_cust_acct_sites HZCAS