Product: | ASO - Order Capture |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ASO_SUP_SECT_COMP_V |
SELECT ASOSCM.ROWID ROW_ID
, ASOSCM.SECT_COMP_MAP_ID
, ASOSCM.SECTION_ID
, ASOSCM.COMPONENT_ID
, ASOSV.SECTION_NAME
, ASOSV.DESCRIPTION SECTION_DESCRIPTION
, DECODE(ASOSCM.SECTION_COMPONENT_TYPE
, 'COMPONENT'
, ASOCV.COMPONENT_NAME
, '') NAME
, DECODE(ASOSCM.SECTION_COMPONENT_TYPE
, 'COMPONENT'
, ASOCV.DESCRIPTION
, '') DESCRIPTION
, ASOSCM.DISPLAY_SEQUENCE
, ASOSCM.CHILD_COMPONENT_ID
, ASOSCM.SUB_SECTION_ID
, ASOSCM.DEFAULT_RESPONSE_ID
, ASOSCM.PRESENTATION_STYLE
, DECODE(ASOSCM.SECTION_COMPONENT_TYPE
, 'COMPONENT'
, D.MEANING
, '') PRESENTATION_STYLE_MEANING
, ASORV.RESPONSE_NAME DEFAULT_VALUE
, ASOSCM.SECTION_COMPONENT_TYPE
, E.MEANING SECTION_COMPONENT_TYPE_MEANING
, ASOSCM.CREATED_BY
, ASOSCM.CREATION_DATE
, ASOSCM.LAST_UPDATED_BY
, ASOSCM.LAST_UPDATE_DATE
, ASOSCM.LAST_UPDATE_LOGIN
, ASOSCM.CONTEXT
, ASOSCM.ATTRIBUTE1
, ASOSCM.ATTRIBUTE2
, ASOSCM.ATTRIBUTE3
, ASOSCM.ATTRIBUTE4
, ASOSCM.ATTRIBUTE5
, ASOSCM.ATTRIBUTE6
, ASOSCM.ATTRIBUTE7
, ASOSCM.ATTRIBUTE8
, ASOSCM.ATTRIBUTE9
, ASOSCM.ATTRIBUTE10
, ASOSCM.ATTRIBUTE11
, ASOSCM.ATTRIBUTE12
, ASOSCM.ATTRIBUTE13
, ASOSCM.ATTRIBUTE14
, ASOSCM.ATTRIBUTE15
FROM ASO_SUP_SECTION_VL ASOSV
, ASO_SUP_COMPONENT_VL ASOCV
, ASO_SUP_SECT_COMP_MAP ASOSCM
, ASO_SUP_RESPONSE_VL ASORV
, FND_LOOKUP_VALUES_VL D
, FND_LOOKUP_VALUES_VL E
WHERE ASOSCM.COMPONENT_ID = ASOCV.COMPONENT_ID
AND ASOSCM.SECTION_ID = ASOSV.SECTION_ID
AND D.LOOKUP_TYPE = 'ASO_SUP_PRESENTATION_STYLE'
AND D.LOOKUP_CODE = ASOSCM.PRESENTATION_STYLE
AND E.LOOKUP_TYPE = 'ASO_SUP_SECTION_COMPONENT_TYPE'
AND E.LOOKUP_CODE = ASOSCM.SECTION_COMPONENT_TYPE
AND ASOSCM.DEFAULT_RESPONSE_ID = ASORV.RESPONSE_ID(+)