VIEW: APPS.PA_PROJECT_ROLE_TYPES_BASE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'