APPS.INV_PICK_RELEASE_PUB dependencies on WMS_USER_TASK_TYPE_ATTRIBUTES

Line 979: FROM wms_user_task_type_attributes wutta

975: WHERE mmtt.move_order_header_id = p_mo_hdr_id
976: AND mmtt.parent_line_id IS NULL
977: AND EXISTS
978: ( SELECT 'x'
979: FROM wms_user_task_type_attributes wutta
980: WHERE wutta.organization_id = mmtt.organization_id
981: AND wutta.user_task_type_id = mmtt.standard_operation_id
982: AND wutta.honor_case_pick_flag = 'Y'
983: )

Line 997: FROM wms_user_task_type_attributes wutta

993: AND mmtt2.transaction_temp_id <> mmtt2.parent_line_id
994: )
995: AND EXISTS
996: ( SELECT 'x'
997: FROM wms_user_task_type_attributes wutta
998: WHERE wutta.organization_id = mmtt.organization_id
999: AND wutta.user_task_type_id = mmtt.standard_operation_id
1000: AND wutta.honor_case_pick_flag = 'Y'
1001: );