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

Line 214: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),

210: -- bug 9234524 convert to user key units when matching
211: and decode
212: (put.user_key_units,
213: 'D', to_char(fnd_date.canonical_to_date(X_ROW_LOW_RANGE_OR_NAME)),
214: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),
215: 'T', upper (X_ROW_LOW_RANGE_OR_NAME),
216: null) =
217: decode
218: (put.user_key_units,

Line 220: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),

216: null) =
217: decode
218: (put.user_key_units,
219: 'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),
220: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),
221: 'T', upper (pur.row_low_range_or_name),
222: null)
223: and ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
224: OR decode

Line 227: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),

223: and ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
224: OR decode
225: (put.user_key_units,
226: 'D', to_char(fnd_date.canonical_to_date(X_ROW_HIGH_RANGE)),
227: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),
228: 'T', upper (X_ROW_HIGH_RANGE),
229: null) =
230: decode
231: (put.user_key_units,

Line 233: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),

229: null) =
230: decode
231: (put.user_key_units,
232: 'D', to_char(fnd_date.canonical_to_date(pur.row_high_range)),
233: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),
234: 'T', upper (pur.row_high_range),
235: null))
236: -- end bug 9234524
237: AND put.user_table_name = X_USER_TABLE_NAME

Line 291: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),

287: -- bug 9234524 convert to user key units when matching
288: WHERE decode
289: (l_user_key_units,
290: 'D', to_char(fnd_date.canonical_to_date(X_ROW_LOW_RANGE_OR_NAME)),
291: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),
292: 'T', upper (X_ROW_LOW_RANGE_OR_NAME),
293: null) =
294: decode
295: (l_user_key_units,

Line 297: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),

293: null) =
294: decode
295: (l_user_key_units,
296: 'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),
297: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),
298: 'T', upper (pur.row_low_range_or_name),
299: null)
300: and ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
301: OR decode

Line 304: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),

300: and ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
301: OR decode
302: (l_user_key_units,
303: 'D', to_char(fnd_date.canonical_to_date(X_ROW_HIGH_RANGE)),
304: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),
305: 'T', upper (X_ROW_HIGH_RANGE),
306: null) =
307: decode
308: (l_user_key_units,

Line 310: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),

306: null) =
307: decode
308: (l_user_key_units,
309: 'D', to_char(fnd_date.canonical_to_date(pur.row_high_range)),
310: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),
311: 'T', upper (pur.row_high_range),
312: null))
313: -- end bug 9234524 changes
314: AND (

Line 547: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),

543: -- bug 9234524 convert to user key units when matching
544: AND decode
545: (put.user_key_units,
546: 'D', to_char(fnd_date.canonical_to_date(X_ROW_LOW_RANGE_OR_NAME)),
547: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),
548: 'T', upper (X_ROW_LOW_RANGE_OR_NAME),
549: null) =
550: decode
551: (put.user_key_units,

Line 553: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),

549: null) =
550: decode
551: (put.user_key_units,
552: 'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),
553: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),
554: 'T', upper (pur.row_low_range_or_name),
555: null)
556: AND ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
557: OR decode

Line 560: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),

556: AND ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
557: OR decode
558: (put.user_key_units,
559: 'D', to_char(fnd_date.canonical_to_date(X_ROW_HIGH_RANGE)),
560: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),
561: 'T', upper (X_ROW_HIGH_RANGE),
562: null) =
563: decode
564: (put.user_key_units,

Line 566: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),

562: null) =
563: decode
564: (put.user_key_units,
565: 'D', to_char(fnd_date.canonical_to_date(pur.row_high_range)),
566: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),
567: 'T', upper (pur.row_high_range),
568: null))
569: -- bug 9234524 changes end
570: AND puc.user_column_name = X_USER_COLUMN_NAME

Line 621: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),

617: -- bug 9234524 convert to user key units when matching
618: AND decode
619: (put.user_key_units,
620: 'D', to_char(fnd_date.canonical_to_date(X_ROW_LOW_RANGE_OR_NAME)),
621: 'N', to_char(fnd_number.canonical_to_number(X_ROW_LOW_RANGE_OR_NAME)),
622: 'T', upper (X_ROW_LOW_RANGE_OR_NAME),
623: null) =
624: decode
625: (put.user_key_units,

Line 627: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),

623: null) =
624: decode
625: (put.user_key_units,
626: 'D', to_char(fnd_date.canonical_to_date(pur.row_low_range_or_name)),
627: 'N', to_char(fnd_number.canonical_to_number(pur.row_low_range_or_name)),
628: 'T', upper (pur.row_low_range_or_name),
629: null)
630: AND ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
631: OR decode

Line 634: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),

630: AND ( NVL(pur.row_high_range,'NULL') = NVL(X_ROW_HIGH_RANGE,'NULL')
631: OR decode
632: (put.user_key_units,
633: 'D', to_char(fnd_date.canonical_to_date(X_ROW_HIGH_RANGE)),
634: 'N', to_char(fnd_number.canonical_to_number(X_ROW_HIGH_RANGE)),
635: 'T', upper (X_ROW_HIGH_RANGE),
636: null) =
637: decode
638: (put.user_key_units,

Line 640: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),

636: null) =
637: decode
638: (put.user_key_units,
639: 'D', to_char(fnd_date.canonical_to_date(pur.row_high_range)),
640: 'N', to_char(fnd_number.canonical_to_number(pur.row_high_range)),
641: 'T', upper (pur.row_high_range),
642: null))
643: -- bug 9234524 changes end
644: AND put.user_table_name = X_USER_TABLE_NAME