VIEW: APPS.BEN_COM_ELIG_V

Source

View Text - Preformatted

SELECT eo.elig_obj_id ,eoe.elig_prfl_id eligy_prfl_id ,eoe.elig_obj_elig_prfl_id ,eoe.mndtry_flag ,to_number (eo.column_value) cm_typ_id ,eoe.effective_start_date ,eoe.effective_end_date ,eoe.business_group_id ,eoe.bep_attribute_category ,eoe.bep_attribute1 ,eoe.bep_attribute2 ,eoe.bep_attribute3 ,eoe.bep_attribute4 ,eoe.bep_attribute5 ,eoe.bep_attribute6 ,eoe.bep_attribute7 ,eoe.bep_attribute8 ,eoe.bep_attribute9 ,eoe.bep_attribute10 ,eoe.bep_attribute11 ,eoe.bep_attribute12 ,eoe.bep_attribute13 ,eoe.bep_attribute14 ,eoe.bep_attribute15 ,eoe.bep_attribute16 ,eoe.bep_attribute17 ,eoe.bep_attribute18 ,eoe.bep_attribute19 ,eoe.bep_attribute20 ,eoe.object_version_number ,eoe.created_by ,eoe.creation_date ,eoe.last_update_login ,eoe.last_updated_by ,eoe.last_update_date FROM ben_elig_obj_f eo ,ben_elig_obj_elig_profl_f eoe ,fnd_sessions se WHERE eo.table_name = 'BEN_CM_TYP_F' AND eo.column_name = 'CM_TYP_ID' AND eo.elig_obj_id = eoe.elig_obj_id AND se.effective_date BETWEEN eoe.effective_start_date AND eoe.effective_end_date AND se.effective_date BETWEEN eo.effective_start_date AND eo.effective_end_date AND se.session_id = userenv ('sessionid')

View Text - HTML Formatted

SELECT EO.ELIG_OBJ_ID
, EOE.ELIG_PRFL_ID ELIGY_PRFL_ID
, EOE.ELIG_OBJ_ELIG_PRFL_ID
, EOE.MNDTRY_FLAG
, TO_NUMBER (EO.COLUMN_VALUE) CM_TYP_ID
, EOE.EFFECTIVE_START_DATE
, EOE.EFFECTIVE_END_DATE
, EOE.BUSINESS_GROUP_ID
, EOE.BEP_ATTRIBUTE_CATEGORY
, EOE.BEP_ATTRIBUTE1
, EOE.BEP_ATTRIBUTE2
, EOE.BEP_ATTRIBUTE3
, EOE.BEP_ATTRIBUTE4
, EOE.BEP_ATTRIBUTE5
, EOE.BEP_ATTRIBUTE6
, EOE.BEP_ATTRIBUTE7
, EOE.BEP_ATTRIBUTE8
, EOE.BEP_ATTRIBUTE9
, EOE.BEP_ATTRIBUTE10
, EOE.BEP_ATTRIBUTE11
, EOE.BEP_ATTRIBUTE12
, EOE.BEP_ATTRIBUTE13
, EOE.BEP_ATTRIBUTE14
, EOE.BEP_ATTRIBUTE15
, EOE.BEP_ATTRIBUTE16
, EOE.BEP_ATTRIBUTE17
, EOE.BEP_ATTRIBUTE18
, EOE.BEP_ATTRIBUTE19
, EOE.BEP_ATTRIBUTE20
, EOE.OBJECT_VERSION_NUMBER
, EOE.CREATED_BY
, EOE.CREATION_DATE
, EOE.LAST_UPDATE_LOGIN
, EOE.LAST_UPDATED_BY
, EOE.LAST_UPDATE_DATE
FROM BEN_ELIG_OBJ_F EO
, BEN_ELIG_OBJ_ELIG_PROFL_F EOE
, FND_SESSIONS SE
WHERE EO.TABLE_NAME = 'BEN_CM_TYP_F'
AND EO.COLUMN_NAME = 'CM_TYP_ID'
AND EO.ELIG_OBJ_ID = EOE.ELIG_OBJ_ID
AND SE.EFFECTIVE_DATE BETWEEN EOE.EFFECTIVE_START_DATE
AND EOE.EFFECTIVE_END_DATE
AND SE.EFFECTIVE_DATE BETWEEN EO.EFFECTIVE_START_DATE
AND EO.EFFECTIVE_END_DATE
AND SE.SESSION_ID = USERENV ('SESSIONID')