[Home] [Help] [Dependency Information]
Object Name: | POS_HZ_LOCATION_BO |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
LOCATION_ID | NUMBER |
|
15 |
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY | NUMBER |
|
15 |
CREATION_DATE | DATE |
|
|
CREATED_BY | NUMBER |
|
15 |
LAST_UPDATE_LOGIN | NUMBER |
|
15 |
REQUEST_ID | NUMBER |
|
15 |
PROGRAM_APPLICATION_ID | NUMBER |
|
15 |
PROGRAM_ID | NUMBER |
|
15 |
PROGRAM_UPDATE_DATE | DATE |
|
|
WH_UPDATE_DATE | DATE |
|
|
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | |
ATTRIBUTE1 | VARCHAR2 | (150) | |
ATTRIBUTE2 | VARCHAR2 | (150) | |
ATTRIBUTE3 | VARCHAR2 | (150) | |
ATTRIBUTE4 | VARCHAR2 | (150) | |
ATTRIBUTE5 | VARCHAR2 | (150) | |
ATTRIBUTE6 | VARCHAR2 | (150) | |
ATTRIBUTE7 | VARCHAR2 | (150) | |
ATTRIBUTE8 | VARCHAR2 | (150) | |
ATTRIBUTE9 | VARCHAR2 | (150) | |
ATTRIBUTE10 | VARCHAR2 | (150) | |
ATTRIBUTE11 | VARCHAR2 | (150) | |
ATTRIBUTE12 | VARCHAR2 | (150) | |
ATTRIBUTE13 | VARCHAR2 | (150) | |
ATTRIBUTE14 | VARCHAR2 | (150) | |
ATTRIBUTE15 | VARCHAR2 | (150) | |
ATTRIBUTE16 | VARCHAR2 | (150) | |
ATTRIBUTE17 | VARCHAR2 | (150) | |
ATTRIBUTE18 | VARCHAR2 | (150) | |
ATTRIBUTE19 | VARCHAR2 | (150) | |
ATTRIBUTE20 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | |
COUNTRY | VARCHAR2 | (60) | |
ADDRESS1 | VARCHAR2 | (240) | |
ADDRESS2 | VARCHAR2 | (240) | |
ADDRESS3 | VARCHAR2 | (240) | |
ADDRESS4 | VARCHAR2 | (240) | |
CITY | VARCHAR2 | (60) | |
POSTAL_CODE | VARCHAR2 | (60) | |
STATE | VARCHAR2 | (60) | |
PROVINCE | VARCHAR2 | (60) | |
COUNTY | VARCHAR2 | (60) | |
ADDRESS_KEY | VARCHAR2 | (500) | |
ADDRESS_STYLE | VARCHAR2 | (30) | |
VALIDATED_FLAG | VARCHAR2 | (1) | |
ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | |
APARTMENT_FLAG | VARCHAR2 | (1) | |
PO_BOX_NUMBER | VARCHAR2 | (50) | |
HOUSE_NUMBER | VARCHAR2 | (50) | |
STREET_SUFFIX | VARCHAR2 | (50) | |
APARTMENT_NUMBER | VARCHAR2 | (50) | |
SECONDARY_SUFFIX_ELEMENT | VARCHAR2 | (240) | |
STREET | VARCHAR2 | (50) | |
RURAL_ROUTE_TYPE | VARCHAR2 | (50) | |
RURAL_ROUTE_NUMBER | VARCHAR2 | (50) | |
STREET_NUMBER | VARCHAR2 | (50) | |
BUILDING | VARCHAR2 | (50) | |
FLOOR_NAME | VARCHAR2 | (50) | |
SUITE | VARCHAR2 | (50) | |
ROOM | VARCHAR2 | (50) | |
POSTAL_PLUS4_CODE | VARCHAR2 | (10) | |
TIME_ZONE | VARCHAR2 | (50) | |
OVERSEAS_ADDRESS_FLAG | VARCHAR2 | (1) | |
POST_OFFICE | VARCHAR2 | (50) | |
POSITION | VARCHAR2 | (50) | |
DELIVERY_POINT_CODE | VARCHAR2 | (50) | |
LOCATION_DIRECTIONS | VARCHAR2 | (640) | |
ADDRESS_EFFECTIVE_DATE | DATE |
|
|
ADDRESS_EXPIRATION_DATE | DATE |
|
|
ADDRESS_ERROR_CODE | VARCHAR2 | (50) | |
CLLI_CODE | VARCHAR2 | (60) | |
DODAAC | VARCHAR2 | (6) | |
TRAILING_DIRECTORY_CODE | VARCHAR2 | (60) | |
LANGUAGE | VARCHAR2 | (4) | |
LIFE_CYCLE_STATUS | VARCHAR2 | (30) | |
SHORT_DESCRIPTION | VARCHAR2 | (240) | |
DESCRIPTION | VARCHAR2 | (2000) | |
CONTENT_SOURCE_TYPE | VARCHAR2 | (30) | |
LOC_HIERARCHY_ID | NUMBER |
|
15 |
SALES_TAX_GEOCODE | VARCHAR2 | (30) | |
SALES_TAX_INSIDE_CITY_LIMITS | VARCHAR2 | (30) | |
FA_LOCATION_ID | NUMBER |
|
15 |
OBJECT_VERSION_NUMBER | NUMBER |
|
|
CREATED_BY_MODULE | VARCHAR2 | (150) | |
APPLICATION_ID | NUMBER |
|
|
TIMEZONE_ID | NUMBER |
|
|
GEOMETRY_STATUS_CODE | VARCHAR2 | (30) | |
ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | |
VALIDATION_STATUS_CODE | VARCHAR2 | (30) | |
DATE_VALIDATED | DATE |
|
|
DO_NOT_VALIDATE_FLAG | VARCHAR2 | (1) | |
GEOMETRY | SDO_GEOMETRY |
|
|
|
|