Product: | FII - Financial Intelligence |
---|---|
Description: | This view is based on table FII_AR_RECEIPTS_F. It sotres receipts and credit memos. |
Implementation/DBA Data: | APPS.FII_AR_RECEIPTS_F_V |
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