eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CSC_ALL_HZ_PARTIES_INFO_V

Object Details

Object Name:	CSC_ALL_HZ_PARTIES_INFO_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID column
PARTY_ID	NUMBER	(15)	Yes	Party identifier
PARTY_NUMBER	VARCHAR2	(30)	Yes	Unique identification number for this party
PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
PARTY_TYPE	VARCHAR2	(30)	Yes	The party type can only be Person, Organization, Group or Relationship.
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure definition
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE16	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE17	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE18	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE19	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE20	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE21	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE22	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE23	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE24	VARCHAR2	(150)		Descriptive Flexfield segment
JGZZ_FISCAL_CODE	VARCHAR2	(20)		Taxpayer identification number. Used in Europe to identify customers. Also known as the fiscal code or NIF.
PERSON_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Salutary introduction, such as Mr. or Herr
PERSON_FIRST_NAME	VARCHAR2	(150)		First name of the person
PERSON_MIDDLE_NAME	VARCHAR2	(60)		Middle name of the person
PERSON_LAST_NAME	VARCHAR2	(150)		Last or surname of the person
PERSON_NAME_SUFFIX	VARCHAR2	(30)		Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
PERSON_TITLE	VARCHAR2	(60)		A professional or family title. For example, Don or The Right Honorable.
COUNTRY	VARCHAR2	(60)	Yes	The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
ADDRESS	VARCHAR2	(963)		Identifying address
ADDRESS1	VARCHAR2	(240)	Yes	First line of the Identifying address
ADDRESS2	VARCHAR2	(240)		Second line of the Identifying address
ADDRESS3	VARCHAR2	(240)		Third line of the Identifying address
ADDRESS4	VARCHAR2	(240)		Fourth line of the Identifying address
CITY	VARCHAR2	(60)		City of the Identifying address
POSTAL_CODE	VARCHAR2	(60)		Postal Code of the Identifying address
STATE	VARCHAR2	(60)		State of the Identifying address
PROVINCE	VARCHAR2	(60)		Province of the Identifying address
STATUS	VARCHAR2	(1)	Yes	Party status flag.
COUNTY	VARCHAR2	(60)		County of the Identifying address
URL	VARCHAR2	(2000)		Uniform resource locator
EMAIL_ADDRESS	VARCHAR2	(2000)		E-mail address
ORGANIZATION_NAME_PHONETIC	VARCHAR2	(320)		Japanese Kana, or phonetic representation of organization name
PERSON_FIRST_NAME_PHONETIC	VARCHAR2	(60)		Phonetic representation of the person's first name
PERSON_LAST_NAME_PHONETIC	VARCHAR2	(60)		Phonetic representation of the person's last name
TERRITORY_SHORT_NAME	VARCHAR2	(80)		The short name that stands for the territory
LOCATION_ID	NUMBER	(15)	Yes	Location id from hz_locations
SITE_STATUS	VARCHAR2	(1)	Yes
ADDRESSEE	VARCHAR2	(360)
PARTY_SITE_NAME	VARCHAR2	(240)
PARTY_SITE_NUMBER	VARCHAR2	(30)	Yes
PARTY_SITE_ID	NUMBER	(15)	Yes
LOC_ATTRIBUTE1	VARCHAR2	(150)
LOC_ATTRIBUTE2	VARCHAR2	(150)
LOC_ATTRIBUTE3	VARCHAR2	(150)
LOC_ATTRIBUTE4	VARCHAR2	(150)
LOC_ATTRIBUTE5	VARCHAR2	(150)
LOC_ATTRIBUTE6	VARCHAR2	(150)
LOC_ATTRIBUTE7	VARCHAR2	(150)
LOC_ATTRIBUTE8	VARCHAR2	(150)
LOC_ATTRIBUTE9	VARCHAR2	(150)
LOC_ATTRIBUTE10	VARCHAR2	(150)
LOC_ATTRIBUTE11	VARCHAR2	(150)
LOC_ATTRIBUTE12	VARCHAR2	(150)
LOC_ATTRIBUTE13	VARCHAR2	(150)
LOC_ATTRIBUTE14	VARCHAR2	(150)
LOC_ATTRIBUTE15	VARCHAR2	(150)
LOC_ATTRIBUTE16	VARCHAR2	(150)
LOC_ATTRIBUTE17	VARCHAR2	(150)
LOC_ATTRIBUTE18	VARCHAR2	(150)
LOC_ATTRIBUTE19	VARCHAR2	(150)
LOC_ATTRIBUTE20	VARCHAR2	(150)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      PARTY_ID
,      PARTY_NUMBER
,      PARTY_NAME
,      PARTY_TYPE
,      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
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      JGZZ_FISCAL_CODE
,      PERSON_PRE_NAME_ADJUNCT
,      PERSON_FIRST_NAME
,      PERSON_MIDDLE_NAME
,      PERSON_LAST_NAME
,      PERSON_NAME_SUFFIX
,      PERSON_TITLE
,      COUNTRY
,      ADDRESS
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      STATUS
,      COUNTY
,      URL
,      EMAIL_ADDRESS
,      ORGANIZATION_NAME_PHONETIC
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_LAST_NAME_PHONETIC
,      TERRITORY_SHORT_NAME
,      LOCATION_ID
,      SITE_STATUS
,      ADDRESSEE
,      PARTY_SITE_NAME
,      PARTY_SITE_NUMBER
,      PARTY_SITE_ID
,      LOC_ATTRIBUTE1
,      LOC_ATTRIBUTE2
,      LOC_ATTRIBUTE3
,      LOC_ATTRIBUTE4
,      LOC_ATTRIBUTE5
,      LOC_ATTRIBUTE6
,      LOC_ATTRIBUTE7
,      LOC_ATTRIBUTE8
,      LOC_ATTRIBUTE9
,      LOC_ATTRIBUTE10
,      LOC_ATTRIBUTE11
,      LOC_ATTRIBUTE12
,      LOC_ATTRIBUTE13
,      LOC_ATTRIBUTE14
,      LOC_ATTRIBUTE15
,      LOC_ATTRIBUTE16
,      LOC_ATTRIBUTE17
,      LOC_ATTRIBUTE18
,      LOC_ATTRIBUTE19
,      LOC_ATTRIBUTE20
FROM APPS.CSC_ALL_HZ_PARTIES_INFO_V;

Dependencies

[top of page]

APPS.CSC_ALL_HZ_PARTIES_INFO_V references the following:

APPS: FND_TERRITORIES_TL; HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES

APPS.CSC_ALL_HZ_PARTIES_INFO_V is not referenced by any database object