View: IGWFV_GRNT_PRPSL_ROUTG_LST_MBR

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

View Text

SELECT ALLMAPS.DESCRIPTION
, HR.NAME
, MPDTS.USER_NAME
, MPDTS.APPROVER_TYPE
, MPDTS.MAP_ID
, MPDTS.STOP_ID
, MPDTS.LAST_UPDATE_DATE
, MPDTS.LAST_UPDATED_BY
, MPDTS.CREATION_DATE
, MPDTS.CREATED_BY
FROM IGW_ORG_MAP_DETAILS MPDTS
, IGW_ORG_MAPS_ALL ALLMAPS
, HR_ALL_ORGANIZATION_UNITS HR
WHERE MPDTS.MAP_ID = ALLMAPS.MAP_ID
AND SYSDATE BETWEEN HR.DATE_FROM
AND NVL(HR.DATE_TO
, SYSDATE)
AND HR.ORGANIZATION_ID = ALLMAPS.ORGANIZATION_ID WITH READ ONLY

Columns