VIEW: APPS.BEN_PL_BNF_CTFN_V

Source

View Text - Preformatted

SELECT PCX.ROWID ROW_ID , PCX.PL_BNF_CTFN_ID , PCX.EFFECTIVE_START_DATE , PCX.EFFECTIVE_END_DATE , PCX.PL_ID , PCX.BNF_CTFN_TYP_CD , PCX.LACK_CTFN_SSPND_ENRT_FLAG , PCX.PFD_FLAG , PCX.RQD_FLAG , PCX.CTFN_RQD_WHEN_RL , PCX.BNF_TYP_CD , PCX.RLSHP_TYP_CD , PCX.BUSINESS_GROUP_ID , PCX.PCX_ATTRIBUTE_CATEGORY , PCX.PCX_ATTRIBUTE1 , PCX.PCX_ATTRIBUTE2 , PCX.PCX_ATTRIBUTE3 , PCX.PCX_ATTRIBUTE4 , PCX.PCX_ATTRIBUTE5 , PCX.PCX_ATTRIBUTE6 , PCX.PCX_ATTRIBUTE7 , PCX.PCX_ATTRIBUTE8 , PCX.PCX_ATTRIBUTE9 , PCX.PCX_ATTRIBUTE10 , PCX.PCX_ATTRIBUTE11 , PCX.PCX_ATTRIBUTE12 , PCX.PCX_ATTRIBUTE13 , PCX.PCX_ATTRIBUTE14 , PCX.PCX_ATTRIBUTE15 , PCX.PCX_ATTRIBUTE16 , PCX.PCX_ATTRIBUTE17 , PCX.PCX_ATTRIBUTE18 , PCX.PCX_ATTRIBUTE19 , PCX.PCX_ATTRIBUTE20 , PCX.PCX_ATTRIBUTE21 , PCX.PCX_ATTRIBUTE22 , PCX.PCX_ATTRIBUTE23 , PCX.PCX_ATTRIBUTE24 , PCX.PCX_ATTRIBUTE25 , PCX.PCX_ATTRIBUTE26 , PCX.PCX_ATTRIBUTE27 , PCX.PCX_ATTRIBUTE28 , PCX.PCX_ATTRIBUTE29 , PCX.PCX_ATTRIBUTE30 , PCX.LAST_UPDATE_DATE , PCX.LAST_UPDATED_BY , PCX.LAST_UPDATE_LOGIN , PCX.CREATED_BY , PCX.CREATION_DATE , PCX.OBJECT_VERSION_NUMBER FROM BEN_PL_BNF_CTFN_F PCX, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN PCX.EFFECTIVE_START_DATE AND PCX.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT PCX.ROWID ROW_ID
, PCX.PL_BNF_CTFN_ID
, PCX.EFFECTIVE_START_DATE
, PCX.EFFECTIVE_END_DATE
, PCX.PL_ID
, PCX.BNF_CTFN_TYP_CD
, PCX.LACK_CTFN_SSPND_ENRT_FLAG
, PCX.PFD_FLAG
, PCX.RQD_FLAG
, PCX.CTFN_RQD_WHEN_RL
, PCX.BNF_TYP_CD
, PCX.RLSHP_TYP_CD
, PCX.BUSINESS_GROUP_ID
, PCX.PCX_ATTRIBUTE_CATEGORY
, PCX.PCX_ATTRIBUTE1
, PCX.PCX_ATTRIBUTE2
, PCX.PCX_ATTRIBUTE3
, PCX.PCX_ATTRIBUTE4
, PCX.PCX_ATTRIBUTE5
, PCX.PCX_ATTRIBUTE6
, PCX.PCX_ATTRIBUTE7
, PCX.PCX_ATTRIBUTE8
, PCX.PCX_ATTRIBUTE9
, PCX.PCX_ATTRIBUTE10
, PCX.PCX_ATTRIBUTE11
, PCX.PCX_ATTRIBUTE12
, PCX.PCX_ATTRIBUTE13
, PCX.PCX_ATTRIBUTE14
, PCX.PCX_ATTRIBUTE15
, PCX.PCX_ATTRIBUTE16
, PCX.PCX_ATTRIBUTE17
, PCX.PCX_ATTRIBUTE18
, PCX.PCX_ATTRIBUTE19
, PCX.PCX_ATTRIBUTE20
, PCX.PCX_ATTRIBUTE21
, PCX.PCX_ATTRIBUTE22
, PCX.PCX_ATTRIBUTE23
, PCX.PCX_ATTRIBUTE24
, PCX.PCX_ATTRIBUTE25
, PCX.PCX_ATTRIBUTE26
, PCX.PCX_ATTRIBUTE27
, PCX.PCX_ATTRIBUTE28
, PCX.PCX_ATTRIBUTE29
, PCX.PCX_ATTRIBUTE30
, PCX.LAST_UPDATE_DATE
, PCX.LAST_UPDATED_BY
, PCX.LAST_UPDATE_LOGIN
, PCX.CREATED_BY
, PCX.CREATION_DATE
, PCX.OBJECT_VERSION_NUMBER
FROM BEN_PL_BNF_CTFN_F PCX
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PCX.EFFECTIVE_START_DATE
AND PCX.EFFECTIVE_END_DATE