VIEW: APPS.PA_COMPETENCES_V

Source

View Text - Preformatted

SELECT comp.competence_id, comp.competence_alias, comp.name, comp.description, comp.date_from, comp.date_to, comp_def.segment1, comp_def.Segment2, comp_def.Segment3, comp_def.Segment4, comp_def.Segment5, comp_def.Segment6, comp_def.Segment7, comp_def.Segment8, comp_def.Segment9, comp_def.Segment10, comp_def.Segment11, comp_def.Segment12, comp_def.Segment13, comp_def.Segment14, comp_def.Segment15, comp_def.Segment16, comp_def.Segment17, comp_def.Segment18, comp_def.Segment19, comp_def.Segment20, comp_def.Segment21, comp_def.Segment22, comp_def.Segment23, comp_def.Segment24, comp_def.Segment25, comp_def.Segment26, comp_def.Segment27, comp_def.Segment28, comp_def.Segment29, comp_def.Segment30 FROM per_competences comp, per_competence_definitions comp_def WHERE comp.competence_definition_id = comp_def.competence_definition_id

View Text - HTML Formatted

SELECT COMP.COMPETENCE_ID
, COMP.COMPETENCE_ALIAS
, COMP.NAME
, COMP.DESCRIPTION
, COMP.DATE_FROM
, COMP.DATE_TO
, COMP_DEF.SEGMENT1
, COMP_DEF.SEGMENT2
, COMP_DEF.SEGMENT3
, COMP_DEF.SEGMENT4
, COMP_DEF.SEGMENT5
, COMP_DEF.SEGMENT6
, COMP_DEF.SEGMENT7
, COMP_DEF.SEGMENT8
, COMP_DEF.SEGMENT9
, COMP_DEF.SEGMENT10
, COMP_DEF.SEGMENT11
, COMP_DEF.SEGMENT12
, COMP_DEF.SEGMENT13
, COMP_DEF.SEGMENT14
, COMP_DEF.SEGMENT15
, COMP_DEF.SEGMENT16
, COMP_DEF.SEGMENT17
, COMP_DEF.SEGMENT18
, COMP_DEF.SEGMENT19
, COMP_DEF.SEGMENT20
, COMP_DEF.SEGMENT21
, COMP_DEF.SEGMENT22
, COMP_DEF.SEGMENT23
, COMP_DEF.SEGMENT24
, COMP_DEF.SEGMENT25
, COMP_DEF.SEGMENT26
, COMP_DEF.SEGMENT27
, COMP_DEF.SEGMENT28
, COMP_DEF.SEGMENT29
, COMP_DEF.SEGMENT30
FROM PER_COMPETENCES COMP
, PER_COMPETENCE_DEFINITIONS COMP_DEF
WHERE COMP.COMPETENCE_DEFINITION_ID = COMP_DEF.COMPETENCE_DEFINITION_ID