[Home] [Help]
MATERIALIZED VIEW: APPS.OPI_MTL_VAR_ACT_MV_F
Source
SELECT
f.Organization_id Organization_id
,f.Job_type Job_type
,f.Job_id Job_Id
,f.Assembly_item_id Assembly_item_id
,f.Component_item_id Component_item_id
,f.source Source
,sum(f.ACTUAL_QUANTITY) actual_quantity
,count(f.ACTUAL_QUANTITY) actual_quantity_cnt
,sum(f.ACTUAL_VALUE_B) actual_value_b
,count(f.ACTUAL_VALUE_B) actual_value_b_cnt
,sum(f.ACTUAL_VALUE_G) actual_value_g
,count(f.ACTUAL_VALUE_G) actual_value_g_cnt
,sum(f.ACTUAL_VALUE_SG) actual_value_sg
,count(f.ACTUAL_VALUE_SG) actual_value_sg_cnt
,COUNT(*) cnt
FROM
OPI.OPI_DBI_JOB_MTL_DETAILS_F f
GROUP BY
f.Organization_id
,f.Job_id
,f.Job_type
,f.Assembly_item_id
,f.Component_item_id
,f.Source