[Home] [Help] [Dependency Information]
Object Name: | OTA_HR_GL_FLEX_MAPS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_HR_GL_FLEX_MAPS |
Subobject Name: | |
Status: | VALID |
This table stores the detail mappings between Oracle General Ledger's Chart of Account keyflex segments and Oracle Human Resources' Cost Allocation keyflex segments. Oracle Training Self Serivce modules use the information stored in both OTA_CROSS_CHARGES and OTA_HR_GL_FLEX_MAPS to perform cross charging of internal enrollments.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_HR_GL_FLEX_MAPS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | GL_DEFAULT_SEGMENT_ID |
OTA_HR_GL_FLEX_MAPS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CROSS_CHARGE_ID
SEGMENT SEGMENT_NUM |
Table | |
Foreign Table | Foreign Key Column | OTA_HR_GL_FLEX_MAPS | OTA_CROSS_CHARGES | OTA_HR_GL_FLEX_MAPS CROSS_CHARGE_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GL_DEFAULT_SEGMENT_ID | NUMBER | Yes | The system generated surrogatekey for this entry. | |
CROSS_CHARGE_ID | NUMBER | (15) | Yes | Foreign key to OTA_CROSS_CHARGES. |
SEGMENT | VARCHAR2 | (30) | Yes | Name of the segment in the accounting flexfield structure to which this record applies |
SEGMENT_NUM | NUMBER | Yes | Number of the segment in the accounting flexfield structure to which this record is applied | |
HR_DATA_SOURCE | VARCHAR2 | (30) | Name of the table on which this segment is based | |
CONSTANT | VARCHAR2 | (30) | Constant value for this segment | |
HR_COST_SEGMENT | VARCHAR2 | (30) | Cost Segment from Pay Cost Allocation Keyflex | |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
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 GL_DEFAULT_SEGMENT_ID
, CROSS_CHARGE_ID
, SEGMENT
, SEGMENT_NUM
, HR_DATA_SOURCE
, CONSTANT
, HR_COST_SEGMENT
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM OTA.OTA_HR_GL_FLEX_MAPS;
OTA.OTA_HR_GL_FLEX_MAPS does not reference any database object
OTA.OTA_HR_GL_FLEX_MAPS is referenced by following:
|
|
|