远程oracle查询视图连接错误,查询视图 ORA-00904

请教各位:

我在查询时正常:[php]

SELECT rownum ID,

pha.segment1 po,

pha.vendor_id,

nvl(pv.vendor_name_alt, pv.vendor_name) vendor_name,

pha.currency_code currency,

pla.line_num line,

pla.creation_date,

nvl(pla.closed_code, 'open') status,

ppv.full_name NAME,

msi.segment1 item,

pla.item_description,

pll.need_by_date,

pla.unit_meas_lookup_code unit,

pla.unit_price,

pla.quantity,

pla.unit_price * pla.quantity SUM,

nvl(rt.qty, 0) rcv_qty,

pla.quantity - nvl(rt.qty, 0) residue

FROM apps.po_lines_all@ebs pla,

apps.po_headers_all@ebs pha,

apps.po_line_locations_all@ebs pll,

apps.per_people_v7@ebs ppv,

apps.mtl_system_items_b@ebs msi,

apps.po_vendors@ebs pv,

(SELECT po_line_id, SUM(quantity) qty

FROM apps.rcv_transactions@ebs

WHERE transaction_type = 'RECEIVE'

GROUP BY po_line_id) rt

WHERE pla.po_header_id = pha.po_header_id(+)

AND pla.po_line_id = pll.po_line_id(+)

AND pha.agent_id = ppv.person_id(+)

AND pla.item_id = msi.inventory_item_id(+)

AND (msi.organization_id = 202 OR msi.organization_id IS NULL)

AND pha.vendor_id = pv.vendor_id(+)

AND pla.po_line_id = rt.po_line_id(+)

and pla.org_id=184

order by pla.po_line_id desc[/php]

使用这个语句建立视图也正常:

[php]

create or replace view po_status_RT as

SELECT rownum ID,

......

......

......

[/php]

但是查询这个视图时,提示错误:

[php]

select * from po_status_RT;

[/php]

ORA-00904:"A2"."PO_LINE_ID":无效的标识符

ORA-02063:,preceding line from EBS

请教各位有什么解决方法?

[本帖最后由 kissmmx 于 2009-7-15 15:58 编辑]

xx.JPG

(9.31 KB, 下载次数: 11)

2009-7-15 15:29 上传