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_SET_PUB_OPTIONS

Object Details

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

Stores the publishing options set for a report or request set.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FRM_SET_PUB_OPTIONS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REPORT_SET_ID REPORT_ID SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_SET_ID	NUMBER	(15)	Yes	Entity Identifier across all applications
REPORT_ID	NUMBER	(15)	Yes	Entity Identifier across all applications
SEQUENCE_NUMBER	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)		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.
PUBLISH_FLAG	VARCHAR2	(1)		Status flag to determine if report is published
TIME_FRAME	VARCHAR2	(240)		Default timeframe for the report.
EXPANDED_VALUE	VARCHAR2	(240)		Default expanded value for standard report.
PRES_TEMPLATE_ASN	VARCHAR2	(50)		Default template Application Short Name for the report.
PRES_TEMPLATE_CODE	VARCHAR2	(240)		Default template for the report.
DOCUMENT_TYPE	VARCHAR2	(20)		Default document type for the report.
PRES_RESP_ID	NUMBER	(15)		Default responsibility Id for the report.
REVIEWERS_ID	VARCHAR2	(240)		Default reviewer id's for the report.
PRES_MENU_NAME	VARCHAR2	(240)		Default menu name for the report.
DOCUMENT_NAME	VARCHAR2	(240)		Default document name for the report.
PRES_MENU_PATH	VARCHAR2	(4000)		Default folder location for the report.
ARCHIVE_DATE	DATE			Default archive date for the report.
AVAILABILITY_DATE_TIME	DATE			Default availability date and time for the report.

Query Text

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


SELECT REPORT_SET_ID
,      REPORT_ID
,      SEQUENCE_NUMBER
,      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
,      PUBLISH_FLAG
,      TIME_FRAME
,      EXPANDED_VALUE
,      PRES_TEMPLATE_ASN
,      PRES_TEMPLATE_CODE
,      DOCUMENT_TYPE
,      PRES_RESP_ID
,      REVIEWERS_ID
,      PRES_MENU_NAME
,      DOCUMENT_NAME
,      PRES_MENU_PATH
,      ARCHIVE_DATE
,      AVAILABILITY_DATE_TIME
FROM FRM.FRM_SET_PUB_OPTIONS;

Dependencies

[top of page]

FRM.FRM_SET_PUB_OPTIONS does not reference any database object

FRM.FRM_SET_PUB_OPTIONS is referenced by following:

APPS: FRM_SET_PUB_OPTIONS