VIEW: APPS.OKX_CUST_TRX_LINES_V

Source

View Text - Preformatted

SELECT CTL.ORG_ID ORG_ID, CTL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, CTL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID, CTL.INTERFACE_LINE_CONTEXT INTERFACE_LINE_CONTEXT, CTL.INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1, CTL.INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2, CTL.INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3, CTL.INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4, CTL.INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5, CTL.INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6, CTL.INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7, CTL.INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8, CTL.INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10, CTL.INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11, CTL.INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12, CTL.INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13, CTL.INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14, CTL.INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15, CTL.INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9, CTL.LINE_TYPE LINE_TYPE, CTL.EXTENDED_AMOUNT EXTENDED_AMOUNT , CTL.LINK_TO_CUST_TRX_LINE_ID FROM RA_CUSTOMER_TRX_LINES_ALL CTL

View Text - HTML Formatted

SELECT CTL.ORG_ID ORG_ID
, CTL.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CTL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, CTL.CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, CTL.INTERFACE_LINE_CONTEXT INTERFACE_LINE_CONTEXT
, CTL.INTERFACE_LINE_ATTRIBUTE1 INTERFACE_LINE_ATTRIBUTE1
, CTL.INTERFACE_LINE_ATTRIBUTE2 INTERFACE_LINE_ATTRIBUTE2
, CTL.INTERFACE_LINE_ATTRIBUTE3 INTERFACE_LINE_ATTRIBUTE3
, CTL.INTERFACE_LINE_ATTRIBUTE4 INTERFACE_LINE_ATTRIBUTE4
, CTL.INTERFACE_LINE_ATTRIBUTE5 INTERFACE_LINE_ATTRIBUTE5
, CTL.INTERFACE_LINE_ATTRIBUTE6 INTERFACE_LINE_ATTRIBUTE6
, CTL.INTERFACE_LINE_ATTRIBUTE7 INTERFACE_LINE_ATTRIBUTE7
, CTL.INTERFACE_LINE_ATTRIBUTE8 INTERFACE_LINE_ATTRIBUTE8
, CTL.INTERFACE_LINE_ATTRIBUTE10 INTERFACE_LINE_ATTRIBUTE10
, CTL.INTERFACE_LINE_ATTRIBUTE11 INTERFACE_LINE_ATTRIBUTE11
, CTL.INTERFACE_LINE_ATTRIBUTE12 INTERFACE_LINE_ATTRIBUTE12
, CTL.INTERFACE_LINE_ATTRIBUTE13 INTERFACE_LINE_ATTRIBUTE13
, CTL.INTERFACE_LINE_ATTRIBUTE14 INTERFACE_LINE_ATTRIBUTE14
, CTL.INTERFACE_LINE_ATTRIBUTE15 INTERFACE_LINE_ATTRIBUTE15
, CTL.INTERFACE_LINE_ATTRIBUTE9 INTERFACE_LINE_ATTRIBUTE9
, CTL.LINE_TYPE LINE_TYPE
, CTL.EXTENDED_AMOUNT EXTENDED_AMOUNT
, CTL.LINK_TO_CUST_TRX_LINE_ID
FROM RA_CUSTOMER_TRX_LINES_ALL CTL