DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 3722: from csp_rs_cust_relations rcr, hz_cust_acct_sites cas, hz_cust_site_uses csu,

3718: WHERE PRIMARY_FLAG ='Y'
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'