eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.FA_RX_ATTRSETS_VL

Object Details

Object Name:	FA_RX_ATTRSETS_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_RX_ATTRSETS_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

FA_RX_ATTRSETS_VL stores attribute set information for RX reports. (translated MLS view)

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
PAGE_WIDTH	NUMBER
PAGE_HEIGHT	NUMBER
PRINT_SOB_FLAG	VARCHAR2	(1)
PRINT_FUNC_CURR_FLAG	VARCHAR2	(1)
PRINT_TITLE	VARCHAR2	(1)
PRINT_SUBMISSION_DATE	VARCHAR2	(1)
PRINT_CURRENT_PAGE	VARCHAR2	(1)
PRINT_TOTAL_PAGES	VARCHAR2	(1)
PRINT_PARAMETERS	VARCHAR2	(1)
PRINT_PAGE_BREAK_COLS	VARCHAR2	(1)
GROUP_DISPLAY_TYPE	VARCHAR2	(15)
REPORT_ID	NUMBER		Yes
ATTRIBUTE_SET	VARCHAR2	(30)	Yes
PUBLIC_FLAG	VARCHAR2	(1)	Yes
SYSTEM_FLAG	VARCHAR2	(1)	Yes
DEFAULT_DATE_FORMAT	VARCHAR2	(20)
DEFAULT_DATE_TIME_FORMAT	VARCHAR2	(30)
DEFAULT_NUMERIC_CHARACTERS	VARCHAR2	(2)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
REPORT_TITLE	VARCHAR2	(100)
USER_ATTRIBUTE_SET	VARCHAR2	(80)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.FA_RX_ATTRSETS_VL;

Dependencies

[top of page]

APPS.FA_RX_ATTRSETS_VL references the following:

APPS: FA_RX_ATTRSETS_B; FA_RX_ATTRSETS_TL

APPS.FA_RX_ATTRSETS_VL is referenced by following:

APPS: FA_RX_ATTRSETS