Product: | CSI - Install Base |
---|---|
Description: | View on top of Transaction Details Extended attribs CSI_T_EXTEND_ATTRIBS |
Implementation/DBA Data: | APPS.CSI_T_EXTEND_ATTRIBS_V |
SELECT CTEA.TXN_ATTRIB_DETAIL_ID
, CTEA.TXN_LINE_DETAIL_ID
, CTLD.CONFIG_INST_HDR_ID
, CTLD.CONFIG_INST_REV_NUM
, CTLD.CONFIG_INST_ITEM_ID
, CTEA.ATTRIB_SOURCE_TABLE
, CTEA.ATTRIB_SOURCE_ID
, CIEA.ATTRIBUTE_CODE
, CIEA.ATTRIBUTE_NAME
, CIEA.ATTRIBUTE_CATEGORY
, CIEA.ATTRIBUTE_LEVEL
, CTEA.ATTRIBUTE_VALUE
, CTEA.ACTIVE_START_DATE
, CTEA.ACTIVE_END_DATE
, CTEA.OBJECT_VERSION_NUMBER
FROM CSI_T_EXTEND_ATTRIBS CTEA
, CSI_I_EXTENDED_ATTRIBS CIEA
, CSI_T_TXN_LINE_DETAILS CTLD
WHERE CTEA.ATTRIB_SOURCE_TABLE = 'CSI_I_EXTENDED_ATTRIBS' AND CTEA.ATTRIB_SOURCE_ID = CIEA.ATTRIBUTE_ID AND CTEA.TXN_LINE_DETAIL_ID = CTLD.TXN_LINE_DETAIL_ID