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