APPS.WSH_OTM_OUTBOUND dependencies on HZ_CUST_SITE_USES_ALL

Line 933: hz_cust_site_uses_all su

929: SELECT ca.cust_account_id customer_id, count(*) cnt
930: FROM wsh_delivery_assignments wda,
931: wsh_delivery_details wdd,
932: hz_cust_acct_sites_all ca,
933: hz_cust_site_uses_all su
934: WHERE ca.cust_acct_site_id = su.cust_acct_site_id
935: AND su.site_use_id = wdd.ship_to_site_use_id
936: AND wdd.delivery_detail_id = wda.delivery_detail_id
937: AND wda.delivery_id = p_delivery_id

Line 1065: ||' hz_cust_acct_sites_all ca , hz_cust_site_uses_all su '

1061: ||'wda.parent_delivery_detail_id,'
1062: ||'wdd.cust_po_number,'
1063: ||'wdd.source_header_number,''CUST_PO'',''SO_NUM'', wda.delivery_id,nvl(wdd.NET_WEIGHT,0))'
1064: ||' from wsh_new_deliveries wnd, wsh_delivery_details wdd , wsh_delivery_assignments wda , '
1065: ||' hz_cust_acct_sites_all ca , hz_cust_site_uses_all su '
1066: ||' where ca.cust_acct_site_id(+) = su.cust_acct_site_id '
1067: ||' and su.site_use_id(+) = wdd.ship_to_site_use_id '
1068: ||' and wdd.delivery_detail_id(+) = wda.delivery_detail_id '
1069: ||' and wnd.delivery_id = wda.delivery_id(+) '