Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_COMPETENCES_V |
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