APPS.WMS_PARAMETER_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 6020: wsh_delivery_assignments_v wda,

6016: BEGIN
6017: SELECT wda.delivery_id
6018: INTO l_delivery_id
6019: FROM
6020: wsh_delivery_assignments_v wda,
6021: wsh_delivery_details wdd,
6022: mtl_material_transactions_temp mmtt
6023: WHERE
6024: mmtt.cartonization_id = p_lpn_id

Line 6049: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda

6045: SELECT 'Y'
6046: INTO multiple_lpns
6047: FROM DUAL
6048: WHERE EXISTS( SELECT mmtt.transaction_temp_id
6049: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda
6050: WHERE NVL(mmtt.cartonization_id, -1) <> p_lpn_id
6051: AND mmtt.move_order_line_id = wdd.move_order_line_id
6052: AND wdd.delivery_detail_id = wda.delivery_detail_id
6053: AND wda.delivery_id = l_delivery_id);