APPS.WMS_PICKING_PKG dependencies on STANDARD

Line 1005: AND mmtt.standard_operation_id = wutta.user_task_type_id

1001: BEGIN
1002: SELECT wutta.honor_case_pick_flag, pgvl.template_name into l_honor_case_pick_flag, l_template_name
1003: FROM mtl_material_transactions_temp mmtt, wms_user_task_type_attributes wutta , wms_page_templates_tl pgtl, WMS_PAGE_TEMPLATES_VL pgvl
1004: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1005: AND mmtt.standard_operation_id = wutta.user_task_type_id
1006: AND mmtt.organization_id = wutta.organization_id
1007: AND pgtl.template_id = wutta.pick_load_page_template_id
1008: AND pgtl.template_id = pgvl.template_id
1009: AND pgtl.language = userenv('LANG');

Line 1853: l_standard_operation_id NUMBER;

1849: x_msg_data OUT NOCOPY VARCHAR2) IS
1850:
1851: l_person_resource_id NUMBER;
1852: l_machine_resource_id NUMBER;
1853: l_standard_operation_id NUMBER;
1854: l_operation_plan_id NUMBER;
1855: l_move_order_line_id NUMBER;
1856: l_user_id NUMBER;
1857: l_mmtt_rowcnt NUMBER;

Line 2045: t.standard_operation_id,

2041: IF l_wdt_rowcnt = 0 THEN
2042: BEGIN
2043: SELECT bremp.resource_id role_id,
2044: t.wms_task_type,
2045: t.standard_operation_id,
2046: t.operation_plan_id,
2047: t.move_order_line_id,
2048: t.inventory_item_id
2049: INTO l_person_resource_id,

Line 2051: l_standard_operation_id,

2047: t.move_order_line_id,
2048: t.inventory_item_id
2049: INTO l_person_resource_id,
2050: x_task_type_id,
2051: l_standard_operation_id,
2052: l_operation_plan_id,
2053: l_move_order_line_id,
2054: l_item_id
2055: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp

Line 2057: AND t.standard_operation_id = bsor.standard_operation_id

2053: l_move_order_line_id,
2054: l_item_id
2055: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
2056: WHERE t.transaction_temp_id = p_transaction_temp_id
2057: AND t.standard_operation_id = bsor.standard_operation_id
2058: AND bsor.resource_id = bremp.resource_id
2059: AND bremp.resource_type = 2
2060: AND ROWNUM < 2;
2061:

Line 2194: l_standard_operation_id,

2190: VALUES
2191: (wms_dispatched_tasks_s.NEXTVAL,
2192: p_transaction_temp_id,
2193: p_organization_id,
2194: l_standard_operation_id,
2195: p_employee_id,
2196: p_effective_start_date,
2197: p_effective_end_date,
2198: p_equipment_id,

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

3219: VALUES
3220: (wms_dispatched_tasks_s.NEXTVAL,
3221: task_record.transaction_temp_id,
3222: p_organization_id,
3223: NVL(task_record.standard_operation_id, 2),
3224: p_employee_id,
3225: sysdate , --task_record.effective_start_date, --bug#6409956
3226: sysdate , --task_record.effective_end_date, --bug#6409956
3227: p_equipment_id,

Line 4203: standard_operation_id ,

4199: shipment_number ,
4200: org_cost_group_id ,
4201: cost_type_id ,
4202: transaction_status ,
4203: standard_operation_id ,
4204: task_priority ,
4205: wms_task_type ,
4206: parent_line_id ,
4207: source_lot_number ,

Line 4440: standard_operation_id ,

4436: shipment_number ,
4437: org_cost_group_id ,
4438: cost_type_id ,
4439: transaction_status ,
4440: standard_operation_id ,
4441: task_priority ,
4442: wms_task_type ,
4443: parent_line_id ,
4444: source_lot_number ,