VIEW: APPS.FII_AR_RECEIPTS_F_V

Source

View Text - Preformatted

SELECT RECEIVABLE_APPLICATION_ID, TIME_ID, CASH_RECEIPT_ID, APPLICATION_STATUS, HEADER_STATUS, AMOUNT_APPLIED_RCT, AMOUNT_APPLIED_TRX, AMOUNT_APPLIED_RCT_FUNC, AMOUNT_APPLIED_TRX_FUNC, AMOUNT_APPLIED_RCT_PRIM, AMOUNT_APPLIED_TRX_PRIM, AMOUNT_APPLIED_RCT_SEC, AMOUNT_APPLIED_TRX_SEC, EARNED_DISCOUNT_AMOUNT_TRX, EARNED_DISCOUNT_AMOUNT_FUNC, EARNED_DISCOUNT_AMOUNT_PRIM, EARNED_DISCOUNT_AMOUNT_SEC, UNEARNED_DISCOUNT_AMOUNT_TRX, UNEARNED_DISCOUNT_AMOUNT_FUNC, UNEARNED_DISCOUNT_AMOUNT_PRIM, UNEARNED_DISCOUNT_AMOUNT_SEC, APPLY_DATE, GL_DATE, FILTER_DATE, APPLICATION_TYPE, APPLIED_PAYMENT_SCHEDULE_ID, APPLIED_CUSTOMER_TRX_ID, CUSTOMER_TRX_ID, PAYMENT_SCHEDULE_ID, RECEIPT_NUMBER, RECEIPT_TYPE, RECEIPT_DATE, RCT_ACTUAL_DATE_CLOSED, RECEIPT_METHOD_ID, CURRENCY_CODE, USER_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID, COLLECTOR_BILL_TO_CUSTOMER_ID, COLLECTOR_BILL_TO_SITE_USE_ID, ORG_ID, TRX_DATE, DUE_DATE, CM_PREVIOUS_CUSTOMER_TRX_ID, TOTAL_RECEIPT_COUNT, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, AR_CREATION_DATE, HEADER_FILTER_DATE, CASE WHEN APPLICATION_STATUS = 'UNAPP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT ELSE 0 END UNAPP_AMOUNT, CASE WHEN APPLICATION_STATUS = 'UNAPP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_FUNC ELSE 0 END UNAPP_AMOUNT_FUNC, CASE WHEN APPLICATION_STATUS = 'UNAPP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_PRIM ELSE 0 END UNAPP_AMOUNT_PRIM, CASE WHEN APPLICATION_STATUS = 'UNAPP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_SEC ELSE 0 END UNAPP_AMOUNT_SEC, CASE WHEN APPLICATION_STATUS = 'UNID' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT ELSE 0 END UNID_AMOUNT, CASE WHEN APPLICATION_STATUS = 'UNID' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_FUNC ELSE 0 END UNID_AMOUNT_FUNC, CASE WHEN APPLICATION_STATUS = 'UNID' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_PRIM ELSE 0 END UNID_AMOUNT_PRIM, CASE WHEN APPLICATION_STATUS = 'UNID' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_SEC ELSE 0 END UNID_AMOUNT_SEC, CASE WHEN APPLICATION_STATUS = 'APP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT ELSE 0 END APP_AMOUNT, CASE WHEN APPLICATION_STATUS = 'APP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_FUNC ELSE 0 END APP_AMOUNT_FUNC, CASE WHEN APPLICATION_STATUS = 'APP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_PRIM ELSE 0 END APP_AMOUNT_PRIM, CASE WHEN APPLICATION_STATUS = 'APP' AND HEADER_STATUS NOT IN ('REV', 'NSF', 'STOP') AND NVL(APPLIED_PAYMENT_SCHEDULE_ID, 1) > 0 AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_SEC ELSE 0 END APP_AMOUNT_SEC FROM FII_AR_RECEIPTS_F

View Text - HTML Formatted

SELECT RECEIVABLE_APPLICATION_ID
, TIME_ID
, CASH_RECEIPT_ID
, APPLICATION_STATUS
, HEADER_STATUS
, AMOUNT_APPLIED_RCT
, AMOUNT_APPLIED_TRX
, AMOUNT_APPLIED_RCT_FUNC
, AMOUNT_APPLIED_TRX_FUNC
, AMOUNT_APPLIED_RCT_PRIM
, AMOUNT_APPLIED_TRX_PRIM
, AMOUNT_APPLIED_RCT_SEC
, AMOUNT_APPLIED_TRX_SEC
, EARNED_DISCOUNT_AMOUNT_TRX
, EARNED_DISCOUNT_AMOUNT_FUNC
, EARNED_DISCOUNT_AMOUNT_PRIM
, EARNED_DISCOUNT_AMOUNT_SEC
, UNEARNED_DISCOUNT_AMOUNT_TRX
, UNEARNED_DISCOUNT_AMOUNT_FUNC
, UNEARNED_DISCOUNT_AMOUNT_PRIM
, UNEARNED_DISCOUNT_AMOUNT_SEC
, APPLY_DATE
, GL_DATE
, FILTER_DATE
, APPLICATION_TYPE
, APPLIED_PAYMENT_SCHEDULE_ID
, APPLIED_CUSTOMER_TRX_ID
, CUSTOMER_TRX_ID
, PAYMENT_SCHEDULE_ID
, RECEIPT_NUMBER
, RECEIPT_TYPE
, RECEIPT_DATE
, RCT_ACTUAL_DATE_CLOSED
, RECEIPT_METHOD_ID
, CURRENCY_CODE
, USER_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_SITE_USE_ID
, COLLECTOR_BILL_TO_CUSTOMER_ID
, COLLECTOR_BILL_TO_SITE_USE_ID
, ORG_ID
, TRX_DATE
, DUE_DATE
, CM_PREVIOUS_CUSTOMER_TRX_ID
, TOTAL_RECEIPT_COUNT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, AR_CREATION_DATE
, HEADER_FILTER_DATE
, CASE WHEN APPLICATION_STATUS = 'UNAPP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT ELSE 0 END UNAPP_AMOUNT
, CASE WHEN APPLICATION_STATUS = 'UNAPP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_FUNC ELSE 0 END UNAPP_AMOUNT_FUNC
, CASE WHEN APPLICATION_STATUS = 'UNAPP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_PRIM ELSE 0 END UNAPP_AMOUNT_PRIM
, CASE WHEN APPLICATION_STATUS = 'UNAPP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_SEC ELSE 0 END UNAPP_AMOUNT_SEC
, CASE WHEN APPLICATION_STATUS = 'UNID'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT ELSE 0 END UNID_AMOUNT
, CASE WHEN APPLICATION_STATUS = 'UNID'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_FUNC ELSE 0 END UNID_AMOUNT_FUNC
, CASE WHEN APPLICATION_STATUS = 'UNID'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_PRIM ELSE 0 END UNID_AMOUNT_PRIM
, CASE WHEN APPLICATION_STATUS = 'UNID'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_SEC ELSE 0 END UNID_AMOUNT_SEC
, CASE WHEN APPLICATION_STATUS = 'APP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT ELSE 0 END APP_AMOUNT
, CASE WHEN APPLICATION_STATUS = 'APP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_FUNC ELSE 0 END APP_AMOUNT_FUNC
, CASE WHEN APPLICATION_STATUS = 'APP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_PRIM ELSE 0 END APP_AMOUNT_PRIM
, CASE WHEN APPLICATION_STATUS = 'APP'
AND HEADER_STATUS NOT IN ('REV'
, 'NSF'
, 'STOP')
AND NVL(APPLIED_PAYMENT_SCHEDULE_ID
, 1) > 0
AND APPLICATION_TYPE = 'CASH' THEN AMOUNT_APPLIED_RCT_SEC ELSE 0 END APP_AMOUNT_SEC
FROM FII_AR_RECEIPTS_F