FND Design Data [Home] [Help]

View: FA_RX_ATTRSETS_VL

Product: OFA - Assets
Description: Stores attribute set information for RX reports (translated MLS view)
Implementation/DBA Data: ViewAPPS.FA_RX_ATTRSETS_VL
View Text

SELECT B.ROWID ROW_ID
, B.PAGE_WIDTH
, B.PAGE_HEIGHT
, B.PRINT_SOB_FLAG
, B.PRINT_FUNC_CURR_FLAG
, B.PRINT_TITLE
, B.PRINT_SUBMISSION_DATE
, B.PRINT_CURRENT_PAGE
, B.PRINT_TOTAL_PAGES
, B.PRINT_PARAMETERS
, B.PRINT_PAGE_BREAK_COLS
, B.GROUP_DISPLAY_TYPE
, B.REPORT_ID
, B.ATTRIBUTE_SET
, B.PUBLIC_FLAG
, B.SYSTEM_FLAG
, B.DEFAULT_DATE_FORMAT
, B.DEFAULT_DATE_TIME_FORMAT
, B.DEFAULT_NUMERIC_CHARACTERS
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATE_LOGIN
, T.REPORT_TITLE
, T.USER_ATTRIBUTE_SET
FROM FA_RX_ATTRSETS_TL T
, FA_RX_ATTRSETS_B B
WHERE B.REPORT_ID = T.REPORT_ID
AND B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
PAGE_WIDTH
PAGE_HEIGHT
PRINT_SOB_FLAG
PRINT_FUNC_CURR_FLAG
PRINT_TITLE
PRINT_SUBMISSION_DATE
PRINT_CURRENT_PAGE
PRINT_TOTAL_PAGES
PRINT_PARAMETERS
PRINT_PAGE_BREAK_COLS
GROUP_DISPLAY_TYPE
REPORT_ID
ATTRIBUTE_SET
PUBLIC_FLAG
SYSTEM_FLAG
DEFAULT_DATE_FORMAT
DEFAULT_DATE_TIME_FORMAT
DEFAULT_NUMERIC_CHARACTERS
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
REPORT_TITLE
USER_ATTRIBUTE_SET