APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_ITEM_LOCATIONS

Line 4739: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS

4735: SELECT
4736: ILOC.inventory_location_id
4737: FROM
4738: -- jaramana on Feb 14, 2008 for bug 6819370
4739: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4740: MTL_ITEM_LOCATIONS ILOC,
4741: AHL_VISITS_B VST
4742: WHERE
4743: ILOC.subinventory_code = C.inv_subinventory_name

Line 4740: MTL_ITEM_LOCATIONS ILOC,

4736: ILOC.inventory_location_id
4737: FROM
4738: -- jaramana on Feb 14, 2008 for bug 6819370
4739: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4740: MTL_ITEM_LOCATIONS ILOC,
4741: AHL_VISITS_B VST
4742: WHERE
4743: ILOC.subinventory_code = C.inv_subinventory_name
4744: AND ILOC.organization_id = C.inv_organization_id

Line 4878: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS

4874: SELECT
4875: ILOC.inventory_location_id
4876: FROM
4877: -- jaramana on Feb 14, 2008 for bug 6819370
4878: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4879: MTL_ITEM_LOCATIONS ILOC,
4880: AHL_VISITS_B VST
4881: WHERE
4882: ILOC.subinventory_code = C.inv_subinventory_name

Line 4879: MTL_ITEM_LOCATIONS ILOC,

4875: ILOC.inventory_location_id
4876: FROM
4877: -- jaramana on Feb 14, 2008 for bug 6819370
4878: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4879: MTL_ITEM_LOCATIONS ILOC,
4880: AHL_VISITS_B VST
4881: WHERE
4882: ILOC.subinventory_code = C.inv_subinventory_name
4883: AND ILOC.organization_id = C.inv_organization_id

Line 5089: MTL_ITEM_LOCATIONS_KFV

5085: IS
5086: SELECT
5087: concatenated_segments
5088: FROM
5089: MTL_ITEM_LOCATIONS_KFV
5090: WHERE
5091: inventory_location_id = c_inv_location_id;
5092:
5093: -- declare all local variables here