3 Replies Latest reply: Nov 13, 2012 8:37 AM by DanielB RSS

    ORA-01722: invalid number

    973552
      SELECT
      oa.OAWR_NUMBER,
      oa.OAWR_AMENDMENT,
      oa.CONTRACTOR_PO,
      oa.LINE_ITEM,
      oa.VENDNO,
      v.VENDOR_NAME,
      oa.PART_NUMBER,
      oa.PART_DESCRIPTION,
      oa.QUANTITY_REQUIRED,
      oa.PROCUREMENT_COST,
      ol.UNIT_COST,
      (ol.UNIT_COST-oa.PROCUREMENT_COST) COST_ADJ,
      (oa.PROCUREMENT_COST*1.17) UNIT_PRICE,
      ((oa.QUANTITY_REQUIRED*oa.PROCUREMENT_COST)*1.17) EXT_PRICE,
      oa.TAIL_#,
      po.NG_PO_NUMBER,
      pol.NG_PO_L_I,
      oa.PART_CLIN,
      po.CONTRACT_YEAR,
      ol.ORDER_STATUS,
      st.STATUS_CODE,
      oa.BILLING_COMMENTS,
      oa.BATCH,
      org.origin_code,
      oa.INITIATOR
      FROM kc10_vendor_order_lines ol,OAWR_REGISTER oa, oawr_po po, oawr_po_line pol, KC10_VENDORS v, oawr_status st, order_type_origin oto, origin org
      WHERE oa.contractor_po=ol.ORDER_NUMBER(+)
      and oa.LINE_ITEM =ol.ORDER_LINE_ITEM(+)
      AND oa.VENDNO=v.VENDOR_NUMBER(+)
      and oa.material_po_item_id is not null
      and oa.material_po_item_id = pol.oawr_po_line_id
      and pol.oawr_po_id = po.oawr_po_id
      and oa.trackingstatus = st.status_id
      AND oa.MATERIAL_INVOICE_# IS NULL
      AND ol.ORDER_STATUS IN ('P','T')
      and oa.order_type_origin_id = oto.order_type_origin_id
      and oto.origin_id = org.origin_id