select a.col1
,a.col2
,b.col1
,b.col2
from A a
,B b
where a.bookid=b.bookid
and 1=
(
case
when a.secid=0 and a.prodid=b.prodid then 1
when a.secid=b.secid then 1
else
0
end
);
create or replace PACKAGE APPS.XXXX_PO_WF_SCHEDULING_PKG IS --|==========================================================================...
No comments:
Post a Comment