VIEW: APPS.ASO_SUP_TMPL_SECT_V

Source

View Text - Preformatted

SELECT asotsm.rowid row_id, asotsm.template_section_map_id, asotsm.template_id, asotv.template_name, asotv.description template_description, asotsm.section_id, asosv.section_name, asosv.description section_description, asotsm.display_sequence, asotsm.created_by, asotsm.creation_date, asotsm.last_updated_by, asotsm.last_update_date, asotsm.last_update_login, asotsm.context, asotsm.attribute1, asotsm.attribute2, asotsm.attribute3, asotsm.attribute4, asotsm.attribute5, asotsm.attribute6, asotsm.attribute7, asotsm.attribute8, asotsm.attribute9, asotsm.attribute10, asotsm.attribute11, asotsm.attribute12, asotsm.attribute13, asotsm.attribute14, asotsm.attribute15, asotsm.attribute16, asotsm.attribute17, asotsm.attribute18, asotsm.attribute19, asotsm.attribute20 from aso_sup_template_vl asotv, aso_sup_section_vl asosv , aso_sup_tmpl_sect_map asotsm WHERE asotsm.template_id = asotv.template_id and asotsm.section_id = asosv.section_id

View Text - HTML Formatted

SELECT ASOTSM.ROWID ROW_ID
, ASOTSM.TEMPLATE_SECTION_MAP_ID
, ASOTSM.TEMPLATE_ID
, ASOTV.TEMPLATE_NAME
, ASOTV.DESCRIPTION TEMPLATE_DESCRIPTION
, ASOTSM.SECTION_ID
, ASOSV.SECTION_NAME
, ASOSV.DESCRIPTION SECTION_DESCRIPTION
, ASOTSM.DISPLAY_SEQUENCE
, ASOTSM.CREATED_BY
, ASOTSM.CREATION_DATE
, ASOTSM.LAST_UPDATED_BY
, ASOTSM.LAST_UPDATE_DATE
, ASOTSM.LAST_UPDATE_LOGIN
, ASOTSM.CONTEXT
, ASOTSM.ATTRIBUTE1
, ASOTSM.ATTRIBUTE2
, ASOTSM.ATTRIBUTE3
, ASOTSM.ATTRIBUTE4
, ASOTSM.ATTRIBUTE5
, ASOTSM.ATTRIBUTE6
, ASOTSM.ATTRIBUTE7
, ASOTSM.ATTRIBUTE8
, ASOTSM.ATTRIBUTE9
, ASOTSM.ATTRIBUTE10
, ASOTSM.ATTRIBUTE11
, ASOTSM.ATTRIBUTE12
, ASOTSM.ATTRIBUTE13
, ASOTSM.ATTRIBUTE14
, ASOTSM.ATTRIBUTE15
, ASOTSM.ATTRIBUTE16
, ASOTSM.ATTRIBUTE17
, ASOTSM.ATTRIBUTE18
, ASOTSM.ATTRIBUTE19
, ASOTSM.ATTRIBUTE20
FROM ASO_SUP_TEMPLATE_VL ASOTV
, ASO_SUP_SECTION_VL ASOSV
, ASO_SUP_TMPL_SECT_MAP ASOTSM
WHERE ASOTSM.TEMPLATE_ID = ASOTV.TEMPLATE_ID
AND ASOTSM.SECTION_ID = ASOSV.SECTION_ID