VIEW: APPS.BEN_BNFTS_BAL_V

Source

View Text - Preformatted

SELECT BNB.ROWID ROW_ID , BNB.BNFTS_BAL_ID , BNB.EFFECTIVE_START_DATE , BNB.EFFECTIVE_END_DATE , BNB.NAME , BNB.BNFTS_BAL_USG_CD , BNB.BNFTS_BAL_DESC , BNB.UOM , BNB.NNMNTRY_UOM , BNB.BUSINESS_GROUP_ID , BNB.BNB_ATTRIBUTE_CATEGORY , BNB.BNB_ATTRIBUTE1 , BNB.BNB_ATTRIBUTE2 , BNB.BNB_ATTRIBUTE3 , BNB.BNB_ATTRIBUTE4 , BNB.BNB_ATTRIBUTE5 , BNB.BNB_ATTRIBUTE6 , BNB.BNB_ATTRIBUTE7 , BNB.BNB_ATTRIBUTE8 , BNB.BNB_ATTRIBUTE9 , BNB.BNB_ATTRIBUTE10 , BNB.BNB_ATTRIBUTE11 , BNB.BNB_ATTRIBUTE12 , BNB.BNB_ATTRIBUTE13 , BNB.BNB_ATTRIBUTE14 , BNB.BNB_ATTRIBUTE15 , BNB.BNB_ATTRIBUTE16 , BNB.BNB_ATTRIBUTE17 , BNB.BNB_ATTRIBUTE18 , BNB.BNB_ATTRIBUTE19 , BNB.BNB_ATTRIBUTE20 , BNB.BNB_ATTRIBUTE21 , BNB.BNB_ATTRIBUTE22 , BNB.BNB_ATTRIBUTE23 , BNB.BNB_ATTRIBUTE24 , BNB.BNB_ATTRIBUTE25 , BNB.BNB_ATTRIBUTE26 , BNB.BNB_ATTRIBUTE27 , BNB.BNB_ATTRIBUTE28 , BNB.BNB_ATTRIBUTE29 , BNB.BNB_ATTRIBUTE30 , BNB.LAST_UPDATE_DATE , BNB.LAST_UPDATED_BY , BNB.LAST_UPDATE_LOGIN , BNB.CREATED_BY , BNB.CREATION_DATE , BNB.OBJECT_VERSION_NUMBER FROM BEN_BNFTS_BAL_F BNB, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN BNB.EFFECTIVE_START_DATE AND BNB.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT BNB.ROWID ROW_ID
, BNB.BNFTS_BAL_ID
, BNB.EFFECTIVE_START_DATE
, BNB.EFFECTIVE_END_DATE
, BNB.NAME
, BNB.BNFTS_BAL_USG_CD
, BNB.BNFTS_BAL_DESC
, BNB.UOM
, BNB.NNMNTRY_UOM
, BNB.BUSINESS_GROUP_ID
, BNB.BNB_ATTRIBUTE_CATEGORY
, BNB.BNB_ATTRIBUTE1
, BNB.BNB_ATTRIBUTE2
, BNB.BNB_ATTRIBUTE3
, BNB.BNB_ATTRIBUTE4
, BNB.BNB_ATTRIBUTE5
, BNB.BNB_ATTRIBUTE6
, BNB.BNB_ATTRIBUTE7
, BNB.BNB_ATTRIBUTE8
, BNB.BNB_ATTRIBUTE9
, BNB.BNB_ATTRIBUTE10
, BNB.BNB_ATTRIBUTE11
, BNB.BNB_ATTRIBUTE12
, BNB.BNB_ATTRIBUTE13
, BNB.BNB_ATTRIBUTE14
, BNB.BNB_ATTRIBUTE15
, BNB.BNB_ATTRIBUTE16
, BNB.BNB_ATTRIBUTE17
, BNB.BNB_ATTRIBUTE18
, BNB.BNB_ATTRIBUTE19
, BNB.BNB_ATTRIBUTE20
, BNB.BNB_ATTRIBUTE21
, BNB.BNB_ATTRIBUTE22
, BNB.BNB_ATTRIBUTE23
, BNB.BNB_ATTRIBUTE24
, BNB.BNB_ATTRIBUTE25
, BNB.BNB_ATTRIBUTE26
, BNB.BNB_ATTRIBUTE27
, BNB.BNB_ATTRIBUTE28
, BNB.BNB_ATTRIBUTE29
, BNB.BNB_ATTRIBUTE30
, BNB.LAST_UPDATE_DATE
, BNB.LAST_UPDATED_BY
, BNB.LAST_UPDATE_LOGIN
, BNB.CREATED_BY
, BNB.CREATION_DATE
, BNB.OBJECT_VERSION_NUMBER
FROM BEN_BNFTS_BAL_F BNB
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN BNB.EFFECTIVE_START_DATE
AND BNB.EFFECTIVE_END_DATE