DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on HZ_CUST_SITE_USES

Line 3770: hz_cust_site_uses_all hcsua,

3766: select crh.requirement_header_id,
3767: decode(crh.address_type,'R',null,'S',null,crh.ship_to_location_id),
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

Line 6157: hz_cust_site_uses csu,

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
6161: AND cas.cust_acct_site_id = csu.cust_acct_site_id (+)