DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 123: FROM wsh_delivery_assignments_v WDA,

119: wsh_new_deliveries d
120: WHERE d.delivery_id = t.id
121: AND NOT EXISTS (
122: SELECT /*+ no_unnest */ WDA.delivery_detail_id
123: FROM wsh_delivery_assignments_v WDA,
124: wsh_delivery_details WDD
125: WHERE WDA.delivery_detail_id = WDD.delivery_detail_id
126: AND WDA.delivery_id = t.id
127: AND WDA.delivery_id is not NULL

Line 1051: wsh_delivery_assignments_v wda,

1047: wdd.lpn_id,
1048: wsp.appending_limit,
1049: wdd.ignore_for_planning --bugfix 7164767
1050: FROM wsh_delivery_details wdd,
1051: wsh_delivery_assignments_v wda,
1052: wsh_shipping_parameters wsp
1053: WHERE wdd.delivery_detail_id = c_detail_id
1054: AND wda.delivery_detail_id = wdd.delivery_detail_id
1055: AND wda.delivery_id is NULL