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.JA_CN_SI_BANK_DET_PKG dependencies on FND_NUMBER

Line 201: (fnd_number.canonical_to_number(v.flex_value) BETWEEN

197: fnd_flex_value_sets s
198: WHERE h.flex_value_set_id = v.flex_value_set_id
199: AND s.flex_value_set_id = v.flex_value_set_id
200: AND (((s.format_type = 'N') AND
201: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
202: fnd_number.canonical_to_number(h.child_flex_value_low) AND
203: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
204: ((s.format_type IN ('D', 'T')) AND
205: (to_date(v.flex_value,

Line 202: fnd_number.canonical_to_number(h.child_flex_value_low) AND

198: WHERE h.flex_value_set_id = v.flex_value_set_id
199: AND s.flex_value_set_id = v.flex_value_set_id
200: AND (((s.format_type = 'N') AND
201: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
202: fnd_number.canonical_to_number(h.child_flex_value_low) AND
203: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
204: ((s.format_type IN ('D', 'T')) AND
205: (to_date(v.flex_value,
206: (decode(s.maximum_size,

Line 203: fnd_number.canonical_to_number(h.child_flex_value_high))) OR

199: AND s.flex_value_set_id = v.flex_value_set_id
200: AND (((s.format_type = 'N') AND
201: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
202: fnd_number.canonical_to_number(h.child_flex_value_low) AND
203: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
204: ((s.format_type IN ('D', 'T')) AND
205: (to_date(v.flex_value,
206: (decode(s.maximum_size,
207: 5,

Line 1215: (fnd_number.canonical_to_number(v.flex_value) BETWEEN

1211: WHERE h.flex_value_set_id = v.flex_value_set_id
1212: AND v.ENABLED_FLAG = 'Y'
1213: AND s.flex_value_set_id = v.flex_value_set_id
1214: AND (((s.format_type = 'N') AND
1215: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
1216: fnd_number.canonical_to_number(h.child_flex_value_low) AND
1217: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
1218: ((s.format_type IN ('D', 'T')) AND
1219: (to_date(v.flex_value,

Line 1216: fnd_number.canonical_to_number(h.child_flex_value_low) AND

1212: AND v.ENABLED_FLAG = 'Y'
1213: AND s.flex_value_set_id = v.flex_value_set_id
1214: AND (((s.format_type = 'N') AND
1215: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
1216: fnd_number.canonical_to_number(h.child_flex_value_low) AND
1217: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
1218: ((s.format_type IN ('D', 'T')) AND
1219: (to_date(v.flex_value,
1220: (decode(s.maximum_size,

Line 1217: fnd_number.canonical_to_number(h.child_flex_value_high))) OR

1213: AND s.flex_value_set_id = v.flex_value_set_id
1214: AND (((s.format_type = 'N') AND
1215: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
1216: fnd_number.canonical_to_number(h.child_flex_value_low) AND
1217: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
1218: ((s.format_type IN ('D', 'T')) AND
1219: (to_date(v.flex_value,
1220: (decode(s.maximum_size,
1221: 5,

Line 1297: (fnd_number.canonical_to_number(v.flex_value) BETWEEN

1293: WHERE h.flex_value_set_id = v.flex_value_set_id
1294: AND v.ENABLED_FLAG = 'Y'
1295: AND s.flex_value_set_id = v.flex_value_set_id
1296: AND (((s.format_type = 'N') AND
1297: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
1298: fnd_number.canonical_to_number(h.child_flex_value_low) AND
1299: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
1300: ((s.format_type IN ('D', 'T')) AND
1301: (to_date(v.flex_value,

Line 1298: fnd_number.canonical_to_number(h.child_flex_value_low) AND

1294: AND v.ENABLED_FLAG = 'Y'
1295: AND s.flex_value_set_id = v.flex_value_set_id
1296: AND (((s.format_type = 'N') AND
1297: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
1298: fnd_number.canonical_to_number(h.child_flex_value_low) AND
1299: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
1300: ((s.format_type IN ('D', 'T')) AND
1301: (to_date(v.flex_value,
1302: (decode(s.maximum_size,

Line 1299: fnd_number.canonical_to_number(h.child_flex_value_high))) OR

1295: AND s.flex_value_set_id = v.flex_value_set_id
1296: AND (((s.format_type = 'N') AND
1297: (fnd_number.canonical_to_number(v.flex_value) BETWEEN
1298: fnd_number.canonical_to_number(h.child_flex_value_low) AND
1299: fnd_number.canonical_to_number(h.child_flex_value_high))) OR
1300: ((s.format_type IN ('D', 'T')) AND
1301: (to_date(v.flex_value,
1302: (decode(s.maximum_size,
1303: 5,