[Home] [Help]
View: IGS_AD_ADV_PLACEMENT_V
| Product: | IGS - Student System (Obsolete) |
| Description: | |
| Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT AP.ROWID ROW_ID
, AP.TEST_EXEMPTION_ID TEST_EXEMPTION_ID
, AP.PERSON_ID PERSON_ID
, AP.EXEMPTION_ID EXEMPTION_ID
, CC.NAME NAME
, CC.DESCRIPTION DESCRIPTION
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_AD_CODE_CLASSES CC
, IGS_AD_ADV_PLACEMENT AP
WHERE CC.CODE_ID = AP.EXEMPTION_ID
Columns
| Name |
| ROW_ID |
| TEST_EXEMPTION_ID |
| PERSON_ID |
| EXEMPTION_ID |
| NAME |
| DESCRIPTION |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |