DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 4705: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS

4701: SELECT
4702: ILOC.inventory_location_id
4703: FROM
4704: -- jaramana on Feb 14, 2008 for bug 6819370
4705: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4706: MTL_ITEM_LOCATIONS ILOC,
4707: AHL_VISITS_B VST
4708: WHERE
4709: ILOC.subinventory_code = C.inv_subinventory_name

Line 4819: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS

4815: SELECT
4816: ILOC.inventory_location_id
4817: FROM
4818: -- jaramana on Feb 14, 2008 for bug 6819370
4819: -- Changed MTL_ITEM_LOCATIONS_KFV to MTL_ITEM_LOCATIONS
4820: MTL_ITEM_LOCATIONS ILOC,
4821: AHL_VISITS_B VST
4822: WHERE
4823: ILOC.subinventory_code = C.inv_subinventory_name

Line 4994: MTL_ITEM_LOCATIONS_KFV

4990: IS
4991: SELECT
4992: concatenated_segments
4993: FROM
4994: MTL_ITEM_LOCATIONS_KFV
4995: WHERE
4996: inventory_location_id = c_inv_location_id;
4997:
4998: -- declare all local variables here