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_NUMBER

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 1086: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_LOW) 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)
1089: BETWEEN
1090: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE)) AND

Line 1087: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_HIGH) 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)
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

Line 1088: fnd_number.canonical_to_number(H.PARENT_FLEX_VALUE)

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

Line 1090: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE)) AND

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

Line 1091: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE))) AND

1087: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_HIGH) AND
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

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 1114: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_LOW) 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
1118: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE)))))

Line 1115: fnd_number.canonical_to_number(H.CHILD_FLEX_VALUE_HIGH) 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
1118: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE)))))
1119: ORDER BY

Line 1116: fnd_number.canonical_to_number(H.PARENT_FLEX_VALUE) BETWEEN

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

Line 1117: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_LOW, H.PARENT_FLEX_VALUE)) 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
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,

Line 1118: fnd_number.canonical_to_number(NVL(L.FLEX_VALUE_HIGH, H.PARENT_FLEX_VALUE)))))

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

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 $ */