[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
ZD_EDITION_NAME |
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. | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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
, ZD_EDITION_NAME
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:
|
|
|