eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HZ_WSRVC_PARTY_GROUPS_V

Product:	AR - Receivables
Description:	Internal view for Groups
Implementation/DBA Data:	APPS.HZ_WSRVC_PARTY_GROUPS_V

View Text

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

Columns

Name
APPLICATION_ID
ATTRIBUTE1
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE2
ATTRIBUTE20
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE_CATEGORY
CATEGORY_CODE
CREATED_BY_MODULE
GROUP_TYPE
ORIG_SYSTEM_REFERENCE
ORIG_SYSTEM
PARTY_OBJECT_VERSION_NUMBER
PARTY_ID
GROUP_NAME
PARTY_NUMBER
SALUTATION
STATUS
VALIDATED_FLAG
LAST_UPDATED_BY
CREATION_DATE
LAST_UPDATE_LOGIN
CREATED_BY
LAST_UPDATE_DATE