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: ONT.OE_FOLDER_EXTENSIONS

Object Details

Object Name:	OE_FOLDER_EXTENSIONS
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_FOLDER_EXTENSIONS
Subobject Name:
Status:	VALID

This table stores the information about Folder Extensions.
Each row includes the name of the objects in the folders, user identifier, folder identifier, information about the tabs and line detail regions that are displayed for the folder.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FOLDER_EXTENSION_ID	NUMBER		Yes	Folder Extension Identifier
OBJECT	VARCHAR2	(30)	Yes	Folder Object Name
USER_ID	NUMBER		Yes	User Name
FOLDER_ID	NUMBER		Yes	Folder Identifier
APPLICATION_ID	NUMBER		Yes	Application Identifier
DISPLAY_ORDER_MAIN	VARCHAR2	(1)		Flag to indicate, if the header main tab should be displayed
DISPLAY_ORDER_OTHERS	VARCHAR2	(1)		Flag to indicate, if the header others tab should be displayed
DISPLAY_LINE_MAIN	VARCHAR2	(1)		Flag to indicate, if the line main tab should be displayed.
DISPLAY_LINE_PRICING	VARCHAR2	(1)		Flag to indicate, if the line pricing tab should be displayed
DISPLAY_LINE_SHIPPING	VARCHAR2	(1)		Flag to indicate, if the line shipping tab should be displayed.
DISPLAY_LINE_ADDRESSES	VARCHAR2	(1)		Flag to indicate, if the line addresses tab should be displayed.
DISPLAY_LINE_SERVICES	VARCHAR2	(1)		Flag to indicate, if the line services tab should be displayed.
DISPLAY_LINE_RETURNS	VARCHAR2	(1)		Flag to indicate, if the lines returns tab should be displayed.
DISPLAY_LINE_OTHERS	VARCHAR2	(1)		Flag to indicate if the Line Others tab should be displayed.
DISPLAY_OPTIONS_DETAILS	VARCHAR2	(1)		Flag to indicate, if the options region in line details should be displayed.
DISPLAY_SERVICES_DETAILS	VARCHAR2	(1)		Flag to indicate, if the services region in line details should be displayed.
DISPLAY_ADJUSTMENT_DETAILS	VARCHAR2	(1)		Flag to indicate, if the adjustment region in line details should be displayed.
DISPLAY_RELATED_ITEMS_DETAILS	VARCHAR2	(1)		Flag to indicate, if the related items region in line details should be displayed.
DISPLAY_PRICING_AVA_DETAILS	VARCHAR2	(1)		Flag to indicate, if the pricing/availability region in line details should be displayed
DEFAULT_LINE_REGION	VARCHAR2	(1)		Name of the line region that should be displayed as default region.
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard who column

Query Text

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


SELECT FOLDER_EXTENSION_ID
,      OBJECT
,      USER_ID
,      FOLDER_ID
,      APPLICATION_ID
,      DISPLAY_ORDER_MAIN
,      DISPLAY_ORDER_OTHERS
,      DISPLAY_LINE_MAIN
,      DISPLAY_LINE_PRICING
,      DISPLAY_LINE_SHIPPING
,      DISPLAY_LINE_ADDRESSES
,      DISPLAY_LINE_SERVICES
,      DISPLAY_LINE_RETURNS
,      DISPLAY_LINE_OTHERS
,      DISPLAY_OPTIONS_DETAILS
,      DISPLAY_SERVICES_DETAILS
,      DISPLAY_ADJUSTMENT_DETAILS
,      DISPLAY_RELATED_ITEMS_DETAILS
,      DISPLAY_PRICING_AVA_DETAILS
,      DEFAULT_LINE_REGION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ONT.OE_FOLDER_EXTENSIONS;

Dependencies

[top of page]

ONT.OE_FOLDER_EXTENSIONS does not reference any database object

ONT.OE_FOLDER_EXTENSIONS is referenced by following:

APPS: OE_FOLDER_EXTENSIONS