VIEW: APPS.BEN_PTD_LMT_V

Source

View Text - Preformatted

SELECT pdl.ROWID ROW_ID, pdl.PTD_LMT_ID ,pdl.EFFECTIVE_START_DATE ,pdl.EFFECTIVE_END_DATE ,pdl.NAME ,pdl.MX_COMP_TO_CNSDR ,pdl.MX_VAL ,pdl.MX_PCT_VAL ,pdl.PTD_LMT_CALC_RL ,pdl.LMT_DET_CD ,pdl.COMP_LVL_FCTR_ID ,pdl.BALANCE_TYPE_ID ,pdl.BUSINESS_GROUP_ID ,pdl.PDL_ATTRIBUTE_CATEGORY ,pdl.PDL_ATTRIBUTE1 ,pdl.PDL_ATTRIBUTE2 ,pdl.PDL_ATTRIBUTE3 ,pdl.PDL_ATTRIBUTE4 ,pdl.PDL_ATTRIBUTE5 ,pdl.PDL_ATTRIBUTE6 ,pdl.PDL_ATTRIBUTE7 ,pdl.PDL_ATTRIBUTE8 ,pdl.PDL_ATTRIBUTE9 ,pdl.PDL_ATTRIBUTE10 ,pdl.PDL_ATTRIBUTE11 ,pdl.PDL_ATTRIBUTE12 ,pdl.PDL_ATTRIBUTE13 ,pdl.PDL_ATTRIBUTE14 ,pdl.PDL_ATTRIBUTE15 ,pdl.PDL_ATTRIBUTE16 ,pdl.PDL_ATTRIBUTE17 ,pdl.PDL_ATTRIBUTE18 ,pdl.PDL_ATTRIBUTE19 ,pdl.PDL_ATTRIBUTE20 ,pdl.PDL_ATTRIBUTE21 ,pdl.PDL_ATTRIBUTE22 ,pdl.PDL_ATTRIBUTE23 ,pdl.PDL_ATTRIBUTE24 ,pdl.PDL_ATTRIBUTE25 ,pdl.PDL_ATTRIBUTE26 ,pdl.PDL_ATTRIBUTE27 ,pdl.PDL_ATTRIBUTE28 ,pdl.PDL_ATTRIBUTE29 ,pdl.PDL_ATTRIBUTE30 ,pdl.LAST_UPDATE_DATE ,pdl.LAST_UPDATED_BY ,pdl.LAST_UPDATE_LOGIN ,pdl.CREATED_BY ,pdl.CREATION_DATE ,pdl.OBJECT_VERSION_NUMBER from BEN_PTD_LMT_F pdl, fnd_sessions se WHERE se.session_id = userenv('sessionid') and se.effective_date between pdl.effective_start_date and pdl.effective_end_date

View Text - HTML Formatted

SELECT PDL.ROWID ROW_ID
, PDL.PTD_LMT_ID
, PDL.EFFECTIVE_START_DATE
, PDL.EFFECTIVE_END_DATE
, PDL.NAME
, PDL.MX_COMP_TO_CNSDR
, PDL.MX_VAL
, PDL.MX_PCT_VAL
, PDL.PTD_LMT_CALC_RL
, PDL.LMT_DET_CD
, PDL.COMP_LVL_FCTR_ID
, PDL.BALANCE_TYPE_ID
, PDL.BUSINESS_GROUP_ID
, PDL.PDL_ATTRIBUTE_CATEGORY
, PDL.PDL_ATTRIBUTE1
, PDL.PDL_ATTRIBUTE2
, PDL.PDL_ATTRIBUTE3
, PDL.PDL_ATTRIBUTE4
, PDL.PDL_ATTRIBUTE5
, PDL.PDL_ATTRIBUTE6
, PDL.PDL_ATTRIBUTE7
, PDL.PDL_ATTRIBUTE8
, PDL.PDL_ATTRIBUTE9
, PDL.PDL_ATTRIBUTE10
, PDL.PDL_ATTRIBUTE11
, PDL.PDL_ATTRIBUTE12
, PDL.PDL_ATTRIBUTE13
, PDL.PDL_ATTRIBUTE14
, PDL.PDL_ATTRIBUTE15
, PDL.PDL_ATTRIBUTE16
, PDL.PDL_ATTRIBUTE17
, PDL.PDL_ATTRIBUTE18
, PDL.PDL_ATTRIBUTE19
, PDL.PDL_ATTRIBUTE20
, PDL.PDL_ATTRIBUTE21
, PDL.PDL_ATTRIBUTE22
, PDL.PDL_ATTRIBUTE23
, PDL.PDL_ATTRIBUTE24
, PDL.PDL_ATTRIBUTE25
, PDL.PDL_ATTRIBUTE26
, PDL.PDL_ATTRIBUTE27
, PDL.PDL_ATTRIBUTE28
, PDL.PDL_ATTRIBUTE29
, PDL.PDL_ATTRIBUTE30
, PDL.LAST_UPDATE_DATE
, PDL.LAST_UPDATED_BY
, PDL.LAST_UPDATE_LOGIN
, PDL.CREATED_BY
, PDL.CREATION_DATE
, PDL.OBJECT_VERSION_NUMBER
FROM BEN_PTD_LMT_F PDL
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PDL.EFFECTIVE_START_DATE
AND PDL.EFFECTIVE_END_DATE