VIEW: APPS.AR_CM_UOM_L_VL

Source

View Text - Preformatted

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ mtltlf.description cm_line_uom_description ,mtltlf.unit_of_measure cm_line_uom_unit_of_measure ,mtltlf.unit_of_measure_tl cm_line_uom_unit_of_measure_tl ,mtltlf.uom_class cm_line_uom_class ,mtltlf.uom_code cm_line_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' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') 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 CM_LINE_UOM_DESCRIPTION
, MTLTLF.UNIT_OF_MEASURE CM_LINE_UOM_UNIT_OF_MEASURE
, MTLTLF.UNIT_OF_MEASURE_TL CM_LINE_UOM_UNIT_OF_MEASURE_TL
, MTLTLF.UOM_CLASS CM_LINE_UOM_CLASS
, MTLTLF.UOM_CODE CM_LINE_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'
AND L.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE') 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