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_RULE_LINES

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 1076: FND_FLEX_VALUE_RULE_LINES L,

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

Line 1096: FROM FND_FLEX_VALUE_RULE_LINES L WHERE

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

Line 1108: NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_HIER_ALL H, FND_FLEX_VALUE_RULE_LINES L

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

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 1156: FND_FLEX_VALUE_RULE_LINES L,

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

Line 1173: FROM FND_FLEX_VALUE_RULE_LINES L WHERE

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

Line 1184: NOT EXISTS (SELECT NULL FROM FND_FLEX_VALUE_HIER_ALL H, FND_FLEX_VALUE_RULE_LINES L

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