APPS.AHL_FMP_PVT dependencies on AHL_UNIT_INSTALLED_DETAILS_V

Line 6: --Define Global Cursor: get item instance attributes from ahl_unit_installed_details_v.

2: /* $Header: AHLVFMPB.pls 120.9.12010000.2 2008/12/27 01:04:51 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AHL_FMP_PVT';
5: G_APPLN_USAGE VARCHAR2(30):=FND_PROFILE.VALUE('AHL_APPLN_USAGE');
6: --Define Global Cursor: get item instance attributes from ahl_unit_installed_details_v.
7: --The last two attributes: manufacturer_id and counctry_code are not in the view definition.
8: CURSOR get_inst_attri(c_item_instance_id NUMBER) IS
9: SELECT serial_number, item_number, inventory_item_id,
10: location_description, status, owner_name, condition,

Line 12: FROM ahl_unit_installed_details_v

8: CURSOR get_inst_attri(c_item_instance_id NUMBER) IS
9: SELECT serial_number, item_number, inventory_item_id,
10: location_description, status, owner_name, condition,
11: mfg_date, 'm' manufacturer_id, 'c' country_code
12: FROM ahl_unit_installed_details_v
13: WHERE csi_item_instance_id = c_item_instance_id;
14:
15:
16: --Check whether the given item instance exists