[Home] [Help]
View: IPA_INTEREST_SUSPENSION_V
View Text
SELECT IIS.ROWID ROW_ID
, IIS.PROJECT_ID PROJECT_ID
, IIS.LAST_ACTIVITY_DATE LAST_ACTIVITY_DATE
, IIS.SUSPEN_START_DATE SUSPEN_START_DATE
, IIS.SUSPEN_END_DATE SUSPEN_END_DATE
, IIS.COMMENTS COMMENTS
, IIS.CREATION_DATE CREATION_DATE
, IIS.CREATED_BY CREATED_BY
, IIS.LAST_UPDATED_BY LAST_UPDATED_BY
, IIS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IIS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PAP.SEGMENT1 PROJECT_NUMBER
, PAP.NAME NAME
FROM PA_PROJECTS_ALL PAP
, IPA_INTEREST_SUSPENSION IIS
WHERE IIS.PROJECT_ID = PAP.PROJECT_ID
Columns
Name |
ROW_ID |
PROJECT_ID |
LAST_ACTIVITY_DATE |
SUSPEN_START_DATE |
SUSPEN_END_DATE |
COMMENTS |
CREATION_DATE |
CREATED_BY |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
PROJECT_NUMBER |
NAME |