DBA Data[Home] [Help]

APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on HZ_CUST_ACCT_SITES

Line 65: /* Bug#5223170. Added hz_cust_acct_sites, hz_party_sites and join conditions */

61: -- | execution of report. |
62: -- | |
63: -- +======================================================================+
64: IS
65: /* Bug#5223170. Added hz_cust_acct_sites, hz_party_sites and join conditions */
66:
67:
68: l_precision NUMBER := 0;
69: l_curr_factor NUMBER := 1;

Line 90: ,hz_cust_acct_sites HZCAS

86: FROM jg_zz_vat_trx_details JZVTD
87: ,jg_zz_vat_rep_status JZVRS
88: ,ra_cust_trx_types RTT
89: ,ra_customer_trx RCT
90: ,hz_cust_acct_sites HZCAS
91: ,hz_party_sites HPS
92: ,hz_locations HZL
93: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
94: AND JZVTD.reporting_status_id = JZVRS.reporting_status_id