Product: | OFA - Assets |
---|---|
Description: | Stores attribute set information for RX reports (translated MLS view) |
Implementation/DBA Data: | APPS.FA_RX_ATTRSETS_VL |
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')