Product: | PA - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PA_PROJECT_ROLE_TYPES_BASE_V |
SELECT ROLE.ROW_ID
, ROLE.PROJECT_ROLE_ID
, ROLE.PROJECT_ROLE_TYPE
, ROLE.MEANING
, ROLE.QUERY_LABOR_COST_FLAG
, ROLE.START_DATE_ACTIVE
, ROLE.RECORD_VERSION_NUMBER
, ROLE.LAST_UPDATE_DATE
, ROLE.LAST_UPDATED_BY
, ROLE.CREATION_DATE
, ROLE.CREATED_BY
, ROLE.LAST_UPDATE_LOGIN
, ROLE.END_DATE_ACTIVE
, ROLE.DESCRIPTION
, ROLE.DEFAULT_MIN_JOB_LEVEL
, ROLE.DEFAULT_MAX_JOB_LEVEL
, ROLE.MENU_ID
, ROLE.DEFAULT_JOB_ID
, ROLE.FREEZE_RULES_FLAG
, ROLE.ATTRIBUTE_CATEGORY
, ROLE.ATTRIBUTE1
, ROLE.ATTRIBUTE2
, ROLE.ATTRIBUTE3
, ROLE.ATTRIBUTE4
, ROLE.ATTRIBUTE5
, ROLE.ATTRIBUTE6
, ROLE.ATTRIBUTE7
, ROLE.ATTRIBUTE8
, ROLE.ATTRIBUTE9
, ROLE.ATTRIBUTE10
, ROLE.ATTRIBUTE11
, ROLE.ATTRIBUTE12
, ROLE.ATTRIBUTE13
, ROLE.ATTRIBUTE14
, ROLE.ATTRIBUTE15
FROM PA_PROJECT_ROLE_TYPES_VL ROLE
WHERE TRUNC(SYSDATE) BETWEEN TRUNC(ROLE.START_DATE_ACTIVE)
AND TRUNC(NVL(ROLE.END_DATE_ACTIVE
, SYSDATE))
AND ROLE.ROLE_PARTY_CLASS='PERSON'