View: ASO_SUP_COMP_RESP_MAP_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_SUP_COMP_RESP_MAP_V

View Text

SELECT ASOCRM.ROWID ROW_ID
, ASOCRM.COMPONENT_RESPONSE_ID
, ASOCRM.COMPONENT_ID
, ASOCRM.RESPONSE_ID
, ASOCV.COMPONENT_NAME
, ASOCV.DESCRIPTION COMPONENT_DESCRIPTION
, ASOCV.INSTRUCTION
, ASOCV.COMPONENT_TYPE
, ASOCV.COMPONENT_TYPE_MEANING
, ASOCV.RESPONSE_TYPE
, ASOCV.RESPONSE_TYPE_MEANING
, ASOCV.MANDATORY_FLAG
, ASORV.RESPONSE_NAME
, ASORV.DESCRIPTION RESPONSE_DESCRIPTION
, ASOCRM.DISPLAY_SEQUENCE
, ASOCRM.CREATED_BY
, ASOCRM.CREATION_DATE
, ASOCRM.LAST_UPDATED_BY
, ASOCRM.LAST_UPDATE_DATE
, ASOCRM.LAST_UPDATE_LOGIN
, ASOCRM.CONTEXT
, ASOCRM.ATTRIBUTE1
, ASOCRM.ATTRIBUTE2
, ASOCRM.ATTRIBUTE3
, ASOCRM.ATTRIBUTE4
, ASOCRM.ATTRIBUTE5
, ASOCRM.ATTRIBUTE6
, ASOCRM.ATTRIBUTE7
, ASOCRM.ATTRIBUTE8
, ASOCRM.ATTRIBUTE9
, ASOCRM.ATTRIBUTE10
, ASOCRM.ATTRIBUTE11
, ASOCRM.ATTRIBUTE12
, ASOCRM.ATTRIBUTE13
, ASOCRM.ATTRIBUTE14
, ASOCRM.ATTRIBUTE15
FROM ASO_SUP_COMPONENT_V ASOCV
, ASO_SUP_RESPONSE_VL ASORV
, ASO_SUP_COMP_RESP_MAP ASOCRM
WHERE ASOCRM.COMPONENT_ID = ASOCV.COMPONENT_ID
AND ASOCRM.RESPONSE_ID = ASORV.RESPONSE_ID

Columns