APPS.WMS_TASK_LOAD dependencies on MTL_ITEM_LOCATIONS

Line 7233: FROM mtl_item_locations_kfv

7229:
7230: -- verify if locator is active
7231: SELECT COUNT(*)
7232: INTO l_loc_active
7233: FROM mtl_item_locations_kfv
7234: WHERE NVL(disable_date, SYSDATE + 1) > SYSDATE
7235: AND organization_id = p_org_id
7236: AND subinventory_code = l_sub
7237: AND inventory_location_id = l_loc_id;

Line 7261: from mtl_item_locations

7257: where transaction_temp_id = p_temp_id;
7258:
7259: select nvl(project_id ,-999) , nvl(task_id ,-999)
7260: into l_mmtt_proj_id , l_mmtt_task_id
7261: from mtl_item_locations
7262: where inventory_location_id = l_locator_id
7263: and organization_id = l_organization_id ;
7264:
7265: select nvl(project_id, -999) , nvl(task_id ,-999)

Line 7267: from mtl_item_locations

7263: and organization_id = l_organization_id ;
7264:
7265: select nvl(project_id, -999) , nvl(task_id ,-999)
7266: into l_mil_proj_id , l_mil_task_id
7267: from mtl_item_locations
7268: where inventory_location_id = l_loc_id
7269: and organization_id = p_org_id ;
7270:
7271: mydebug('mmtt project id = '||l_mmtt_proj_id);

Line 10660: ( prj_id mtl_item_locations.project_id%TYPE

10656:
10657: pick_to_lpn_rec lpn_rectype;
10658:
10659: TYPE pjm_rectype IS RECORD
10660: ( prj_id mtl_item_locations.project_id%TYPE
10661: , tsk_id mtl_item_locations.task_id%TYPE
10662: );
10663:
10664: mtl_pjm_prj_tsk_rec pjm_rectype;

Line 10661: , tsk_id mtl_item_locations.task_id%TYPE

10657: pick_to_lpn_rec lpn_rectype;
10658:
10659: TYPE pjm_rectype IS RECORD
10660: ( prj_id mtl_item_locations.project_id%TYPE
10661: , tsk_id mtl_item_locations.task_id%TYPE
10662: );
10663:
10664: mtl_pjm_prj_tsk_rec pjm_rectype;
10665: lpn_pjm_prj_tsk_rec pjm_rectype;

Line 10713: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt

10709: --
10710: CURSOR lpn_project_task_cursor(p_pick_to_lpn_id NUMBER) IS
10711: SELECT NVL(mil.project_id, -1)
10712: , NVL(mil.task_id, -1)
10713: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt
10714: WHERE mil.inventory_location_id = mmtt.transfer_to_location
10715: AND mil.organization_id = mmtt.organization_id
10716: AND mmtt.transfer_lpn_id = p_pick_to_lpn_id
10717: AND mmtt.organization_id = p_organization_id;

Line 10726: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt

10722: --
10723: CURSOR mtl_project_task_cursor IS
10724: SELECT NVL(mil.project_id, -1)
10725: , NVL(mil.task_id, -1)
10726: FROM mtl_item_locations mil, mtl_material_transactions_temp mmtt
10727: WHERE mil.inventory_location_id = mmtt.transfer_to_location
10728: AND mil.organization_id = mmtt.organization_id
10729: AND mmtt.organization_id = p_organization_id
10730: AND mmtt.transaction_temp_id = p_temp_id;