MATERIALIZED VIEW: APPS.ASO_BI_QLIN_L1_MV

Source

SELECT  FACT.Rowid Qrowid,
        STAR.Rowid Srowid,
        FACT.Resource_id Resource_Id,
        FACT.Resource_grp_id Resource_Grp_Id,
        FACT.line_quote_value * FACT.Reporting_conversion_rate Line_amount,
        FACT.line_quote_value * FACT.sec_conversion_rate sec_Line_amount,
        STAR.Vbh_Category_id Category_id,
        DECODE(STAR.Master_id,NULL,STAR.id,STAR.Master_id) Master_id,
        FACT.Quote_creation_date,
        FACT.Order_creation_date,
        FACT.Quote_expiration_date,
        FACT.Order_id
FROM  ASO.ASO_BI_QUOTE_LINES_ALL FACT,
      ENI.ENI_OLTP_ITEM_STAR STAR
WHERE 
      FACT.Inventory_item_id = STAR.inventory_item_id
AND   FACT.Organization_id = STAR.Organization_id
AND   FACT.Resource_grp_id is NOT NULL
AND FACT. CHARGE_PERIODICITY_CODE IS NULL