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.CSP_SCH_INT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 3772: hz_cust_acct_sites_all hcasa,

3768: decode(crh.address_type,'R',null,'S',null,hps.location_id)
3769: from csp_requirement_headers crh,
3770: hz_cust_site_uses_all hcsua,
3771: po_location_associations_all plaa,
3772: hz_cust_acct_sites_all hcasa,
3773: hz_party_sites hps
3774: where crh.task_id = p_task_id
3775: and plaa.location_id = crh.ship_to_location_id
3776: and hcsua.site_use_id = plaa.site_use_id

Line 3822: hz_cust_acct_sites_all hcasa

3818: select crstaav.ship_to_location_id,
3819: crstaav.site_loc_id,
3820: hcasa.org_id
3821: from csp_rs_ship_to_addresses_all_v crstaav,
3822: hz_cust_acct_sites_all hcasa
3823: where crstaav.resource_type = p_resource_type
3824: and crstaav.resource_id = p_resource_id
3825: and crstaav.primary_flag = 'Y'
3826: and hcasa.cust_acct_site_id = crstaav.cust_acct_site_id;

Line 6156: hz_cust_acct_sites cas,

6152: AND resource_id = c_resource_id
6153: AND resource_type = c_resource_type;*/
6154: SELECT hzl.time_zone TIMEZONE_ID
6155: FROM csp_rs_cust_relations rcr,
6156: hz_cust_acct_sites cas,
6157: hz_cust_site_uses csu,
6158: hz_party_sites ps,
6159: hz_locations hzl
6160: WHERE rcr.customer_id = cas.cust_account_id