Home » Applications » Oracle Fusion Apps & E-Business Suite » workflow query
workflow query [message #600870] Wed, 13 November 2013 06:34 Go to next message
mist598
Messages: 1029
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

Help me on this query please

SELECT 
  a.order_number,
  a.header_id,
  b.line_id,
  c.activity_status,
  b.flow_status_code
FROM 
  oe_order_headers_all a,
  oe_order_lines_all b,
  wf_item_activity_statuses c,
  wf_process_activities d,
  wf_activities_vl e
WHERE  a.header_id = b.header_id
  AND c.item_key = to_char (b.line_id)      
  AND d.instance_id = c.process_activity       
  AND a.order_number = 4721
  and e.ITEM_TYPE='OEOL'--d.PROCESS_ITEM_TYPE--'OEOL'
  AND b.ato_line_id IS NULL     
  AND b.ship_from_org_id = 604
 -- and e.RUNNABLE_FLAG='Y'


Thank you in advance
Surya
Re: workflow query [message #601022 is a reply to message #600870] Thu, 14 November 2013 13:53 Go to previous messageGo to next message
Littlefoot
Messages: 19822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'd put a fair amount of money, betting that someone who posted more than 200 messages on this forum knows how to ask a question. I'd lose.

Man, you posted a query and said "help". What do you think, how much would it cost if you actually explained what kind of help you expect? (It wouldn't cost anything). So, what's wrong with that query? Looks pretty fine to me, it is nicely formatted (although I'd omit commented lines as they don't contribute positively to the picture, they just distract attention). In my opinion, it is OK and you don't need any help.
Re: workflow query [message #601026 is a reply to message #600870] Thu, 14 November 2013 16:18 Go to previous messageGo to next message
John Watson
Messages: 4806
Registered: January 2010
Location: Global Village
Senior Member
I think this is another instance of the problems caused by not using ANSI join syntax: you have a horrible jumble of joins and filters in the predicate, and have ended up with a cross join to to E. Use ANSI syntax, and this will not happen.
Otherwise, add a predicate that joins E to some other table.
Re: workflow query [message #601031 is a reply to message #601022] Thu, 14 November 2013 22:48 Go to previous message
mist598
Messages: 1029
Registered: February 2013
Location: Hyderabad
Senior Member
Hi Littlefoot,

Quote:
I'd put a fair amount of money, betting that someone who posted more than 200 messages on this forum knows how to ask a question. I'd lose.

Man, you posted a query and said "help". What do you think, how much would it cost if you actually explained what kind of help you expect? (It wouldn't cost anything). So, what's wrong with that query? Looks pretty fine to me, it is nicely formatted (although I'd omit commented lines as they don't contribute positively to the picture, they just distract attention). In my opinion, it is OK and you don't need any help.


I posted wrong way , actually i am getting no of records and i want only few records only and once again sorry for wrong post

Thank you
Previous Topic: UPDATE_BUDGET
Next Topic: OFSAA
Goto Forum:
  


Current Time: Fri Nov 28 06:54:59 CST 2014

Total time taken to generate the page: 0.12744 seconds