APPS.WMS_TASK_DISPATCH_GEN dependencies on BOM_STD_OP_RESOURCES

Line 714: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

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

Line 729: FROM mtl_cycle_count_entries mcce, bom_std_op_resources bsor, bom_resources bremp,mtl_cycle_count_headers mcch

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

Line 754: --bom_std_op_resources bsor,

750: AND ROWNUM < 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

Line 1280: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

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

Line 1298: bom_std_op_resources bsor,

1294: l_wms_task_type,
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

Line 12848: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

12844: , l_wms_task_type
12845: , l_std_op_id
12846: , l_operation_plan_id
12847: , l_move_order_line_id
12848: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
12849: WHERE t.transaction_temp_id = task_rec.task_id
12850: AND t.standard_operation_id = bsor.standard_operation_id
12851: AND bsor.resource_id = bremp.resource_id
12852: AND bremp.resource_type = 2

Line 12871: bom_std_op_resources bsor,

12867: /*
12868: select breqp.resource_id equip_type_id
12869: INTO l_mac_res_id
12870: from mtl_material_transactions_temp t,
12871: bom_std_op_resources bsor,
12872: bom_resources breqp
12873: where t.transaction_temp_id = task_rec.task_id
12874: and t.standard_operation_id = bsor.standard_operation_id
12875: and bsor.resource_id = breqp.resource_id

Line 13195: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

13191: , l_std_op_id
13192: , l_operation_plan_id
13193: , l_move_order_line_id
13194: , l_item_id --Bug6009436
13195: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
13196: WHERE t.transaction_temp_id = l_pick_slip_id
13197: AND t.standard_operation_id = bsor.standard_operation_id
13198: AND bsor.resource_id = bremp.resource_id
13199: AND bremp.resource_type = 2

Line 13228: bom_std_op_resources bsor,

13224: /*
13225: select breqp.resource_id equip_type_id
13226: INTO l_mac_res_id
13227: from mtl_material_transactions_temp t,
13228: bom_std_op_resources bsor,
13229: bom_resources breqp
13230: where t.transaction_temp_id = task_rec.task_id
13231: and t.standard_operation_id = bsor.standard_operation_id
13232: and bsor.resource_id = breqp.resource_id