Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Strange problem.

Re: Strange problem.

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 07 Dec 2005 03:12:07 GMT
Message-ID: <Xns9724C37676181SunnySD@70.168.83.30>


Chuck <skilover_nospam_at_bluebottle.com> wrote in news:1133889203.ba727e1adc34c4abde94a39bd7453edb_at_news.nntpserver.com:

> I have an update that I'm trying to optimize.
>
> UPDATE PS_TL_PAYABLE_TIME
> SET PAYABLE_STATUS = 'RP'
> WHERE PAY_SYSTEM = 'NA'
> AND PAYABLE_STATUS NOT IN ('PD', 'DL')
> AND PAYROLL_REQ_NUM <> 1
> AND EXISTS (
> SELECT 'X'
> FROM PS_TL_XREF_TBL A, PS_PY_XREF_WRK B
> WHERE A.PAY_SYSTEM = 'NA'
> AND A.SEQ_NBR = PS_TL_PAYABLE_TIME.SEQ_NBR
> AND B.XREF_NUM = A.XREF_NUM
> AND B.PROCESS_INSTANCE = :1)
 UPDATE PS_TL_PAYABLE_TIME
    SET PAYABLE_STATUS = 'RP'
  WHERE PAY_SYSTEM = 'NA'
    AND PAYABLE_STATUS NOT IN ('PD', 'DL')     AND PAYROLL_REQ_NUM <> 1
    AND EXISTS (

           SELECT 'X'
             FROM PS_TL_XREF_TBL A,
            WHERE A.PAY_SYSTEM = 'NA'
              AND A.SEQ_NBR = PS_TL_PAYABLE_TIME.SEQ_NBR
              AND A.XREF_NUM in (SELECT B.XREF_NUM FROM  PS_PY_XREF_WRK B
                                 WHERE B.PROCESS_INSTANCE = :1
                                )
                )
Received on Tue Dec 06 2005 - 21:12:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US