DBA Data[Home] [Help]

APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on HZ_PARTY_SITES

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

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

Line 92: ,hz_party_sites HPS

88: ,jg_zz_vat_rep_status JZVRS
89: ,ra_cust_trx_types RTT
90: ,ra_customer_trx RCT
91: ,hz_cust_acct_sites HZCAS
92: ,hz_party_sites HPS
93: ,hz_locations HZL
94: WHERE JZVRS.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
95: AND JZVTD.reporting_status_id = JZVRS.reporting_status_id
96: AND RTT.cust_trx_type_id = JZVTD.trx_type_id