DBA Data[Home] [Help]

APPS.JG_ZZ_TURNOVER_AR_PKG dependencies on HZ_LOCATIONS

Line 92: ,hz_locations HZL

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
95: AND RTT.cust_trx_type_id = JZVTD.trx_type_id
96: AND RTT.type IN ('INV','CM','DM')