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.

VIEW: APPS.AR_UOM_L_VL

Source

View Text - Preformatted


SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ mtltlf.description uom_description ,mtltlf.unit_of_measure uom_unit_of_measure ,mtltlf.unit_of_measure_tl uom_unit_of_measure_tl ,mtltlf.uom_class uom_class ,mtltlf.uom_code uom_code ,l.event_id event_id ,l.line_number line_number ,mtltlf.language language ,l.ledger_id ledger_id FROM mtl_units_of_measure_tl mtltlf ,ar_xla_lines_extract l WHERE mtltlf.uom_code = l.uom_code AND l.level_flag = 'L' GROUP BY mtltlf.description ,mtltlf.unit_of_measure ,mtltlf.unit_of_measure_tl ,mtltlf.uom_class ,mtltlf.uom_code ,l.event_id ,l.line_number ,mtltlf.language ,l.ledger_id

View Text - HTML Formatted

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ MTLTLF.DESCRIPTION UOM_DESCRIPTION
, MTLTLF.UNIT_OF_MEASURE UOM_UNIT_OF_MEASURE
, MTLTLF.UNIT_OF_MEASURE_TL UOM_UNIT_OF_MEASURE_TL
, MTLTLF.UOM_CLASS UOM_CLASS
, MTLTLF.UOM_CODE UOM_CODE
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, MTLTLF.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM MTL_UNITS_OF_MEASURE_TL MTLTLF
, AR_XLA_LINES_EXTRACT L
WHERE MTLTLF.UOM_CODE = L.UOM_CODE
AND L.LEVEL_FLAG = 'L' GROUP BY MTLTLF.DESCRIPTION
, MTLTLF.UNIT_OF_MEASURE
, MTLTLF.UNIT_OF_MEASURE_TL
, MTLTLF.UOM_CLASS
, MTLTLF.UOM_CODE
, L.EVENT_ID
, L.LINE_NUMBER
, MTLTLF.LANGUAGE
, L.LEDGER_ID