[Home] [Help]
View: IGS_PE_LOCVENUE_USE_V
View Text
SELECT PLV.ROWID ROW_ID
, PLV.LOCVENUE_USE_ID
, PLV.LOC_VENUE_ADDR_ID
, PLV.SITE_USE_CODE
, PLV.LOCATION
, PLV.ACTIVE_IND
, LK.MEANING
, PLV.CREATED_BY
, PLV.CREATION_DATE
, PLV.LAST_UPDATED_BY
, PLV.LAST_UPDATE_DATE
, PLV.LAST_UPDATE_LOGIN
FROM IGS_PE_LOCVENUE_USE PLV
, FND_LOOKUP_VALUES LK
WHERE PLV.SITE_USE_CODE = 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
Columns
| Name |
| ROW_ID |
| LOCVENUE_USE_ID |
| LOC_VENUE_ADDR_ID |
| SITE_USE_CODE |
| LOCATION |
| ACTIVE_IND |
| MEANING |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
APPS.IGS_PE_LOCVENUE_USE_V