VIEW: AR.AR_ACTIVITY_DETAILS#

Source

View Text - Preformatted

select CASH_RECEIPT_ID CASH_RECEIPT_ID, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, ALLOCATED_RECEIPT_AMOUNT ALLOCATED_RECEIPT_AMOUNT, AMOUNT AMOUNT, TAX TAX, FREIGHT FREIGHT, CHARGES CHARGES, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LINE_DISCOUNT LINE_DISCOUNT, TAX_DISCOUNT TAX_DISCOUNT, FREIGHT_DISCOUNT FREIGHT_DISCOUNT, LINE_BALANCE LINE_BALANCE, TAX_BALANCE TAX_BALANCE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, COMMENTS COMMENTS, APPLY_TO APPLY_TO, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, GROUP_ID GROUP_ID, REFERENCE2 REFERENCE2, REFERENCE1 REFERENCE1, REFERENCE3 REFERENCE3, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY_MODULE CREATED_BY_MODULE, SOURCE_ID SOURCE_ID, SOURCE_TABLE SOURCE_TABLE, LINE_ID LINE_ID, CURRENT_ACTIVITY_FLAG CURRENT_ACTIVITY_FLAG, OFFSET_REC_FLAG OFFSET_REC_FLAG from "AR"."AR_ACTIVITY_DETAILS"

View Text - HTML Formatted

SELECT CASH_RECEIPT_ID CASH_RECEIPT_ID
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, ALLOCATED_RECEIPT_AMOUNT ALLOCATED_RECEIPT_AMOUNT
, AMOUNT AMOUNT
, TAX TAX
, FREIGHT FREIGHT
, CHARGES CHARGES
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LINE_DISCOUNT LINE_DISCOUNT
, TAX_DISCOUNT TAX_DISCOUNT
, FREIGHT_DISCOUNT FREIGHT_DISCOUNT
, LINE_BALANCE LINE_BALANCE
, TAX_BALANCE TAX_BALANCE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, COMMENTS COMMENTS
, APPLY_TO APPLY_TO
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, GROUP_ID GROUP_ID
, REFERENCE2 REFERENCE2
, REFERENCE1 REFERENCE1
, REFERENCE3 REFERENCE3
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE CREATED_BY_MODULE
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, LINE_ID LINE_ID
, CURRENT_ACTIVITY_FLAG CURRENT_ACTIVITY_FLAG
, OFFSET_REC_FLAG OFFSET_REC_FLAG
FROM "AR"."AR_ACTIVITY_DETAILS"