AR_CM_UOM_L_VL

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
CM_LINE_UOM_DESCRIPTION CM_LINE_UOM_UNIT_OF_MEASURE CM_LINE_UOM_UNIT_OF_MEASURE_TL LANGUAGE CM_LINE_UOM_CLASS CM_LINE_UOM_CODE EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ t.description cm_line_uom_description ,t.unit_of_measure cm_line_uom_unit_of_measure ,t.unit_of_measure cm_line_uom_unit_of_measure_tl ,t.language language ,b.uom_class cm_line_uom_class ,b.uom_code cm_line_uom_code ,l.event_id event_id ,l.line_number line_number ,l.ledger_id ledger_id FROM INV_UNITS_OF_MEASURE_TL t ,inv_units_of_measure_b b,ar_xla_lines_extract l WHERE l.level_flag = 'L' AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') AND b.uom_code = l.uom_code AND b.unit_of_measure_id = t.unit_of_measure_id AND t.LANGUAGE = userenv('LANG') GROUP BY t.description ,t.unit_of_measure ,t.unit_of_measure ,t.language ,b.uom_class ,b.uom_code ,l.event_id ,l.line_number ,l.ledger_id