VIEW: APPS.HZ_WSRVC_PARTY_GROUPS_V

Source

View Text - Preformatted

SELECT PTY.APPLICATION_ID, PTY.ATTRIBUTE1, PTY.ATTRIBUTE10, PTY.ATTRIBUTE11, PTY.ATTRIBUTE12, PTY.ATTRIBUTE13, PTY.ATTRIBUTE14, PTY.ATTRIBUTE15, PTY.ATTRIBUTE16, PTY.ATTRIBUTE17, PTY.ATTRIBUTE18, PTY.ATTRIBUTE19, PTY.ATTRIBUTE2, PTY.ATTRIBUTE20, PTY.ATTRIBUTE3, PTY.ATTRIBUTE4, PTY.ATTRIBUTE5, PTY.ATTRIBUTE6, PTY.ATTRIBUTE7, PTY.ATTRIBUTE8, PTY.ATTRIBUTE9, PTY.ATTRIBUTE_CATEGORY, PTY.CATEGORY_CODE, PTY.CREATED_BY_MODULE, PTY.GROUP_TYPE, PTY.ORIG_SYSTEM_REFERENCE, MOSR.ORIG_SYSTEM, PTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER, PTY.PARTY_ID, PTY.PARTY_NAME GROUP_NAME, PTY.PARTY_NUMBER, PTY.SALUTATION, PTY.STATUS, PTY.VALIDATED_FLAG, PTY.LAST_UPDATED_BY, PTY.CREATION_DATE, PTY.LAST_UPDATE_LOGIN, PTY.CREATED_BY, PTY.LAST_UPDATE_DATE FROM HZ_PARTIES PTY, HZ_ORIG_SYS_REFERENCES MOSR WHERE PTY.PARTY_TYPE = 'GROUP' AND MOSR.OWNER_TABLE_NAME (+) ='HZ_PARTIES' AND MOSR.OWNER_TABLE_ID (+) = PTY.PARTY_ID

View Text - HTML Formatted

SELECT PTY.APPLICATION_ID
, PTY.ATTRIBUTE1
, PTY.ATTRIBUTE10
, PTY.ATTRIBUTE11
, PTY.ATTRIBUTE12
, PTY.ATTRIBUTE13
, PTY.ATTRIBUTE14
, PTY.ATTRIBUTE15
, PTY.ATTRIBUTE16
, PTY.ATTRIBUTE17
, PTY.ATTRIBUTE18
, PTY.ATTRIBUTE19
, PTY.ATTRIBUTE2
, PTY.ATTRIBUTE20
, PTY.ATTRIBUTE3
, PTY.ATTRIBUTE4
, PTY.ATTRIBUTE5
, PTY.ATTRIBUTE6
, PTY.ATTRIBUTE7
, PTY.ATTRIBUTE8
, PTY.ATTRIBUTE9
, PTY.ATTRIBUTE_CATEGORY
, PTY.CATEGORY_CODE
, PTY.CREATED_BY_MODULE
, PTY.GROUP_TYPE
, PTY.ORIG_SYSTEM_REFERENCE
, MOSR.ORIG_SYSTEM
, PTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER
, PTY.PARTY_ID
, PTY.PARTY_NAME GROUP_NAME
, PTY.PARTY_NUMBER
, PTY.SALUTATION
, PTY.STATUS
, PTY.VALIDATED_FLAG
, PTY.LAST_UPDATED_BY
, PTY.CREATION_DATE
, PTY.LAST_UPDATE_LOGIN
, PTY.CREATED_BY
, PTY.LAST_UPDATE_DATE
FROM HZ_PARTIES PTY
, HZ_ORIG_SYS_REFERENCES MOSR
WHERE PTY.PARTY_TYPE = 'GROUP'
AND MOSR.OWNER_TABLE_NAME (+) ='HZ_PARTIES'
AND MOSR.OWNER_TABLE_ID (+) = PTY.PARTY_ID