AR_CM_NET_REVENUE_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) , sum(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) ) ) , period_set_name FROM AR_CM_NET_REV_ASSIGNMENTS_V RA group by previous_customer_trx_line_id, trunc(gl_date), previous_customer_trx_id, period_set_name