VIEW: APPS.BEN_ELIG_ORG_UNIT_PRTE_D

Source

View Text - Preformatted

SELECT eou.elig_org_unit_prte_id, eou.effective_start_date, eou.effective_end_date, org.NAME, hl1.meaning, eou.ordr_num, eou.criteria_weight, eou.criteria_score, eou.last_update_date, fuser.user_name FROM ben_elig_org_unit_prte_f eou, hr_lookups hl1, hr_organization_units_v org, fnd_user fuser WHERE hl1.lookup_code(+) = eou.excld_flag AND hl1.lookup_type(+) = 'YES_NO' AND org.organization_id = eou.organization_id AND org.business_group_id + 0 = eou.business_group_id AND fuser.user_id(+) = eou.last_updated_by

View Text - HTML Formatted

SELECT EOU.ELIG_ORG_UNIT_PRTE_ID
, EOU.EFFECTIVE_START_DATE
, EOU.EFFECTIVE_END_DATE
, ORG.NAME
, HL1.MEANING
, EOU.ORDR_NUM
, EOU.CRITERIA_WEIGHT
, EOU.CRITERIA_SCORE
, EOU.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ELIG_ORG_UNIT_PRTE_F EOU
, HR_LOOKUPS HL1
, HR_ORGANIZATION_UNITS_V ORG
, FND_USER FUSER
WHERE HL1.LOOKUP_CODE(+) = EOU.EXCLD_FLAG
AND HL1.LOOKUP_TYPE(+) = 'YES_NO'
AND ORG.ORGANIZATION_ID = EOU.ORGANIZATION_ID
AND ORG.BUSINESS_GROUP_ID + 0 = EOU.BUSINESS_GROUP_ID
AND FUSER.USER_ID(+) = EOU.LAST_UPDATED_BY