View: BEN_ORG_UNIT_PRDCT_V

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_ORG_UNIT_PRDCT_V

View Text

SELECT OUP.ROWID ROW_ID
, OUP.ORG_UNIT_PRDCT_ID
, OUP.EFFECTIVE_START_DATE
, OUP.EFFECTIVE_END_DATE
, OUP.NAME
, OUP.ORGANIZATION_ID
, OUP.BUSINESS_GROUP_ID
, OUP.OUP_ATTRIBUTE_CATEGORY
, OUP.OUP_ATTRIBUTE1
, OUP.OUP_ATTRIBUTE2
, OUP.OUP_ATTRIBUTE3
, OUP.OUP_ATTRIBUTE4
, OUP.OUP_ATTRIBUTE5
, OUP.OUP_ATTRIBUTE6
, OUP.OUP_ATTRIBUTE7
, OUP.OUP_ATTRIBUTE8
, OUP.OUP_ATTRIBUTE9
, OUP.OUP_ATTRIBUTE10
, OUP.OUP_ATTRIBUTE11
, OUP.OUP_ATTRIBUTE12
, OUP.OUP_ATTRIBUTE13
, OUP.OUP_ATTRIBUTE14
, OUP.OUP_ATTRIBUTE15
, OUP.OUP_ATTRIBUTE16
, OUP.OUP_ATTRIBUTE17
, OUP.OUP_ATTRIBUTE18
, OUP.OUP_ATTRIBUTE19
, OUP.OUP_ATTRIBUTE20
, OUP.OUP_ATTRIBUTE21
, OUP.OUP_ATTRIBUTE22
, OUP.OUP_ATTRIBUTE23
, OUP.OUP_ATTRIBUTE24
, OUP.OUP_ATTRIBUTE25
, OUP.OUP_ATTRIBUTE26
, OUP.OUP_ATTRIBUTE27
, OUP.OUP_ATTRIBUTE28
, OUP.OUP_ATTRIBUTE29
, OUP.OUP_ATTRIBUTE30
, OUP.LAST_UPDATE_DATE
, OUP.LAST_UPDATED_BY
, OUP.LAST_UPDATE_LOGIN
, OUP.CREATED_BY
, OUP.CREATION_DATE
, OUP.OBJECT_VERSION_NUMBER
FROM BEN_ORG_UNIT_PRDCT_F OUP
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN OUP.EFFECTIVE_START_DATE
AND OUP.EFFECTIVE_END_DATE

Columns