Product: | OKS - Service Contracts |
---|---|
Description: | PM Activities View |
Implementation/DBA Data: | APPS.OKS_PM_ACTIVITIES_V |
SELECT PMA.ROWID ROW_ID
, PMA.ID ID
, PMA.CLE_ID CLE_ID
, PMA.DNZ_CHR_ID DNZ_CHR_ID
, PMA.ACTIVITY_ID ACTIVITY_ID
, PMA.SELECT_YN SELECT_YN
, PMA.CONF_REQ_YN CONF_REQ_YN
, PMA.SCH_EXISTS_YN SCH_EXISTS_YN
, PMA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PMA.PROGRAM_ID PROGRAM_ID
, PMA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PMA.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PMA.SECURITY_GROUP_ID SECURITY_GROUP_ID
, PMA.REQUEST_ID REQUEST_ID
, PMA.CREATED_BY CREATED_BY
, PMA.CREATION_DATE CREATION_DATE
, PMA.LAST_UPDATED_BY LAST_UPDATED_BY
, PMA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PMA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKS_PM_ACTIVITIES PMA