DBA Data[Home] [Help]

APPS.CSM_WF_PKG dependencies on HZ_LOCATIONS

Line 2389: hz_locations hzl

2385: hz_cust_acct_sites_all cas,
2386: csp_rs_cust_relations rcr,
2387: jtf_rs_resource_extns jtrs,
2388: hz_party_sites hps,
2389: hz_locations hzl
2390: WHERE pla.location_id = p_locationid
2391: AND csu.site_use_id = pla.site_use_id
2392: AND csu.site_use_code = 'SHIP_TO'
2393: AND csu.cust_acct_site_id = cas.cust_acct_site_id

Line 2466: hz_locations hzl

2462: hz_cust_acct_sites_all cas,
2463: csp_rs_cust_relations rcr,
2464: jtf_rs_resource_extns jtrs,
2465: hz_party_sites hps,
2466: hz_locations hzl
2467: WHERE pla.location_id = p_locationid
2468: AND csu.site_use_id = pla.site_use_id
2469: AND csu.site_use_code = 'SHIP_TO'
2470: AND csu.cust_acct_site_id = cas.cust_acct_site_id