View: IGS_PE_PARTYSITEUSE_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PE_PARTYSITEUSE_V

View Text

SELECT PSU.ROWID ROW_ID
, PSU.PARTY_SITE_USE_ID
, PSU.PARTY_SITE_ID
, PSU.SITE_USE_TYPE
, LK.MEANING /*LOCATION*/
, 0
, 0
, NVL(PSU.STATUS
, 'I') /* ACTIVE*/
, PSU.CREATED_BY CREATED_BY
, PSU.CREATION_DATE CREATION_DATE
, PSU.LAST_UPDATED_BY LAST_UPDATED_BY
, PSU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PS.ATTRIBUTE_CATEGORY
, PS.ATTRIBUTE1
, PS.ATTRIBUTE2
, PS.ATTRIBUTE3
, PS.ATTRIBUTE4
, PS.ATTRIBUTE5
, PS.ATTRIBUTE6
, PS.ATTRIBUTE7
, PS.ATTRIBUTE8
, PS.ATTRIBUTE9
, PS.ATTRIBUTE10
, PS.ATTRIBUTE11
, PS.ATTRIBUTE12
, PS.ATTRIBUTE13
, PS.ATTRIBUTE14
, PS.ATTRIBUTE15
, PS.ATTRIBUTE16
, PS.ATTRIBUTE17
, PS.ATTRIBUTE18
, PS.ATTRIBUTE19
, PS.ATTRIBUTE20
, PSU.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM HZ_PARTY_SITE_USES PSU
, HZ_PARTY_SITES PS
, FND_LOOKUP_VALUES LK
WHERE PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID
AND PSU.SITE_USE_TYPE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'PARTY_SITE_USE_CODE'
AND LK.LANGUAGE = USERENV('LANG')
AND LK.VIEW_APPLICATION_ID = 222
AND LK.SECURITY_GROUP_ID = 0
AND NVL(PSU.STATUS
, 'I') IN ('A'
, 'I')

Columns