DBA Data[Home] [Help]

APPS.ONT_OEXOHHSA_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 157: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

153: HZ_CUST_SITE_USES_ALL SU,
154: HZ_PARTY_SITES PARTY_SITE,
155: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
156: HZ_LOCATIONS LOC,
157: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
158: WHERE SU.SITE_USE_ID = OBJECT_ID
159: AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
160: AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
161: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID

Line 298: HZ_CUST_ACCT_SITES_ALL ACCT_SITE

294: HZ_CUST_SITE_USES_ALL SU,
295: HZ_PARTY_SITES PARTY_SITE,
296: HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
297: HZ_LOCATIONS LOC,
298: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
299: WHERE SU.SITE_USE_ID = OBJECT_ID2
300: AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
301: AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
302: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID