View: HZ_PARTY_SITES_EXT_VL

Product:	AR - Receivables
Description:	Multilingual view of extensible attributes for party sites
Implementation/DBA Data:	APPS.HZ_PARTY_SITES_EXT_VL

View Text

SELECT B.EXTENSION_ID
, B.PARTY_SITE_ID
, B.ATTR_GROUP_ID
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, TL.SOURCE_LANG
, TL.LANGUAGE
, B.C_EXT_ATTR1
, B.C_EXT_ATTR2
, B.C_EXT_ATTR3
, B.C_EXT_ATTR4
, B.C_EXT_ATTR5
, B.C_EXT_ATTR6
, B.C_EXT_ATTR7
, B.C_EXT_ATTR8
, B.C_EXT_ATTR9
, B.C_EXT_ATTR10
, B.C_EXT_ATTR11
, B.C_EXT_ATTR12
, B.C_EXT_ATTR13
, B.C_EXT_ATTR14
, B.C_EXT_ATTR15
, B.C_EXT_ATTR16
, B.C_EXT_ATTR17
, B.C_EXT_ATTR18
, B.C_EXT_ATTR19
, B.C_EXT_ATTR20
, B.N_EXT_ATTR1
, B.N_EXT_ATTR2
, B.N_EXT_ATTR3
, B.N_EXT_ATTR4
, B.N_EXT_ATTR5
, B.N_EXT_ATTR6
, B.N_EXT_ATTR7
, B.N_EXT_ATTR8
, B.N_EXT_ATTR9
, B.N_EXT_ATTR10
, B.D_EXT_ATTR1
, B.D_EXT_ATTR2
, B.D_EXT_ATTR3
, B.D_EXT_ATTR4
, B.D_EXT_ATTR5
, B.N_EXT_ATTR11
, B.N_EXT_ATTR12
, B.N_EXT_ATTR13
, B.N_EXT_ATTR14
, B.N_EXT_ATTR15
, B.N_EXT_ATTR16
, B.N_EXT_ATTR17
, B.N_EXT_ATTR18
, B.N_EXT_ATTR19
, B.N_EXT_ATTR20
, B.D_EXT_ATTR6
, B.D_EXT_ATTR7
, B.D_EXT_ATTR8
, B.D_EXT_ATTR9
, B.D_EXT_ATTR10
, TL.TL_EXT_ATTR1
, TL.TL_EXT_ATTR2
, TL.TL_EXT_ATTR3
, TL.TL_EXT_ATTR4
, TL.TL_EXT_ATTR5
, TL.TL_EXT_ATTR6
, TL.TL_EXT_ATTR7
, TL.TL_EXT_ATTR8
, TL.TL_EXT_ATTR9
, TL.TL_EXT_ATTR10
, TL.TL_EXT_ATTR11
, TL.TL_EXT_ATTR12
, TL.TL_EXT_ATTR13
, TL.TL_EXT_ATTR14
, TL.TL_EXT_ATTR15
, TL.TL_EXT_ATTR16
, TL.TL_EXT_ATTR17
, TL.TL_EXT_ATTR18
, TL.TL_EXT_ATTR19
, TL.TL_EXT_ATTR20
FROM HZ_PARTY_SITES_EXT_B B
, HZ_PARTY_SITES_EXT_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns