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_BLOCKS_B

Object Details

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

BNE_LAYOUT_BLOCKS_B defines logical grouping of BNE_INTERFACE_COLS columns in a layout. Each block may have a parent, it may be oriented in different ways and given a block size (number of rows to show). Each layout block may use styles for formatting.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BNE_LAYOUT_BLOCKS_B_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID LAYOUT_CODE BLOCK_ID

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	Unique sequence number of block.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object Version Number
PARENT_ID	NUMBER	(15)		Parent layout block.
LAYOUT_ELEMENT	VARCHAR2	(240)	Yes	Valid values: CONTEXT, HEADER, LINES.
STYLE_CLASS	VARCHAR2	(50)		Style class name.
STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride STYLE_CLASS.
ROW_STYLE_CLASS	VARCHAR2	(50)		Row style class name.
ROW_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride ROW_STYLE_CLASS.
COL_STYLE_CLASS	VARCHAR2	(50)		Column style class name.
COL_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride COL_STYLE_CLASS.
PROMPT_DISPLAYED_FLAG	VARCHAR2	(1)	Yes	Do we display prompt (Y/N)?
PROMPT_STYLE_CLASS	VARCHAR2	(50)		Prompt style class name.
PROMPT_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride PROMPT_STYLE_CLASS.
HINT_DISPLAYED_FLAG	VARCHAR2	(1)	Yes	Do we display hint text (Y/N).
HINT_STYLE_CLASS	VARCHAR2	(50)		Hint style class name.
HINT_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride HINT_STYLE_CLASS.
ORIENTATION	VARCHAR2	(20)	Yes	Block layout orientation. Valid values: VERTICAL, HORIZONTAL.
LAYOUT_CONTROL	VARCHAR2	(20)	Yes	Valid values: TABLE_FLOW, COLUMN_FLOW.
DISPLAY_FLAG	VARCHAR2	(1)	Yes	Do we display this block (Y/N)?
BLOCKSIZE	NUMBER	(15)	Yes	Number of rows to show in this block.
MINSIZE	NUMBER	(15)	Yes	For future use.
MAXSIZE	NUMBER	(15)	Yes	For future use.
SEQUENCE_NUM	NUMBER	(15)	Yes	The order in which the columns are rendered.
PROMPT_COLSPAN	NUMBER	(15)		Number of viewer columns a prompt overlays.
HINT_COLSPAN	NUMBER	(15)		Number of columns a hint overlays.
ROW_COLSPAN	NUMBER	(15)		Number of cloumns to skip befor showing this block.
SUMMARY_STYLE_CLASS	VARCHAR2	(50)		Summary style class name.
SUMMARY_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride SUMMARY_STYLE_CLASS.
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.
TITLE_STYLE_CLASS	VARCHAR2	(50)		Title style class name.
TITLE_STYLE	VARCHAR2	(2000)		Optional free form style text to over-ride TITLE_STYLE_CLASS.

Query Text

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


SELECT APPLICATION_ID
,      LAYOUT_CODE
,      BLOCK_ID
,      OBJECT_VERSION_NUMBER
,      PARENT_ID
,      LAYOUT_ELEMENT
,      STYLE_CLASS
,      STYLE
,      ROW_STYLE_CLASS
,      ROW_STYLE
,      COL_STYLE_CLASS
,      COL_STYLE
,      PROMPT_DISPLAYED_FLAG
,      PROMPT_STYLE_CLASS
,      PROMPT_STYLE
,      HINT_DISPLAYED_FLAG
,      HINT_STYLE_CLASS
,      HINT_STYLE
,      ORIENTATION
,      LAYOUT_CONTROL
,      DISPLAY_FLAG
,      BLOCKSIZE
,      MINSIZE
,      MAXSIZE
,      SEQUENCE_NUM
,      PROMPT_COLSPAN
,      HINT_COLSPAN
,      ROW_COLSPAN
,      SUMMARY_STYLE_CLASS
,      SUMMARY_STYLE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      TITLE_STYLE_CLASS
,      TITLE_STYLE
FROM BNE.BNE_LAYOUT_BLOCKS_B;

Dependencies

[top of page]

BNE.BNE_LAYOUT_BLOCKS_B does not reference any database object

BNE.BNE_LAYOUT_BLOCKS_B is referenced by following:

APPS: BNE_LAYOUT_BLOCKS_B