VIEW: APPS.GMD_FORMULA_CLASS_VL

Source

View Text - Preformatted

SELECT b.rowid row_id ,b.formula_class ,a.formula_class_desc ,b.trans_cnt ,b.delete_mark ,b.text_code ,b.created_by ,b.creation_date ,b.last_updated_by ,b.last_update_login ,b.last_update_date FROM gmd_formula_class_b b, gmd_formula_class_tl a WHERE a.formula_class = b.formula_class AND a.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.FORMULA_CLASS
, A.FORMULA_CLASS_DESC
, B.TRANS_CNT
, B.DELETE_MARK
, B.TEXT_CODE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
FROM GMD_FORMULA_CLASS_B B
, GMD_FORMULA_CLASS_TL A
WHERE A.FORMULA_CLASS = B.FORMULA_CLASS
AND A.LANGUAGE = USERENV('LANG')