DBA Data[Home] [Help]

APPS.JG_ZZ_AUDIT_AR_PKG dependencies on HZ_PARTY_SITES

Line 65: ,hz_party_sites HPS

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

Line 141: ,hz_party_sites HPS

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