eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 130: hz_cust_acct_sites_all cas,

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
134: AND csu.site_use_code = 'SHIP_TO'

Line 240: hz_cust_acct_sites_all cas,

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
244: AND csu.site_use_code = 'SHIP_TO'

Line 293: hz_cust_acct_sites_all cas,

289: acc.user_id,
290: cas.party_site_id
291: FROM po_location_associations_all pla,
292: csm_po_loc_ass_all_acc acc,
293: hz_cust_acct_sites_all cas,
294: asg_user au
295: WHERE acc.user_id = au.user_id AND acc.location_id = pla.location_id AND acc.org_id = pla.org_id AND acc.RESOURCE_TYPE= 'G'
296: AND pla.address_id = cas.cust_acct_site_id
297: AND NOT EXISTS( SELECT 1 FROM csp_rs_cust_relations rcr