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_DOC_PUB_OPTIONS

Object Details

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

Stores the document specific options for a report published to the Report Manager repository.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FRM_DOC_PUB_OPTIONS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DOCUMENT_ID TIMEFRAME
FRM_DOC_PUB_OPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
FRM_DOC_PUB_OPTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ARCHIVED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_ID	NUMBER	(15)	Yes	Entity Identifier across all applications
TIMEFRAME	VARCHAR2	(240)	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.
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.
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.
END_DATE	DATE			Date that this row is archived or deleted.
ARCHIVED_FLAG	VARCHAR2	(1)		Flag to indicate if the row is archived.
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 DOCUMENT_ID
,      TIMEFRAME
,      TEMPLATE_CODE
,      APPLICATION_SHORT_NAME
,      OUTPUT_TYPE
,      AVAILABILITY_TYPE
,      AVAILABILITY_DATE
,      SECURITY_TYPE
,      SECURITY_CODE
,      PUBLISHER_TYPE
,      FUNCTION_ID
,      MENU_ID
,      MENU_ENTRY_SEQ
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      END_DATE
,      ARCHIVED_FLAG
,      ARCHIVE_PERIOD_MONTHS
FROM FRM.FRM_DOC_PUB_OPTIONS;

Dependencies

[top of page]

FRM.FRM_DOC_PUB_OPTIONS does not reference any database object

FRM.FRM_DOC_PUB_OPTIONS is referenced by following:

FRM: FRM_DOC_PUB_OPTIONS#