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 AHL_MC_RELATIONSHIPS

Line 1043: l_position_ref_cd ahl_mc_relationships.position_ref_code%TYPE;

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:
1047: BEGIN

Line 1053: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE relationship_id IN (SELECT position_reference FROM csi_ii_relationships WHERE subject_id = p_instance_id AND relationship_type_code = 'COMPONENT-OF') AND ROWNUM < 2;

1049:
1050: SELECT COUNT(subject_id) INTO l_child_inst FROM csi_ii_relationships WHERE subject_id = p_instance_id;
1051:
1052: IF(l_child_inst > 0) THEN
1053: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE relationship_id IN (SELECT position_reference FROM csi_ii_relationships WHERE subject_id = p_instance_id AND relationship_type_code = 'COMPONENT-OF') AND ROWNUM < 2;
1054: ELSE
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:

Line 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;

1051:
1052: IF(l_child_inst > 0) THEN
1053: SELECT position_ref_code INTO l_position_ref_cd FROM ahl_mc_relationships WHERE relationship_id IN (SELECT position_reference FROM csi_ii_relationships WHERE subject_id = p_instance_id AND relationship_type_code = 'COMPONENT-OF') AND ROWNUM < 2;
1054: ELSE
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;