SQL & PL/SQL

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!

Sql Query..

753772Aug 26 2010 — edited Aug 26 2010

Hi All,

In the receiving table, we have destination_code as ('RECEVING,'EXPENSE','INVENTORY') in RCV_TRANSACTIONS now if the receipt is recived completed the same transaction will have two line receiving and expense or inventory. Now i want to write a query to get all the records which are partially received so only the records with 'RECEIVING' as destination_code. Could any one get me how to get it done.

Ashish

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2010

Added on Aug 26 2010

11 comments

3,441 views