MATERIALIZED VIEW: APPS.CSD_RETURNS_BI_POM_MV

Source

(SELECT "A3"."OPERATING_UNIT_ID" "OPERATING_UNIT_ID","A3"."INVENTORY_ORG_ID" "INVENTORY_ORG_ID","A3"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID",(-1)*SUM("A3"."RECEIVED_QUANTITY") "TOTAL_QUANTITY","A3"."PRIMARY_UOM_CODE" "PRIMARY_UOM_CODE","A3"."TRANSACTION_DATE" "TRANSACTION_DATE",(-1)*SUM("A3"."RECEIVED_WEIGHT") "TOTAL_WEIGHT","A3"."WEIGHT_UOM_CODE" "WEIGHT_UOM_CODE","A3"."CATEGORY_ID" "CATEGORY_ID","A3"."CATEGORY_SET_ID" "CATEGORY_SET_ID","A3"."SHIP_GEOGRAPHY_TYPE" "SHIP_GEOGRAPHY_TYPE","A3"."SHIP_GEOGRAPHY_ID" "SHIP_GEOGRAPHY_ID","A3"."CUSTOMER_TYPE" "CUSTOMER_TYPE" FROM "CSD"."CSD_RETURNS_BI_RCV_TXNS_F" "A3" WHERE "A3"."POM_OFFSET"='T' GROUP BY "A3"."INVENTORY_ITEM_ID","A3"."PRIMARY_UOM_CODE","A3"."INVENTORY_ORG_ID","A3"."TRANSACTION_DATE","A3"."OPERATING_UNIT_ID","A3"."WEIGHT_UOM_CODE","A3"."CATEGORY_ID","A3"."CATEGORY_SET_ID","A3"."SHIP_GEOGRAPHY_TYPE","A3"."SHIP_GEOGRAPHY_ID","A3"."CUSTOMER_TYPE") UNION ALL  (SELECT "A2"."OPERATING_UNIT_ID" "OPERATING_UNIT_ID","A2"."INVENTORY_ORG_ID" "INVENTORY_ORG_ID","A2"."INVENTORY_ITEM_ID" "INVENTORY_ITEM_ID",SUM("A2"."SHIPPED_QUANTITY") "TOTAL_QUANTITY","A2"."PRIMARY_UOM_CODE" "PRIMARY_UOM_CODE","A2"."TRANSACTION_DATE" "TRANSACTION_DATE",SUM("A2"."SHIPPED_WEIGHT") "TOTAL_WEIGHT","A2"."WEIGHT_UOM_CODE" "WEIGHT_UOM_CODE","A2"."CATEGORY_ID" "CATEGORY_ID","A2"."CATEGORY_SET_ID" "CATEGORY_SET_ID","A2"."SHIP_GEOGRAPHY_TYPE" "SHIP_GEOGRAPHY_TYPE","A2"."SHIP_GEOGRAPHY_ID" "SHIP_GEOGRAPHY_ID","A2"."CUSTOMER_TYPE" "CUSTOMER_TYPE" FROM "CSD"."CSD_RETURNS_BI_SHP_TXNS_F" "A2" GROUP BY "A2"."INVENTORY_ITEM_ID","A2"."PRIMARY_UOM_CODE","A2"."INVENTORY_ORG_ID","A2"."TRANSACTION_DATE","A2"."OPERATING_UNIT_ID","A2"."WEIGHT_UOM_CODE","A2"."CATEGORY_ID","A2"."CATEGORY_SET_ID","A2"."SHIP_GEOGRAPHY_TYPE","A2"."SHIP_GEOGRAPHY_ID","A2"."CUSTOMER_TYPE")