APPS.WMS_PARAMETER_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 6006: wsh_delivery_assignments_v wda,

6002: BEGIN
6003: SELECT wda.delivery_id
6004: INTO l_delivery_id
6005: FROM
6006: wsh_delivery_assignments_v wda,
6007: wsh_delivery_details wdd,
6008: mtl_material_transactions_temp mmtt
6009: WHERE
6010: mmtt.cartonization_id = p_lpn_id

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

6031: SELECT 'Y'
6032: INTO multiple_lpns
6033: FROM DUAL
6034: WHERE EXISTS( SELECT mmtt.transaction_temp_id
6035: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda
6036: WHERE NVL(mmtt.cartonization_id, -1) <> p_lpn_id
6037: AND mmtt.move_order_line_id = wdd.move_order_line_id
6038: AND wdd.delivery_detail_id = wda.delivery_detail_id
6039: AND wda.delivery_id = l_delivery_id);