CMR_ACCRUAL_CLEARING_INFO_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
CMR_PO_DISTRIBUTION_ID ACCRUAL_CLR_RULE_NAME ACCRUAL_STATUS START_DATE END_DATE ACCRUAL_PROCESS_STATUS DELIVERY_PROCESS_STATUS CMR_ACCRUAL_AMT AP_ACCRUAL_AMT ACCRUAL_CLR_AMT

Query

SQL_Statement
SELECT cmr_po_distribution_id, accrual_clr_rule_name, accrual_status, accrual_cleared_date start_date, nvl(LEAD(accrual_cleared_date) OVER(PARTITION BY cmr_po_distribution_id ORDER BY accrual_cleared_date ), TO_DATE('12/31/4712', 'mm/dd/yyyy')) end_date, accrual_process_status, delivery_process_status, cmr_accrual_amt, ap_accrual_amt, accrual_clr_amt FROM fusion.cmr_auto_accrual_clr_dtls