APPS.WMS_POST_ALLOCATION dependencies on WMS_USER_TASK_TYPE_ATTRIBUTES

Line 91: FROM wms_user_task_type_attributes wutta

87: WHERE mmtt.move_order_header_id = p_mo_hdr_id
88: AND mmtt.parent_line_id IS NULL
89: AND EXISTS
90: ( SELECT 'x'
91: FROM wms_user_task_type_attributes wutta
92: WHERE wutta.organization_id = mmtt.organization_id
93: AND wutta.user_task_type_id = mmtt.standard_operation_id
94: AND wutta.honor_case_pick_flag = 'Y'
95: )

Line 109: FROM wms_user_task_type_attributes wutta

105: AND mmtt2.transaction_temp_id <> mmtt2.parent_line_id
106: )
107: AND EXISTS
108: ( SELECT 'x'
109: FROM wms_user_task_type_attributes wutta
110: WHERE wutta.organization_id = mmtt.organization_id
111: AND wutta.user_task_type_id = mmtt.standard_operation_id
112: AND wutta.honor_case_pick_flag = 'Y'
113: );

Line 855: FROM wms_user_task_type_attributes wutta1

851: FROM mtl_material_transactions_temp mmtt2
852: WHERE mmtt2.move_order_header_id = p_mo_header_id
853: AND EXISTS
854: ( SELECT 'x'
855: FROM wms_user_task_type_attributes wutta1
856: WHERE wutta1.organization_id = mmtt2.organization_id
857: AND wutta1.user_task_type_id = mmtt2.standard_operation_id
858: AND wutta1.honor_case_pick_flag = 'Y'
859: )

Line 873: FROM wms_user_task_type_attributes wutta2

869: AND mmtt4.transaction_temp_id <> mmtt4.parent_line_id
870: )
871: AND EXISTS
872: ( SELECT 'x'
873: FROM wms_user_task_type_attributes wutta2
874: WHERE wutta2.organization_id = mmtt3.organization_id
875: AND wutta2.user_task_type_id = mmtt3.standard_operation_id
876: AND wutta2.honor_case_pick_flag = 'Y'
877: )