[Home] [Help]
View: IGSFV_ORG_UNIT_LOCATIONS
Product: | IGS - Student System (Obsolete) |
Description: | This entity contains the locations associated with the organizational unit |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT UL.ORG_UNIT_CD ORG_UNIT_CODE
, UL.START_DT START_DATE
, UL.LOCATION_CD ORG_UNIT_LOCATION
, LOC.DESCRIPTION ORG_UNIT_LOCATION_DESC
, HP.PARTY_NAME ORG_UNIT_NAME
, UL.CREATED_BY
, UL.CREATION_DATE
, UL.LAST_UPDATED_BY
, UL.LAST_UPDATE_DATE
FROM IGS_OR_UNIT_LOC UL
, IGS_AD_LOCATION_ALL LOC
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE UL.LOCATION_CD = LOC.LOCATION_CD
AND UL.ORG_UNIT_CD = IHP.OSS_ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID WITH READ ONLY
Columns
Name |
ORG_UNIT_CODE |
START_DATE |
ORG_UNIT_LOCATION |
ORG_UNIT_LOCATION_DESC |
ORG_UNIT_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |