DBA Data[Home] [Help]

APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 261: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA

257: wdd.weight_uom_code,
258: p_uom,
259: WDD.GROSS_WEIGHT)) gross_weight_converted,
260: WDA.DELIVERY_DETAIL_ID
261: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA
262: WHERE WDA.DELIVERY_ID = p_delivery_id
263: AND wda.delivery_detail_id = wdd.delivery_detail_id
264: AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL
265: AND WDD.WEIGHT_UOM_CODE IS NOT NULL

Line 272: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA

268:
269: -- this will get all delivery details' (non LPN) released status
270: CURSOR c_get_delivery_line(p_delivery_id IN NUMBER) IS
271: SELECT WDD.RELEASED_STATUS
272: FROM WSH_DELIVERY_DETAILS WDD, WSH_DELIVERY_ASSIGNMENTS WDA
273: WHERE WDA.DELIVERY_ID = p_delivery_id
274: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
275: AND WDD.CONTAINER_FLAG = 'N'
276: AND WDD.RELEASED_STATUS NOT IN ('R', 'B', 'X');