VIEW: APPS.CSC_ALL_HZ_PARTIES_INFO_V

Source

View Text - Preformatted

SELECT PARTY.ROWID,PARTY.PARTY_ID , PARTY.PARTY_NUMBER , PARTY.PARTY_NAME , PARTY.PARTY_TYPE , PARTY.OBJECT_VERSION_NUMBER , PARTY.ATTRIBUTE_CATEGORY , PARTY.ATTRIBUTE1 , PARTY.ATTRIBUTE2 , PARTY.ATTRIBUTE3 , PARTY.ATTRIBUTE4 , PARTY.ATTRIBUTE5 , PARTY.ATTRIBUTE6 , PARTY.ATTRIBUTE7 , PARTY.ATTRIBUTE8 , PARTY.ATTRIBUTE9 , PARTY.ATTRIBUTE10 , PARTY.ATTRIBUTE11 , PARTY.ATTRIBUTE12 , PARTY.ATTRIBUTE13 , PARTY.ATTRIBUTE14 , PARTY.ATTRIBUTE15 , PARTY.ATTRIBUTE16 , PARTY.ATTRIBUTE17 , PARTY.ATTRIBUTE18 , PARTY.ATTRIBUTE19 , PARTY.ATTRIBUTE20 , PARTY.ATTRIBUTE21 , PARTY.ATTRIBUTE22 , PARTY.ATTRIBUTE23 , PARTY.ATTRIBUTE24 , PARTY.JGZZ_FISCAL_CODE,PARTY.PERSON_PRE_NAME_ADJUNCT , PARTY.PERSON_FIRST_NAME , PARTY.PERSON_MIDDLE_NAME , PARTY.PERSON_LAST_NAME , PARTY.PERSON_NAME_SUFFIX , PARTY.PERSON_TITLE , LOC.COUNTRY , LOC.ADDRESS1||' '|| LOC.ADDRESS2||' '|| LOC.ADDRESS3||' '|| LOC.ADDRESS4 ADDRESS , LOC.ADDRESS1 , LOC.ADDRESS2 , LOC.ADDRESS3 , LOC.ADDRESS4 , LOC.CITY , LOC.POSTAL_CODE , LOC.STATE , LOC.PROVINCE,PARTY.STATUS, LOC.COUNTY , PARTY.URL , PARTY.EMAIL_ADDRESS , PARTY.ORGANIZATION_NAME_PHONETIC , PARTY.PERSON_FIRST_NAME_PHONETIC , PARTY.PERSON_LAST_NAME_PHONETIC , TERI.TERRITORY_SHORT_NAME ,loc.location_id, SITES.STATUS SITE_STATUS, SITES.ADDRESSEE ADDRESSEE , SITES.PARTY_SITE_NAME PARTY_SITE_NAME , SITES.PARTY_SITE_NUMBER PARTY_SITE_NUMBER, SITES.PARTY_SITE_ID 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 HZ_PARTIES PARTY, FND_TERRITORIES_TL TERI, HZ_LOCATIONS LOC,HZ_PARTY_SITES SITES WHERE LOC.COUNTRY = TERI.TERRITORY_CODE(+) AND TERI.LANGUAGE(+) = USERENV( 'LANG' ) AND LOC.LOCATION_ID=SITES.LOCATION_ID AND SITES.PARTY_ID=PARTY.PARTY_ID AND PARTY.STATUS NOT IN ('M', 'D') AND LOC.ADDRESS_EXPIRATION_DATE IS NULL AND NVL(SITES.CREATED_BY_MODULE,'XXX') <> 'SR_ONETIME'

View Text - HTML Formatted

SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_NAME
, PARTY.PARTY_TYPE
, PARTY.OBJECT_VERSION_NUMBER
, PARTY.ATTRIBUTE_CATEGORY
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
, PARTY.ATTRIBUTE21
, PARTY.ATTRIBUTE22
, PARTY.ATTRIBUTE23
, PARTY.ATTRIBUTE24
, PARTY.JGZZ_FISCAL_CODE
, PARTY.PERSON_PRE_NAME_ADJUNCT
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_NAME_SUFFIX
, PARTY.PERSON_TITLE
, LOC.COUNTRY
, LOC.ADDRESS1||' '|| LOC.ADDRESS2||' '|| LOC.ADDRESS3||' '|| LOC.ADDRESS4 ADDRESS
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, LOC.PROVINCE
, PARTY.STATUS
, LOC.COUNTY
, PARTY.URL
, PARTY.EMAIL_ADDRESS
, PARTY.ORGANIZATION_NAME_PHONETIC
, PARTY.PERSON_FIRST_NAME_PHONETIC
, PARTY.PERSON_LAST_NAME_PHONETIC
, TERI.TERRITORY_SHORT_NAME
, LOC.LOCATION_ID
, SITES.STATUS SITE_STATUS
, SITES.ADDRESSEE ADDRESSEE
, SITES.PARTY_SITE_NAME PARTY_SITE_NAME
, SITES.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, SITES.PARTY_SITE_ID 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 HZ_PARTIES PARTY
, FND_TERRITORIES_TL TERI
, HZ_LOCATIONS LOC
, HZ_PARTY_SITES SITES
WHERE LOC.COUNTRY = TERI.TERRITORY_CODE(+)
AND TERI.LANGUAGE(+) = USERENV( 'LANG' )
AND LOC.LOCATION_ID=SITES.LOCATION_ID
AND SITES.PARTY_ID=PARTY.PARTY_ID
AND PARTY.STATUS NOT IN ('M'
, 'D')
AND LOC.ADDRESS_EXPIRATION_DATE IS NULL
AND NVL(SITES.CREATED_BY_MODULE
, 'XXX') <> 'SR_ONETIME'