LOV Extract SQL Query

For Pulling out LOV Extract you can use below SQL Query:

SELECT 

10000+ROWNUM ROW_ID,

'FOR_IMPORT' IF_ROW_STAT,

CASE WHEN LOV.TYPE='LOV_TYPE' THEN 1000+ TRUNC((ROWNUM-1)/1000)

    WHEN PAR.TYPE IS NULL THEN 1010+ TRUNC((ROWNUM-1)/1000)

    ELSE 1020+ TRUNC((ROWNUM-1)/1000)

END IF_ROW_BATCH_NUM,

LOV.TYPE,

LOV.VAL,

LOV.NAME,

LOV.ACTIVE_FLG,

LOV.DFLT_LIC_FLG,

LOV.LANG_ID,

LOV.MLTORG_DISALW_FLG,

LOV.MULTI_LINGUAL_FLG,

LOV.REQD_LIC_FLG,

LOV.RPLCTN_LVL_CD,

LOV.SUB_TYPE,

BU.NAME,

LOV.HIGH,

LOV.LOW,

LOV.TARGET_HIGH,

LOV.TARGET_LOW,

LOV.ORDER_BY,

LOV.DESC_TEXT,

LOV.TRANSLATE_FLG,

BU.NAME,

PAR.TYPE,

PAR.VAL,

BU.NAME,

PAR.SUB_TYPE,

PAR.LANG_ID

FROM SIEBEL.S_LST_OF_VAL LOV

LEFT OUTER JOIN SIEBEL.S_BU BU ON LOV.BU_ID=BU.ROW_ID

LEFT OUTER JOIN SIEBEL.S_LST_OF_VAL PAR ON LOV.PAR_ROW_ID=PAR.ROW_ID

--WHERE LOV.TYPE='PROVIDE LOV TYPE';-- In case you need some specific LOV Extract then remove the comment -- and provide LOV TYPE

WHERE LOV.LAST_UPD>SYSDATE-30;