[Home] [Help]
View: IGWFV_GRNT_PRPSL_APRVL_LST_MBR
Product: | IGW - Grants Proposal (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PR.PROPOSAL_NUMBER
, PMS.USER_NAME
, PMS.WF_ROLE_NAME
, PMS.WF_DISPLAY_ROLE_NAME
, PMS.APPROVER_TYPE
, PMS.APPROVAL_STATUS
, PMS.SUBMISSION_DATE
, PMS.APPROVAL_DATE
, PMS.COMMENTS
, PR.PROPOSAL_ID
, MAP.RUN_ID
, PMS.PROP_MAP_ID
, PMS.STOP_ID
, PMS.LAST_UPDATE_DATE
, PMS.LAST_UPDATED_BY
, PMS.CREATION_DATE
, PMS.CREATED_BY
FROM IGW_PROP_MAP_STOPS PMS
, IGW_PROP_MAPS MAP
, IGW_PROPOSALS_ALL PR
WHERE PMS.PROP_MAP_ID = MAP.PROP_MAP_ID
AND MAP.PROPOSAL_ID = PR.PROPOSAL_ID WITH READ ONLY
Columns
Name |
PROPOSAL_NUMBER |
USER_NAME |
WF_ROLE_NAME |
WF_DISPLAY_ROLE_NAME |
APPROVER_TYPE |
APPROVAL_STATUS |
SUBMISSION_DATE |
APPROVAL_DATE |
COMMENTS |
PROPOSAL_ID |
RUN_ID |
PROP_MAP_ID |
APPROVAL_STOP_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |