[Home] [Help]
View: IGWFV_GRANT_PRPSL_ROUTING_LIST
View Text
SELECT ORGMAPS.DESCRIPTION
, HR.NAME
, ORGMAPS.START_DATE_ACTIVE
, ORGMAPS.END_DATE_ACTIVE
, ORGMAPS.MAP_ID
, ORGMAPS.ORGANIZATION_ID
, ORGMAPS.ORG_ID
, ORGMAPS.LAST_UPDATE_DATE
, ORGMAPS.LAST_UPDATED_BY
, ORGMAPS.CREATION_DATE
, ORGMAPS.CREATED_BY
FROM IGW_ORG_MAPS_ALL ORGMAPS
, HR_ALL_ORGANIZATION_UNITS HR
WHERE HR.ORGANIZATION_ID = ORGMAPS.ORGANIZATION_ID WITH READ ONLY
Columns
| Name |
| MAP_DESCRIPTION |
| ORGANIZATION_NAME |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| MAP_ID |
| ORGANIZATION_ID |
| ORG_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
APPS.IGWFV_GRANT_PRPSL_ROUTING_LIST