VIEW: APPS.PA_RES_FORMATS_VL

Source

View Text - Preformatted

SELECT B.rowid row_id, B.RES_FORMAT_ID, B.RESOURCE_FORMAT_SEQ, B.RESOURCE_CLASS_ID, B.RES_TYPE_ID, B.RES_TYPE_ENABLED_FLAG, B.RESOURCE_TYPE_DISP_CHARS, B.ORGN_ENABLED_FLAG, B.ORGN_DISP_CHARS, B.FIN_CAT_ENABLED_FLAG, B.FIN_CAT_DISP_CHARS, B.INCURRED_BY_ENABLED_FLAG, B.INCURRED_BY_DISP_CHARS, B.SUPPLIER_ENABLED_FLAG, B.SUPPLIER_DISP_CHARS, B.ROLE_ENABLED_FLAG, B.ROLE_DISP_CHARS, B.RESOURCE_CLASS_FLAG, B.last_update_date, B.last_updated_by, B.creation_date, B.created_by, B.last_update_login, T.name, T.description from PA_RES_FORMATS_TL T, PA_RES_FORMATS_B B WHERE B.res_format_id = T.res_format_id and T.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RES_FORMAT_ID
, B.RESOURCE_FORMAT_SEQ
, B.RESOURCE_CLASS_ID
, B.RES_TYPE_ID
, B.RES_TYPE_ENABLED_FLAG
, B.RESOURCE_TYPE_DISP_CHARS
, B.ORGN_ENABLED_FLAG
, B.ORGN_DISP_CHARS
, B.FIN_CAT_ENABLED_FLAG
, B.FIN_CAT_DISP_CHARS
, B.INCURRED_BY_ENABLED_FLAG
, B.INCURRED_BY_DISP_CHARS
, B.SUPPLIER_ENABLED_FLAG
, B.SUPPLIER_DISP_CHARS
, B.ROLE_ENABLED_FLAG
, B.ROLE_DISP_CHARS
, B.RESOURCE_CLASS_FLAG
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, T.NAME
, T.DESCRIPTION
FROM PA_RES_FORMATS_TL T
, PA_RES_FORMATS_B B
WHERE B.RES_FORMAT_ID = T.RES_FORMAT_ID
AND T.LANGUAGE = USERENV('LANG')