VIEW: APPS.AMS_IBA_EMPLOYEE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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