[Home] [Help]
View: IGW_PROP_COMMENTS_V
View Text
SELECT PPC.ROWID ROW_ID
, PPC.PROPOSAL_ID
, PA.PROPOSAL_NUMBER
, PA.PROPOSAL_TITLE
, PPC.COMMENT_ID
, PPC.COMMENTS
, PPX.FULL_NAME
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
, PPC.LAST_UPDATE_LOGIN
, FNU.USER_NAME
FROM IGW_PROP_COMMENTS PPC
, IGW_PROPOSALS_ALL PA
, FND_USER FNU
, PER_PEOPLE_X PPX
WHERE PPC.PROPOSAL_ID = PA.PROPOSAL_ID
AND FNU.USER_ID = PPC.LAST_UPDATED_BY
AND PPX.PERSON_ID(+) = FNU.EMPLOYEE_ID
Columns
| Name |
| ROW_ID |
| PROPOSAL_ID |
| PROPOSAL_NUMBER |
| PROPOSAL_TITLE |
| COMMENT_ID |
| COMMENTS |
| FULL_NAME |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| USER_NAME |
APPS.IGW_PROP_COMMENTS_V