DBA Data[Home] [Help]

APPS.WSH_CONTAINER_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 2087: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda

2083:
2084: CURSOR Check_Detail (v_detail_id NUMBER) IS
2085: SELECT wdd.delivery_detail_id, wdd.container_flag,wdd.released_status,
2086: wdd.organization_id ,wda.delivery_id
2087: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda
2088: WHERE wdd.delivery_detail_id = v_detail_id
2089: AND wdd.delivery_detail_id = wda.delivery_detail_id
2090: AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
2091: