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: HR.PQP_FLXDU_COLUMNS

Object Details

Object Name:	PQP_FLXDU_COLUMNS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PQP.PQP_FLXDU_COLUMNS
Subobject Name:
Status:	VALID

This table is used to maintain all the fields for a HR entity types available in a spreadsheet.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PQP_FLXDU_COLUMNS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FLXDU_COLUMN_ID
PQP_FLXDU_COLUMNS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FLXDU_COLUMN_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FLXDU_COLUMN_ID	NUMBER	(22)	Yes	Generated primary key.
FLXDU_COLUMN_NAME	VARCHAR2	(150)	Yes	Field Name which RIW supports in spreadsheet
FLXDU_COLUMN_XML_TAG	VARCHAR2	(150)	Yes	Field XML Tag name
FLXDU_COLUMN_DATA_TYPE	VARCHAR2	(30)	Yes	Field Data Type
FLXDU_COLUMN_DATA_LENGTH	VARCHAR2	(30)		Field Data Length
FLXDU_COLUMN_XML_DATA	VARCHAR2	(150)		Sample XML data.
FLXDU_SEQ_NUM	NUMBER	(15)	Yes	The sequence number where this column appears in order.
FLXDU_GROUP_NAME	VARCHAR2	(30)		The group name to which this column belongs to.
ENTITY_TYPE	VARCHAR2	(30)	Yes	Entity which this field belongs
REQUIRED_FLAG	VARCHAR2	(1)		Whether field is required or not at the API level for the business logic
DISPLAY_FLAG	VARCHAR2	(1)		Whether the field is visible or not.
DESCRIPTION	VARCHAR2	(240)		Description of the column.
OBJECT_VERSION_NUMBER	NUMBER		Yes	System generated version of row. Increments by one with each update.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO column
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column

Query Text

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


SELECT FLXDU_COLUMN_ID
,      FLXDU_COLUMN_NAME
,      FLXDU_COLUMN_XML_TAG
,      FLXDU_COLUMN_DATA_TYPE
,      FLXDU_COLUMN_DATA_LENGTH
,      FLXDU_COLUMN_XML_DATA
,      FLXDU_SEQ_NUM
,      FLXDU_GROUP_NAME
,      ENTITY_TYPE
,      REQUIRED_FLAG
,      DISPLAY_FLAG
,      DESCRIPTION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PQP_FLXDU_COLUMNS;

Dependencies

[top of page]

HR.PQP_FLXDU_COLUMNS does not reference any database object

HR.PQP_FLXDU_COLUMNS is referenced by following:

APPS: PQP_FLXDU_COLUMNS; PQP_FLXDU_COLUMNS_WHO
PUBLIC: PQP_FLXDU_COLUMNS