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 51: FROM fnd_currencies fc,

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

Line 164: FROM fnd_currencies fc,

160: SELECT fc.minimum_accountable_unit,
161: fc.precision
162: INTO x_min_unit,
163: x_precision
164: FROM fnd_currencies fc,
165: po_headers_archive_all pha
166: WHERE pha.po_header_id = X_header_id
167: AND pha.revision_num = X_revision_num
168: AND fc.currency_code = pha.currency_code;

Line 241: FROM fnd_currencies fc,

237: SELECT fc.minimum_accountable_unit,
238: fc.precision
239: INTO x_min_unit,
240: x_precision
241: FROM fnd_currencies fc,
242: po_headers_archive_all pha,
243: po_releases_archive_all pra
244: WHERE pha.po_header_id = pra.po_header_id
245: AND pha.LATEST_EXTERNAL_FLAG = 'Y'

Line 325: FROM fnd_currencies fc,

321: SELECT fc.minimum_accountable_unit,
322: fc.precision
323: INTO x_min_unit,
324: x_precision
325: FROM fnd_currencies fc,
326: po_headers_archive_all poh
327: WHERE poh.revision_num = x_revision_num
328: AND poh.po_header_id = x_po_header_id
329: AND fc.currency_code = poh.currency_code;

Line 376: FND_CURRENCIES FC,

372: fc.precision
373: INTO x_min_unit,
374: x_precision
375: FROM PO_HEADERS_ALL POH,
376: FND_CURRENCIES FC,
377: PO_RELEASES_ARCHIVE_ALL POR
378: WHERE POR.po_release_id = x_po_release_id
379: AND por.revision_num = x_revision_num
380: AND POH.po_header_id = POR.po_header_id

Line 387: FROM fnd_currencies fc,

383: SELECT fc.minimum_accountable_unit,
384: fc.precision
385: INTO x_min_unit,
386: x_precision
387: FROM fnd_currencies fc,
388: po_headers_archive_all poh
389: WHERE poh.revision_num = x_revision_num
390: AND poh.po_header_id = x_po_header_id
391: AND fc.currency_code = poh.currency_code;

Line 495: FROM fnd_currencies fc,

491: SELECT fc.minimum_accountable_unit,
492: fc.precision
493: INTO x_min_unit,
494: x_precision
495: FROM fnd_currencies fc,
496: po_headers_all pha,
497: po_line_locations_archive_all poll
498: WHERE poll.line_location_id = x_po_line_location_id
499: AND poll.po_header_id = pha.po_header_id

Line 559: FROM fnd_currencies fc,

555: SELECT fc.minimum_accountable_unit,
556: fc.precision
557: INTO x_min_unit,
558: x_precision
559: FROM fnd_currencies fc,
560: po_headers_all pha,
561: po_line_locations_archive_all poll
562: WHERE poll.line_location_id = p_po_line_location_id
563: AND poll.po_header_id = pha.po_header_id

Line 690: FROM fnd_currencies fc,

686: SELECT fc.minimum_accountable_unit,
687: fc.precision
688: INTO x_min_unit,
689: x_precision
690: FROM fnd_currencies fc,
691: po_headers_archive_all pha
692: WHERE fc.currency_code = pha.currency_code
693: AND pha.po_header_id = p_po_header_id
694: AND pha.latest_external_flag='Y';

Line 812: FROM fnd_currencies fc,

808: SELECT fc.minimum_accountable_unit,
809: fc.precision
810: INTO x_min_unit,
811: x_precision
812: FROM fnd_currencies fc,
813: po_headers_archive_all pha
814: WHERE fc.currency_code = pha.currency_code
815: AND pha.po_header_id = p_po_header_id
816: AND pha.latest_external_flag='Y';