DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on HZ_LOCATIONS

Line 3723: hz_party_sites ps, hz_locations hzl

3719: AND resource_id = c_resource_id
3720: AND resource_type = c_resource_type;*/
3721: SELECT hzl.time_zone TIMEZONE_ID
3722: from csp_rs_cust_relations rcr, hz_cust_acct_sites cas, hz_cust_site_uses csu,
3723: hz_party_sites ps, hz_locations hzl
3724: where rcr.customer_id = cas.cust_account_id
3725: and cas.cust_acct_site_id = csu.cust_acct_site_id (+)
3726: and csu.site_use_code = 'SHIP_TO'
3727: and cas.party_site_id = ps.party_site_id