1. Tables and Views for SCM
  2. CTO_TIA_V

CTO_TIA_V

Details

  • Schema: FUSION

  • Object owner: CTO

  • Object type: VIEW

Columns

Name

LINE_ID

MATCH_TXN_ATTR_ID

ATTRIBUTE_NAME

TIMESTAMP_ATTRIBUTE_VALUE

NUMBER_ATTRIBUTE_VALUE

DATE_ATTRIBUTE_VALUE

CHARACTER_ATTRIBUTE_VALUE

CONFIG_ITEM_ID

Query

SQL_Statement

SELECT

T.LINE_ID,

T.MATCH_TXN_ATTR_ID,

T.ATTRIBUTE_NAME,

T.TIMESTAMP_ATTRIBUTE_VALUE,

T.NUMBER_ATTRIBUTE_VALUE,

T.DATE_ATTRIBUTE_VALUE,

T.CHARACTER_ATTRIBUTE_VALUE,

H.CONFIG_ITEM_ID

FROM

CTO_MATCH_HEADERS H, CTO_MATCH_LINES L, CTO_MATCH_TXN_ATTR T

WHERE H.HEADER_ID = L.HEADER_ID

AND L.LINE_ID = T.LINE_ID