Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CTR.ROWID
, CTR.LAST_UPDATE_DATE
, CTR.LAST_UPDATED_BY
, CTR.LAST_UPDATE_LOGIN
, CTR.CREATION_DATE
, CTR.CREATED_BY
, CTR.ORG_ID
, CTR.TRX_SET_LINE_ID
, CTR.TRX_SET_ID
, CTR.SEQUENCE_NUMBER
, CTR.EVENT
, CTR.START_DATE
, CTR.END_DATE
, CTR.CUST_TRX_TYPE_ID
, RCT.TYPE
, ALP.MEANING
, RCT.NAME
, RCT.DESCRIPTION
, RCT.START_DATE
, RCT.END_DATE
, CTR.ATTRIBUTE_CATEGORY
, CTR.ATTRIBUTE1
, CTR.ATTRIBUTE2
, CTR.ATTRIBUTE3
, CTR.ATTRIBUTE4
, CTR.ATTRIBUTE5
, CTR.ATTRIBUTE6
, CTR.ATTRIBUTE7
, CTR.ATTRIBUTE8
, CTR.ATTRIBUTE9
, CTR.ATTRIBUTE10
, CTR.ATTRIBUTE11
, CTR.ATTRIBUTE12
, CTR.ATTRIBUTE13
, CTR.ATTRIBUTE14
, CTR.ATTRIBUTE15
FROM AR_TA_TRX_SET_LN CTR
, AR_LOOKUPS ALP
, RA_CUST_TRX_TYPES RCT
WHERE CTR.CUST_TRX_TYPE_ID = RCT.CUST_TRX_TYPE_ID
AND CTR.EVENT = ALP.LOOKUP_CODE
AND ALP.LOOKUP_TYPE = 'TRANSACTION EVENT'