APPS.WMS_POSTALLOC_PVT dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 3711: , wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda

3707: , mmtt.item_serial_control_code
3708: , mmtt.serial_allocated_flag
3709: , mmtt.transaction_batch_id
3710: FROM mtl_material_transactions_temp mmtt, mtl_txn_request_lines mol
3711: , wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda
3712: WHERE mmtt.move_order_line_id = mol.line_id
3713: AND mol.header_id = p_move_order_header_id
3714: AND mol.line_id = wdd.move_order_line_id
3715: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 4075: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda

4071: AND NVL(transaction_type_id, -1) = NVL(l_transaction_type_id(kk), NVL(transaction_type_id, -1))
4072: AND NVL(transaction_action_id, -1) = NVL(l_transaction_action_id(kk), NVL(transaction_action_id, -1))
4073: AND NVL(transaction_source_type_id, -1) = NVL(l_transaction_source_type_id(kk), NVL(transaction_source_type_id, -1))
4074: AND EXISTS( SELECT 1
4075: FROM mtl_txn_request_lines mol,wsh_delivery_details_ob_grp_v wdd,wsh_delivery_assignments_v wda
4076: WHERE mol.line_id = mmtt.move_order_line_id
4077: AND mol.line_id = wdd.move_order_line_id
4078: AND wdd.delivery_detail_id = wda.delivery_detail_id
4079: AND NVL(wda.delivery_id,mol.carton_grouping_id) = l_carton_grouping_id(kk) )

Line 4269: , wsh_delivery_details_ob_grp_v wdd

4265: SELECT mmtt.transaction_temp_id
4266: , mmtt.transaction_quantity
4267: FROM mtl_material_transactions_temp mmtt
4268: , mtl_txn_request_lines mol
4269: , wsh_delivery_details_ob_grp_v wdd
4270: , wsh_delivery_assignments_v wda
4271: WHERE mmtt.parent_line_id = p_parent_line_id
4272: AND mol.line_id = mmtt.move_order_line_id
4273: AND mol.line_id = wdd.move_order_line_id