View - FND_ID_SEGMENT_NAME_AP_V

 SELECT A.SEGMENT_NAME SEGMENT_NAME

, COUNT(*) SEGMENT_NUM
FROM FND_ID_FLEX_SEGMENTS A
, FND_ID_FLEX_SEGMENTS B
WHERE A.ENABLED_FLAG = 'Y'
AND B.ENABLED_FLAG = A.ENABLED_FLAG

View - OIE_ATTENDEES

 SELECT ATTENDEE_LINE_ID

, REPORT_LINE_ID
, EMPLOYEE_FLAG
, EMPLOYEE_ID
, ATTENDEE_TYPE
, NAME
, TITLE
, EMPLOYER
, EMPLOYER_ADDRESS
, TAX_ID
, ORG_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY

View Definition - PA_PROJECT_TASKS_AP_V

 SELECT PAP.SEGMENT1 PROJECT

, PAP.NAME DESCRIPTION
, PAP.PROJECT_ID PROJECT_ID
, COUNT ( DISTINCT PAT.TASK_ID ) TASKS_PER_PROJ
FROM PA_PROJECTS PAP
, PA_TASKS_EXPEND_V PAT
WHERE PAP.PROJECT_ID = PAT.PROJECT_ID ( + ) GROUP BY PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME