VIEW: APPS.CSC_HZ_PARTIES_INFO_V

Source

View Text - Preformatted

SELECT PARTY.ROWID, PARTY_ID , PARTY_NUMBER , PARTY_NAME , PARTY_TYPE , PARTY.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 , ADDRESS1||' '||ADDRESS2||' '||ADDRESS3||' '||ADDRESS4 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 , TERI.TERRITORY_SHORT_NAME FROM HZ_PARTIES PARTY, FND_TERRITORIES_TL TERI WHERE PARTY.COUNTRY = TERI.TERRITORY_CODE(+) AND PARTY.STATUS NOT IN ('M', 'D') AND TERI.LANGUAGE(+) = USERENV( 'LANG' )

View Text - HTML Formatted

SELECT PARTY.ROWID
, PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
, PARTY_TYPE
, PARTY.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
, ADDRESS1||' '||ADDRESS2||' '||ADDRESS3||' '||ADDRESS4 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
, TERI.TERRITORY_SHORT_NAME
FROM HZ_PARTIES PARTY
, FND_TERRITORIES_TL TERI
WHERE PARTY.COUNTRY = TERI.TERRITORY_CODE(+)
AND PARTY.STATUS NOT IN ('M'
, 'D')
AND TERI.LANGUAGE(+) = USERENV( 'LANG' )