[Home] [Help]
View: IGS_PE_ACT_SITE_V
Product: | IGS - Student System |
Description: | Exchange Visitor Site of Activity |
Implementation/DBA Data: |
APPS.IGS_PE_ACT_SITE_V
|
View Text
SELECT T.ROWID ROW_ID
, T.PERSON_ID
, T.ACTIVITY_SITE_CD
, S.DESCRIPTION ACTIVITY_SITE_DESC
, T.LOCATION_ID
, L.ADDRESS1
, L.ADDRESS2
, L.CITY
, L.POSTAL_CODE
, L.STATE
, L.PROVINCE
, T.START_DATE
, T.END_DATE
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
, T.REMARKS
, T.PRIMARY_FLAG
FROM IGS_PE_ACT_SITE T
, IGS_AD_LOCATION_ALL S
, HZ_LOCATIONS L
WHERE T.ACTIVITY_SITE_CD = S. LOCATION_CD
AND T.LOCATION_ID = L.LOCATION_ID
Columns
Name |
ROW_ID |
PERSON_ID |
ACTIVITY_SITE_CD |
ACTIVITY_SITE_DESC |
LOCATION_ID |
ADDRESS1 |
ADDRESS2 |
CITY |
POSTAL_CODE |
STATE |
PROVINCE |
START_DATE |
END_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
REMARKS |
PRIMARY_FLAG |