AR_UOM_L_VL

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
UOM_DESCRIPTION UOM_UNIT_OF_MEASURE UOM_UNIT_OF_MEASURE_TL LANGUAGE UOM_CLASS UOM_CODE EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ t.description uom_description ,t.unit_of_measure uom_unit_of_measure ,t.unit_of_measure uom_unit_of_measure_tl ,t.language language ,b.uom_class uom_class ,b.uom_code 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 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