APPS.INV_RCV_COMMON_APIS dependencies on MTL_ITEM_LOCATIONS

Line 3024: FROM mtl_item_locations mil

3020: INTO l_dummy
3021: FROM DUAL
3022: WHERE EXISTS(
3023: SELECT 1
3024: FROM mtl_item_locations mil
3025: WHERE mil.organization_id = p_organization_id
3026: AND mil.subinventory_code = l_sub
3027: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3028: AND mil.inventory_location_id = l_locator_id

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

3763: END IF;
3764:
3765: --Bug #3360067
3766: --If the LPN resides in inventory and the current org is PJM-enabled
3767: --get the project_id and task_id from MTL_ITEM_LOCATIONS for this locator
3768: --and compare the project and task of the locator with those passed
3769: --In case of project/task commingling, raise an error indicating the same
3770: --Added extra condition l_count_lpn <> 0 for Bug 5928199
3771: IF (l_lpn_context = 1 AND l_locator_id IS NOT NULL AND l_count_lpn <> 0) THEN

Line 3783: FROM mtl_item_locations mil

3779: SELECT mil.project_id
3780: , mil.task_id
3781: INTO l_loc_project_id
3782: , l_loc_task_id
3783: FROM mtl_item_locations mil
3784: WHERE mil.organization_id = p_organization_id
3785: AND mil.inventory_location_id = l_locator_id;
3786:
3787: IF (l_debug = 1) THEN

Line 3994: FROM mtl_item_loc_defaults mild, mtl_item_locations mil

3990:
3991: BEGIN
3992: SELECT mild.locator_id
3993: INTO l_locator_id
3994: FROM mtl_item_loc_defaults mild, mtl_item_locations mil
3995: WHERE mild.inventory_item_id = p_item_id
3996: AND mild.organization_id = p_organization_id
3997: AND mild.subinventory_code = x_sub_code
3998: AND mil.inventory_location_id = mild.locator_id

Line 4026: FROM mtl_item_loc_defaults mild, mtl_item_locations mil

4022: x_default_source := 'ITD';
4023: BEGIN
4024: SELECT mild.locator_id
4025: INTO l_locator_id
4026: FROM mtl_item_loc_defaults mild, mtl_item_locations mil
4027: WHERE mild.inventory_item_id = p_item_id
4028: AND mild.organization_id = p_organization_id
4029: AND mild.subinventory_code = x_sub_code
4030: AND mil.inventory_location_id = mild.locator_id

Line 4054: FROM mtl_item_locations

4050:
4051: BEGIN
4052: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
4053: INTO x_locator_segs
4054: FROM mtl_item_locations
4055: WHERE organization_id = p_organization_id
4056: AND inventory_location_id = l_locator_id;
4057:
4058: x_locator_id := l_locator_id;

Line 7161: FROM mtl_item_locations

7157: l_progress := '70';
7158: BEGIN
7159: SELECT inv_project.get_locsegs(inventory_location_id, organization_id)
7160: INTO x_locator_segs
7161: FROM mtl_item_locations
7162: WHERE organization_id = p_organization_id
7163: AND inventory_location_id = l_locator_id;
7164: EXCEPTION
7165: WHEN OTHERS THEN