| Error Code ORA-00918 Column ambiguosly defined [message #590450] |
Thu, 18 July 2013 05:46  |
 |
imtiazg
Messages: 3
Registered: July 2013
|
Junior Member |
|
|
Hi...I have written this code below in Disco Admin 10g but get Ora-00918 column ambiguosly defined error even though I have used alias in the table name. Can anyone please tell me what the error is for? Thanks
Select
porh.segment1
,Porh.creation_date
,Porh.last_update_date
,porh.closed_code
,porh.authorization_status
,porh.description
,porh.note_to_authorizer
,porh.cancel_flag
,porh.enabled_flag
,porl.line_num
,porl.item_description
,porl.quantity
,porl.unit_price
,porl.suggested_vendor_name
,mtl.segment3
,mtl.description
,glcc.segment1
,glcc.segment2
,glcc.segment3
,glcc.segment4
,glcc.segment5
From
apps.po_requisition_headers_v porh
,apps.po_requisition_lines_v porl
,apps.Mtl_categories_v mtl
,apps.Gl_code_combinations_v glcc
Where
Porh.requisition_header_id=porl.requisition_header_id
and Porl.category_id=mtl.category_id
and Porl.charge_account_id=glcc.code_combination_id
|
|
|
|
|
|
|
|
|
|
| Re: Error Code ORA-00918 Column ambiguosly defined [message #590540 is a reply to message #590459] |
Fri, 19 July 2013 03:11  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Aha, it means that Discoverer objects because PORH.DESCRIPTION and MTL.DESCRIPTION are ambiguous ... That's different from Reports Builder (which, in such a case, automatically renames the second one to "DESCRIPTION1").
Thank you for letting us know!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
