View: PA_ADV_RULE_OBJECTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_ADV_RULE_OBJECTS_V

View Text

SELECT ASGN.ASSIGNMENT_ID
, ASGN.ASSIGNMENT_TYPE
, ASGN.ASSIGNMENT_NAME
, ASGN.PROJECT_ID
, PROJ.SEGMENT1
FROM PA_PROJECT_ASSIGNMENTS ASGN
, PA_PROJECTS_ALL PROJ
, PA_PROJECT_STATUSES PS
WHERE ASGN.ASSIGNMENT_TYPE='OPEN_ASSIGNMENT'
AND ASGN.PROJECT_ID = PROJ.PROJECT_ID
AND ASGN.STATUS_CODE = PS.PROJECT_STATUS_CODE (+)
AND (PS.PROJECT_SYSTEM_STATUS_CODE = 'OPEN_ASGMT' OR PS.PROJECT_SYSTEM_STATUS_CODE IS NULL)
AND PROJ.PROJECT_STATUS_CODE <> 'CLOSED'

Columns