[Home] [Help]
710: , l_wms_task_type
711: , l_std_op_id
712: , l_operation_plan_id
713: , l_move_order_line_id
714: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
715: WHERE t.transaction_temp_id = task_rec.task_id
716: AND t.standard_operation_id = bsor.standard_operation_id
717: AND bsor.resource_id = bremp.resource_id
718: AND bremp.resource_type = 2
725: INTO l_per_res_id
726: , l_wms_task_type
727: , l_std_op_id
728: --Bug 3808770- Added the table mtl_cycle_count_headers in the FROM clause
729: FROM mtl_cycle_count_entries mcce, bom_std_op_resources bsor, bom_resources bremp,mtl_cycle_count_headers mcch
730: WHERE mcce.cycle_count_entry_id = task_rec.task_id
731: AND mcce.standard_operation_id = bsor.standard_operation_id
732: AND bsor.resource_id = bremp.resource_id
733: AND bremp.resource_type = 2
751: --select breqp.resource_id equip_type_id
752: --INTO l_mac_res_id
753: --from mtl_material_transactions_temp t,
754: --bom_std_op_resources bsor,
755: --bom_resources breqp
756: --where t.transaction_temp_id = task_rec.task_id
757: --and t.standard_operation_id = bsor.standard_operation_id
758: --and bsor.resource_id = breqp.resource_id
759: --and breqp.resource_type = 1
1276: , l_wms_task_type
1277: , l_std_op_id
1278: , l_operation_plan_id
1279: , l_move_order_line_id
1280: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
1281: WHERE t.transaction_temp_id = task_rec.task_id
1282: AND t.standard_operation_id = bsor.standard_operation_id
1283: AND bsor.resource_id = bremp.resource_id
1284: AND bremp.resource_type = 2
1295: l_std_op_id
1296: FROM
1297: mtl_cycle_count_entries mcce,
1298: bom_std_op_resources bsor,
1299: bom_resources bremp
1300: where mcce.cycle_count_entry_id = task_rec.task_id
1301: and mcce.standard_operation_id = bsor.standard_operation_id
1302: and bsor.resource_id = bremp.resource_id
1303: and bremp.resource_type = 2
12592: , l_wms_task_type
12593: , l_std_op_id
12594: , l_operation_plan_id
12595: , l_move_order_line_id
12596: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
12597: WHERE t.transaction_temp_id = task_rec.task_id
12598: AND t.standard_operation_id = bsor.standard_operation_id
12599: AND bsor.resource_id = bremp.resource_id
12600: AND bremp.resource_type = 2
12616: select breqp.resource_id equip_type_id
12617: INTO l_mac_res_id
12618: from mtl_material_transactions_temp t,
12619: bom_std_op_resources bsor,
12620: bom_resources breqp
12621: where t.transaction_temp_id = task_rec.task_id
12622: and t.standard_operation_id = bsor.standard_operation_id
12623: and bsor.resource_id = breqp.resource_id
12624: and breqp.resource_type = 1
12939: , l_std_op_id
12940: , l_operation_plan_id
12941: , l_move_order_line_id
12942: , l_item_id --Bug6009436
12943: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
12944: WHERE t.transaction_temp_id = l_pick_slip_id
12945: AND t.standard_operation_id = bsor.standard_operation_id
12946: AND bsor.resource_id = bremp.resource_id
12947: AND bremp.resource_type = 2
12973: select breqp.resource_id equip_type_id
12974: INTO l_mac_res_id
12975: from mtl_material_transactions_temp t,
12976: bom_std_op_resources bsor,
12977: bom_resources breqp
12978: where t.transaction_temp_id = task_rec.task_id
12979: and t.standard_operation_id = bsor.standard_operation_id
12980: and bsor.resource_id = breqp.resource_id
12981: and breqp.resource_type = 1