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: HXC.HXC_RPT_LAYOUT_COMP_QUERIES

Object Details

Object Name:	HXC_RPT_LAYOUT_COMP_QUERIES
Object Type:	TABLE
Owner:	HXC
FND Design Data:	HXC.HXC_RPT_LAYOUT_COMP_QUERIES
Subobject Name:
Status:	VALID

Holds all the user enterable layout_component_ids and the queries associated with them to translate the ids stored to the display values

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HXC_RPT_LAYOUT_COMP_QUERIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LAYOUT_COMPONENT_ID
HXC_RPT_LAYOUT_COMP_QUERIES_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LAYOUT_ID ATTRIBUTE

Columns

Name	Datatype	Length	Mandatory	Comments
LAYOUT_ID	NUMBER	(15)		Layout_id
LAYOUT_COMPONENT_ID	NUMBER	(15)	Yes	Layout_component_id
QUERY	VARCHAR2	(4000)		The query for translating id to display_value
ATTRIBUTE	VARCHAR2	(15)		Column this layout_component corresponds to in HXC_RPT_TC_DETAILS_ALL
COMPONENT_NAME	VARCHAR2	(50)		Display name for the component

Query Text

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


SELECT LAYOUT_ID
,      LAYOUT_COMPONENT_ID
,      QUERY
,      ATTRIBUTE
,      COMPONENT_NAME
FROM HXC.HXC_RPT_LAYOUT_COMP_QUERIES;

Dependencies

[top of page]

HXC.HXC_RPT_LAYOUT_COMP_QUERIES does not reference any database object

HXC.HXC_RPT_LAYOUT_COMP_QUERIES is referenced by following:

HXC: HXC_RPT_LAYOUT_COMP_QUERIES#