[Home] [Help] [Dependency Information]
Object Name: | JTF_LOC_HIERARCHIES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JTF.JTF_LOC_HIERARCHIES_VL |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View based on JTF_LOC_HIERARCHIES_B table. Stores information about what geographic location hierarchies are available to be used in Oracle Marketing.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row id of the table. | |
LOCATION_HIERARCHY_ID | NUMBER | Yes | Unique identifier. | |
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). |
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). | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | This column is used for locking purposes. |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
CREATED_BY_APPLICATION_ID | NUMBER | Yes | Identifier of the application that created record. | |
LOCATION_TYPE_CODE | VARCHAR2 | (30) | Yes | Foreign key to table JTF_LOC_TYPES_B. |
LOCATION_TYPE_NAME | VARCHAR2 | (240) | Yes | Name of the location type. |
START_DATE_ACTIVE | DATE | Yes | The date on which the hierarchy record becomes active. | |
END_DATE_ACTIVE | DATE | The date until which the hierarchy record remains active. | ||
AREA1_ID | NUMBER | Identifier of AREA1-type location area. | ||
AREA1_CODE | VARCHAR2 | (30) | Short name of AREA1-type location area that AREA1_ID identifies. | |
AREA1_NAME | VARCHAR2 | (240) | Name of AREA1-type location area that AREA1_ID identifies. | |
AREA2_ID | NUMBER | Identifier of AREA2-type location area. | ||
AREA2_CODE | VARCHAR2 | (30) | Short name of AREA2-type location area that AREA2_ID identifies. | |
AREA2_NAME | VARCHAR2 | (240) | Name of AREA2-type location area that AREA2_ID identifies. | |
COUNTRY_ID | NUMBER | Identifier of COUNTRY-type location area. | ||
COUNTRY_CODE | VARCHAR2 | (30) | Short name of COUNTRY-type location area that COUNTRY_ID identifies. | |
COUNTRY_NAME | VARCHAR2 | (240) | Name of COUNTRY-type location area that COUNTRY_ID identifies. | |
COUNTRY_REGION_ID | NUMBER | Identifier of COUNTRY_REGION-type location area. | ||
COUNTRY_REGION_CODE | VARCHAR2 | (30) | Short name of COUNTRY_REGION-type location area that COUNTRY_REGION_ID identifies. | |
COUNTRY_REGION_NAME | VARCHAR2 | (240) | Name of COUNTRY_REGION-type location area that COUNTRY_REGION_ID identifies. | |
STATE_ID | NUMBER | Identifier of STATE-type location area. | ||
STATE_CODE | VARCHAR2 | (30) | Short name of STATE-type location area that STATE_ID identifies. | |
STATE_NAME | VARCHAR2 | (240) | Name of STATE-type location area that STATE_ID identifies. | |
STATE_REGION_ID | NUMBER | Identifier of STATE_REGION-type location area. | ||
STATE_REGION_CODE | VARCHAR2 | (30) | Short name of STATE_REGION-type location area that STATE_REGION_ID identifies. | |
STATE_REGION_NAME | VARCHAR2 | (240) | Name of STATE_REGION-type location area that STATE_REGION_ID identifies. | |
CITY_ID | NUMBER | Identifier of CITY-type location area. | ||
CITY_CODE | VARCHAR2 | (30) | Short name of CITY-type location area that CITY_ID identifies. | |
CITY_NAME | VARCHAR2 | (240) | Name of CITY-type location area that CITY_ID identifies. | |
POSTAL_CODE_ID | NUMBER | Identifier of POSTAL_CODE-type location area. | ||
POSTAL_CODE_START | VARCHAR2 | (6) | Indicates the beginning of a postal code range. | |
POSTAL_CODE_END | VARCHAR2 | (6) | Indicates the end of a postal code range. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LOCATION_HIERARCHY_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY_APPLICATION_ID
, LOCATION_TYPE_CODE
, LOCATION_TYPE_NAME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, AREA1_ID
, AREA1_CODE
, AREA1_NAME
, AREA2_ID
, AREA2_CODE
, AREA2_NAME
, COUNTRY_ID
, COUNTRY_CODE
, COUNTRY_NAME
, COUNTRY_REGION_ID
, COUNTRY_REGION_CODE
, COUNTRY_REGION_NAME
, STATE_ID
, STATE_CODE
, STATE_NAME
, STATE_REGION_ID
, STATE_REGION_CODE
, STATE_REGION_NAME
, CITY_ID
, CITY_CODE
, CITY_NAME
, POSTAL_CODE_ID
, POSTAL_CODE_START
, POSTAL_CODE_END
FROM APPS.JTF_LOC_HIERARCHIES_VL;
|
|
|