VIEW: APPS.PA_REP_ALL_COMP_V

Source

View Text - Preformatted

SELECT comp.competence_id, comp.competence_alias, comp.name, comp.description, comp.business_group_id, bg.name FROM per_competences comp, per_business_groups bg WHERE comp.business_group_id = bg.business_group_id (+)

View Text - HTML Formatted

SELECT COMP.COMPETENCE_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP.DESCRIPTION
, COMP.BUSINESS_GROUP_ID
, BG.NAME
FROM PER_COMPETENCES COMP
, PER_BUSINESS_GROUPS BG
WHERE COMP.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID (+)