Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Item details with Last Transaction Date ?

RamaKrishnan SMay 12 2014 — edited Jun 10 2014

Hi,

Please help someone to fine tune this query :-

Select ILLITM,ILDOC, ILDCT, ILTRDJ

FROM CRPDTA.F4111

where ILTRDJ in (Select max(ILTRDJ) FROM CRPDTA.F4111);

The above query is returning the latest transaction date with Item details.

But expected output is: Every Item with last transactional date.

Hope I am clear on the above requirement please.

Thanks in advance.

RAM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2014
Added on May 12 2014
#designer
2 comments
2,990 views