APPS.INV_RCV_COMMON_APIS dependencies on MTL_ITEM_LOCATIONS

Line 3202: FROM mtl_item_locations mil

3198: INTO l_dummy
3199: FROM DUAL
3200: WHERE EXISTS(
3201: SELECT 1
3202: FROM mtl_item_locations mil
3203: WHERE mil.organization_id = p_organization_id
3204: AND mil.subinventory_code = l_sub
3205: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3206: AND mil.inventory_location_id = l_locator_id

Line 4250: --get the project_id and task_id from MTL_ITEM_LOCATIONS for this locator

4246: END IF;
4247:
4248: --Bug #3360067
4249: --If the LPN resides in inventory and the current org is PJM-enabled
4250: --get the project_id and task_id from MTL_ITEM_LOCATIONS for this locator
4251: --and compare the project and task of the locator with those passed
4252: --In case of project/task commingling, raise an error indicating the same
4253: --Added extra condition l_count_lpn <> 0 for Bug 5928199
4254: IF (l_lpn_context = 1 AND l_locator_id IS NOT NULL AND l_count_lpn <> 0) THEN

Line 4266: FROM mtl_item_locations mil

4262: SELECT mil.project_id
4263: , mil.task_id
4264: INTO l_loc_project_id
4265: , l_loc_task_id
4266: FROM mtl_item_locations mil
4267: WHERE mil.organization_id = p_organization_id
4268: AND mil.inventory_location_id = l_locator_id;
4269:
4270: IF (l_debug = 1) THEN

Line 4477: FROM mtl_item_loc_defaults mild, mtl_item_locations mil

4473:
4474: BEGIN
4475: SELECT mild.locator_id
4476: INTO l_locator_id
4477: FROM mtl_item_loc_defaults mild, mtl_item_locations mil
4478: WHERE mild.inventory_item_id = p_item_id
4479: AND mild.organization_id = p_organization_id
4480: AND mild.subinventory_code = x_sub_code
4481: AND mil.inventory_location_id = mild.locator_id

Line 4509: FROM mtl_item_loc_defaults mild, mtl_item_locations mil

4505: x_default_source := 'ITD';
4506: BEGIN
4507: SELECT mild.locator_id
4508: INTO l_locator_id
4509: FROM mtl_item_loc_defaults mild, mtl_item_locations mil
4510: WHERE mild.inventory_item_id = p_item_id
4511: AND mild.organization_id = p_organization_id
4512: AND mild.subinventory_code = x_sub_code
4513: AND mil.inventory_location_id = mild.locator_id

Line 4537: FROM mtl_item_locations

4533:
4534: BEGIN
4535: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
4536: INTO x_locator_segs
4537: FROM mtl_item_locations
4538: WHERE organization_id = p_organization_id
4539: AND inventory_location_id = l_locator_id;
4540:
4541: x_locator_id := l_locator_id;

Line 7693: FROM mtl_item_locations

7689: l_progress := '70';
7690: BEGIN
7691: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
7692: INTO x_locator_segs
7693: FROM mtl_item_locations
7694: WHERE organization_id = p_organization_id
7695: AND inventory_location_id = l_locator_id;
7696: EXCEPTION
7697: WHEN OTHERS THEN