FND Design Data [Home] [Help]

View: OKX_CUST_TRX_LINES_V

Product: OKX - Contracts Integration
Description: Customer invoice, debit memo, chargeback, credit memo and commitment lines
Implementation/DBA Data: ViewAPPS.OKX_CUST_TRX_LINES_V
View Text

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

Columns

Name
ORG_ID
SET_OF_BOOKS_ID
CUSTOMER_TRX_LINE_ID
CUSTOMER_TRX_ID
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_ATTRIBUTE10
INTERFACE_LINE_ATTRIBUTE11
INTERFACE_LINE_ATTRIBUTE12
INTERFACE_LINE_ATTRIBUTE13
INTERFACE_LINE_ATTRIBUTE14
INTERFACE_LINE_ATTRIBUTE15
INTERFACE_LINE_ATTRIBUTE9
LINE_TYPE
EXTENDED_AMOUNT
LINK_TO_CUST_TRX_LINE_ID