VIEW: APPS.RA_CUSTOMER_TRX_RA_V

Source

View Text - Preformatted

SELECT CT.ROWID , CT.CUSTOMER_TRX_ID , CT.TRX_NUMBER , CT.OLD_TRX_NUMBER , CT.RECURRED_FROM_TRX_NUMBER , CT.TRX_DATE , CT.PREVIOUS_CUSTOMER_TRX_ID , CT.INITIAL_CUSTOMER_TRX_ID , CT.RELATED_BATCH_SOURCE_ID , CT.RELATED_CUSTOMER_TRX_ID , CT.CUST_TRX_TYPE_ID , CT.BATCH_ID , CT.BATCH_SOURCE_ID , CT.REASON_CODE , CT.TERM_ID , CT.PRIMARY_SALESREP_ID , CT.AGREEMENT_ID , CT.CREDIT_METHOD_FOR_RULES , CT.CREDIT_METHOD_FOR_INSTALLMENTS , CT.RECEIPT_METHOD_ID , CT.INVOICING_RULE_ID , CT.SHIP_VIA , CT.FOB_POINT , CT.FINANCE_CHARGES , CT.COMPLETE_FLAG , CT.CUSTOMER_BANK_ACCOUNT_ID , CT.RECURRED_FROM_TRX_NUMBER , CT.STATUS_TRX , CT.DEFAULT_TAX_EXEMPT_FLAG , CT.SOLD_TO_CUSTOMER_ID , CT.SOLD_TO_SITE_USE_ID , CT.SOLD_TO_CONTACT_ID , CT.BILL_TO_CUSTOMER_ID , CT.BILL_TO_SITE_USE_ID , CT.BILL_TO_CONTACT_ID , CT.SHIP_TO_CUSTOMER_ID , CT.SHIP_TO_SITE_USE_ID , CT.SHIP_TO_CONTACT_ID , CT.REMIT_TO_ADDRESS_ID , CT.INVOICE_CURRENCY_CODE , CT.CREATED_FROM , CT.SET_OF_BOOKS_ID , CT.PRINTING_ORIGINAL_DATE , CT.PRINTING_LAST_PRINTED , CT.PRINTING_OPTION , CT.PRINTING_COUNT , CT.PRINTING_PENDING , CT.LAST_PRINTED_SEQUENCE_NUM , CT.PURCHASE_ORDER , CT.PURCHASE_ORDER_REVISION , CT.PURCHASE_ORDER_DATE , CT.CUSTOMER_REFERENCE , CT.CUSTOMER_REFERENCE_DATE , CT.COMMENTS , CT.INTERNAL_NOTES , CT.EXCHANGE_RATE_TYPE , CT.EXCHANGE_DATE , CT.EXCHANGE_RATE , CT.TERRITORY_ID , CT.END_DATE_COMMITMENT , CT.START_DATE_COMMITMENT , CT.ORIG_SYSTEM_BATCH_NAME , CT.SHIP_DATE_ACTUAL , CT.WAYBILL_NUMBER , CT.DOC_SEQUENCE_ID , CT.DOC_SEQUENCE_VALUE , CT.PAYING_CUSTOMER_ID , CT.PAYING_SITE_USE_ID , CT.ATTRIBUTE_CATEGORY , CT.ATTRIBUTE1 , CT.ATTRIBUTE2 , CT.ATTRIBUTE3 , CT.ATTRIBUTE4 , CT.ATTRIBUTE5 , CT.ATTRIBUTE6 , CT.ATTRIBUTE7 , CT.ATTRIBUTE8 , CT.ATTRIBUTE9 , CT.ATTRIBUTE10 , CT.ATTRIBUTE11 , CT.ATTRIBUTE12 , CT.ATTRIBUTE13 , CT.ATTRIBUTE14 , CT.ATTRIBUTE15 , CT.INTERFACE_HEADER_CONTEXT , CT.INTERFACE_HEADER_ATTRIBUTE1 , CT.INTERFACE_HEADER_ATTRIBUTE2 , CT.INTERFACE_HEADER_ATTRIBUTE3 , CT.INTERFACE_HEADER_ATTRIBUTE4 , CT.INTERFACE_HEADER_ATTRIBUTE5 , CT.INTERFACE_HEADER_ATTRIBUTE6 , CT.INTERFACE_HEADER_ATTRIBUTE7 , CT.INTERFACE_HEADER_ATTRIBUTE8 , CT.INTERFACE_HEADER_ATTRIBUTE9 , CT.INTERFACE_HEADER_ATTRIBUTE10 , CT.INTERFACE_HEADER_ATTRIBUTE11 , CT.INTERFACE_HEADER_ATTRIBUTE12 , CT.INTERFACE_HEADER_ATTRIBUTE13 , CT.INTERFACE_HEADER_ATTRIBUTE14 , CT.INTERFACE_HEADER_ATTRIBUTE15 , CT.GLOBAL_ATTRIBUTE1 , CT.GLOBAL_ATTRIBUTE2 , CT.GLOBAL_ATTRIBUTE3 , CT.GLOBAL_ATTRIBUTE4 , CT.GLOBAL_ATTRIBUTE5 , CT.GLOBAL_ATTRIBUTE6 , CT.GLOBAL_ATTRIBUTE7 , CT.GLOBAL_ATTRIBUTE8 , CT.GLOBAL_ATTRIBUTE9 , CT.GLOBAL_ATTRIBUTE10 , CT.GLOBAL_ATTRIBUTE11 , CT.GLOBAL_ATTRIBUTE12 , CT.GLOBAL_ATTRIBUTE13 , CT.GLOBAL_ATTRIBUTE14 , CT.GLOBAL_ATTRIBUTE15 , CT.GLOBAL_ATTRIBUTE16 , CT.GLOBAL_ATTRIBUTE17 , CT.GLOBAL_ATTRIBUTE18 , CT.GLOBAL_ATTRIBUTE19 , CT.GLOBAL_ATTRIBUTE20 , CT.GLOBAL_ATTRIBUTE_CATEGORY , CT.DEFAULT_USSGL_TRANSACTION_CODE , CT.LAST_UPDATE_DATE , CT.LAST_UPDATED_BY , CT.CREATION_DATE , CT.CREATED_BY , CT.LAST_UPDATE_LOGIN , CT.REQUEST_ID , SUBSTRB(PARTY.PARTY_NAME,1,50) , RAC_BILL.ACCOUNT_NUMBER , BS.NAME , BS.AUTO_TRX_NUMBERING_FLAG , BS.COPY_DOC_NUMBER_FLAG , CTT.NAME , CTT.TYPE , CTT.POST_TO_GL , CTT.ACCOUNTING_AFFECT_FLAG , CTT.ALLOW_FREIGHT_FLAG , CTT.CREATION_SIGN , CTT.ALLOW_OVERAPPLICATION_FLAG , CTT.NATURAL_APPLICATION_ONLY_FLAG , CTT.TAX_CALCULATION_FLAG , CTT.DEFAULT_STATUS , CTT.DEFAULT_TERM , CTT.DEFAULT_PRINTING_OPTION , DECODE(CT.INVOICING_RULE_ID, NULL, 'N', 'Y') , DECODE(CT.PRINTING_LAST_PRINTED, NULL, 'N', 'Y') , DECODE(CT.PREVIOUS_CUSTOMER_TRX_ID, NULL, 'N', 'Y') , RAC_BILL.STATUS , CT.GLOBAL_ATTRIBUTE21 , CT.GLOBAL_ATTRIBUTE22 , CT.GLOBAL_ATTRIBUTE23 , CT.GLOBAL_ATTRIBUTE24 , CT.GLOBAL_ATTRIBUTE15 , CT.GLOBAL_ATTRIBUTE26 , CT.GLOBAL_ATTRIBUTE27 , CT.GLOBAL_ATTRIBUTE28 , CT.GLOBAL_ATTRIBUTE29 , CT.GLOBAL_ATTRIBUTE30 , BS.BATCH_SOURCE_TYPE , CT.ORG_ID , CT.LEGAL_ENTITY_ID FROM RA_CUSTOMER_TRX CT, HZ_CUST_ACCOUNTS RAC_BILL, HZ_PARTIES PARTY, RA_BATCH_SOURCES_ALL BS, RA_CUST_TRX_TYPES_ALL CTT WHERE CT.BILL_TO_CUSTOMER_ID = RAC_BILL.CUST_ACCOUNT_ID AND RAC_BILL.PARTY_ID = PARTY.PARTY_ID AND CT.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID AND CT.ORG_ID = BS.ORG_ID AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID AND CT.ORG_ID = CTT.ORG_ID AND CTT.TYPE NOT IN ('BR','CB','GUAR') AND CT.COMPLETE_FLAG = 'Y'

View Text - HTML Formatted

SELECT CT.ROWID
, CT.CUSTOMER_TRX_ID
, CT.TRX_NUMBER
, CT.OLD_TRX_NUMBER
, CT.RECURRED_FROM_TRX_NUMBER
, CT.TRX_DATE
, CT.PREVIOUS_CUSTOMER_TRX_ID
, CT.INITIAL_CUSTOMER_TRX_ID
, CT.RELATED_BATCH_SOURCE_ID
, CT.RELATED_CUSTOMER_TRX_ID
, CT.CUST_TRX_TYPE_ID
, CT.BATCH_ID
, CT.BATCH_SOURCE_ID
, CT.REASON_CODE
, CT.TERM_ID
, CT.PRIMARY_SALESREP_ID
, CT.AGREEMENT_ID
, CT.CREDIT_METHOD_FOR_RULES
, CT.CREDIT_METHOD_FOR_INSTALLMENTS
, CT.RECEIPT_METHOD_ID
, CT.INVOICING_RULE_ID
, CT.SHIP_VIA
, CT.FOB_POINT
, CT.FINANCE_CHARGES
, CT.COMPLETE_FLAG
, CT.CUSTOMER_BANK_ACCOUNT_ID
, CT.RECURRED_FROM_TRX_NUMBER
, CT.STATUS_TRX
, CT.DEFAULT_TAX_EXEMPT_FLAG
, CT.SOLD_TO_CUSTOMER_ID
, CT.SOLD_TO_SITE_USE_ID
, CT.SOLD_TO_CONTACT_ID
, CT.BILL_TO_CUSTOMER_ID
, CT.BILL_TO_SITE_USE_ID
, CT.BILL_TO_CONTACT_ID
, CT.SHIP_TO_CUSTOMER_ID
, CT.SHIP_TO_SITE_USE_ID
, CT.SHIP_TO_CONTACT_ID
, CT.REMIT_TO_ADDRESS_ID
, CT.INVOICE_CURRENCY_CODE
, CT.CREATED_FROM
, CT.SET_OF_BOOKS_ID
, CT.PRINTING_ORIGINAL_DATE
, CT.PRINTING_LAST_PRINTED
, CT.PRINTING_OPTION
, CT.PRINTING_COUNT
, CT.PRINTING_PENDING
, CT.LAST_PRINTED_SEQUENCE_NUM
, CT.PURCHASE_ORDER
, CT.PURCHASE_ORDER_REVISION
, CT.PURCHASE_ORDER_DATE
, CT.CUSTOMER_REFERENCE
, CT.CUSTOMER_REFERENCE_DATE
, CT.COMMENTS
, CT.INTERNAL_NOTES
, CT.EXCHANGE_RATE_TYPE
, CT.EXCHANGE_DATE
, CT.EXCHANGE_RATE
, CT.TERRITORY_ID
, CT.END_DATE_COMMITMENT
, CT.START_DATE_COMMITMENT
, CT.ORIG_SYSTEM_BATCH_NAME
, CT.SHIP_DATE_ACTUAL
, CT.WAYBILL_NUMBER
, CT.DOC_SEQUENCE_ID
, CT.DOC_SEQUENCE_VALUE
, CT.PAYING_CUSTOMER_ID
, CT.PAYING_SITE_USE_ID
, CT.ATTRIBUTE_CATEGORY
, CT.ATTRIBUTE1
, CT.ATTRIBUTE2
, CT.ATTRIBUTE3
, CT.ATTRIBUTE4
, CT.ATTRIBUTE5
, CT.ATTRIBUTE6
, CT.ATTRIBUTE7
, CT.ATTRIBUTE8
, CT.ATTRIBUTE9
, CT.ATTRIBUTE10
, CT.ATTRIBUTE11
, CT.ATTRIBUTE12
, CT.ATTRIBUTE13
, CT.ATTRIBUTE14
, CT.ATTRIBUTE15
, CT.INTERFACE_HEADER_CONTEXT
, CT.INTERFACE_HEADER_ATTRIBUTE1
, CT.INTERFACE_HEADER_ATTRIBUTE2
, CT.INTERFACE_HEADER_ATTRIBUTE3
, CT.INTERFACE_HEADER_ATTRIBUTE4
, CT.INTERFACE_HEADER_ATTRIBUTE5
, CT.INTERFACE_HEADER_ATTRIBUTE6
, CT.INTERFACE_HEADER_ATTRIBUTE7
, CT.INTERFACE_HEADER_ATTRIBUTE8
, CT.INTERFACE_HEADER_ATTRIBUTE9
, CT.INTERFACE_HEADER_ATTRIBUTE10
, CT.INTERFACE_HEADER_ATTRIBUTE11
, CT.INTERFACE_HEADER_ATTRIBUTE12
, CT.INTERFACE_HEADER_ATTRIBUTE13
, CT.INTERFACE_HEADER_ATTRIBUTE14
, CT.INTERFACE_HEADER_ATTRIBUTE15
, CT.GLOBAL_ATTRIBUTE1
, CT.GLOBAL_ATTRIBUTE2
, CT.GLOBAL_ATTRIBUTE3
, CT.GLOBAL_ATTRIBUTE4
, CT.GLOBAL_ATTRIBUTE5
, CT.GLOBAL_ATTRIBUTE6
, CT.GLOBAL_ATTRIBUTE7
, CT.GLOBAL_ATTRIBUTE8
, CT.GLOBAL_ATTRIBUTE9
, CT.GLOBAL_ATTRIBUTE10
, CT.GLOBAL_ATTRIBUTE11
, CT.GLOBAL_ATTRIBUTE12
, CT.GLOBAL_ATTRIBUTE13
, CT.GLOBAL_ATTRIBUTE14
, CT.GLOBAL_ATTRIBUTE15
, CT.GLOBAL_ATTRIBUTE16
, CT.GLOBAL_ATTRIBUTE17
, CT.GLOBAL_ATTRIBUTE18
, CT.GLOBAL_ATTRIBUTE19
, CT.GLOBAL_ATTRIBUTE20
, CT.GLOBAL_ATTRIBUTE_CATEGORY
, CT.DEFAULT_USSGL_TRANSACTION_CODE
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATED_BY
, CT.CREATION_DATE
, CT.CREATED_BY
, CT.LAST_UPDATE_LOGIN
, CT.REQUEST_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, RAC_BILL.ACCOUNT_NUMBER
, BS.NAME
, BS.AUTO_TRX_NUMBERING_FLAG
, BS.COPY_DOC_NUMBER_FLAG
, CTT.NAME
, CTT.TYPE
, CTT.POST_TO_GL
, CTT.ACCOUNTING_AFFECT_FLAG
, CTT.ALLOW_FREIGHT_FLAG
, CTT.CREATION_SIGN
, CTT.ALLOW_OVERAPPLICATION_FLAG
, CTT.NATURAL_APPLICATION_ONLY_FLAG
, CTT.TAX_CALCULATION_FLAG
, CTT.DEFAULT_STATUS
, CTT.DEFAULT_TERM
, CTT.DEFAULT_PRINTING_OPTION
, DECODE(CT.INVOICING_RULE_ID
, NULL
, 'N'
, 'Y')
, DECODE(CT.PRINTING_LAST_PRINTED
, NULL
, 'N'
, 'Y')
, DECODE(CT.PREVIOUS_CUSTOMER_TRX_ID
, NULL
, 'N'
, 'Y')
, RAC_BILL.STATUS
, CT.GLOBAL_ATTRIBUTE21
, CT.GLOBAL_ATTRIBUTE22
, CT.GLOBAL_ATTRIBUTE23
, CT.GLOBAL_ATTRIBUTE24
, CT.GLOBAL_ATTRIBUTE15
, CT.GLOBAL_ATTRIBUTE26
, CT.GLOBAL_ATTRIBUTE27
, CT.GLOBAL_ATTRIBUTE28
, CT.GLOBAL_ATTRIBUTE29
, CT.GLOBAL_ATTRIBUTE30
, BS.BATCH_SOURCE_TYPE
, CT.ORG_ID
, CT.LEGAL_ENTITY_ID
FROM RA_CUSTOMER_TRX CT
, HZ_CUST_ACCOUNTS RAC_BILL
, HZ_PARTIES PARTY
, RA_BATCH_SOURCES_ALL BS
, RA_CUST_TRX_TYPES_ALL CTT
WHERE CT.BILL_TO_CUSTOMER_ID = RAC_BILL.CUST_ACCOUNT_ID
AND RAC_BILL.PARTY_ID = PARTY.PARTY_ID
AND CT.BATCH_SOURCE_ID = BS.BATCH_SOURCE_ID
AND CT.ORG_ID = BS.ORG_ID
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND CT.ORG_ID = CTT.ORG_ID
AND CTT.TYPE NOT IN ('BR'
, 'CB'
, 'GUAR')
AND CT.COMPLETE_FLAG = 'Y'