DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_AR_PKG dependencies on HZ_PARTY_SITES

Line 67: ,hz_party_sites HPS

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
70: ,ra_cust_trx_types RTT
71: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id

Line 146: ,hz_party_sites HPS

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
149: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
150: AND JZVRS.source = 'AR'