[Home] [Help]
[Dependency Information]
[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 | (240) | ||
| 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) | ||
| HOUSEBOAT | VARCHAR2 | (150) | ||
| CARAVAN | VARCHAR2 | (150) | ||
| PHONE_NUMBER | NUMBER | |||
| MOBILE_PHONE_NUMBER | NUMBER | |||
| LOCATION_DESCRIPTION | VARCHAR2 | (150) | ||
| ISO_COUNTRY_CODE | VARCHAR2 | (150) | ||
| POSTAL_CODE___OFFICE | VARCHAR2 | (30) | ||
| POST_OFFICE | VARCHAR2 | (30) | ||
| STREET_TYPE | VARCHAR2 | (240) | ||
| COMMUNITY | VARCHAR2 | (120) | ||
| POST | VARCHAR2 | (150) | ||
| POST_BOX | VARCHAR2 | (150) | ||
| LOCALITY | VARCHAR2 | (240) | ||
| ENTRANCE | VARCHAR2 | (150) | ||
| APARTMENT_NUMBER | VARCHAR2 | (240) | ||
| PHONE | VARCHAR2 | (60) | ||
| MOBILE | VARCHAR2 | (60) | ||
| VARCHAR2 | (150) | |||
| ADDRESS_CATEGORY | VARCHAR2 | (150) | ||
| PLACE_OKATO_ | VARCHAR2 | (120) | ||
| REGION_DISTRICT | VARCHAR2 | (120) | ||
| 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) | ||
| SAME_AS_RESIDENTIAL_ADDRESS | VARCHAR2 | (120) | ||
| TOWN___CITY | VARCHAR2 | (30) | ||
| UNIT_NUMBER | VARCHAR2 | (240) | ||
| COMPLEX | VARCHAR2 | (240) | ||
| STREET_OR_NAME_OF_FARM | VARCHAR2 | (120) | ||
| SUBURB_OR_DISTRICT | VARCHAR2 | (120) | ||
| CONCATENATED_SEGMENTS | VARCHAR2 | (1965) |
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
, HOUSEBOAT
, CARAVAN
, PHONE_NUMBER
, MOBILE_PHONE_NUMBER
, LOCATION_DESCRIPTION
, ISO_COUNTRY_CODE
, POSTAL_CODE___OFFICE
, POST_OFFICE
, STREET_TYPE
, COMMUNITY
, POST
, POST_BOX
, LOCALITY
, ENTRANCE
, APARTMENT_NUMBER
, PHONE
, MOBILE
, EMAIL
, ADDRESS_CATEGORY
, PLACE_OKATO_
, REGION_DISTRICT
, 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
, SAME_AS_RESIDENTIAL_ADDRESS
, TOWN___CITY
, UNIT_NUMBER
, COMPLEX
, STREET_OR_NAME_OF_FARM
, SUBURB_OR_DISTRICT
, CONCATENATED_SEGMENTS
FROM APPS.PER_ADDRESSES1_DFV;
APPS
FND_NUMBER
- show dependent code
PER_ADDRESSES
APPS.PER_ADDRESSES1_DFV is not referenced by any database object
|
|
|
|