CMR_PO_ACCRUAL_AMTS_GT_V

Details

• Schema: FUSION

• Object owner: CMR

• Object type: VIEW

Columns

Name
CMR_PO_DISTRIBUTION_ID ACCRUAL_QTY ACCRUAL_AMT NONRECOVERABLE_TAX TAX_EXCLUDE_ACCRUAL_AMOUNT ENCUMBRANCE_REVERSAL_ENTR_AMT

Query

SQL_Statement
SELECT CMR_PO_DISTRIBUTION_ID, SUM(ACCRUAL_QTY) ACCRUAL_QTY, SUM(ACCRUAL_AMT) ACCRUAL_AMT, SUM(NONRECOVERABLE_TAX) NONRECOVERABLE_TAX, SUM(TAX_EXCLUDE_ACCRUAL_AMOUNT) TAX_EXCLUDE_ACCRUAL_AMOUNT, SUM(ENCUMBRANCE_REVERSAL_ENTR_AMT) ENCUMBRANCE_REVERSAL_ENTR_AMT FROM CMR_PO_ACCRUAL_AMTS_GT GROUP BY CMR_PO_DISTRIBUTION_ID