Product: | OKX - Contracts Integration |
---|---|
Description: | Customer invoice, debit memo, chargeback, credit memo and commitment lines |
Implementation/DBA Data: | APPS.OKX_CUST_TRX_LINES_V |
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