CMR_ACCRUAL_CLEARING_INFO_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CMR
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 |