[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
HXC.HXC_RPT_LAYOUT_COMP_QUERIES does not reference any database object
HXC.HXC_RPT_LAYOUT_COMP_QUERIES is referenced by following:
|
|
|