[Home] [Help]
421: , wdt.priority
422: , wdt.task_id task_id
423: , sub.picking_order sub_picking_order
424: , loc.picking_order loc_picking_order
425: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
426: WHERE wdt.person_id = l_user_id
427: AND wdt.organization_id = l_org_id
428: AND wdt.status <= 3
429: AND wdt.task_type IN (1, 4, 5, 6)
440: , wdt.task_id task_id
441: , sub.picking_order sub_picking_order
442: , loc.picking_order loc_picking_order
443: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
444: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
445: ,mtl_cycle_count_headers mcch
446: WHERE wdt.person_id = l_user_id
447: AND wdt.organization_id = l_org_id
448: AND wdt.status <= 3
468: , wdt.priority
469: , wdt.task_id task_id
470: , sub.picking_order sub_picking_order
471: , loc.picking_order loc_picking_order
472: FROM mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
473: WHERE wdt.person_id = l_user_id
474: AND wdt.organization_id = l_org_id
475: AND wdt.status <= 3
476: AND wdt.task_type IN (1, 4, 5, 6)
486: , wdt.task_id task_id
487: , sub.picking_order sub_picking_order
488: , loc.picking_order loc_picking_order
489: --Bug 3808770 -Added the table mtl_cycle_count_headers in the FROM clause
490: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt, mtl_item_locations loc, mtl_secondary_inventories sub
491: , mtl_cycle_count_headers mcch
492: WHERE wdt.person_id = l_user_id
493: AND wdt.organization_id = l_org_id
494: AND wdt.status <= 3
2854:
2855: -- verify if locator is active
2856: SELECT COUNT(*)
2857: INTO l_loc_active
2858: FROM mtl_item_locations_kfv
2859: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
2860: AND organization_id = p_org_id
2861: AND subinventory_code = l_sub
2862: AND inventory_location_id = l_loc_id;
2875: where transaction_temp_id = p_temp_id;
2876:
2877: select nvl(project_id ,-999) , nvl(task_id ,-999)
2878: into l_mmtt_proj_id , l_mmtt_task_id
2879: from mtl_item_locations
2880: where inventory_location_id = l_locator_id
2881: and organization_id = l_organization_id ;
2882:
2883: select nvl(project_id, -999) , nvl(task_id ,-999)
2881: and organization_id = l_organization_id ;
2882:
2883: select nvl(project_id, -999) , nvl(task_id ,-999)
2884: into l_mil_proj_id , l_mil_task_id
2885: from mtl_item_locations
2886: where inventory_location_id = l_loc_id
2887: and organization_id = p_org_id ;
2888:
2889: mydebug('mmtt project id = '||l_mmtt_proj_id);
7966:
7967: pick_to_lpn_rec lpn_rectype;
7968:
7969: TYPE pjm_rectype IS RECORD
7970: ( prj_id mtl_item_locations.project_id%TYPE
7971: , tsk_id mtl_item_locations.task_id%TYPE
7972: );
7973:
7974: mtl_pjm_prj_tsk_rec pjm_rectype;
7967: pick_to_lpn_rec lpn_rectype;
7968:
7969: TYPE pjm_rectype IS RECORD
7970: ( prj_id mtl_item_locations.project_id%TYPE
7971: , tsk_id mtl_item_locations.task_id%TYPE
7972: );
7973:
7974: mtl_pjm_prj_tsk_rec pjm_rectype;
7975: lpn_pjm_prj_tsk_rec pjm_rectype;
8024: --
8025: CURSOR lpn_project_task_cursor IS
8026: SELECT NVL(mil.project_id, -1)
8027: , NVL(mil.task_id, -1)
8028: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt
8029: WHERE mil.inventory_location_id = mmtt.transfer_to_location
8030: AND mil.organization_id = mmtt.organization_id
8031: AND mmtt.transfer_lpn_id = p_pick_to_lpn
8032: AND mmtt.organization_id = p_organization_id;
8037: --
8038: CURSOR mtl_project_task_cursor IS
8039: SELECT NVL(mil.project_id, -1)
8040: , NVL(mil.task_id, -1)
8041: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt
8042: WHERE mil.inventory_location_id = mmtt.transfer_to_location
8043: AND mil.organization_id = mmtt.organization_id
8044: AND mmtt.organization_id = p_organization_id
8045: AND mmtt.transaction_temp_id = p_temp_id;