DBA Data[Home] [Help]

APPS.MRP_GET_PROJECT dependencies on HZ_CUST_SITE_USES_ALL

Line 237: hz_cust_site_uses_all SU

233: into address_name
234: from hz_locations A,
235: HZ_PARTY_SITES PS1,
236: HZ_CUST_ACCT_SITES_ALL AS1,
237: hz_cust_site_uses_all SU
238: where SU.site_use_id = arg_site_id
239: AND SU.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID
240: AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID
241: AND PS1.LOCATION_ID = A.LOCATION_ID ;