[Home] [Help] [Dependency Information]
Object Name: | PER_ADDRESSES1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ADDRESS_STYLE | VARCHAR2 | (30) | Yes | |
ADDRESS_LINE_1 | VARCHAR2 | (240) | ||
ADDRESS_LINE_2 | VARCHAR2 | (240) | ||
EMIRATE | VARCHAR2 | (240) | ||
CITY___VILLAGE | VARCHAR2 | (30) | ||
REGION___AREA | VARCHAR2 | (120) | ||
STREET | VARCHAR2 | (240) | ||
BUILDING | VARCHAR2 | (240) | ||
FLAT_NUMBER | VARCHAR2 | (150) | ||
PO_BOX | NUMBER | |||
COUNTRY | VARCHAR2 | (60) | ||
ADDRESS_LINE_3 | VARCHAR2 | (240) | ||
CITY | VARCHAR2 | (30) | ||
PROVINCE | VARCHAR2 | (120) | ||
ZONE | VARCHAR2 | (120) | ||
POSTAL_CODE | VARCHAR2 | (30) | ||
TELEPHONE | VARCHAR2 | (60) | ||
FAX | VARCHAR2 | (60) | ||
MOBILE_PHONE | VARCHAR2 | (60) | ||
INTERNET_ADDRESS | VARCHAR2 | (120) | ||
REGION | VARCHAR2 | (120) | ||
TELEPHONE2 | VARCHAR2 | (60) | ||
TELEPHONE3 | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (120) | ||
NUM | VARCHAR2 | (240) | ||
BOX | VARCHAR2 | (240) | ||
TOWN_CITY | VARCHAR2 | (150) | ||
REGION_1 | VARCHAR2 | (120) | ||
REGION_2 | VARCHAR2 | (120) | ||
REGION_3 | VARCHAR2 | (120) | ||
POSTCODE | VARCHAR2 | (30) | ||
TELEPHONE_1 | VARCHAR2 | (60) | ||
TELEPHONE_2 | VARCHAR2 | (60) | ||
TELEPHONE_3 | VARCHAR2 | (60) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
NEIGHBOURHOOD | VARCHAR2 | (120) | ||
ZIP_CODE | VARCHAR2 | (30) | ||
ADDRESS_LINE1 | VARCHAR2 | (240) | ||
ADDRESS_LINE2 | VARCHAR2 | (240) | ||
ADDRESS_LINE3 | VARCHAR2 | (240) | ||
CANTON | VARCHAR2 | (120) | ||
PROVINCE_CITY_SAR | VARCHAR2 | (30) | ||
NEIGHBORHOOD | VARCHAR2 | (240) | ||
AREA_CODE | NUMBER | |||
HOUSE_NUMBER | VARCHAR2 | (240) | ||
TOWN | VARCHAR2 | (240) | ||
BUNDESLAND | VARCHAR2 | (120) | ||
ROAD_NUMBER | VARCHAR2 | (240) | ||
ADDITIONAL_INFORMATION | VARCHAR2 | (240) | ||
POSTAL_CODE_TOWN | VARCHAR2 | (30) | ||
LOCATION_TYPE | VARCHAR2 | (240) | ||
LOCATION_NAME | VARCHAR2 | (240) | ||
LOCATION_NUMBER | VARCHAR2 | (240) | ||
STAIRS | VARCHAR2 | (150) | ||
FLOOR | VARCHAR2 | (150) | ||
DOOR | VARCHAR2 | (150) | ||
PROVINCE_NAME | VARCHAR2 | (120) | ||
INSEE_CODE | VARCHAR2 | (120) | ||
SMALL_TOWN | VARCHAR2 | (120) | ||
DEPARTMENT | VARCHAR2 | (120) | ||
ADDRESS_LINE4 | VARCHAR2 | (120) | ||
COUNTY | VARCHAR2 | (120) | ||
POST_CODE | VARCHAR2 | (30) | ||
TOWN_OR_CITY | VARCHAR2 | (30) | ||
TELEPHONE_NUMBER_1 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER_2 | VARCHAR2 | (60) | ||
DISTRICT | VARCHAR2 | (120) | ||
AREA | VARCHAR2 | (120) | ||
STREET_NUMBER | VARCHAR2 | (240) | ||
STAIRWAY | VARCHAR2 | (150) | ||
ENA_DIS_POSTAL_CODE | VARCHAR2 | (120) | ||
GEO_CODE | NUMBER | |||
ADDRESS_LINE_4 | VARCHAR2 | (150) | ||
STATE_UT | VARCHAR2 | (150) | ||
PIN_CODE | NUMBER | |||
METRO_STATUS | VARCHAR2 | (150) | ||
TOWN_CITY_DISTRICT | VARCHAR2 | (150) | ||
PIN | VARCHAR2 | (30) | ||
DISTRICT_CODE | VARCHAR2 | (30) | ||
TELEPHONE_NUMBER1 | VARCHAR2 | (60) | ||
TELEPHONE_NUMBER2 | VARCHAR2 | (60) | ||
FAX_NUMBER | VARCHAR2 | (60) | ||
ADDRESS_LINE1__KANA_ | VARCHAR2 | (120) | ||
ADDRESS_LINE2__KANA_ | VARCHAR2 | (120) | ||
ADDRESS_LINE3__KANA_ | VARCHAR2 | (120) | ||
ADDRESS_LINE1_HD | VARCHAR2 | (240) | ||
PHONE_NUMBER_HOME_ | VARCHAR2 | (60) | ||
PHONE_NUMBER_MOBILE_ | VARCHAR2 | (60) | ||
PHONE_NUMBER_WORK_ | VARCHAR2 | (60) | ||
GOVERNORATE | VARCHAR2 | (240) | ||
BLOCK | VARCHAR2 | (120) | ||
LANE_ROAD | VARCHAR2 | (150) | ||
BUILDING_APARTMENT | VARCHAR2 | (150) | ||
STREET_NAME_AND_NUMBER | VARCHAR2 | (240) | ||
MUNICIPALITY | VARCHAR2 | (120) | ||
STATE_OR_PROVINCE | VARCHAR2 | (120) | ||
HOUSE_NUMBER_ADDITION | VARCHAR2 | (150) | ||
STREET_NAME | VARCHAR2 | (240) | ||
PO_BOX_NUMBER | VARCHAR2 | (120) | ||
POSTAL_CODE___OFFICE | VARCHAR2 | (30) | ||
POST_OFFICE | VARCHAR2 | (30) | ||
STREET_TYPE | VARCHAR2 | (240) | ||
COMMUNITY | VARCHAR2 | (120) | ||
POST | VARCHAR2 | (150) | ||
POST_BOX | VARCHAR2 | (150) | ||
ADDRESS_CATEGORY | VARCHAR2 | (150) | ||
PLACE_OKATO_ | VARCHAR2 | (120) | ||
REGION_DISTRICT | VARCHAR2 | (120) | ||
APARTMENT_NUMBER | VARCHAR2 | (240) | ||
BLOCK_NUMBER_OR_ADDRESS_NUMBER | VARCHAR2 | (240) | ||
APARTMENT_UNIT_FLOOR_NUMBER | VARCHAR2 | (240) | ||
PAY_CITY | VARCHAR2 | (150) | ||
PAY_STATE | VARCHAR2 | (150) | ||
PAY_ZIP | VARCHAR2 | (150) | ||
PAY_COUNTY | VARCHAR2 | (150) | ||
ZIP_OR_POSTAL_CODE | VARCHAR2 | (30) | ||
REGION_OR_COUNTY | VARCHAR2 | (120) | ||
TELEPHONE1 | VARCHAR2 | (60) | ||
TOWN___CITY | VARCHAR2 | (30) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (1723) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ADDRESS_STYLE
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, EMIRATE
, CITY___VILLAGE
, REGION___AREA
, STREET
, BUILDING
, FLAT_NUMBER
, PO_BOX
, COUNTRY
, ADDRESS_LINE_3
, CITY
, PROVINCE
, ZONE
, POSTAL_CODE
, TELEPHONE
, FAX
, MOBILE_PHONE
, INTERNET_ADDRESS
, REGION
, TELEPHONE2
, TELEPHONE3
, STATE
, NUM
, BOX
, TOWN_CITY
, REGION_1
, REGION_2
, REGION_3
, POSTCODE
, TELEPHONE_1
, TELEPHONE_2
, TELEPHONE_3
, ADDRESS1
, ADDRESS2
, ADDRESS3
, NEIGHBOURHOOD
, ZIP_CODE
, ADDRESS_LINE1
, ADDRESS_LINE2
, ADDRESS_LINE3
, CANTON
, PROVINCE_CITY_SAR
, NEIGHBORHOOD
, AREA_CODE
, HOUSE_NUMBER
, TOWN
, BUNDESLAND
, ROAD_NUMBER
, ADDITIONAL_INFORMATION
, POSTAL_CODE_TOWN
, LOCATION_TYPE
, LOCATION_NAME
, LOCATION_NUMBER
, STAIRS
, FLOOR
, DOOR
, PROVINCE_NAME
, INSEE_CODE
, SMALL_TOWN
, DEPARTMENT
, ADDRESS_LINE4
, COUNTY
, POST_CODE
, TOWN_OR_CITY
, TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2
, DISTRICT
, AREA
, STREET_NUMBER
, STAIRWAY
, ENA_DIS_POSTAL_CODE
, GEO_CODE
, ADDRESS_LINE_4
, STATE_UT
, PIN_CODE
, METRO_STATUS
, TOWN_CITY_DISTRICT
, PIN
, DISTRICT_CODE
, TELEPHONE_NUMBER1
, TELEPHONE_NUMBER2
, FAX_NUMBER
, ADDRESS_LINE1__KANA_
, ADDRESS_LINE2__KANA_
, ADDRESS_LINE3__KANA_
, ADDRESS_LINE1_HD
, PHONE_NUMBER_HOME_
, PHONE_NUMBER_MOBILE_
, PHONE_NUMBER_WORK_
, GOVERNORATE
, BLOCK
, LANE_ROAD
, BUILDING_APARTMENT
, STREET_NAME_AND_NUMBER
, MUNICIPALITY
, STATE_OR_PROVINCE
, HOUSE_NUMBER_ADDITION
, STREET_NAME
, PO_BOX_NUMBER
, POSTAL_CODE___OFFICE
, POST_OFFICE
, STREET_TYPE
, COMMUNITY
, POST
, POST_BOX
, ADDRESS_CATEGORY
, PLACE_OKATO_
, REGION_DISTRICT
, APARTMENT_NUMBER
, BLOCK_NUMBER_OR_ADDRESS_NUMBER
, APARTMENT_UNIT_FLOOR_NUMBER
, PAY_CITY
, PAY_STATE
, PAY_ZIP
, PAY_COUNTY
, ZIP_OR_POSTAL_CODE
, REGION_OR_COUNTY
, TELEPHONE1
, TOWN___CITY
, CONCATENATED_SEGMENTS
FROM APPS.PER_ADDRESSES1_DFV;
|
|
|