VIEW: APPS.BEN_CSS_RLTD_PER_PER_IN_LER_X

Source

View Text - Preformatted

SELECT CSR.CSS_RLTD_PER_PER_IN_LER_ID , CSR.EFFECTIVE_START_DATE , CSR.EFFECTIVE_END_DATE , CSR.ORDR_TO_PRCS_NUM , CSR.LER_ID , CSR.RSLTG_LER_ID , CSR.BUSINESS_GROUP_ID , CSR.CSR_ATTRIBUTE_CATEGORY , CSR.CSR_ATTRIBUTE1 , CSR.CSR_ATTRIBUTE2 , CSR.CSR_ATTRIBUTE3 , CSR.CSR_ATTRIBUTE4 , CSR.CSR_ATTRIBUTE5 , CSR.CSR_ATTRIBUTE6 , CSR.CSR_ATTRIBUTE7 , CSR.CSR_ATTRIBUTE8 , CSR.CSR_ATTRIBUTE9 , CSR.CSR_ATTRIBUTE10 , CSR.CSR_ATTRIBUTE11 , CSR.CSR_ATTRIBUTE12 , CSR.CSR_ATTRIBUTE13 , CSR.CSR_ATTRIBUTE14 , CSR.CSR_ATTRIBUTE15 , CSR.CSR_ATTRIBUTE16 , CSR.CSR_ATTRIBUTE17 , CSR.CSR_ATTRIBUTE18 , CSR.CSR_ATTRIBUTE19 , CSR.CSR_ATTRIBUTE20 , CSR.CSR_ATTRIBUTE21 , CSR.CSR_ATTRIBUTE22 , CSR.CSR_ATTRIBUTE23 , CSR.CSR_ATTRIBUTE24 , CSR.CSR_ATTRIBUTE25 , CSR.CSR_ATTRIBUTE26 , CSR.CSR_ATTRIBUTE27 , CSR.CSR_ATTRIBUTE28 , CSR.CSR_ATTRIBUTE29 , CSR.CSR_ATTRIBUTE30 , CSR.LAST_UPDATE_DATE , CSR.LAST_UPDATED_BY , CSR.LAST_UPDATE_LOGIN , CSR.CREATED_BY , CSR.CREATION_DATE , CSR.OBJECT_VERSION_NUMBER FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR WHERE TRUNC(SYSDATE) BETWEEN CSR.EFFECTIVE_START_DATE AND CSR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT CSR.CSS_RLTD_PER_PER_IN_LER_ID
, CSR.EFFECTIVE_START_DATE
, CSR.EFFECTIVE_END_DATE
, CSR.ORDR_TO_PRCS_NUM
, CSR.LER_ID
, CSR.RSLTG_LER_ID
, CSR.BUSINESS_GROUP_ID
, CSR.CSR_ATTRIBUTE_CATEGORY
, CSR.CSR_ATTRIBUTE1
, CSR.CSR_ATTRIBUTE2
, CSR.CSR_ATTRIBUTE3
, CSR.CSR_ATTRIBUTE4
, CSR.CSR_ATTRIBUTE5
, CSR.CSR_ATTRIBUTE6
, CSR.CSR_ATTRIBUTE7
, CSR.CSR_ATTRIBUTE8
, CSR.CSR_ATTRIBUTE9
, CSR.CSR_ATTRIBUTE10
, CSR.CSR_ATTRIBUTE11
, CSR.CSR_ATTRIBUTE12
, CSR.CSR_ATTRIBUTE13
, CSR.CSR_ATTRIBUTE14
, CSR.CSR_ATTRIBUTE15
, CSR.CSR_ATTRIBUTE16
, CSR.CSR_ATTRIBUTE17
, CSR.CSR_ATTRIBUTE18
, CSR.CSR_ATTRIBUTE19
, CSR.CSR_ATTRIBUTE20
, CSR.CSR_ATTRIBUTE21
, CSR.CSR_ATTRIBUTE22
, CSR.CSR_ATTRIBUTE23
, CSR.CSR_ATTRIBUTE24
, CSR.CSR_ATTRIBUTE25
, CSR.CSR_ATTRIBUTE26
, CSR.CSR_ATTRIBUTE27
, CSR.CSR_ATTRIBUTE28
, CSR.CSR_ATTRIBUTE29
, CSR.CSR_ATTRIBUTE30
, CSR.LAST_UPDATE_DATE
, CSR.LAST_UPDATED_BY
, CSR.LAST_UPDATE_LOGIN
, CSR.CREATED_BY
, CSR.CREATION_DATE
, CSR.OBJECT_VERSION_NUMBER
FROM BEN_CSS_RLTD_PER_PER_IN_LER_F CSR
WHERE TRUNC(SYSDATE) BETWEEN CSR.EFFECTIVE_START_DATE
AND CSR.EFFECTIVE_END_DATE