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.POS_TOTALS_PO_SV dependencies on FND_CURRENCIES

Line 50: FROM fnd_currencies fc,

46: global_agreement_flag
47: INTO x_min_unit,
48: x_precision,
49: x_global_agree_flag
50: FROM fnd_currencies fc,
51: po_headers_archive_all pha
52: WHERE pha.po_header_id = X_header_id
53: AND pha.revision_num = X_revision_num
54: AND fc.currency_code = pha.currency_code;

Line 185: FROM fnd_currencies fc,

181: SELECT fc.minimum_accountable_unit,
182: fc.precision
183: INTO x_min_unit,
184: x_precision
185: FROM fnd_currencies fc,
186: po_headers_archive_all pha
187: WHERE pha.po_header_id = X_header_id
188: AND pha.revision_num = X_revision_num
189: AND fc.currency_code = pha.currency_code;

Line 262: FROM fnd_currencies fc,

258: SELECT fc.minimum_accountable_unit,
259: fc.precision
260: INTO x_min_unit,
261: x_precision
262: FROM fnd_currencies fc,
263: po_headers_archive_all pha,
264: po_releases_archive_all pra
265: WHERE pha.po_header_id = pra.po_header_id
266: AND pha.LATEST_EXTERNAL_FLAG = 'Y'

Line 346: FROM fnd_currencies fc,

342: SELECT fc.minimum_accountable_unit,
343: fc.precision
344: INTO x_min_unit,
345: x_precision
346: FROM fnd_currencies fc,
347: po_headers_archive_all poh
348: WHERE poh.revision_num = x_revision_num
349: AND poh.po_header_id = x_po_header_id
350: AND fc.currency_code = poh.currency_code;

Line 397: FND_CURRENCIES FC,

393: fc.precision
394: INTO x_min_unit,
395: x_precision
396: FROM PO_HEADERS_ALL POH,
397: FND_CURRENCIES FC,
398: PO_RELEASES_ARCHIVE_ALL POR
399: WHERE POR.po_release_id = x_po_release_id
400: AND por.revision_num = x_revision_num
401: AND POH.po_header_id = POR.po_header_id

Line 408: FROM fnd_currencies fc,

404: SELECT fc.minimum_accountable_unit,
405: fc.precision
406: INTO x_min_unit,
407: x_precision
408: FROM fnd_currencies fc,
409: po_headers_archive_all poh
410: WHERE poh.revision_num = x_revision_num
411: AND poh.po_header_id = x_po_header_id
412: AND fc.currency_code = poh.currency_code;

Line 516: FROM fnd_currencies fc,

512: SELECT fc.minimum_accountable_unit,
513: fc.precision
514: INTO x_min_unit,
515: x_precision
516: FROM fnd_currencies fc,
517: po_headers_all pha,
518: po_line_locations_archive_all poll
519: WHERE poll.line_location_id = x_po_line_location_id
520: AND poll.po_header_id = pha.po_header_id

Line 580: FROM fnd_currencies fc,

576: SELECT fc.minimum_accountable_unit,
577: fc.precision
578: INTO x_min_unit,
579: x_precision
580: FROM fnd_currencies fc,
581: po_headers_all pha,
582: po_line_locations_archive_all poll
583: WHERE poll.line_location_id = p_po_line_location_id
584: AND poll.po_header_id = pha.po_header_id

Line 711: FROM fnd_currencies fc,

707: SELECT fc.minimum_accountable_unit,
708: fc.precision
709: INTO x_min_unit,
710: x_precision
711: FROM fnd_currencies fc,
712: po_headers_archive_all pha
713: WHERE fc.currency_code = pha.currency_code
714: AND pha.po_header_id = p_po_header_id
715: AND pha.latest_external_flag='Y';

Line 799: FROM fnd_currencies fc,

795: SELECT fc.minimum_accountable_unit,
796: fc.precision
797: INTO x_min_unit,
798: x_precision
799: FROM fnd_currencies fc,
800: po_headers_archive_all pha
801: WHERE fc.currency_code = pha.currency_code
802: AND pha.po_header_id = p_po_header_id
803: AND pha.latest_external_flag='Y';