VIEW: APPS.BEN_LER_CHG_PL_NIP_RL_V

Source

View Text - Preformatted

SELECT LNR.ROWID ROW_ID , LNR.LER_CHG_PL_NIP_RL_ID , LNR.EFFECTIVE_START_DATE , LNR.EFFECTIVE_END_DATE , LNR.BUSINESS_GROUP_ID , LNR.FORMULA_ID , LNR.ORDR_TO_APLY_NUM , LNR.LER_CHG_PL_NIP_ENRT_ID , LNR.LNR_ATTRIBUTE_CATEGORY , LNR.LNR_ATTRIBUTE1 , LNR.LNR_ATTRIBUTE2 , LNR.LNR_ATTRIBUTE3 , LNR.LNR_ATTRIBUTE4 , LNR.LNR_ATTRIBUTE5 , LNR.LNR_ATTRIBUTE6 , LNR.LNR_ATTRIBUTE7 , LNR.LNR_ATTRIBUTE8 , LNR.LNR_ATTRIBUTE9 , LNR.LNR_ATTRIBUTE10 , LNR.LNR_ATTRIBUTE11 , LNR.LNR_ATTRIBUTE12 , LNR.LNR_ATTRIBUTE13 , LNR.LNR_ATTRIBUTE14 , LNR.LNR_ATTRIBUTE15 , LNR.LNR_ATTRIBUTE16 , LNR.LNR_ATTRIBUTE17 , LNR.LNR_ATTRIBUTE18 , LNR.LNR_ATTRIBUTE19 , LNR.LNR_ATTRIBUTE20 , LNR.LNR_ATTRIBUTE21 , LNR.LNR_ATTRIBUTE22 , LNR.LNR_ATTRIBUTE23 , LNR.LNR_ATTRIBUTE24 , LNR.LNR_ATTRIBUTE25 , LNR.LNR_ATTRIBUTE26 , LNR.LNR_ATTRIBUTE27 , LNR.LNR_ATTRIBUTE28 , LNR.LNR_ATTRIBUTE29 , LNR.LNR_ATTRIBUTE30 , LNR.LAST_UPDATE_DATE , LNR.LAST_UPDATED_BY , LNR.LAST_UPDATE_LOGIN , LNR.CREATED_BY , LNR.CREATION_DATE , LNR.OBJECT_VERSION_NUMBER FROM BEN_LER_CHG_PL_NIP_RL_F LNR, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN LNR.EFFECTIVE_START_DATE AND LNR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT LNR.ROWID ROW_ID
, LNR.LER_CHG_PL_NIP_RL_ID
, LNR.EFFECTIVE_START_DATE
, LNR.EFFECTIVE_END_DATE
, LNR.BUSINESS_GROUP_ID
, LNR.FORMULA_ID
, LNR.ORDR_TO_APLY_NUM
, LNR.LER_CHG_PL_NIP_ENRT_ID
, LNR.LNR_ATTRIBUTE_CATEGORY
, LNR.LNR_ATTRIBUTE1
, LNR.LNR_ATTRIBUTE2
, LNR.LNR_ATTRIBUTE3
, LNR.LNR_ATTRIBUTE4
, LNR.LNR_ATTRIBUTE5
, LNR.LNR_ATTRIBUTE6
, LNR.LNR_ATTRIBUTE7
, LNR.LNR_ATTRIBUTE8
, LNR.LNR_ATTRIBUTE9
, LNR.LNR_ATTRIBUTE10
, LNR.LNR_ATTRIBUTE11
, LNR.LNR_ATTRIBUTE12
, LNR.LNR_ATTRIBUTE13
, LNR.LNR_ATTRIBUTE14
, LNR.LNR_ATTRIBUTE15
, LNR.LNR_ATTRIBUTE16
, LNR.LNR_ATTRIBUTE17
, LNR.LNR_ATTRIBUTE18
, LNR.LNR_ATTRIBUTE19
, LNR.LNR_ATTRIBUTE20
, LNR.LNR_ATTRIBUTE21
, LNR.LNR_ATTRIBUTE22
, LNR.LNR_ATTRIBUTE23
, LNR.LNR_ATTRIBUTE24
, LNR.LNR_ATTRIBUTE25
, LNR.LNR_ATTRIBUTE26
, LNR.LNR_ATTRIBUTE27
, LNR.LNR_ATTRIBUTE28
, LNR.LNR_ATTRIBUTE29
, LNR.LNR_ATTRIBUTE30
, LNR.LAST_UPDATE_DATE
, LNR.LAST_UPDATED_BY
, LNR.LAST_UPDATE_LOGIN
, LNR.CREATED_BY
, LNR.CREATION_DATE
, LNR.OBJECT_VERSION_NUMBER
FROM BEN_LER_CHG_PL_NIP_RL_F LNR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LNR.EFFECTIVE_START_DATE
AND LNR.EFFECTIVE_END_DATE