APPS.WMS_POST_ALLOCATION dependencies on STANDARD

Line 93: AND wutta.user_task_type_id = mmtt.standard_operation_id

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: )
96: UNION ALL
97: -- Bulk pick parent tasks

Line 111: AND wutta.user_task_type_id = mmtt.standard_operation_id

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: );
114:
115: -- Op plan assignment: fetch unique item IDs across all records

Line 783: SET standard_operation_id = l_ttype_id

779: print_debug ('l_ttype_id value: ' || l_ttype_id, l_api_name);
780: END IF;
781:
782: UPDATE mtl_material_transactions_temp
783: SET standard_operation_id = l_ttype_id
784: WHERE move_order_header_id = p_mo_header_id;
785: END IF;
786:
787: COMMIT;

Line 857: AND wutta1.user_task_type_id = mmtt2.standard_operation_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: )
860: )
861: OR EXISTS

Line 875: AND wutta2.user_task_type_id = mmtt3.standard_operation_id

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: )
878: );
879: