Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_RES_FORMATS_VL |
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')