0 Replies Latest reply: May 29, 2013 4:47 AM by 1011580 RSS

    I need a help that when i am creating M-view i am facing error

    1011580
      [Error] Execution (4: 1): ORA-00905: missing keyword



      CREATE MATERIALIZED VIEW APPS.XXNBG_ITEMS
      BUILD IMMEDIATE
      REFRESH FORCE
      index RA_CUSTOMER_TRX_LINES_N2
      AS
      SELECT DISTINCT rcta.trx_number TRX_NUMBER,
      rtl.inventory_item_id INVENTORY_ITEM_ID,
      rtl.customer_trx_line_id CUSTOMER_TRX_LINE_ID,
      rtl.sales_order SALES_ORDER,
      rtl.sales_order_line SALES_ORDER_LINE,
      rtl.sales_order_date SALES_ORDER_DATE,
      rtl.interface_line_attribute11 INTERFACE_LINE_ATTRIBUTE11,
      rtl.quantity_invoiced QUANTITY_INVOICED,
      rtl.quantity_credited QUANTITY_CREDITED,
      rtl.unit_selling_price UNIT_SELLING_PRICE,
      rtl.extended_amount EXTENDED_AMOUNT,
      msi.segment1 SEGMENT1,
      msi.item_type ITEM_TYPE,
      ol.price_list_id PRICE_LIST_ID
      FROM apps.ra_customer_trx_lines_all@APPS_NBP.NAMCO.COM rtl,
      apps.mtl_system_items_b@APPS_NBP.NAMCO.COM msi,
      apps.ra_customer_trx_all@APPS_NBP.NAMCO.COM rcta,
      apps.oe_order_headers_all@APPS_NBP.NAMCO.COM oh,
      apps.oe_order_lines_all@APPS_NBP.NAMCO.COM ol
      WHERE rcta.customer_trx_id = rtl.customer_trx_id
      AND rtl.inventory_item_id = msi.inventory_item_id
      AND oh.header_id = ol.header_id
      AND rtl.interface_line_attribute1 = TO_CHAR (oh.order_number)
      AND TO_CHAR (ol.LINE_id) = rtl.interface_line_attribute6