VIEW: APPS.BEN_PCT_FL_TM_RT_V

Source

View Text - Preformatted

SELECT PFR.ROWID ROW_ID , PFR.PCT_FL_TM_RT_ID , PFR.EFFECTIVE_START_DATE , PFR.EFFECTIVE_END_DATE , PFR.BUSINESS_GROUP_ID , PFR.VRBL_RT_PRFL_ID , PFR.PCT_FL_TM_FCTR_ID , PFR.EXCLD_FLAG , PFR.ORDR_NUM , PFR.PFR_ATTRIBUTE_CATEGORY , PFR.PFR_ATTRIBUTE1 , PFR.PFR_ATTRIBUTE2 , PFR.PFR_ATTRIBUTE3 , PFR.PFR_ATTRIBUTE4 , PFR.PFR_ATTRIBUTE5 , PFR.PFR_ATTRIBUTE6 , PFR.PFR_ATTRIBUTE7 , PFR.PFR_ATTRIBUTE8 , PFR.PFR_ATTRIBUTE9 , PFR.PFR_ATTRIBUTE10 , PFR.PFR_ATTRIBUTE11 , PFR.PFR_ATTRIBUTE12 , PFR.PFR_ATTRIBUTE13 , PFR.PFR_ATTRIBUTE14 , PFR.PFR_ATTRIBUTE15 , PFR.PFR_ATTRIBUTE16 , PFR.PFR_ATTRIBUTE17 , PFR.PFR_ATTRIBUTE18 , PFR.PFR_ATTRIBUTE19 , PFR.PFR_ATTRIBUTE20 , PFR.PFR_ATTRIBUTE21 , PFR.PFR_ATTRIBUTE22 , PFR.PFR_ATTRIBUTE23 , PFR.PFR_ATTRIBUTE24 , PFR.PFR_ATTRIBUTE25 , PFR.PFR_ATTRIBUTE26 , PFR.PFR_ATTRIBUTE27 , PFR.PFR_ATTRIBUTE28 , PFR.PFR_ATTRIBUTE29 , PFR.PFR_ATTRIBUTE30 , PFR.LAST_UPDATE_DATE , PFR.LAST_UPDATED_BY , PFR.LAST_UPDATE_LOGIN , PFR.CREATED_BY , PFR.CREATION_DATE , PFR.OBJECT_VERSION_NUMBER FROM BEN_PCT_FL_TM_RT_F PFR, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN PFR.EFFECTIVE_START_DATE AND PFR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PFR.ROWID ROW_ID
, PFR.PCT_FL_TM_RT_ID
, PFR.EFFECTIVE_START_DATE
, PFR.EFFECTIVE_END_DATE
, PFR.BUSINESS_GROUP_ID
, PFR.VRBL_RT_PRFL_ID
, PFR.PCT_FL_TM_FCTR_ID
, PFR.EXCLD_FLAG
, PFR.ORDR_NUM
, PFR.PFR_ATTRIBUTE_CATEGORY
, PFR.PFR_ATTRIBUTE1
, PFR.PFR_ATTRIBUTE2
, PFR.PFR_ATTRIBUTE3
, PFR.PFR_ATTRIBUTE4
, PFR.PFR_ATTRIBUTE5
, PFR.PFR_ATTRIBUTE6
, PFR.PFR_ATTRIBUTE7
, PFR.PFR_ATTRIBUTE8
, PFR.PFR_ATTRIBUTE9
, PFR.PFR_ATTRIBUTE10
, PFR.PFR_ATTRIBUTE11
, PFR.PFR_ATTRIBUTE12
, PFR.PFR_ATTRIBUTE13
, PFR.PFR_ATTRIBUTE14
, PFR.PFR_ATTRIBUTE15
, PFR.PFR_ATTRIBUTE16
, PFR.PFR_ATTRIBUTE17
, PFR.PFR_ATTRIBUTE18
, PFR.PFR_ATTRIBUTE19
, PFR.PFR_ATTRIBUTE20
, PFR.PFR_ATTRIBUTE21
, PFR.PFR_ATTRIBUTE22
, PFR.PFR_ATTRIBUTE23
, PFR.PFR_ATTRIBUTE24
, PFR.PFR_ATTRIBUTE25
, PFR.PFR_ATTRIBUTE26
, PFR.PFR_ATTRIBUTE27
, PFR.PFR_ATTRIBUTE28
, PFR.PFR_ATTRIBUTE29
, PFR.PFR_ATTRIBUTE30
, PFR.LAST_UPDATE_DATE
, PFR.LAST_UPDATED_BY
, PFR.LAST_UPDATE_LOGIN
, PFR.CREATED_BY
, PFR.CREATION_DATE
, PFR.OBJECT_VERSION_NUMBER
FROM BEN_PCT_FL_TM_RT_F PFR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PFR.EFFECTIVE_START_DATE
AND PFR.EFFECTIVE_END_DATE