AR_CM_NET_REV_DIST_FORM_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
PREVIOUS_CUSTOMER_TRX_LINE_ID PREVIOUS_CUSTOMER_TRX_ID GL_DATE AMOUNT NET_UNIT_PRICE PERIOD_SET_NAME

Query

SQL_Statement

SELECT PREVIOUS_CUSTOMER_TRX_LINE_ID, PREVIOUS_CUSTOMER_TRX_ID, TRUNC(GL_DATE) GL_DATE, SUM(AMOUNT) AMOUNT, SUM(DECODE(CREDIT_METHOD_FOR_RULES, 'UNIT', 0, 'LIFO', 0, AMOUNT)) / DECODE(SUM(DECODE(CREDIT_METHOD_FOR_RULES, '', QUANTITY, 0)), 0, 1, SUM(DECODE(CREDIT_METHOD_FOR_RULES, '', QUANTITY, 0))) NET_UNIT_PRICE, PERIOD_SET_NAME FROM AR_CM_NET_DISTS_V ra GROUP BY PREVIOUS_CUSTOMER_TRX_LINE_ID, TRUNC(GL_DATE), PREVIOUS_CUSTOMER_TRX_ID, PERIOD_SET_NAME