[Home] [Help] [Dependency Information]
Object Name: | CSC_HZ_PARTY_SITES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSC.CSC_HZ_PARTY_SITES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Standard Row ID column | |
PARTY_ID | NUMBER | (15) | Yes | Party identifier. FK to HZ_PARTIES |
PARTY_NUMBER | VARCHAR2 | (30) | Yes | Party number |
PARTY_NAME | VARCHAR2 | (360) | Yes | Party name |
PARTY_TYPE | VARCHAR2 | (30) | Yes | Type of party. This is limited to person, organization, group or relationship. |
LOCATION_ID | NUMBER | (15) | Yes | Location identifier and foreign key to HZ_LOCATIONS. |
PARTY_SITE_ID | NUMBER | (15) | Yes | Party site identifier |
STATUS | VARCHAR2 | (1) | Yes | Site use type |
SITE_NAME | VARCHAR2 | (240) | User defined location name | |
ADDRESSEE | VARCHAR2 | (360) | Addressee information | |
LANGUAGE | VARCHAR2 | (4) | Operating language of the location. FK to FND_LANGUAGES | |
ADDRESS | VARCHAR2 | (963) | Partial Address | |
FULL_ADDRESS | VARCHAR2 | (1268) | Full Address | |
ADDRESS1 | VARCHAR2 | (240) | Yes | First line for address |
ADDRESS2 | VARCHAR2 | (240) | Second line for address | |
ADDRESS3 | VARCHAR2 | (240) | Third line for address | |
ADDRESS4 | VARCHAR2 | (240) | Fourth line for address | |
STREET | VARCHAR2 | (50) | In an address, (e.g., 121 Any Street #101, Small Town, California, United States of America) the street is 'Any'. | |
HOUSE_NUMBER | VARCHAR2 | (50) | House Number. In an address, (e.g., 121 Any Street #101, Small Town, California, United States of America) the house number is '121'. | |
APARTMENT_NUMBER | VARCHAR2 | (50) | In an address, (e.g., 121 Any Street #101, Small Town, California, United States of | |
BUILDING | VARCHAR2 | (50) | A number assigned to an entire building within an address. | |
POSITION | VARCHAR2 | (50) | The primary direction (for example North, East, etc.) by which access to the location is achieved | |
CITY | VARCHAR2 | (60) | City | |
STATE | VARCHAR2 | (60) | State | |
PROVINCE | VARCHAR2 | (60) | Province | |
POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
PO_BOX_NUMBER | VARCHAR2 | (50) | Post Office Box Number | |
COUNTY | VARCHAR2 | (60) | County | |
COUNTRY | VARCHAR2 | (60) | Yes | FND_TERRITORY.TERRITORY_CODE |
PRIMARY_FLAG | VARCHAR2 | (1) | Yes | Y or N indicates whether this is the identifying address for the party. |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ADDRESS_KEY | VARCHAR2 | (500) | Address Key | |
APARTMENT_FLAG | VARCHAR2 | (1) | Apartment Flag | |
STREET_SUFFIX | VARCHAR2 | (50) | Street Suffix | |
SECONDARY_SUFFIX_ELEMENT | VARCHAR2 | (240) | Secondary Suffix | |
RURAL_ROUTE_TYPE | VARCHAR2 | (50) | Rural Route Type | |
RURAL_ROUTE_NUMBER | VARCHAR2 | (50) | Rural Route Number | |
STREET_NUMBER | VARCHAR2 | (50) | Street Number | |
FLOOR | VARCHAR2 | (50) | Floor | |
SUITE | VARCHAR2 | (50) | Suite | |
ROOM | VARCHAR2 | (50) | Room | |
POSTAL_PLUS4_CODE | VARCHAR2 | (10) | Postal Plus4 Code | |
TIME_ZONE | VARCHAR2 | (50) | Time Zone | |
POST_OFFICE | VARCHAR2 | (50) | Post Office | |
DELIVERY_POINT_CODE | VARCHAR2 | (50) | Delivery Point Code | |
LOCATION_DIRECTIONS | VARCHAR2 | (640) | Location Directions | |
ADDRESS_ERROR_CODE | VARCHAR2 | (50) | Address Error Code | |
CLLI_CODE | VARCHAR2 | (60) | CLLI code | |
DODAAC | VARCHAR2 | (6) | DODAAC | |
TRAILING_DIRECTORY_CODE | VARCHAR2 | (60) | Trailing Directory Code | |
LIFE_CYCLE_STATUS | VARCHAR2 | (30) | Life Cycle Status | |
SHORT_DESCRIPTION | VARCHAR2 | (240) | Short Description | |
DESCRIPTION | VARCHAR2 | (2000) | Description | |
SALES_TAX_GEOCODE | VARCHAR2 | (30) | Sales Tax Geocode | |
SALES_TAX_INSIDE_CITY_LIMITS | VARCHAR2 | (30) | Sales Tax Inside City Limits | |
SITE_OBJECT_VERSION_NUMBER | NUMBER | Site Object Version Number | ||
TIMEZONE_ID | NUMBER | Timezone identifier | ||
ADDRESS_LINES_PHONETIC | VARCHAR2 | (560) | Address Lines Phonetic | |
ADDRESS_STYLE | VARCHAR2 | (30) | Address Style | |
SITE_NUMBER | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PARTY_TYPE
, LOCATION_ID
, PARTY_SITE_ID
, STATUS
, SITE_NAME
, ADDRESSEE
, LANGUAGE
, ADDRESS
, FULL_ADDRESS
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, STREET
, HOUSE_NUMBER
, APARTMENT_NUMBER
, BUILDING
, POSITION
, CITY
, STATE
, PROVINCE
, POSTAL_CODE
, PO_BOX_NUMBER
, COUNTY
, COUNTRY
, PRIMARY_FLAG
, OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ADDRESS_KEY
, APARTMENT_FLAG
, STREET_SUFFIX
, SECONDARY_SUFFIX_ELEMENT
, RURAL_ROUTE_TYPE
, RURAL_ROUTE_NUMBER
, STREET_NUMBER
, FLOOR
, SUITE
, ROOM
, POSTAL_PLUS4_CODE
, TIME_ZONE
, POST_OFFICE
, DELIVERY_POINT_CODE
, LOCATION_DIRECTIONS
, ADDRESS_ERROR_CODE
, CLLI_CODE
, DODAAC
, TRAILING_DIRECTORY_CODE
, LIFE_CYCLE_STATUS
, SHORT_DESCRIPTION
, DESCRIPTION
, SALES_TAX_GEOCODE
, SALES_TAX_INSIDE_CITY_LIMITS
, SITE_OBJECT_VERSION_NUMBER
, TIMEZONE_ID
, ADDRESS_LINES_PHONETIC
, ADDRESS_STYLE
, SITE_NUMBER
FROM APPS.CSC_HZ_PARTY_SITES_V;
APPS.CSC_HZ_PARTY_SITES_V is not referenced by any database object
|
|
|