eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.RA_INTERFACE_LINES_ALL_DFV

Source

View Text - Preformatted


SELECT ROWID, INTERFACE_LINE_CONTEXT, (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CLAIM', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE1), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE3), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE4), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE5), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', TO_DATE(INTERFACE_LINE_ATTRIBUTE7, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', TO_DATE(INTERFACE_LINE_ATTRIBUTE8, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'CONTRACTS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE9), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'SERVICE', INTERFACE_LINE_ATTRIBUTE3, 'CONTRACTS', INTERFACE_LINE_ATTRIBUTE10, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EMD TRANSACTIONS', INTERFACE_LINE_ATTRIBUTE8, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE INVOICES', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE_XML_INVOICE', INTERFACE_LINE_ATTRIBUTE2, 'EXCHANGE INVOICES', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE_XML_INVOICE', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE_XML_INVOICE', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'EXCHANGE_XML_INVOICE', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Global_Procurement', INTERFACE_LINE_ATTRIBUTE1, 'GLOBAL_PROCUREMENT', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Global_Procurement', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2), 'GLOBAL_PROCUREMENT', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Global_Procurement', INTERFACE_LINE_ATTRIBUTE3, 'GLOBAL_PROCUREMENT', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Global_Procurement', INTERFACE_LINE_ATTRIBUTE4, 'GLOBAL_PROCUREMENT', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE3, 'Global_Procurement', INTERFACE_LINE_ATTRIBUTE5, 'GLOBAL_PROCUREMENT', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Global_Procurement', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6), 'GLOBAL_PROCUREMENT', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE7, 'GLOBAL_PROCUREMENT', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE15, 'Global_Procurement', INTERFACE_LINE_ATTRIBUTE15, 'GLOBAL_PROCUREMENT', INTERFACE_LINE_ATTRIBUTE8, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Global_Procurement', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE7), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INDIA INVOICES', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INDIA INVOICES', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE1, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE1, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', INTERFACE_LINE_ATTRIBUTE8, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERCOMPANY', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE9), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERNAL_ALLOCATIONS', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'INTERNAL_ALLOCATIONS', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE6, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE6, 'INTERNAL_ALLOCATIONS', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'LOANS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE1), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'LOANS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'LOANS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE3), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'LOANS', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE9, 'LOANS', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'LOANS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'LOANS', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE7), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKL_INVESTOR', INTERFACE_LINE_ATTRIBUTE14, 'OKL_CONTRACTS', INTERFACE_LINE_ATTRIBUTE14, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE8, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'OKS CONTRACTS', INTERFACE_LINE_ATTRIBUTE10, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE2, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE3, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE4, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE5, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE7, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE8, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE8, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE9, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE9, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE10, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE10, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER MANAGEMENT', INTERFACE_LINE_ATTRIBUTE11, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE11, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE12, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE13, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'ORDER ENTRY', INTERFACE_LINE_ATTRIBUTE14, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE2, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE5, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Work Order Billing', INTERFACE_LINE_ATTRIBUTE4, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE6, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE7, 'PA Internal Invoices', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'PROJECTS INVOICES', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE8, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE9, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Property-Projects', INTERFACE_LINE_ATTRIBUTE10, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'SERVICE', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'SERVICE', FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2), NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'SERVICE', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'SERVICE', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'SERVICE', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE3, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE4, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE5, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE6, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'STP NETTING', INTERFACE_LINE_ATTRIBUTE7, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Work Order Billing', INTERFACE_LINE_ATTRIBUTE1, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Work Order Billing', INTERFACE_LINE_ATTRIBUTE2, NULL)), (DECODE (INTERFACE_LINE_CONTEXT, 'Work Order Billing', INTERFACE_LINE_ATTRIBUTE3, NULL)),  
 (DECODE (INTERFACE_LINE_CONTEXT,  
      'Accrue Finance Charges', INTERFACE_LINE_CONTEXT,  
      'CLAIM', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7,  
      'CONTRACTS', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10,  
      'EMD TRANSACTIONS', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8,  
      'EXCHANGE INVOICES', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5,  
      'EXCHANGE_XML_INVOICE', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4,  
      'GLOBAL_PROCUREMENT', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8,  
      'Global_Procurement', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE15,  
      'INDIA INVOICES', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2,  
      'INTERCOMPANY', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE15 || '.' || INTERFACE_LINE_ATTRIBUTE9,  
      'INTERNAL_ALLOCATIONS', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3,  
      'LOANS', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7,  
      'OKL_CONTRACTS', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE14,  
      'OKL_INVESTOR', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE14,  
      'OKS CONTRACTS', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10,  
      'ORDER ENTRY', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10 || '.' || INTERFACE_LINE_ATTRIBUTE11 || '.' || INTERFACE_LINE_ATTRIBUTE12 || '.' || INTERFACE_LINE_ATTRIBUTE13 || '.' || INTERFACE_LINE_ATTRIBUTE14,  
      'ORDER MANAGEMENT', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10 || '.' || INTERFACE_LINE_ATTRIBUTE11,  
      'PA Internal Invoices', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7,  
      'PROJECTS INVOICES', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7,  
      'Property-Projects', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10,  
      'SERVICE', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6,  
      'STP NETTING', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7,  
      'Work Order Billing', INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4, NULL)) 
 FROM RA_INTERFACE_LINES_ALL

View Text - HTML Formatted

SELECT ROWID
, INTERFACE_LINE_CONTEXT
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE1)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE3)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE4)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE5)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, TO_DATE(INTERFACE_LINE_ATTRIBUTE7
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, TO_DATE(INTERFACE_LINE_ATTRIBUTE8
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'CONTRACTS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE9)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'SERVICE'
, INTERFACE_LINE_ATTRIBUTE3
, 'CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE10
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_ATTRIBUTE8
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE INVOICES'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE_XML_INVOICE'
, INTERFACE_LINE_ATTRIBUTE2
, 'EXCHANGE INVOICES'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE_XML_INVOICE'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE_XML_INVOICE'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'EXCHANGE_XML_INVOICE'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE1
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'GLOBAL_PROCUREMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2)
, 'GLOBAL_PROCUREMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE3
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE4
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE3
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE5
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'GLOBAL_PROCUREMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6)
, 'GLOBAL_PROCUREMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE7
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE15
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE15
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_ATTRIBUTE8
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'GLOBAL_PROCUREMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE7)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INDIA INVOICES'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INDIA INVOICES'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE1
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE1
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, INTERFACE_LINE_ATTRIBUTE8
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERCOMPANY'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE9)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERNAL_ALLOCATIONS'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'INTERNAL_ALLOCATIONS'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE6
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE6
, 'INTERNAL_ALLOCATIONS'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'LOANS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE1)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'LOANS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'LOANS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE3)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'LOANS'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE9
, 'LOANS'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'LOANS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'LOANS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE7)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKL_INVESTOR'
, INTERFACE_LINE_ATTRIBUTE14
, 'OKL_CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE14
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE8
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'OKS CONTRACTS'
, INTERFACE_LINE_ATTRIBUTE10
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE2
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE3
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE4
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE5
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE7
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE8
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE8
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE9
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE9
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE10
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE10
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_ATTRIBUTE11
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE11
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE12
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE13
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ORDER ENTRY'
, INTERFACE_LINE_ATTRIBUTE14
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE2
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE5
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'WORK ORDER BILLING'
, INTERFACE_LINE_ATTRIBUTE4
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE6
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE7
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROJECTS INVOICES'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE8
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE9
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_ATTRIBUTE10
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'SERVICE'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'SERVICE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INTERFACE_LINE_ATTRIBUTE2)
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'SERVICE'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'SERVICE'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'SERVICE'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE4
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE5
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE6
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'STP NETTING'
, INTERFACE_LINE_ATTRIBUTE7
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'WORK ORDER BILLING'
, INTERFACE_LINE_ATTRIBUTE1
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'WORK ORDER BILLING'
, INTERFACE_LINE_ATTRIBUTE2
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'WORK ORDER BILLING'
, INTERFACE_LINE_ATTRIBUTE3
, NULL))
, (DECODE (INTERFACE_LINE_CONTEXT
, 'ACCRUE FINANCE CHARGES'
, INTERFACE_LINE_CONTEXT
, 'CLAIM'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7
, 'CONTRACTS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10
, 'EMD TRANSACTIONS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8
, 'EXCHANGE INVOICES'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5
, 'EXCHANGE_XML_INVOICE'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8
, 'GLOBAL_PROCUREMENT'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE15
, 'INDIA INVOICES'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2
, 'INTERCOMPANY'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE15 || '.' || INTERFACE_LINE_ATTRIBUTE9
, 'INTERNAL_ALLOCATIONS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3
, 'LOANS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7
, 'OKL_CONTRACTS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE14
, 'OKL_INVESTOR'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE14
, 'OKS CONTRACTS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10
, 'ORDER ENTRY'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10 || '.' || INTERFACE_LINE_ATTRIBUTE11 || '.' || INTERFACE_LINE_ATTRIBUTE12 || '.' || INTERFACE_LINE_ATTRIBUTE13 || '.' || INTERFACE_LINE_ATTRIBUTE14
, 'ORDER MANAGEMENT'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10 || '.' || INTERFACE_LINE_ATTRIBUTE11
, 'PA INTERNAL INVOICES'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7
, 'PROJECTS INVOICES'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7
, 'PROPERTY-PROJECTS'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7 || '.' || INTERFACE_LINE_ATTRIBUTE8 || '.' || INTERFACE_LINE_ATTRIBUTE9 || '.' || INTERFACE_LINE_ATTRIBUTE10
, 'SERVICE'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6
, 'STP NETTING'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4 || '.' || INTERFACE_LINE_ATTRIBUTE5 || '.' || INTERFACE_LINE_ATTRIBUTE6 || '.' || INTERFACE_LINE_ATTRIBUTE7
, 'WORK ORDER BILLING'
, INTERFACE_LINE_CONTEXT || '.' || INTERFACE_LINE_ATTRIBUTE1 || '.' || INTERFACE_LINE_ATTRIBUTE2 || '.' || INTERFACE_LINE_ATTRIBUTE3 || '.' || INTERFACE_LINE_ATTRIBUTE4
, NULL))
FROM RA_INTERFACE_LINES_ALL