[Home] [Help] [Dependency Information]
Object Name: | HR_ORG_INFORMATION_TYPES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.HR_ORG_INFORMATION_TYPES |
Subobject Name: | |
Status: | VALID |
HR_ORG_INFORMATION_TYPES holds a list of predefined types of
organization information. These are the types of information you can
enter when you select an organization classification on the Define
Organization form. For example, costing and standard work day
information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HR_ORG_INFORMATION_TYPES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ORG_INFORMATION_TYPE |
Table | |
Foreign Table | Foreign Key Column | HR_ORGANIZATION_INFORMATION | HR_ORG_INFORMATION_TYPES | HR_ORGANIZATION_INFORMATION ORG_INFORMATION_CONTEXT | HR_ORG_INFO_TYPES_BY_CLASS | HR_ORG_INFORMATION_TYPES | HR_ORG_INFO_TYPES_BY_CLASS ORG_INFORMATION_TYPE |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_INFORMATION_TYPE | VARCHAR2 | (40) | Yes | Developer descriptive flexfield column. |
DESCRIPTION | VARCHAR2 | (240) | Description of information type. | |
DESTINATION | VARCHAR2 | (80) | Zoom or call form destination. | |
DISPLAYED_ORG_INFORMATION_TYPE | VARCHAR2 | (30) | Name of the information type that is visible to the user. | |
FND_APPLICATION_ID | NUMBER | (15) | Foreign key reference to AOL application. | |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation code for Business Group. | |
NAVIGATION_METHOD | VARCHAR2 | (80) | Navigation to be performed to maintain attributes for the organization type. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_INFORMATION_TYPE
, DESCRIPTION
, DESTINATION
, DISPLAYED_ORG_INFORMATION_TYPE
, FND_APPLICATION_ID
, LEGISLATION_CODE
, NAVIGATION_METHOD
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.HR_ORG_INFORMATION_TYPES;
HR.HR_ORG_INFORMATION_TYPES does not reference any database object
HR.HR_ORG_INFORMATION_TYPES is referenced by following:
|
|
|