[Home] [Help]
View: AR_UOM_L_VL
Product: | AR - Receivables |
Description: | unit of measure line mls extract |
Implementation/DBA Data: |
APPS.AR_UOM_L_VL
|
View Text
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
Columns
Name |
UOM_DESCRIPTION |
UOM_UNIT_OF_MEASURE |
UOM_UNIT_OF_MEASURE_TL |
UOM_CLASS |
UOM_CODE |
EVENT_ID |
LINE_NUMBER |
LANGUAGE |
LEDGER_ID |