APPS.WMS_PICKING_PKG dependencies on STANDARD

Line 1222: AND mmtt.standard_operation_id = wutta.user_task_type_id

1218: BEGIN
1219: SELECT wutta.honor_case_pick_flag, pgvl.template_name into l_honor_case_pick_flag, l_template_name
1220: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta , wms_page_templates_tl pgtl, WMS_PAGE_TEMPLATES_VL pgvl
1221: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1222: AND mmtt.standard_operation_id = wutta.user_task_type_id
1223: AND mmtt.organization_id = wutta.organization_id
1224: AND pgtl.template_id = wutta.pick_load_page_template_id
1225: AND pgtl.template_id = pgvl.template_id
1226: AND pgtl.language = userenv('LANG');

Line 2113: l_standard_operation_id NUMBER;

2109: x_msg_data OUT NOCOPY VARCHAR2) IS
2110:
2111: l_person_resource_id NUMBER;
2112: l_machine_resource_id NUMBER;
2113: l_standard_operation_id NUMBER;
2114: l_operation_plan_id NUMBER;
2115: l_move_order_line_id NUMBER;
2116: l_user_id NUMBER;
2117: l_mmtt_rowcnt NUMBER;

Line 2305: t.standard_operation_id,

2301: IF l_wdt_rowcnt = 0 THEN
2302: BEGIN
2303: SELECT bremp.resource_id role_id,
2304: t.wms_task_type,
2305: t.standard_operation_id,
2306: t.operation_plan_id,
2307: t.move_order_line_id,
2308: t.inventory_item_id
2309: INTO l_person_resource_id,

Line 2311: l_standard_operation_id,

2307: t.move_order_line_id,
2308: t.inventory_item_id
2309: INTO l_person_resource_id,
2310: x_task_type_id,
2311: l_standard_operation_id,
2312: l_operation_plan_id,
2313: l_move_order_line_id,
2314: l_item_id
2315: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

Line 2317: AND t.standard_operation_id = bsor.standard_operation_id

2313: l_move_order_line_id,
2314: l_item_id
2315: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
2316: WHERE t.transaction_temp_id = p_transaction_temp_id
2317: AND t.standard_operation_id = bsor.standard_operation_id
2318: AND bsor.resource_id = bremp.resource_id
2319: AND bremp.resource_type = 2
2320: AND ROWNUM < 2;
2321:

Line 2454: l_standard_operation_id,

2450: VALUES
2451: (wms_dispatched_tasks_s.NEXTVAL,
2452: p_transaction_temp_id,
2453: p_organization_id,
2454: l_standard_operation_id,
2455: p_employee_id,
2456: p_effective_start_date,
2457: p_effective_end_date,
2458: p_equipment_id,

Line 3602: NVL(task_record.standard_operation_id, 2),

3598: VALUES
3599: (wms_dispatched_tasks_s.NEXTVAL,
3600: task_record.transaction_temp_id,
3601: p_organization_id,
3602: NVL(task_record.standard_operation_id, 2),
3603: p_employee_id,
3604: sysdate , --task_record.effective_start_date, --bug#6409956
3605: sysdate , --task_record.effective_end_date, --bug#6409956
3606: p_equipment_id,

Line 4631: standard_operation_id ,

4627: shipment_number ,
4628: org_cost_group_id ,
4629: cost_type_id ,
4630: transaction_status ,
4631: standard_operation_id ,
4632: task_priority ,
4633: wms_task_type ,
4634: parent_line_id ,
4635: source_lot_number ,

Line 4869: standard_operation_id ,

4865: shipment_number ,
4866: org_cost_group_id ,
4867: cost_type_id ,
4868: transaction_status ,
4869: standard_operation_id ,
4870: task_priority ,
4871: wms_task_type ,
4872: parent_line_id ,
4873: source_lot_number ,