VIEW: APPS.POS_SUPP_PROF_EXT_VL

Source

View Text - Preformatted

SELECT b.extension_id, b.party_id, b.attr_group_id, b.data_level_id, b.classification_code, b.is_prospect, b.pk1_value, b.pk2_value, b.pk3_value, b.pk4_value, b.pk5_value, 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.c_ext_attr21, b.c_ext_attr22, b.c_ext_attr23, b.c_ext_attr24, b.c_ext_attr25, b.c_ext_attr26, b.c_ext_attr27, b.c_ext_attr28, b.c_ext_attr29, b.c_ext_attr30, b.c_ext_attr31, b.c_ext_attr32, b.c_ext_attr33, b.c_ext_attr34, b.c_ext_attr35, b.c_ext_attr36, b.c_ext_attr37, b.c_ext_attr38, b.c_ext_attr39, b.c_ext_attr40, 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.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.uom_ext_attr1, b.uom_ext_attr2, b.uom_ext_attr3, b.uom_ext_attr4, b.uom_ext_attr5, b.uom_ext_attr6, b.uom_ext_attr7, b.uom_ext_attr8, b.uom_ext_attr9, b.uom_ext_attr10, b.uom_ext_attr11, b.uom_ext_attr12, b.uom_ext_attr13, b.uom_ext_attr14, b.uom_ext_attr15, b.uom_ext_attr16, b.uom_ext_attr17, b.uom_ext_attr18, b.uom_ext_attr19, b.uom_ext_attr20, b.d_ext_attr1, b.d_ext_attr2, b.d_ext_attr3, b.d_ext_attr4, b.d_ext_attr5, 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, tl.tl_ext_attr21, tl.tl_ext_attr22, tl.tl_ext_attr23, tl.tl_ext_attr24, tl.tl_ext_attr25, tl.tl_ext_attr26, tl.tl_ext_attr27, tl.tl_ext_attr28, tl.tl_ext_attr29, tl.tl_ext_attr30, tl.tl_ext_attr31, tl.tl_ext_attr32, tl.tl_ext_attr33, tl.tl_ext_attr34, tl.tl_ext_attr35, tl.tl_ext_attr36, tl.tl_ext_attr37, tl.tl_ext_attr38, tl.tl_ext_attr39, tl.tl_ext_attr40 FROM pos_supp_prof_ext_b b, pos_supp_prof_ext_tl tl WHERE b.extension_id = tl.extension_id AND tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.EXTENSION_ID
, B.PARTY_ID
, B.ATTR_GROUP_ID
, B.DATA_LEVEL_ID
, B.CLASSIFICATION_CODE
, B.IS_PROSPECT
, B.PK1_VALUE
, B.PK2_VALUE
, B.PK3_VALUE
, B.PK4_VALUE
, B.PK5_VALUE
, 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.C_EXT_ATTR21
, B.C_EXT_ATTR22
, B.C_EXT_ATTR23
, B.C_EXT_ATTR24
, B.C_EXT_ATTR25
, B.C_EXT_ATTR26
, B.C_EXT_ATTR27
, B.C_EXT_ATTR28
, B.C_EXT_ATTR29
, B.C_EXT_ATTR30
, B.C_EXT_ATTR31
, B.C_EXT_ATTR32
, B.C_EXT_ATTR33
, B.C_EXT_ATTR34
, B.C_EXT_ATTR35
, B.C_EXT_ATTR36
, B.C_EXT_ATTR37
, B.C_EXT_ATTR38
, B.C_EXT_ATTR39
, B.C_EXT_ATTR40
, 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.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.UOM_EXT_ATTR1
, B.UOM_EXT_ATTR2
, B.UOM_EXT_ATTR3
, B.UOM_EXT_ATTR4
, B.UOM_EXT_ATTR5
, B.UOM_EXT_ATTR6
, B.UOM_EXT_ATTR7
, B.UOM_EXT_ATTR8
, B.UOM_EXT_ATTR9
, B.UOM_EXT_ATTR10
, B.UOM_EXT_ATTR11
, B.UOM_EXT_ATTR12
, B.UOM_EXT_ATTR13
, B.UOM_EXT_ATTR14
, B.UOM_EXT_ATTR15
, B.UOM_EXT_ATTR16
, B.UOM_EXT_ATTR17
, B.UOM_EXT_ATTR18
, B.UOM_EXT_ATTR19
, B.UOM_EXT_ATTR20
, B.D_EXT_ATTR1
, B.D_EXT_ATTR2
, B.D_EXT_ATTR3
, B.D_EXT_ATTR4
, B.D_EXT_ATTR5
, 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
, TL.TL_EXT_ATTR21
, TL.TL_EXT_ATTR22
, TL.TL_EXT_ATTR23
, TL.TL_EXT_ATTR24
, TL.TL_EXT_ATTR25
, TL.TL_EXT_ATTR26
, TL.TL_EXT_ATTR27
, TL.TL_EXT_ATTR28
, TL.TL_EXT_ATTR29
, TL.TL_EXT_ATTR30
, TL.TL_EXT_ATTR31
, TL.TL_EXT_ATTR32
, TL.TL_EXT_ATTR33
, TL.TL_EXT_ATTR34
, TL.TL_EXT_ATTR35
, TL.TL_EXT_ATTR36
, TL.TL_EXT_ATTR37
, TL.TL_EXT_ATTR38
, TL.TL_EXT_ATTR39
, TL.TL_EXT_ATTR40
FROM POS_SUPP_PROF_EXT_B B
, POS_SUPP_PROF_EXT_TL TL
WHERE B.EXTENSION_ID = TL.EXTENSION_ID
AND TL.LANGUAGE = USERENV('LANG')