VIEW: APPS.IEX_EXT_AGNCY_VL

Source

View Text - Preformatted

SELECT ieab.rowid row_id, ieab.external_agency_id ,ieab.external_agency_name ,ieab.vendor_id ,ieab.vendor_site_id ,ieab.rank ,ieab.effective_start_date ,ieab.effective_end_date ,ieat.description ,ieab.created_by ,ieab.creation_date ,ieab.last_updated_by ,ieab.last_update_date ,ieab.last_update_login ,ieat.sfwt_flag ,ieab.object_version_number ,ieab.org_id FROM iex_ext_agncy_tl ieat ,iex_ext_agncy_b ieab WHERE ieab.external_agency_id = ieat.external_agency_id AND ieat.language = userenv ('LANG')

View Text - HTML Formatted

SELECT IEAB.ROWID ROW_ID
, IEAB.EXTERNAL_AGENCY_ID
, IEAB.EXTERNAL_AGENCY_NAME
, IEAB.VENDOR_ID
, IEAB.VENDOR_SITE_ID
, IEAB.RANK
, IEAB.EFFECTIVE_START_DATE
, IEAB.EFFECTIVE_END_DATE
, IEAT.DESCRIPTION
, IEAB.CREATED_BY
, IEAB.CREATION_DATE
, IEAB.LAST_UPDATED_BY
, IEAB.LAST_UPDATE_DATE
, IEAB.LAST_UPDATE_LOGIN
, IEAT.SFWT_FLAG
, IEAB.OBJECT_VERSION_NUMBER
, IEAB.ORG_ID
FROM IEX_EXT_AGNCY_TL IEAT
, IEX_EXT_AGNCY_B IEAB
WHERE IEAB.EXTERNAL_AGENCY_ID = IEAT.EXTERNAL_AGENCY_ID
AND IEAT.LANGUAGE = USERENV ('LANG')