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: BNE.BNE_LAYOUT_COLS

Object Details

Object Name:	BNE_LAYOUT_COLS
Object Type:	TABLE
Owner:	BNE
FND Design Data:	BNE.BNE_LAYOUT_COLS
Subobject Name:
Status:	VALID

BNE_LAYOUT_COLS stores individual column positioning within a BNE_LAYOUT_BLOCK_B.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BNE_LAYOUT_COLS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID BLOCK_ID LAYOUT_CODE SEQUENCE_NUM ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier (foreign key to FND_APPLICATIONS.APPLICATION_ID).
LAYOUT_CODE	VARCHAR2	(30)	Yes	Code identifying this entity for the given APPLICATION_ID.
BLOCK_ID	NUMBER	(15)	Yes	Sequence number for column block.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number
INTERFACE_APP_ID	NUMBER	(15)	Yes	Interface Id of Interface column being layed out.
INTERFACE_CODE	VARCHAR2	(30)	Yes	Interface code of Interface column being layed out.
INTERFACE_SEQ_NUM	NUMBER	(15)	Yes	Sequence number of Interface column being layed out.
SEQUENCE_NUM	NUMBER	(15)	Yes	Sequence number for column.
STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride STYLE_CLASS.
STYLE_CLASS	VARCHAR2	(50)		Style class name.
HINT_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride HINT_STYLE_CLASS.
HINT_STYLE_CLASS	VARCHAR2	(50)		Hint style class name.
PROMPT_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride PROMPT_STYLE_CLASS.
PROMPT_STYLE_CLASS	VARCHAR2	(50)		Prompt style class name.
DEFAULT_TYPE	VARCHAR2	(30)		Valid Values: CONSTANT, ENVIRONMENT, SQL, PARAMETER
DEFAULT_VALUE	VARCHAR2	(2000)		Value depending upon DEFAULT_TYPE.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
DISPLAY_WIDTH	NUMBER	(15)		Width to display column
READ_ONLY_FLAG	VARCHAR2	(1)		Is this layout columne read only?
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT APPLICATION_ID
,      LAYOUT_CODE
,      BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      INTERFACE_APP_ID
,      INTERFACE_CODE
,      INTERFACE_SEQ_NUM
,      SEQUENCE_NUM
,      STYLE
,      STYLE_CLASS
,      HINT_STYLE
,      HINT_STYLE_CLASS
,      PROMPT_STYLE
,      PROMPT_STYLE_CLASS
,      DEFAULT_TYPE
,      DEFAULT_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      DISPLAY_WIDTH
,      READ_ONLY_FLAG
,      ZD_EDITION_NAME
FROM BNE.BNE_LAYOUT_COLS;

Dependencies

[top of page]

BNE.BNE_LAYOUT_COLS does not reference any database object

BNE.BNE_LAYOUT_COLS is referenced by following:

BNE: BNE_LAYOUT_COLS#