DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_UTILITIES dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 117: FROM wsh_delivery_assignments_v WDA,

113: wsh_new_deliveries d
114: WHERE d.delivery_id = t.id
115: AND NOT EXISTS (
116: SELECT WDA.delivery_detail_id
117: FROM wsh_delivery_assignments_v WDA,
118: wsh_delivery_details WDD
119: WHERE WDA.delivery_detail_id = WDD.delivery_detail_id
120: AND WDA.delivery_id = t.id
121: AND WDA.delivery_id is not NULL

Line 1045: wsh_delivery_assignments_v wda,

1041: wdd.lpn_id,
1042: wsp.appending_limit,
1043: wdd.ignore_for_planning --bugfix 7164767
1044: FROM wsh_delivery_details wdd,
1045: wsh_delivery_assignments_v wda,
1046: wsh_shipping_parameters wsp
1047: WHERE wdd.delivery_detail_id = c_detail_id
1048: AND wda.delivery_detail_id = wdd.delivery_detail_id
1049: AND wda.delivery_id is NULL