[Home] [Help] [Dependency Information]
Object Name: | OTA_CROSS_CHARGES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_CROSS_CHARGES |
Subobject Name: | |
Status: | VALID |
This table stores the header information (i.e., Set of Books, Business Groups, Effective period) of the mappings between Oracle General Ledger's Chart of Account elements and Oracle Human Resources' Cost Allocation elements. 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_CROSS_CHARGES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | CROSS_CHARGE_ID |
OTA_CROSS_CHARGES_UK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BUSINESS_GROUP_ID
TYPE FROM_TO START_DATE_ACTIVE END_DATE_ACTIVE |
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 |
---|---|---|---|---|
CROSS_CHARGE_ID | NUMBER | (15) | Yes | The system generated surrogatekey for this entry. |
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | Foreign key to PER_BUSINESS_GROUPS |
GL_SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Foreign key to GL_SETS_OF_BOOKS. |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
TYPE | VARCHAR2 | (30) | Yes | Cross charge type |
FROM_TO | VARCHAR2 | (30) | Yes | Source of the Cross Charge |
START_DATE_ACTIVE | DATE | Yes | The Date on which the definition active. | |
END_DATE_ACTIVE | DATE | The Date on which the definition Ends | ||
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT CROSS_CHARGE_ID
, BUSINESS_GROUP_ID
, GL_SET_OF_BOOKS_ID
, OBJECT_VERSION_NUMBER
, TYPE
, FROM_TO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OTA.OTA_CROSS_CHARGES;
OTA.OTA_CROSS_CHARGES does not reference any database object
OTA.OTA_CROSS_CHARGES is referenced by following:
|
|
|