Home » Applications » Oracle Fusion Apps & E-Business Suite » how to get the item which are not using from last 2 years
how to get the item which are not using from last 2 years [message #522626] Mon, 12 September 2011 23:20 Go to next message
sai_434yahoocom
Messages: 22
Registered: May 2011
Location: HYDERABAD
Junior Member
Dear sir,

how to get the item which are not using from last 2 years

thanks in advance...
Re: how to get the item which are not using from last 2 years [message #522627 is a reply to message #522626] Tue, 13 September 2011 00:05 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't use Oracle Apps., but - generally speaking - these would be items whose date (they were last used) was before "current date minus 24 months":
select items
from your_table
where date_they_were_last_used < add_months(sysdate, -24)
Re: how to get the item which are not using from last 2 years [message #522783 is a reply to message #522626] Tue, 13 September 2011 22:31 Go to previous messageGo to next message
jayaharan76
Messages: 62
Registered: June 2006
Location: BANGALORE
Member

If you wanted to take it through Front end application

1) First note down the Item org assignment - in which org the item assigned

2) Check in the Material Transaction window (or) check through back-end in the respective MTL_TRANSACTIONS table - select with the required Date range

Hope it helps

Cheers, Jay

[Updated on: Tue, 13 September 2011 22:35]

Report message to a moderator

Re: how to get the item which are not using from last 2 years [message #522784 is a reply to message #522783] Tue, 13 September 2011 22:52 Go to previous message
sai_434yahoocom
Messages: 22
Registered: May 2011
Location: HYDERABAD
Junior Member
si,

Can u send the query.

Thanks in advance...
Previous Topic: Reorder qunaity column in MIN-MAX Planning report
Next Topic: How to calculate YTD credit amount and YTD Debit amount
Goto Forum:
  


Current Time: Wed Sep 17 16:53:31 CDT 2014

Total time taken to generate the page: 0.06929 seconds