[Home] [Help]
710: , common_routing_seq_id
711: , org_cost_group_id
712: , cost_type_id
713: , transaction_status
714: , standard_operation_id
715: , task_priority
716: , wms_task_type
717: , parent_line_id
718: , source_lot_number
948: , mmtt.common_routing_seq_id
949: , mmtt.org_cost_group_id
950: , mmtt.cost_type_id
951: , mmtt.transaction_status
952: , mmtt.standard_operation_id
953: , mmtt.task_priority
954: , mmtt.wms_task_type
955: , mmtt.parent_line_id
956: , mmtt.source_lot_number
1192: , common_routing_seq_id
1193: , org_cost_group_id
1194: , cost_type_id
1195: , transaction_status
1196: , standard_operation_id
1197: , task_priority
1198: , wms_task_type
1199: , parent_line_id
1200: , source_lot_number
1430: , mmtt.common_routing_seq_id
1431: , mmtt.org_cost_group_id
1432: , mmtt.cost_type_id
1433: , mmtt.transaction_status
1434: , mmtt.standard_operation_id
1435: , mmtt.task_priority
1436: , mmtt.wms_task_type
1437: , mmtt.parent_line_id
1438: , mmtt.source_lot_number
1727: , mmtt.common_routing_seq_id
1728: , mmtt.org_cost_group_id
1729: , mmtt.cost_type_id
1730: , mmtt.transaction_status
1731: , mmtt.standard_operation_id
1732: , mmtt.task_priority
1733: , mmtt.wms_task_type
1734: , mmtt.parent_line_id
1735: , mmtt.source_lot_number
1965: , wct.common_routing_seq_id
1966: , wct.org_cost_group_id
1967: , wct.cost_type_id
1968: , wct.transaction_status
1969: , wct.standard_operation_id
1970: , wct.task_priority
1971: , wct.wms_task_type
1972: , wct.parent_line_id
1973: , wct.source_lot_number
4282: , bom_std_op_resources tt_x_res
4283: , bom_resources res
4284: , bom_resource_equipments res_equip
4285: WHERE mmtt.transaction_temp_id = p_task_id
4286: AND mmtt.standard_operation_id = tt_x_res.standard_operation_id
4287: AND tt_x_res.resource_id = res.resource_id
4288: AND res.organization_id = mmtt.organization_id
4289: AND res.resource_type = 1
4290: AND res_equip.resource_id = res.resource_id
4308: SELECT NVL(mil.pick_uom_code, msi.pick_uom_code)
4309: , mmtt.organization_id
4310: , mmtt.parent_line_id
4311: , mmtt.inventory_item_id
4312: , mmtt.standard_operation_id
4313: , mmtt.transaction_quantity
4314: , mmtt.transaction_uom
4315: , mmtt.secondary_transaction_quantity
4316: , mmtt.secondary_uom_code
4991: CURSOR c_split_tasks (p_txn_batch_id NUMBER) IS
4992: SELECT transaction_temp_id
4993: FROM mtl_material_transactions_temp
4994: WHERE transaction_batch_id = p_txn_batch_id
4995: AND standard_operation_id IS NOT NULL; -- skip rows without task types
4996:
4997: BEGIN
4998: x_return_status := fnd_api.g_ret_sts_success;
4999:
5136: BEGIN
5137: SELECT rules.rule_id, rules.type_hdr_id BULK COLLECT
5138: INTO g_t_tta_rule_id, g_t_tta_type_hdr_id
5139: FROM wms_rules_b rules
5140: , bom_standard_operations bso
5141: WHERE rules.organization_id IN (g_tta_org_id,-1)
5142: AND rules.type_code = 3
5143: AND rules.enabled_flag = 'Y'
5144: AND rules.type_hdr_id = bso.standard_operation_id
5140: , bom_standard_operations bso
5141: WHERE rules.organization_id IN (g_tta_org_id,-1)
5142: AND rules.type_code = 3
5143: AND rules.enabled_flag = 'Y'
5144: AND rules.type_hdr_id = bso.standard_operation_id
5145: AND bso.organization_id = g_tta_org_id
5146: AND bso.wms_task_type = 1
5147: ORDER BY rules.rule_weight DESC, rules.creation_date;
5148:
5196:
5197: -- Bulk update task_type_id in all the MMTTs with cached values
5198: FORALL kk IN l_mmtt_temp_id.FIRST .. l_mmtt_temp_id.LAST
5199: UPDATE mtl_material_transactions_temp
5200: SET standard_operation_id = l_mmtt_hid(kk)
5201: WHERE transaction_temp_id = l_mmtt_temp_id(kk);
5202: END LOOP; --}
5203:
5204: IF c_mmtt_cursor%ISOPEN THEN
5221: print_debug('l_task_type_id value: ' || l_task_type_id, l_api_name);
5222: END IF;
5223:
5224: UPDATE mtl_material_transactions_temp
5225: SET standard_operation_id = l_task_type_id
5226: WHERE transaction_batch_id = p_transaction_batch_id;
5227: END IF; --}
5228:
5229: UPDATE wms_pr_workers