VIEW: APPS.OKS_PM_ACTIVITIES_HV

Source

View Text - Preformatted

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, PMA.MAJOR_VERSION MAJOR_VERSION FROM OKS_PM_ACTIVITIES_H PMA

View Text - HTML Formatted

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
, PMA.MAJOR_VERSION MAJOR_VERSION
FROM OKS_PM_ACTIVITIES_H PMA