VIEW: APPS.AMS_IBA_EMPLOYEE_ORG_V

Source

View Text - Preformatted

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_RELATIONSHIPS R WHERE O.PARTY_TYPE = 'ORGANIZATION' AND O.PARTY_ID = R.OBJECT_ID AND R.RELATIONSHIP_CODE = 'EMPLOYEE_OF'

View Text - HTML Formatted

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_RELATIONSHIPS R
WHERE O.PARTY_TYPE = 'ORGANIZATION'
AND O.PARTY_ID = R.OBJECT_ID
AND R.RELATIONSHIP_CODE = 'EMPLOYEE_OF'