DBA Data[Home] [Help]

APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 129: hz_cust_site_uses_all csu,

125: decode(rcr.resource_type,'RS_GROUP','G','E') resource_type,
126: cas.status,
127: au.user_id
128: FROM po_location_associations_all pla,
129: hz_cust_site_uses_all csu,
130: hz_cust_acct_sites_all cas,
131: csp_rs_cust_relations rcr,
132: asg_user au
133: WHERE csu.site_use_id = pla.site_use_id

Line 239: hz_cust_site_uses_all csu,

235: 'G' resource_type,
236: au.user_id ,
237: cas.party_site_id
238: FROM po_location_associations_all pla,
239: hz_cust_site_uses_all csu,
240: hz_cust_acct_sites_all cas,
241: csp_rs_cust_relations rcr,
242: asg_user au
243: WHERE csu.site_use_id = pla.site_use_id