VIEW: APPS.IGS_AD_ADV_PLACEMENT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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