OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » workflow query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

workflow query [message #600870]

Wed, 13 November 2013 06:34

mist598
Messages: 1195
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

Report message to a moderator

Re: workflow query [message #601022 is a reply to message #600870]

Thu, 14 November 2013 13:53

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: workflow query [message #601026 is a reply to message #600870]

Thu, 14 November 2013 16:18

John Watson
Messages: 8960
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.

Report message to a moderator

Re: workflow query [message #601031 is a reply to message #601022]

Thu, 14 November 2013 22:48

mist598
Messages: 1195
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

Report message to a moderator

Previous Topic:	UPDATE_BUDGET
Next Topic:	OFSAA

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:11:56 CST 2024