DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on HZ_PARTY_SITES

Line 3773: hz_party_sites hps

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
3777: and hcsua.site_use_code = 'SHIP_TO'

Line 6158: hz_party_sites ps,

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 (+)
6162: AND csu.site_use_code = 'SHIP_TO'