[Home] [Help] [Dependency Information]
Object Name: | AP_POL_LOCATIONS_TL |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_POL_LOCATIONS_TL |
Subobject Name: | |
Status: | VALID |
AP_POL_LOCATIONS_TL is a Policy Compliance-specific table that provides multi-lingual support (MLS) for locations that you define for policy schedules. MLS enables you to store and print the location data that you define in multiple languages. The primary key for this table is LOCATION_ID and LANGUAGE.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_POL_LOCATIONS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LOCATION_ID
LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_ID | NUMBER | (15) | Yes | Location unique identifier. |
LOCATION | VARCHAR2 | (240) | Location definition. | |
DESCRIPTION | VARCHAR2 | (240) | Location description. | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code of the location. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the records current language. |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_ID
, LOCATION
, DESCRIPTION
, LANGUAGE
, SOURCE_LANG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM AP.AP_POL_LOCATIONS_TL;
AP.AP_POL_LOCATIONS_TL does not reference any database object
AP.AP_POL_LOCATIONS_TL is referenced by following:
|
|
|