Actually this proses is in for select do begin <the query> end

> Select distinct( base_nomor )
> from My_Header
> where
> (
> (
> ( revised_code = 'Y' )
> or
> ( POSTED_CODE = 'C' )
> )
> and
> ( TANGGAL <= :BASIS_DATE )
>
> /* <ad_condition> */
>
> and base_nomor not in
> (
> Select distinct(base_nomor)
> from My_header
> where
> (
> ( tanggal <= :BASIS_DATE )
> and
> ( POSTED_CODE = 'P' )
> and
> ( REFF_AKTIF_CODE = 'Y' )
> )
> )
>
> /* </ad_condition> */
>
>
> )

I just think to move sintax in <ad_conditon> and save to result in temporary
table and then select to temporary table. But i want to eleminate temporary
table...

Thanks