View: IGWFV_GRNT_PRPSL_APRVL_LST_MBR

Product:	IGW - Grants Proposal
Description:
Implementation/DBA Data:	APPS.IGWFV_GRNT_PRPSL_APRVL_LST_MBR

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