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_VALUES_VL

Line 1055: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID*(-1),

1051: LAST_UPDATED_BY,
1052: CREATION_DATE,
1053: CREATED_BY)
1054: SELECT
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

Line 1057: FND_FLEX_VALUES_VL.FLEX_VALUE,

1053: CREATED_BY)
1054: SELECT
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

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 1061: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = g_vset.flex_value_set_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'
1064: AND NOT EXISTS
1065: (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES R

Line 1062: AND FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = RS.FLEX_VALUE_SET_ID

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'
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

Line 1063: AND FND_FLEX_VALUES_VL.ENABLED_FLAG = 'Y'

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'
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

Line 1070: AND fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)

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'
1070: AND fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
1071: BETWEEN
1072: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE))
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

Line 1072: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE))

1068: AND R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID
1069: AND L.INCLUDE_EXCLUDE_INDICATOR = 'E'
1070: AND fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
1071: BETWEEN
1072: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE))
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,

Line 1073: AND fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE))) AND

1069: AND L.INCLUDE_EXCLUDE_INDICATOR = 'E'
1070: AND fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
1071: BETWEEN
1072: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE))
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

Line 1084: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)

1080: H.FLEX_VALUE_SET_ID = L.FLEX_VALUE_SET_ID AND
1081: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1082: R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID AND
1083: L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND
1084: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
1085: BETWEEN
1086: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_LOW) AND
1087: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_HIGH) AND
1088: fnd_number.canonical_to_number(H.PARENT_FLEX_VALUE)

Line 1100: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)

1096: FROM FND_FLEX_VALUE_RULE_LINES L WHERE
1097: L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1098: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1099: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
1100: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
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

Line 1102: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE)) AND

1098: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1099: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
1100: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
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

Line 1103: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE))))

1099: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
1100: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE)
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

Line 1113: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE) BETWEEN

1109: WHERE H.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1110: H.FLEX_VALUE_SET_ID = L.FLEX_VALUE_SET_ID AND
1111: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1112: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
1113: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE) BETWEEN
1114: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_LOW) AND
1115: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_HIGH) AND
1116: fnd_number.canonical_to_number(H.PARENT_FLEX_VALUE) BETWEEN
1117: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE)) AND

Line 1120: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID,

1116: fnd_number.canonical_to_number(H.PARENT_FLEX_VALUE) BETWEEN
1117: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE)) AND
1118: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE)))))
1119: ORDER BY
1120: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID,
1121: RS.FLEX_VALUE_RULE_ID,
1122: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE);
1123:
1124: ELSE -- Character format type (DATE TIME are not supported)

Line 1122: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE);

1118: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE)))))
1119: ORDER BY
1120: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID,
1121: RS.FLEX_VALUE_RULE_ID,
1122: fnd_number.canonical_to_number(FND_FLEX_VALUES_VL.FLEX_VALUE);
1123:
1124: ELSE -- Character format type (DATE TIME are not supported)
1125:
1126: INSERT /* $Header: AFFFCHYB.pls 120.4 2011/11/08 19:05:50 hgeorgi ship $ */

Line 1136: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID*(-1),

1132: LAST_UPDATED_BY,
1133: CREATION_DATE,
1134: CREATED_BY)
1135: SELECT
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

Line 1138: FND_FLEX_VALUES_VL.FLEX_VALUE,

1134: CREATED_BY)
1135: SELECT
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

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 1142: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = g_vset.flex_value_set_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'
1145: AND NOT EXISTS
1146: (SELECT NULL FROM FND_FLEX_VALUE_RULE_LINES L, FND_FLEX_VALUE_RULES R

Line 1143: AND FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = RS.FLEX_VALUE_SET_ID

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'
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

Line 1144: AND FND_FLEX_VALUES_VL.ENABLED_FLAG = 'Y'

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'
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

Line 1151: AND FND_FLEX_VALUES_VL.FLEX_VALUE

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'
1151: AND FND_FLEX_VALUES_VL.FLEX_VALUE
1152: BETWEEN NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE)
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,

Line 1152: BETWEEN NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE)

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'
1151: AND FND_FLEX_VALUES_VL.FLEX_VALUE
1152: BETWEEN NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE)
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,

Line 1153: AND NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE)) AND

1149: AND R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID
1150: AND L.INCLUDE_EXCLUDE_INDICATOR = 'E'
1151: AND FND_FLEX_VALUES_VL.FLEX_VALUE
1152: BETWEEN NVL(L.FLEX_VALUE_LOW, FND_FLEX_VALUES_VL.FLEX_VALUE)
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

Line 1164: FND_FLEX_VALUES_VL.FLEX_VALUE

1160: H.FLEX_VALUE_SET_ID = L.FLEX_VALUE_SET_ID AND
1161: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1162: R.FLEX_VALUE_RULE_ID=RS.FLEX_VALUE_RULE_ID AND
1163: L.INCLUDE_EXCLUDE_INDICATOR = 'E' AND
1164: FND_FLEX_VALUES_VL.FLEX_VALUE
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

Line 1177: FND_FLEX_VALUES_VL.FLEX_VALUE BETWEEN NVL(L.FLEX_VALUE_LOW,

1173: FROM FND_FLEX_VALUE_RULE_LINES L WHERE
1174: L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1175: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1176: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
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

Line 1178: FND_FLEX_VALUES_VL.FLEX_VALUE)

1174: L.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1175: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1176: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
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

Line 1179: AND NVL(L.FLEX_VALUE_HIGH, FND_FLEX_VALUES_VL.FLEX_VALUE)))

1175: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1176: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
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

Line 1189: FND_FLEX_VALUES_VL.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND

1185: WHERE H.FLEX_VALUE_SET_ID = g_vset.flex_value_set_id AND
1186: H.FLEX_VALUE_SET_ID = L.FLEX_VALUE_SET_ID AND
1187: L.FLEX_VALUE_RULE_ID = R.FLEX_VALUE_RULE_ID AND
1188: L.INCLUDE_EXCLUDE_INDICATOR = 'I' AND
1189: FND_FLEX_VALUES_VL.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND
1190: H.CHILD_FLEX_VALUE_HIGH
1191: AND H.PARENT_FLEX_VALUE BETWEEN NVL(L.FLEX_VALUE_LOW,
1192: H.PARENT_FLEX_VALUE)
1193: AND NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE))))

Line 1195: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID,

1191: AND H.PARENT_FLEX_VALUE BETWEEN NVL(L.FLEX_VALUE_LOW,
1192: H.PARENT_FLEX_VALUE)
1193: AND NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE))))
1194: ORDER BY
1195: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID,
1196: RS.FLEX_VALUE_RULE_ID,
1197: FND_FLEX_VALUES_VL.FLEX_VALUE;
1198:
1199: END IF;

Line 1197: FND_FLEX_VALUES_VL.FLEX_VALUE;

1193: AND NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE))))
1194: ORDER BY
1195: FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID,
1196: RS.FLEX_VALUE_RULE_ID,
1197: FND_FLEX_VALUES_VL.FLEX_VALUE;
1198:
1199: END IF;
1200:
1201: COMMIT;