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.GL_DRM_INTEGRATION_PKG dependencies on FND_FLEX_VALUE_NORM_HIERARCHY

Line 1165: FROM FND_FLEX_VALUE_NORM_HIERARCHY fnh

1161: WHERE FFV.flex_value_set_id = p_value_set_id
1162: AND FFV.summary_flag = 'Y'
1163: AND NOT EXISTS
1164: (SELECT 'X'
1165: FROM FND_FLEX_VALUE_NORM_HIERARCHY fnh
1166: WHERE FNH.flex_value_set_id = FFV.flex_value_set_id
1167: AND FNH.range_attribute = 'P'
1168: AND FFV.flex_value BETWEEN FNH.child_flex_value_low AND FNH.child_flex_value_high)
1169: -- 1235002: first check if ranges are defined in the norm hierarchy table for this parent

Line 1172: FROM FND_FLEX_VALUE_NORM_HIERARCHY fnh1

1168: AND FFV.flex_value BETWEEN FNH.child_flex_value_low AND FNH.child_flex_value_high)
1169: -- 1235002: first check if ranges are defined in the norm hierarchy table for this parent
1170: AND EXISTS
1171: (SELECT 'X'
1172: FROM FND_FLEX_VALUE_NORM_HIERARCHY fnh1
1173: WHERE FNH1.flex_value_set_id = FFV.flex_value_set_id
1174: AND FNH1.parent_flex_value = FFV.flex_value
1175: -- confirm that the ranges have at least one child node defined
1176: AND EXISTS

Line 1192: FROM Fnd_Flex_Value_Norm_Hierarchy nh,

1188: IS
1189: SELECT
1190: nh.parent_flex_value parent,
1191: cv.flex_value child
1192: FROM Fnd_Flex_Value_Norm_Hierarchy nh,
1193: Fnd_Flex_Values cv
1194: WHERE nh.flex_value_set_id = p_value_set_id
1195: AND nh.flex_value_set_Id = cv.flex_value_set_id
1196: AND cv.flex_value <> nh.parent_flex_value