VIEW: AR.AR_CASH_RECO_LINES_ALL#

Source

View Text - Preformatted

select RECOMMENDATION_ID RECOMMENDATION_ID, LINE_NUMBER LINE_NUMBER, CUSTOMER_TRX_ID CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, AMOUNT_APPLIED AMOUNT_APPLIED, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM, TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE, RECEIPT_DATE RECEIPT_DATE, RECOMMENDATION_REASON RECOMMENDATION_REASON, ORG_ID ORG_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, DISCOUNT_TAKEN_EARNED DISCOUNT_TAKEN_EARNED, DISCOUNT_TAKEN_UNEARNED DISCOUNT_TAKEN_UNEARNED from "AR"."AR_CASH_RECO_LINES_ALL"

View Text - HTML Formatted

SELECT RECOMMENDATION_ID RECOMMENDATION_ID
, LINE_NUMBER LINE_NUMBER
, CUSTOMER_TRX_ID CUSTOMER_TRX_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, AMOUNT_APPLIED AMOUNT_APPLIED
, AMOUNT_APPLIED_FROM AMOUNT_APPLIED_FROM
, TRANS_TO_RECEIPT_RATE TRANS_TO_RECEIPT_RATE
, RECEIPT_CURRENCY_CODE RECEIPT_CURRENCY_CODE
, RECEIPT_DATE RECEIPT_DATE
, RECOMMENDATION_REASON RECOMMENDATION_REASON
, ORG_ID ORG_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, DISCOUNT_TAKEN_EARNED DISCOUNT_TAKEN_EARNED
, DISCOUNT_TAKEN_UNEARNED DISCOUNT_TAKEN_UNEARNED
FROM "AR"."AR_CASH_RECO_LINES_ALL"