This discussion is archived
3 Replies Latest reply: Nov 13, 2012 6:37 AM by DanielB RSS

ORA-01722: invalid number

973552 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points