View: AMS_IBA_EMPLOYEE_ORG_V

Product:	AMS - Marketing
Description:	This view selects organization details of employees. It is used to create segments for business tobusiness users in iMarketing.
Implementation/DBA Data:	APPS.AMS_IBA_EMPLOYEE_ORG_V

View Text

SELECT O.PARTY_ID
, O.PARTY_NUMBER
, O.PARTY_NAME
, O.PARTY_TYPE
, O.VALIDATED_FLAG
, O.LAST_UPDATED_BY
, O.CREATION_DATE
, O.LAST_UPDATE_LOGIN
, O.REQUEST_ID
, O.PROGRAM_APPLICATION_ID
, O.CREATED_BY
, O.LAST_UPDATE_DATE
, O.PROGRAM_ID
, O.PROGRAM_UPDATE_DATE
, O.WH_UPDATE_DATE
, O.ATTRIBUTE_CATEGORY
, O.ATTRIBUTE1
, O.ATTRIBUTE2
, O.ATTRIBUTE3
, O.ATTRIBUTE4
, O.ATTRIBUTE5
, O.ATTRIBUTE6
, O.ATTRIBUTE7
, O.ATTRIBUTE8
, O.ATTRIBUTE9
, O.ATTRIBUTE10
, O.ATTRIBUTE11
, O.ATTRIBUTE12
, O.ATTRIBUTE13
, O.ATTRIBUTE14
, O.ATTRIBUTE15
, O.ATTRIBUTE16
, O.ATTRIBUTE17
, O.ATTRIBUTE18
, O.ATTRIBUTE19
, O.ATTRIBUTE20
, O.ATTRIBUTE21
, O.ATTRIBUTE22
, O.ATTRIBUTE23
, O.ATTRIBUTE24
, O.GLOBAL_ATTRIBUTE_CATEGORY
, O.GLOBAL_ATTRIBUTE1
, O.GLOBAL_ATTRIBUTE2
, O.GLOBAL_ATTRIBUTE3
, O.GLOBAL_ATTRIBUTE4
, O.GLOBAL_ATTRIBUTE5
, O.GLOBAL_ATTRIBUTE6
, O.GLOBAL_ATTRIBUTE7
, O.GLOBAL_ATTRIBUTE8
, O.GLOBAL_ATTRIBUTE9
, O.GLOBAL_ATTRIBUTE10
, O.GLOBAL_ATTRIBUTE11
, O.GLOBAL_ATTRIBUTE12
, O.GLOBAL_ATTRIBUTE13
, O.GLOBAL_ATTRIBUTE14
, O.GLOBAL_ATTRIBUTE15
, O.GLOBAL_ATTRIBUTE16
, O.GLOBAL_ATTRIBUTE17
, O.GLOBAL_ATTRIBUTE18
, O.GLOBAL_ATTRIBUTE19
, O.GLOBAL_ATTRIBUTE20
, O.ORIG_SYSTEM_REFERENCE
, O.SIC_CODE
, O.HQ_BRANCH_IND
, O.CUSTOMER_KEY
, O.TAX_REFERENCE
, O.JGZZ_FISCAL_CODE
, O.DUNS_NUMBER
, O.TAX_NAME
, O.PERSON_PRE_NAME_ADJUNCT
, O.PERSON_FIRST_NAME
, O.PERSON_MIDDLE_NAME
, O.PERSON_LAST_NAME
, O.PERSON_NAME_SUFFIX
, O.PERSON_TITLE
, O.PERSON_ACADEMIC_TITLE
, O.PERSON_PREVIOUS_LAST_NAME
, O.KNOWN_AS
, O.PERSON_IDEN_TYPE
, O.PERSON_IDENTIFIER
, O.GROUP_TYPE
, O.COUNTRY
, O.ADDRESS1
, O.ADDRESS2
, O.ADDRESS3
, O.ADDRESS4
, O.CITY
, O.POSTAL_CODE
, O.STATE
, O.PROVINCE
, O.STATUS
, O.COUNTY
, O.SIC_CODE_TYPE
FROM HZ_PARTIES O
, HZ_PARTY_RELATIONSHIPS R
WHERE O.PARTY_TYPE = 'ORGANIZATION'
AND O.PARTY_ID = R.OBJECT_ID
AND R.PARTY_RELATIONSHIP_TYPE = 'EMPLOYEE_OF'

Columns