OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » how to get the item which are not using from last 2 years

Home » Applications » Oracle Fusion Apps & E-Business Suite » how to get the item which are not using from last 2 years

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

how to get the item which are not using from last 2 years [message #522626]

Mon, 12 September 2011 23:20

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...

Report message to a moderator

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

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

Code: [Select all] [Show/ hide]

select items
from your_table
where date_they_were_last_used < add_months(sysdate, -24)

Report message to a moderator

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

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

sai_434yahoocom
Messages: 22
Registered: May 2011
Location: HYDERABAD

Junior Member

si,

Can u send the query.

Thanks in advance...

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 13:40:15 CDT 2025