VIEW: APPS.IEX_EXT_AGNCY_UV

Source

View Text - Preformatted

SELECT IEAB.ROWID ROW_ID ,IEAB.EXTERNAL_AGENCY_ID ,IEAB.EXTERNAL_AGENCY_NAME ,UPPER(IEAB.EXTERNAL_AGENCY_NAME) UEXTERNAL_AGENCY_NAME ,IEAB.VENDOR_ID ,IEAB.VENDOR_SITE_ID ,IEAB.RANK ,DECODE(IEAB.EFFECTIVE_END_DATE,NULL,'ACTIVE',DECODE(SIGN(MONTHS_BETWEEN(IEAB.EFFECTIVE_END_DATE,SYSDATE)),1,'ACTIVE','INACTIVE')) STATUS ,OVEN.NAME VENDOR_NAME ,OVES.NAME VENDOR_SITE ,OVES.DESCRIPTION SITE_ADDRESS ,IEAB.EFFECTIVE_START_DATE ,IEAB.EFFECTIVE_END_DATE ,IEAT.DESCRIPTION ,IEAT.LANGUAGE ,IEAT.SOURCE_LANG ,IEAT.SFWT_FLAG ,IEAB.OBJECT_VERSION_NUMBER ,IEAB.ORG_ID ,IEAB.ATTRIBUTE_CATEGORY ,IEAB.ATTRIBUTE1 ,IEAB.ATTRIBUTE2 ,IEAB.ATTRIBUTE3 ,IEAB.ATTRIBUTE4 ,IEAB.ATTRIBUTE5 ,IEAB.ATTRIBUTE6 ,IEAB.ATTRIBUTE7 ,IEAB.ATTRIBUTE8 ,IEAB.ATTRIBUTE9 ,IEAB.ATTRIBUTE10 ,IEAB.ATTRIBUTE11 ,IEAB.ATTRIBUTE12 ,IEAB.ATTRIBUTE13 ,IEAB.ATTRIBUTE14 ,IEAB.ATTRIBUTE15 ,IEAB.CREATED_BY ,IEAB.CREATION_DATE ,IEAB.LAST_UPDATED_BY ,IEAB.LAST_UPDATE_DATE ,IEAB.LAST_UPDATE_LOGIN FROM OKX_VENDOR_SITES_V OVES,OKX_VENDORS_V OVEN,IEX_EXT_AGNCY_B IEAB,IEX_EXT_AGNCY_TL IEAT WHERE IEAB.EXTERNAL_AGENCY_ID =IEAT.EXTERNAL_AGENCY_ID AND IEAT.LANGUAGE = USERENV('LANG') AND OVEN.ID1 = IEAB.VENDOR_ID AND OVES.id1 = IEAB. VENDOR_SITE_ID

View Text - HTML Formatted

SELECT IEAB.ROWID ROW_ID
, IEAB.EXTERNAL_AGENCY_ID
, IEAB.EXTERNAL_AGENCY_NAME
, UPPER(IEAB.EXTERNAL_AGENCY_NAME) UEXTERNAL_AGENCY_NAME
, IEAB.VENDOR_ID
, IEAB.VENDOR_SITE_ID
, IEAB.RANK
, DECODE(IEAB.EFFECTIVE_END_DATE
, NULL
, 'ACTIVE'
, DECODE(SIGN(MONTHS_BETWEEN(IEAB.EFFECTIVE_END_DATE
, SYSDATE))
, 1
, 'ACTIVE'
, 'INACTIVE')) STATUS
, OVEN.NAME VENDOR_NAME
, OVES.NAME VENDOR_SITE
, OVES.DESCRIPTION SITE_ADDRESS
, IEAB.EFFECTIVE_START_DATE
, IEAB.EFFECTIVE_END_DATE
, IEAT.DESCRIPTION
, IEAT.LANGUAGE
, IEAT.SOURCE_LANG
, IEAT.SFWT_FLAG
, IEAB.OBJECT_VERSION_NUMBER
, IEAB.ORG_ID
, IEAB.ATTRIBUTE_CATEGORY
, IEAB.ATTRIBUTE1
, IEAB.ATTRIBUTE2
, IEAB.ATTRIBUTE3
, IEAB.ATTRIBUTE4
, IEAB.ATTRIBUTE5
, IEAB.ATTRIBUTE6
, IEAB.ATTRIBUTE7
, IEAB.ATTRIBUTE8
, IEAB.ATTRIBUTE9
, IEAB.ATTRIBUTE10
, IEAB.ATTRIBUTE11
, IEAB.ATTRIBUTE12
, IEAB.ATTRIBUTE13
, IEAB.ATTRIBUTE14
, IEAB.ATTRIBUTE15
, IEAB.CREATED_BY
, IEAB.CREATION_DATE
, IEAB.LAST_UPDATED_BY
, IEAB.LAST_UPDATE_DATE
, IEAB.LAST_UPDATE_LOGIN
FROM OKX_VENDOR_SITES_V OVES
, OKX_VENDORS_V OVEN
, IEX_EXT_AGNCY_B IEAB
, IEX_EXT_AGNCY_TL IEAT
WHERE IEAB.EXTERNAL_AGENCY_ID =IEAT.EXTERNAL_AGENCY_ID
AND IEAT.LANGUAGE = USERENV('LANG')
AND OVEN.ID1 = IEAB.VENDOR_ID
AND OVES.ID1 = IEAB. VENDOR_SITE_ID