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.FND_FLEX_HIERARCHY_COMPILER dependencies on FND_FLEX_VALUE_RULES

Line 1059: FROM FND_FLEX_VALUES_VL, FND_FLEX_VALUE_RULES RS

1055: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID*(-1),
1056: RS.FLEX_VALUE_RULE_ID,
1057: FND_FLEX_VALUES_VL.FLEX_VALUE,
1058: SYSDATE, 0, sysdate, 0
1059: FROM FND_FLEX_VALUES_VL, FND_FLEX_VALUE_RULES RS
1060: WHERE
1061: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id
1062: AND FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = RS.FLEX_VALUE_SET_ID
1063: AND FND_FLEX_VALUES_VL.ENABLED_FLAG = 'Y'

Line 1065: (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES R

1061: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id
1062: AND FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = RS.FLEX_VALUE_SET_ID
1063: AND FND_FLEX_VALUES_VL.ENABLED_FLAG = 'Y'
1064: AND NOT EXISTS
1065: (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES R
1066: WHERE L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id
1067: AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID
1068: AND R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID
1069: AND L.INCLUDE_EXCLUDE_INDICATOR = 'E'

Line 1077: FND_FLEX_VALUE_RULES R

1073: AND fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE))) AND
1074: NOT EXISTS (SELECT NULL FROM
1075: FND_FLEX_VALUE_HIER_ALL H,
1076: FND_FLEX_VALUE_RULE_LINES L,
1077: FND_FLEX_VALUE_RULES R
1078: WHERE
1079: L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1080: H.FLEX_VALUE_SET_ID = L.FLEX_VALUE_SET_ID AND
1081: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND

Line 1092: (NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULES R

1088: fnd_number.canonical_to_number(H.PARENT_FLEX_VALUE)
1089: BETWEEN
1090: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE)) AND
1091: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE))) AND
1092: (NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULES R
1093: WHERE R.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1094: R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID AND
1095: NOT EXISTS (SELECT NULL
1096: FROM FND_FLEX_VALUE_RULE_LINES L WHERE

Line 1105: (SELECT NULL FROM FND_FLEX_VALUE_RULES R

1101: BETWEEN
1102: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE)) AND
1103: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE))))
1104: OR NOT EXISTS
1105: (SELECT NULL FROM FND_FLEX_VALUE_RULES R
1106: WHERE R.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1107: R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID AND
1108: NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_HIER_ALL H, FND_FLEX_VALUE_RULE_LINES L
1109: WHERE H.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND

Line 1140: FROM FND_FLEX_VALUES_VL, FND_FLEX_VALUE_RULES RS

1136: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID*(-1),
1137: RS.FLEX_VALUE_RULE_ID,
1138: FND_FLEX_VALUES_VL.FLEX_VALUE,
1139: SYSDATE, 0, sysdate, 0
1140: FROM FND_FLEX_VALUES_VL, FND_FLEX_VALUE_RULES RS
1141: WHERE
1142: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id
1143: AND FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = RS.FLEX_VALUE_SET_ID
1144: AND FND_FLEX_VALUES_VL.ENABLED_FLAG = 'Y'

Line 1146: (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES R

1142: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id
1143: AND FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = RS.FLEX_VALUE_SET_ID
1144: AND FND_FLEX_VALUES_VL.ENABLED_FLAG = 'Y'
1145: AND NOT EXISTS
1146: (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES R
1147: WHERE L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id
1148: AND L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID
1149: AND R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID
1150: AND L.INCLUDE_EXCLUDE_INDICATOR = 'E'

Line 1157: FND_FLEX_VALUE_RULES R

1153: AND NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE)) AND
1154: NOT EXISTS (SELECT NULL FROM
1155: FND_FLEX_VALUE_HIER_ALL H,
1156: FND_FLEX_VALUE_RULE_LINES L,
1157: FND_FLEX_VALUE_RULES R
1158: WHERE
1159: L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1160: H.FLEX_VALUE_SET_ID = L.FLEX_VALUE_SET_ID AND
1161: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND

Line 1169: (NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULES R

1165: BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH AND
1166: H.PARENT_FLEX_VALUE
1167: BETWEEN NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE) AND
1168: NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE)) AND
1169: (NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_RULES R
1170: WHERE R.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1171: R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID AND
1172: NOT EXISTS (SELECT NULL
1173: FROM FND_FLEX_VALUE_RULE_LINES L WHERE

Line 1181: (SELECT NULL FROM FND_FLEX_VALUE_RULES R

1177: FND_FLEX_VALUES_VL.FLEX_VALUE BETWEEN NVL(L.FLEX_VALUE_LOW,
1178: FND_FLEX_VALUES_VL.FLEX_VALUE)
1179: AND NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE)))
1180: OR NOT EXISTS
1181: (SELECT NULL FROM FND_FLEX_VALUE_RULES R
1182: WHERE R.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1183: R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID AND
1184: NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_HIER_ALL H, FND_FLEX_VALUE_RULE_LINES L
1185: WHERE H.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND