VIEW: APPS.BEN_ORG_UNIT_PRDCT

Source

View Text - Preformatted

SELECT 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 WHERE OUP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND OUP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT 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
WHERE OUP.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND OUP.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))