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]

TABLE: FRM.FRM_USER_PUB_OPTIONS

Object Details

Object Name:	FRM_USER_PUB_OPTIONS
Object Type:	TABLE
Owner:	FRM
FND Design Data:	FRM.FRM_USER_PUB_OPTIONS
Subobject Name:
Status:	VALID

Stores the publishing options for a report by user.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FRM_USER_PUB_OPTIONS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID REPORT_ID USER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_ID	NUMBER	(15)	Yes	Entity Identifier across all applications
USER_ID	NUMBER	(15)	Yes	Entity Identifier across all applications
TEMPLATE_CODE	VARCHAR2	(80)		The code for the template stored in the XML Publisher template repository.
APPLICATION_SHORT_NAME	VARCHAR2	(50)	Yes	The application short name attached to the template code.
OUTPUT_TYPE	VARCHAR2	(30)		The type of output required for this document - Excel, PDF, or HTML etc.
AVAILABILITY_TYPE	VARCHAR2	(30)	Yes	The type of availability for this document, now, on hold, or specific date and time.
AVAILABILITY_DATE	DATE			If the availability type is set to specific date and time, this column stores the date and time.
DOCUMENT_ID	NUMBER	(15)	Yes	The last document id of a report of this type, used to retrieve presentation location data.
EXPANDED_FLAG	VARCHAR2	(1)		Was the last document of this type and expanded report.
SECURITY_TYPE	VARCHAR2	(30)	Yes	The type of security implemented for this report.
SECURITY_CODE	VARCHAR2	(240)		The values or value set used to secure the report.
PUBLISHER_TYPE	VARCHAR2	(30)		The publishing engine used to process the report. Currently XML Publisher or Report Manager.
VALUE_SET_ID	NUMBER	(15)		The value set id of the last value used for User to Value security.
FUNCTION_ID	NUMBER	(15)		The form function id used to launch this report.
MENU_ID	NUMBER	(15)		The menu entry id to which the form function is attached.
MENU_ENTRY_SEQ	NUMBER	(15)		The order of the form function within the menu.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Applications Standard column for a stateless environment.
CREATION_DATE	DATE		Yes	Standard WHO column.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO column.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column.
ARCHIVE_PERIOD_MONTHS	NUMBER	(15)		Period of time in months until this row is archived, or deleted.

Query Text

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


SELECT REPORT_ID
,      USER_ID
,      TEMPLATE_CODE
,      APPLICATION_SHORT_NAME
,      OUTPUT_TYPE
,      AVAILABILITY_TYPE
,      AVAILABILITY_DATE
,      DOCUMENT_ID
,      EXPANDED_FLAG
,      SECURITY_TYPE
,      SECURITY_CODE
,      PUBLISHER_TYPE
,      VALUE_SET_ID
,      FUNCTION_ID
,      MENU_ID
,      MENU_ENTRY_SEQ
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      ARCHIVE_PERIOD_MONTHS
FROM FRM.FRM_USER_PUB_OPTIONS;

Dependencies

[top of page]

FRM.FRM_USER_PUB_OPTIONS does not reference any database object

FRM.FRM_USER_PUB_OPTIONS is referenced by following:

FRM: FRM_USER_PUB_OPTIONS#