SELECT ROWID, INTERFACE_HEADER_CONTEXT, (DECODE (INTERFACE_HEADER_CONTEXT, 'CLAIM', INTERFACE_HEADER_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'CLAIM', INTERFACE_HEADER_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'CLAIM', INTERFACE_HEADER_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'CLAIM', INTERFACE_HEADER_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_HEADER_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_HEADER_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_HEADER_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_HEADER_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'EXCHANGE_XML_INVOICE', INTERFACE_HEADER_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'OKL_CONTRACTS', INTERFACE_HEADER_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'OKL_CONTRACTS', INTERFACE_HEADER_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'OKL_CONTRACTS', INTERFACE_HEADER_ATTRIBUTE15, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'OKL_CONTRACTS', INTERFACE_HEADER_ATTRIBUTE11, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'OKL_CONTRACTS', INTERFACE_HEADER_ATTRIBUTE13, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'PROJECTS INVOICES', INTERFACE_HEADER_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'PROJECTS INVOICES', INTERFACE_HEADER_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'PROJECTS INVOICES', INTERFACE_HEADER_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'PROJECTS INVOICES', INTERFACE_HEADER_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_HEADER_CONTEXT, 'PROJECTS INVOICES', INTERFACE_HEADER_ATTRIBUTE5, NULL)),
(DECODE (INTERFACE_HEADER_CONTEXT,
'CLAIM', INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1 || '.' || INTERFACE_HEADER_ATTRIBUTE5 || '.' || INTERFACE_HEADER_ATTRIBUTE6 || '.' || INTERFACE_HEADER_ATTRIBUTE7,
'EXCHANGE INVOICES', INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1 || '.' || INTERFACE_HEADER_ATTRIBUTE2 || '.' || INTERFACE_HEADER_ATTRIBUTE3 || '.' || INTERFACE_HEADER_ATTRIBUTE4,
'EXCHANGE_XML_INVOICE', INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1,
'OKL_CONTRACTS', INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE4 || '.' || INTERFACE_HEADER_ATTRIBUTE2 || '.' || INTERFACE_HEADER_ATTRIBUTE15 || '.' || INTERFACE_HEADER_ATTRIBUTE11 || '.' || INTERFACE_HEADER_ATTRIBUTE13,
'PROJECTS INVOICES', INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1 || '.' || INTERFACE_HEADER_ATTRIBUTE2 || '.' || INTERFACE_HEADER_ATTRIBUTE3 || '.' || INTERFACE_HEADER_ATTRIBUTE4 || '.' || INTERFACE_HEADER_ATTRIBUTE5, NULL))
FROM RA_CUSTOMER_TRX_ALL
SELECT ROWID
, INTERFACE_HEADER_CONTEXT
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'CLAIM'
, INTERFACE_HEADER_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'CLAIM'
, INTERFACE_HEADER_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'CLAIM'
, INTERFACE_HEADER_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'CLAIM'
, INTERFACE_HEADER_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_HEADER_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_HEADER_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_HEADER_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_HEADER_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'EXCHANGE_XML_INVOICE'
, INTERFACE_HEADER_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, INTERFACE_HEADER_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, INTERFACE_HEADER_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, INTERFACE_HEADER_ATTRIBUTE15
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, INTERFACE_HEADER_ATTRIBUTE11
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'OKL_CONTRACTS'
, INTERFACE_HEADER_ATTRIBUTE13
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_HEADER_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_HEADER_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_HEADER_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_HEADER_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_HEADER_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_HEADER_ATTRIBUTE5
, NULL))
,
(DECODE (INTERFACE_HEADER_CONTEXT
,
'CLAIM'
, INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1 || '.' || INTERFACE_HEADER_ATTRIBUTE5 || '.' || INTERFACE_HEADER_ATTRIBUTE6 || '.' || INTERFACE_HEADER_ATTRIBUTE7
,
'EXCHANGE INVOICES'
, INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1 || '.' || INTERFACE_HEADER_ATTRIBUTE2 || '.' || INTERFACE_HEADER_ATTRIBUTE3 || '.' || INTERFACE_HEADER_ATTRIBUTE4
,
'EXCHANGE_XML_INVOICE'
, INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1
,
'OKL_CONTRACTS'
, INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE4 || '.' || INTERFACE_HEADER_ATTRIBUTE2 || '.' || INTERFACE_HEADER_ATTRIBUTE15 || '.' || INTERFACE_HEADER_ATTRIBUTE11 || '.' || INTERFACE_HEADER_ATTRIBUTE13
,
'PROJECTS INVOICES'
, INTERFACE_HEADER_CONTEXT || '.' || INTERFACE_HEADER_ATTRIBUTE1 || '.' || INTERFACE_HEADER_ATTRIBUTE2 || '.' || INTERFACE_HEADER_ATTRIBUTE3 || '.' || INTERFACE_HEADER_ATTRIBUTE4 || '.' || INTERFACE_HEADER_ATTRIBUTE5
, NULL))
FROM RA_CUSTOMER_TRX_ALL
|
|
|