DBA Data[Home] [Help]

APPS.AHL_APPR_SPACE_CAPB_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 1775: FROM MTL_SYSTEM_ITEMS_B_KFV

1771: IF p_inventory_item_id IS NOT NULL
1772: THEN
1773: SELECT DISTINCT(inventory_item_id)
1774: INTO x_inventory_item_id
1775: FROM MTL_SYSTEM_ITEMS_B_KFV
1776: WHERE inventory_item_id = p_inventory_item_id;
1777: END IF;
1778: --
1779: IF p_item_description IS NOT NULL THEN

Line 1782: FROM MTL_SYSTEM_ITEMS_B_KFV

1778: --
1779: IF p_item_description IS NOT NULL THEN
1780: SELECT DISTINCT(inventory_item_id)
1781: INTO x_inventory_item_id
1782: FROM MTL_SYSTEM_ITEMS_B_KFV
1783: WHERE concatenated_segments = p_item_description;
1784: END IF;
1785: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1786: IF G_DEBUG='Y' THEN