[Home] [Help]
View: PA_REP_ALL_COMP_V
Product: | PA - Projects |
Description: | A view for Yes/No selection |
Implementation/DBA Data: |
APPS.PA_REP_ALL_COMP_V
|
View Text
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 (+)
Columns
Name |
COMPETENCE_ID |
COMPETENCE_ALIAS |
COMPETENCE_NAME |
DESCRIPTION |
BUSINESS_GROUP_ID |
BUSINESS_GROUP_NAME |