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.HR_ITEM_PROPERTIES_B

Object Details

Object Name:	HR_ITEM_PROPERTIES_B
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_ITEM_PROPERTIES_B
Subobject Name:
Status:	VALID

Properties for form or template items used by configurable forms.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: HR_ITEM_PROPERTIES_B_PK

ITEM_PROPERTY_ID

Unique Key: HR_ITEM_PROPERTIES_B_UK

FORM_ITEM_ID
TEMPLATE_ITEM_ID
TEMPLATE_ITEM_CONTEXT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_ITEM_PROPERTIES_B_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_PROPERTY_ID
HR_ITEM_PROPERTIES_B_UK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORM_ITEM_ID TEMPLATE_ITEM_ID TEMPLATE_ITEM_CONTEXT_ID
HR_ITEM_PROPERTIES_B_FK10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION_PARAMETER_ITEM_ID5
HR_ITEM_PROPERTIES_B_FK11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_PARAMETER_ITEM_ID1
HR_ITEM_PROPERTIES_B_FK12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_PARAMETER_ITEM_ID2
HR_ITEM_PROPERTIES_B_FK13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_PARAMETER_ITEM_ID3
HR_ITEM_PROPERTIES_B_FK14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_PARAMETER_ITEM_ID4
HR_ITEM_PROPERTIES_B_FK15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_PARAMETER_ITEM_ID5
HR_ITEM_PROPERTIES_B_FK16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NEXT_NAVIGATION_ITEM_ID
HR_ITEM_PROPERTIES_B_FK17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PREVIOUS_NAVIGATION_ITEM_ID
HR_ITEM_PROPERTIES_B_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ITEM_ID
HR_ITEM_PROPERTIES_B_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TEMPLATE_ITEM_CONTEXT_ID
HR_ITEM_PROPERTIES_B_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION_FORMULA_ID INFORMATION_PARAMETER_ITEM_ID1 INFORMATION_PARAMETER_ITEM_ID2 INFORMATION_PARAMETER_ITEM_ID3 INFORMATION_PARAMETER_ITEM_ID4 INFORMATION_PARAMETER_ITEM_ID5
HR_ITEM_PROPERTIES_B_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATION_FORMULA_ID VALIDATION_PARAMETER_ITEM_ID1 VALIDATION_PARAMETER_ITEM_ID2 VALIDATION_PARAMETER_ITEM_ID3 VALIDATION_PARAMETER_ITEM_ID4 VALIDATION_PARAMETER_ITEM_ID5
HR_ITEM_PROPERTIES_B_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION_PARAMETER_ITEM_ID1
HR_ITEM_PROPERTIES_B_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION_PARAMETER_ITEM_ID2
HR_ITEM_PROPERTIES_B_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION_PARAMETER_ITEM_ID3
HR_ITEM_PROPERTIES_B_FK9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INFORMATION_PARAMETER_ITEM_ID4

Foreign Keys

Table	Foreign Table	Foreign Key Column
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B FORM_ITEM_ID
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B INFORMATION_PARAMETER_ITEM_ID5
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B VALIDATION_PARAMETER_ITEM_ID2
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B VALIDATION_PARAMETER_ITEM_ID3
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B VALIDATION_PARAMETER_ITEM_ID4
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B VALIDATION_PARAMETER_ITEM_ID5
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B NEXT_NAVIGATION_ITEM_ID
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B PREVIOUS_NAVIGATION_ITEM_ID
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B VALIDATION_PARAMETER_ITEM_ID1
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B INFORMATION_PARAMETER_ITEM_ID4
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B INFORMATION_PARAMETER_ITEM_ID1
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B INFORMATION_PARAMETER_ITEM_ID2
HR_ITEM_PROPERTIES_B	HR_FORM_ITEMS_B	HR_ITEM_PROPERTIES_B INFORMATION_PARAMETER_ITEM_ID3
HR_ITEM_PROPERTIES_B	HR_TEMPLATE_ITEMS_B	HR_ITEM_PROPERTIES_B TEMPLATE_ITEM_ID
HR_ITEM_PROPERTIES_B	HR_TEMPLATE_ITEM_CONTEXTS_B	HR_ITEM_PROPERTIES_B TEMPLATE_ITEM_CONTEXT_ID
HR_ITEM_PROPERTIES_TL	HR_ITEM_PROPERTIES_B	HR_ITEM_PROPERTIES_TL ITEM_PROPERTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_PROPERTY_ID	NUMBER	(15)	Yes	System-generated primary key using sequence HR_ITEM_PROPERTIES_B_S
FORM_ITEM_ID	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B
TEMPLATE_ITEM_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEMS_B
TEMPLATE_ITEM_CONTEXT_ID	NUMBER	(15)		Foreign ket to HR_TEMPLATE_ITEM_CONTEXTS_B
ALIGNMENT	NUMBER	(10)		Alignment property of item
BEVEL	NUMBER	(10)		Border bevel property of item
CASE_RESTRICTION	NUMBER	(10)		Case restriction of item
DEFAULT_VALUE	VARCHAR2	(2000)
ENABLED	NUMBER	(10)		Is item enabled or disabled
FORMAT_MASK	VARCHAR2	(80)		Format mask for item
HEIGHT	NUMBER	(12)		Height of item
INFORMATION_FORMULA_ID	NUMBER	(15)		Foreign key to FF_FORMULAS_F
INFORMATION_PARAMETER_ITEM_ID1	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID2	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID3	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID4	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID5	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INSERT_ALLOWED	NUMBER	(10)		Insert property of item
PROMPT_ALIGNMENT_OFFSET	NUMBER	(12)		Prompt alignment offset property of item
PROMPT_DISPLAY_STYLE	NUMBER	(10)		Display style of item prompt
PROMPT_EDGE	NUMBER	(10)		Attachment edge of item prompt
PROMPT_EDGE_ALIGNMENT	NUMBER	(10)		Alignment edge of item prompt
PROMPT_EDGE_OFFSET	NUMBER	(12)		Offset of prompt for item
PROMPT_TEXT_ALIGNMENT	NUMBER	(10)		Alignment of prompt text for item
QUERY_ALLOWED	NUMBER	(10)		Query allowed property for item
REQUIRED	NUMBER	(10)		Required property of item
UPDATE_ALLOWED	NUMBER	(10)		Update allowed property of item
VALIDATION_FORMULA_ID	NUMBER	(15)		Foreign key to FF_FORMULAS_F
VALIDATION_PARAMETER_ITEM_ID1	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID2	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID3	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID4	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID5	NUMBER	(15)		Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VISIBLE	NUMBER	(10)		Visible property of item
WIDTH	NUMBER	(12)		Width of item
X_POSITION	NUMBER	(12)		x-position of item
Y_POSITION	NUMBER	(12)		y-position of item
INFORMATION_CATEGORY	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION1	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION2	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION3	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION4	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION5	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION6	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION7	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION8	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION9	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION10	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION11	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION12	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION13	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION14	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION15	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION16	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION17	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION18	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION19	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION20	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION21	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION22	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION23	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION24	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION25	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION26	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION27	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION28	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION29	VARCHAR2	(150)		Developer descriptive flexfield column.
INFORMATION30	VARCHAR2	(150)		Developer descriptive flexfield column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
NEXT_NAVIGATION_ITEM_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEMS_B.
PREVIOUS_NAVIGATION_ITEM_ID	NUMBER	(15)		Foreign key to HR_TEMPLATE_ITEMS_B.
OBJECT_VERSION_NUMBER	NUMBER			System-generated version of row. Increments by one with each update.

Query Text

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


SELECT ITEM_PROPERTY_ID
,      FORM_ITEM_ID
,      TEMPLATE_ITEM_ID
,      TEMPLATE_ITEM_CONTEXT_ID
,      ALIGNMENT
,      BEVEL
,      CASE_RESTRICTION
,      DEFAULT_VALUE
,      ENABLED
,      FORMAT_MASK
,      HEIGHT
,      INFORMATION_FORMULA_ID
,      INFORMATION_PARAMETER_ITEM_ID1
,      INFORMATION_PARAMETER_ITEM_ID2
,      INFORMATION_PARAMETER_ITEM_ID3
,      INFORMATION_PARAMETER_ITEM_ID4
,      INFORMATION_PARAMETER_ITEM_ID5
,      INSERT_ALLOWED
,      PROMPT_ALIGNMENT_OFFSET
,      PROMPT_DISPLAY_STYLE
,      PROMPT_EDGE
,      PROMPT_EDGE_ALIGNMENT
,      PROMPT_EDGE_OFFSET
,      PROMPT_TEXT_ALIGNMENT
,      QUERY_ALLOWED
,      REQUIRED
,      UPDATE_ALLOWED
,      VALIDATION_FORMULA_ID
,      VALIDATION_PARAMETER_ITEM_ID1
,      VALIDATION_PARAMETER_ITEM_ID2
,      VALIDATION_PARAMETER_ITEM_ID3
,      VALIDATION_PARAMETER_ITEM_ID4
,      VALIDATION_PARAMETER_ITEM_ID5
,      VISIBLE
,      WIDTH
,      X_POSITION
,      Y_POSITION
,      INFORMATION_CATEGORY
,      INFORMATION1
,      INFORMATION2
,      INFORMATION3
,      INFORMATION4
,      INFORMATION5
,      INFORMATION6
,      INFORMATION7
,      INFORMATION8
,      INFORMATION9
,      INFORMATION10
,      INFORMATION11
,      INFORMATION12
,      INFORMATION13
,      INFORMATION14
,      INFORMATION15
,      INFORMATION16
,      INFORMATION17
,      INFORMATION18
,      INFORMATION19
,      INFORMATION20
,      INFORMATION21
,      INFORMATION22
,      INFORMATION23
,      INFORMATION24
,      INFORMATION25
,      INFORMATION26
,      INFORMATION27
,      INFORMATION28
,      INFORMATION29
,      INFORMATION30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      NEXT_NAVIGATION_ITEM_ID
,      PREVIOUS_NAVIGATION_ITEM_ID
,      OBJECT_VERSION_NUMBER
FROM HR.HR_ITEM_PROPERTIES_B;

Dependencies

[top of page]

HR.HR_ITEM_PROPERTIES_B does not reference any database object

HR.HR_ITEM_PROPERTIES_B is referenced by following:

APPS: HR_ITEM_PROPERTIES_B; HR_ITEM_PROPERTIES_B_WHO
PUBLIC: HR_ITEM_PROPERTIES_B