FND Design Data [Home] [Help]

View: PA_RES_FORMATS_VL

Product: PA - Projects
Description:
Implementation/DBA Data: ViewAPPS.PA_RES_FORMATS_VL
View Text

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')

Columns

Name
ROW_ID
RES_FORMAT_ID
RESOURCE_FORMAT_SEQ
RESOURCE_CLASS_ID
RES_TYPE_ID
RES_TYPE_ENABLED_FLAG
RESOURCE_TYPE_DISP_CHARS
ORGN_ENABLED_FLAG
ORGN_DISP_CHARS
FIN_CAT_ENABLED_FLAG
FIN_CAT_DISP_CHARS
INCURRED_BY_ENABLED_FLAG
INCURRED_BY_DISP_CHARS
SUPPLIER_ENABLED_FLAG
SUPPLIER_DISP_CHARS
ROLE_ENABLED_FLAG
ROLE_DISP_CHARS
RESOURCE_CLASS_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
NAME
DESCRIPTION