APPS.WMS_TASK_LOAD dependencies on MTL_ITEM_LOCATIONS

Line 8758: FROM mtl_item_locations_kfv

8754:
8755: -- verify if locator is active
8756: SELECT COUNT(*)
8757: INTO l_loc_active
8758: FROM mtl_item_locations_kfv
8759: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
8760: AND organization_id = p_org_id
8761: AND subinventory_code = l_sub
8762: AND inventory_location_id = l_loc_id;

Line 8787: from mtl_item_locations

8783: where transaction_temp_id = p_temp_id;
8784:
8785: select nvl(project_id ,-999) , nvl(task_id ,-999)
8786: into l_mmtt_proj_id , l_mmtt_task_id
8787: from mtl_item_locations
8788: where inventory_location_id = l_locator_id
8789: and organization_id = l_organization_id ;
8790:
8791: select nvl(project_id, -999) , nvl(task_id ,-999)

Line 8793: from mtl_item_locations

8789: and organization_id = l_organization_id ;
8790:
8791: select nvl(project_id, -999) , nvl(task_id ,-999)
8792: into l_mil_proj_id , l_mil_task_id
8793: from mtl_item_locations
8794: where inventory_location_id = l_loc_id
8795: and organization_id = p_org_id ;
8796:
8797: mydebug('mmtt project id = '||l_mmtt_proj_id);

Line 12956: ( prj_id mtl_item_locations.project_id%TYPE

12952:
12953: pick_to_lpn_rec lpn_rectype;
12954:
12955: TYPE pjm_rectype IS RECORD
12956: ( prj_id mtl_item_locations.project_id%TYPE
12957: , tsk_id mtl_item_locations.task_id%TYPE
12958: );
12959:
12960: mtl_pjm_prj_tsk_rec pjm_rectype;

Line 12957: , tsk_id mtl_item_locations.task_id%TYPE

12953: pick_to_lpn_rec lpn_rectype;
12954:
12955: TYPE pjm_rectype IS RECORD
12956: ( prj_id mtl_item_locations.project_id%TYPE
12957: , tsk_id mtl_item_locations.task_id%TYPE
12958: );
12959:
12960: mtl_pjm_prj_tsk_rec pjm_rectype;
12961: lpn_pjm_prj_tsk_rec pjm_rectype;

Line 13009: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt

13005: --
13006: CURSOR lpn_project_task_cursor(p_pick_to_lpn_id NUMBER) IS
13007: SELECT NVL(mil.project_id, -1)
13008: , NVL(mil.task_id, -1)
13009: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt
13010: WHERE mil.inventory_location_id = mmtt.transfer_to_location
13011: AND mil.organization_id = mmtt.organization_id
13012: AND mmtt.transfer_lpn_id = p_pick_to_lpn_id
13013: AND mmtt.organization_id = p_organization_id;

Line 13022: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt

13018: --
13019: CURSOR mtl_project_task_cursor IS
13020: SELECT NVL(mil.project_id, -1)
13021: , NVL(mil.task_id, -1)
13022: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt
13023: WHERE mil.inventory_location_id = mmtt.transfer_to_location
13024: AND mil.organization_id = mmtt.organization_id
13025: AND mmtt.organization_id = p_organization_id
13026: AND mmtt.transaction_temp_id = p_temp_id;