eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_REPORT_UTILS_PVT dependencies on FND_LOOKUPS

Line 1042: x_position fnd_lookups.Meaning%TYPE;

1038: P_INSTANCE_ID IN NUMBER,
1039: P_ITEM_GRP_ID IN NUMBER)
1040: RETURN VARCHAR2
1041: IS
1042: x_position fnd_lookups.Meaning%TYPE;
1043: l_position_ref_cd ahl_mc_relationships.position_ref_code%TYPE;
1044: l_master_config_id ahl_unit_config_headers.master_config_id%TYPE;
1045: l_child_inst NUMBER;
1046:

Line 1059: SELECT meaning INTO x_position FROM fnd_lookups fnd WHERE fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND fnd.lookup_code = l_position_ref_cd;

1055: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE mc_header_id IN (SELECT master_config_id FROM ahl_unit_config_headers WHERE csi_item_instance_id = P_INSTANCE_ID) AND item_group_id = P_ITEM_GRP_ID AND ROWNUM < 2;
1056: END IF;
1057:
1058: IF(l_position_ref_cd IS NOT NULL) THEN
1059: SELECT meaning INTO x_position FROM fnd_lookups fnd WHERE fnd.lookup_type = 'AHL_POSITION_REFERENCE' AND fnd.lookup_code = l_position_ref_cd;
1060: END IF;
1061: IF(x_position IS NULL) THEN
1062: SELECT concatenated_segments INTO x_position FROM mtl_item_locations_kfv k WHERE inventory_location_id = (SELECT INV_LOCATOR_ID FROM csi_item_instances WHERE instance_id = P_INSTANCE_ID);
1063: END IF;