VIEW: APPS.IGS_PE_ACT_SITE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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