
TKPROF: Release 8.1.7.4.0 - Production on Mon Dec 18 12:49:57 2006

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

Trace file: sty_prod_ora_11020.trc
Sort options: prsela  fchela  exeela  
********************************************************************************
count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing 
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call
********************************************************************************

SELECT OHXACT,  
OHINVTYPE,OHINVAMT_DOC,OHINVAMT_GL,NVL(OHOPNAMT_DOC,OHINVAMT_DOC),NVL(OHOPNAMT_GL,OHINVAMT_GL),
DOCUMENT_CURRENCY,GL_CURRENCY,to_char(OHREFDATE,'YYYYMMDD'),
to_char(OHENTDATE,'YYYYMMDD'),to_char(CONVDATE_EXCHANGE,'YYYYMMDD'),
OHGLAR,OHREFNUM,OHSTATUS,GL_CONVRATETYPE_ID,
0,0,0,0,0,0,0,'','',0,0,'','',
'',
'',0,0,0,0,'0'
FROM ORDERHDR_ALL 
WHERE CUSTOMER_ID  = :v1 
AND OHSTATUS = 'CO'          
AND (    OHREFDATE >= to_date(:v2,'YYYYMMDD') 
AND OHREFDATE < to_date(:v3,'YYYYMMDD') 
OR OHOPNAMT_DOC  < 0 )
FOR UPDATE OF OHOPNAMT_DOC

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute    578      7.73     302.83      24961      37591       2324           0
Fetch     2848      0.84       0.79          0      36790          0        2269
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     3426      8.57     303.62      24961      74381       2324        2269

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FOR UPDATE
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'ORDERHDR_ALL'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'OH_CUST_ID_1' 
                (NON-UNIQUE)

********************************************************************************

SELECT 0,  
0,0,0,0,0,0,0,'','','','','','',1,
CAXACT,CACHKAMT_PAY,CACHKAMT_GL,CACURAMT_PAY,CACURAMT_GL,
CADISAMT_PAY,CADISAMT_GL,to_char(CACHKDATE,'YYYYMMDD'),
CAPP,CAREASONCODE,0,
to_char(CAENTDATE,'YYYYMMDD'),to_char(CARECDATE,'YYYYMMDD'),
CAGLCASH,
CAGLDIS,
PAYMENT_CURRENCY,GL_CURRENCY,CONVRATETYPE_DOC,CONVRATETYPE_GL,CATYPE
FROM CASHRECEIPTS_ALL 
WHERE CUSTOMER_ID  = :v1 
AND CAENTDATE   <  to_date(:v2,'YYYYMMDD') 
AND CAENTDATE   >= to_date(:v3,'YYYYMMDD') 
AND MOD( NVL( CAREASONCODE, 0 ), 2 ) != 0 
AND ( CATYPE IN ('9','1', '3','13', '14','4' ) 
OR ( CATYPE IN ('7','8' ) 
AND NOT EXISTS 
( SELECT OH.OHXACT 
FROM CASHDETAIL   CD, 
ORDERHDR_ALL OH  
WHERE CAXACT      = CD.CADXACT (+)
AND CD.CADOXACT = OH.OHXACT  (+)
AND OH.OHSTATUS = 'DP' ))) 
UNION ALL
SELECT 0,  
0,0,0,0,0,0,0,'','','','','','',1,
CAXACT,CACHKAMT_PAY,CACHKAMT_GL,CACURAMT_PAY,CACURAMT_GL,
CADISAMT_PAY,CADISAMT_GL,to_char(CACHKDATE,'YYYYMMDD'),
CAPP,CAREASONCODE,0,
to_char(CAENTDATE,'YYYYMMDD'),to_char(CARECDATE,'YYYYMMDD'),
CAGLCASH,
CAGLDIS,
PAYMENT_CURRENCY,GL_CURRENCY,CONVRATETYPE_DOC,CONVRATETYPE_GL,CATYPE
FROM CASHRECEIPTS_ALL 
WHERE CUSTOMER_ID  = :v1 
AND (     MOD(NVL(CAREASONCODE,0),2) =0
AND CARECDATE <  to_date(:v2,'YYYYMMDD') 
AND CARECDATE >= to_date(:v3,'YYYYMMDD') ) 
AND CATYPE IN ( '1','3', '8','13','14' )
UNION ALL
SELECT OHXACT,   
OHINVTYPE,OHINVAMT_DOC,OHINVAMT_GL,NVL(OHOPNAMT_DOC,OHINVAMT_DOC),NVL(OHOPNAMT_GL,OHINVAMT_GL),
DOCUMENT_CURRENCY,GL_CURRENCY,to_char(OHREFDATE,'YYYYMMDD'),
to_char(OHENTDATE,'YYYYMMDD'),to_char(CONVDATE_EXCHANGE,'YYYYMMDD'),
OHGLAR,OHREFNUM,OHSTATUS,GL_CONVRATETYPE_ID,
0,0,0,0,0,0,0,'','',0,0,'','',
'',
'',0,0,0,0,'0'
FROM ORDERHDR_ALL 
WHERE CUSTOMER_ID  = :v1 
AND OHINVTYPE   != 5 
AND OHSTATUS     = 'IN' 
AND OHENTDATE   <  to_date(:v2,'YYYYMMDD')  
AND OHENTDATE   >= to_date(:v3,'YYYYMMDD')  
AND NOT EXISTS 
( SELECT CR.CAXACT 
FROM CASHDETAIL       CD, 
CASHRECEIPTS_ALL CR 
WHERE OHXACT     = CD.CADOXACT (+) 
AND CD.CADXACT = CR.CAXACT   (+) 
AND CR.CATYPE  = '8' ) 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute    578      0.11       0.09          0          0          0           0
Fetch     2610      8.06     200.62      21113     123545          0        2032
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     3188      8.17     200.71      21113     123545          0        2032

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   UNION-ALL
      0    FILTER
      0     FILTER
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CASHRECEIPTS_ALL'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CASHCSINDEX' 
                  (NON-UNIQUE)
      0     NESTED LOOPS
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PKCASHDETAIL' 
                 (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'ORDERHDR_ALL'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKORDERHDR_ALL' 
                  (UNIQUE)
      0    FILTER
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'CASHRECEIPTS_ALL'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CASHCSINDEX' 
                 (NON-UNIQUE)
      0    FILTER
      0     FILTER
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'ORDERHDR_ALL'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'OH_CUST_ID_1' 
                  (NON-UNIQUE)
      0     NESTED LOOPS
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CASHDETAIL'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CASHDETAI2INDEX' 
                  (NON-UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CASHRECEIPTS_ALL'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                  'PKCASHRECEIPTS_ALL' (UNIQUE)

********************************************************************************

select CS.CO_ID ,CS.TMCODE ,CS.SPCODE ,CS.SNCODE ,CS.CS_SEQNO ,CS.CURRENCY ,
  CS.CS_ADV_CHARGE_CURRENCY ,CS.CS_STAT_CHNG ,TO_CHAR(CS.CS_DATE_BILLED,
  'YYYY-MM-DD-HH24.MI.SS') ,TO_CHAR(CS.CS_ENTDATE,'YYYY-MM-DD-HH24.MI.SS') ,
  TO_CHAR(CS.CS_ADV_CHARGE_END_DATE,'YYYY-MM-DD-HH24.MI.SS') ,CS.CS_ON_CBB ,
  CS.CS_OVW_SUBSCR ,CS.CS_SUBSCRIPT ,CS.CS_ACCESS ,(-CS.CS_ADV_CHARGE) ,
  CS.CS_OVW_ACCESS ,CS.CS_OVW_ACC_PRD ,CS.CS_OVW_ACC_FIRST ,CS.SUBPAYER ,
  CS.ACCPAYER ,CS.USGPAYER ,DECODE(CS.CS_SRV_TYPE,'V',1,0) ,CS.PRM_VALUE_ID ,
  DECODE(CS.CS_ADV_CHARGE,null ,0,1) ,CS.CS_OVW_LAST ,MPX.QUANTITY_IND  
from
 CONTR_SERVICES CS ,BCH_PROCESS_CONTR BPC ,MPULKNXV MPX where ((((((CS.CO_ID=
  BPC.CONTRACT_ID and BPC.CUSTOMER_SET_ID=:b0) and BPC.BILLSEQNO=:b1) and 
  BPC.BCH_PACKAGE_NUM=:b2) and CS.CS_STAT_CHNG is  not null ) and CS.SNCODE=
  MPX.SNCODE(+)) and (CS.TRIAL_END_DATE<(TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')
  -1) or CS.TRIAL_END_DATE is null )) order by CS.CO_ID,CS.SNCODE,CS.CS_SEQNO 
   for update of CS.CS_STAT_CHNG,CS.CS_DATE_BILLED,CS.CS_ADV_CHARGE,
  CS.CS_ADV_CHARGE_CURRENCY,CS.CS_OVW_LAST,CS.CS_OVW_ACC_PRD,
  CS.CS_OVW_ACC_FIRST 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      6      2.27      45.12       3614      21418      10670           0
Fetch      102      0.38       0.44          0          0          0        9825
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      109      2.66      45.57       3614      21418      10670        9825

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FOR UPDATE
      0    SORT (ORDER BY)
      0     NESTED LOOPS (OUTER)
      0      NESTED LOOPS
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_SERVICES'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CSSIMIX' 
                   (NON-UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'MPULKNXV'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKMPULKNXV' 
                  (UNIQUE)

********************************************************************************

select CO.CUSTOMER_ID ,CO.CO_ID ,CD.CD_SM_NUM ,CH.CH_STATUS ,
  TO_CHAR(CH.CH_VALIDFROM,'YYYY-MM-DD-HH24.MI.SS') ,CO.TMCODE ,CO.SCCODE ,
  CO.CO_ADDR_ON_IBILL ,CO.CO_ITEMIZED_BILL ,CO.CO_IB_CATEGORIES ,
  CO.CO_IB_THRESHOLD ,CO.CURRENCY ,CO.CONTR_CURR_ID ,CO.CONVRATETYPE_CONTRACT 
  ,CO.SEC_CONTR_CURR_ID ,CO.SEC_CONVRATETYPE_CONTRACT ,CO.ARPCODE ,MP.DES ,
  DECODE(CO.SVP_CONTRACT,'X',1,0) ,DECODE(CO.CO_IB_CDR_FLAG,'X',1,0)  
from
 BCH_PROCESS_CUST BPC ,CONTRACT_ALL CO ,CONTR_DEVICES CD ,CONTRACT_HISTORY CH 
  ,MPDSCTAB MP where (((((((((((((BPC.CUSTOMER_SET_ID=:b0 and BPC.BILLSEQNO=
  :b1) and BPC.BCH_PACKAGE_NUM=:b2) and BPC.CUSTOMER_PROCESS_STATUS='I') and 
  BPC.CUSTOMER_ID=CO.CUSTOMER_ID) and CO.CO_ID=CD.CO_ID) and CO.CO_ID=
  CH.CO_ID) and CH.CH_STATUS<>'o') and CD.CD_VALIDFROM=(select 
  max(W.CD_VALIDFROM)  from CONTR_DEVICES W where (W.CO_ID=CO.CO_ID and 
  W.CD_VALIDFROM<TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')))) and CD.CD_SEQNO=
  (select max(X.CD_SEQNO)  from CONTR_DEVICES X where (X.CO_ID=CO.CO_ID and 
  X.CD_VALIDFROM<TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')))) and CH.CH_VALIDFROM=
  (select max(Y.CH_VALIDFROM)  from CONTRACT_HISTORY Y where (Y.CO_ID=
  CO.CO_ID and Y.CH_VALIDFROM<TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')))) and 
  CH.CH_SEQNO=(select max(Z.CH_SEQNO)  from CONTRACT_HISTORY Z where (Z.CO_ID=
  CO.CO_ID and Z.CH_VALIDFROM<TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')))) and 
  CO.SCCODE=MP.SCCODE) and (CO.TRIAL_END_DATE<(TO_DATE(:b3,
  'YYYY-MM-DD-HH24.MI.SS')-1) or CO.TRIAL_END_DATE is null )) union select 
  CO.CUSTOMER_ID ,CO.CO_ID ,null  ,CH.CH_STATUS ,TO_CHAR(CH.CH_VALIDFROM,
  'YYYY-MM-DD-HH24.MI.SS') ,CO.TMCODE ,CO.SCCODE ,CO.CO_ADDR_ON_IBILL ,
  CO.CO_ITEMIZED_BILL ,CO.CO_IB_CATEGORIES ,CO.CO_IB_THRESHOLD ,CO.CURRENCY ,
  CO.CONTR_CURR_ID ,CO.CONVRATETYPE_CONTRACT ,CO.SEC_CONTR_CURR_ID ,
  CO.SEC_CONVRATETYPE_CONTRACT ,CO.ARPCODE ,MP.DES ,1 ,
  DECODE(CO.CO_IB_CDR_FLAG,'X',1,0)  from BCH_PROCESS_CUST BPC ,CONTRACT_ALL 
  CO ,CONTR_DEVICES CD ,CONTRACT_HISTORY CH ,MPDSCTAB MP where 
  (((((((((((((BPC.CUSTOMER_SET_ID=:b0 and BPC.BILLSEQNO=:b1) and 
  BPC.BCH_PACKAGE_NUM=:b2) and BPC.CUSTOMER_PROCESS_STATUS='I') and 
  BPC.CUSTOMER_ID=CO.CUSTOMER_ID) and CO.CO_ID=CD.CO_ID(+)) and 
  CH.CH_STATUS<>'o') and CD.CO_ID is null ) and CO.SVP_CONTRACT='X') and 
  CO.CO_ID=CH.CO_ID) and CH.CH_VALIDFROM=(select max(Y.CH_VALIDFROM)  from 
  CONTRACT_HISTORY Y where (Y.CO_ID=CO.CO_ID and Y.CH_VALIDFROM<TO_DATE(:b3,
  'YYYY-MM-DD-HH24.MI.SS')))) and CH.CH_SEQNO=(select max(Z.CH_SEQNO)  from 
  CONTRACT_HISTORY Z where (Z.CO_ID=CO.CO_ID and Z.CH_VALIDFROM<TO_DATE(:b3,
  'YYYY-MM-DD-HH24.MI.SS')))) and CO.SCCODE=MP.SCCODE) and 
  (CO.TRIAL_END_DATE<(TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')-1) or 
  CO.TRIAL_END_DATE is null )) order by 1,2            


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      0.00       0.02          0          0          0           0
Fetch       12      2.68      37.82       3584      55824         48         772
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       19      2.68      37.84       3584      55824         48         772

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (UNIQUE)
      0    UNION-ALL
      0     FILTER
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        NESTED LOOPS
      0         NESTED LOOPS
      0          TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                     'BCH_PROCESS_CUST'
      0          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'CONTRACT_ALL'
      0           INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                      'FKICOCSID' (NON-UNIQUE)
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'CONTRACT_HISTORY'
      0          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKCONTRACT_HISTORY' (UNIQUE)
      0           SORT (AGGREGATE)
      0            TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) 
                       OF 'CONTRACT_HISTORY'
      0             INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                        'PKCONTRACT_HISTORY' (UNIQUE)
      0        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                   'MPDSCTAB'
      0         INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKMPDSCTAB' 
                    (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_DEVICES'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CODEVCDV' 
                   (NON-UNIQUE)
      0         SORT (AGGREGATE)
      0          FIRST ROW
      0           INDEX   GOAL: ANALYZED (RANGE SCAN (MIN/MAX)) OF 
                      'CODEVCDV' (NON-UNIQUE)
      0      SORT (AGGREGATE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_DEVICES'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CODEVCDV' 
                   (NON-UNIQUE)
      0      SORT (AGGREGATE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTRACT_HISTORY'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTRACT_HISTORY' (UNIQUE)
      0     FILTER
      0      NESTED LOOPS
      0       FILTER
      0        NESTED LOOPS (OUTER)
      0         NESTED LOOPS
      0          NESTED LOOPS
      0           TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                      'BCH_PROCESS_CUST'
      0           TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) 
                      OF 'CONTRACT_ALL'
      0            INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                       'FKICOCSID' (NON-UNIQUE)
      0          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'MPDSCTAB'
      0           INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                      'PKMPDSCTAB' (UNIQUE)
      0         INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CODEVCDV' 
                    (NON-UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTRACT_HISTORY'
      0        INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                   'PKCONTRACT_HISTORY' (UNIQUE)
      0         SORT (AGGREGATE)
      0          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'CONTRACT_HISTORY'
      0           INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                      'PKCONTRACT_HISTORY' (UNIQUE)
      0      SORT (AGGREGATE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTRACT_HISTORY'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTRACT_HISTORY' (UNIQUE)

********************************************************************************

SELECT MIN(PRM_VALID_FROM)   
FROM
 PARAMETER_VALUE  WHERE PRM_VALUE_ID = :b1  AND PRM_VALID_FROM <= :b2  AND 
  DELETED_FLAG IS NULL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   2277      0.06       0.09          0          0          0           0
Fetch     2277      1.19      34.43       3309      11646          0        2277
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     4555      1.25      34.52       3309      11646          0        2277

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (AGGREGATE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'PARAMETER_VALUE'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                'IN_PRMVALUE_ID_REQ_SEQ' (NON-UNIQUE)

********************************************************************************

UPDATE CONTR_SERVICES
SET CS_STAT_CHNG           = :stat,
CS_DATE_BILLED         = TO_DATE( :dtb, 'YYYY-MM-DD-HH24.MI.SS' ),
CS_ADV_CHARGE          = :adv,
CS_ADV_CHARGE_END_DATE = TO_DATE( :adv_end_date, 'YYYY-MM-DD-HH24.MI.SS' ),
CS_OVW_LAST            = :ovw_last,
CS_OVW_ACC_PRD         = :ovw_acc_prd,
CS_OVW_ACC_FIRST       = :ovw_acc_first,
CS_ADV_CHARGE_CURRENCY = :cur_adv,
REC_VERSION            = REC_VERSION + 1
WHERE CO_ID    = :co
AND CS_SEQNO = :seq
AND TMCODE   = :tm
AND SPCODE   = :sp
AND SNCODE   = :sn

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute     11      4.25      21.68       1559      38861      23187        8355
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       12      4.25      21.69       1559      38861      23187        8355

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'CONTR_SERVICES'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'CONTR_SERVICES'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCONTR_SERVICES' 
                (UNIQUE)

********************************************************************************

UPDATE ORDERHDR_ALL SET OHOPNAMT_DOC    = OHOPNAMT_DOC  + :amt_doc,     OHOPNAMT_GL     = OHOPNAMT_GL   + :amt_gl, REC_VERSION = REC_VERSION + 1 
WHERE OHXACT      = :ohxact 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      5      0.74      16.24       1376       3624       1855        1807
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.74      16.25       1376       3624       1855        1807

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'ORDERHDR_ALL'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKORDERHDR_ALL' 
               (UNIQUE)

********************************************************************************

SELECT DISTINCT PRM_NO,PARAMETER_ID   
FROM
 PARAMETER_VALUE PV1  WHERE PRM_VALUE_ID = :b1  AND PRM_VALID_FROM <= :b2  
  AND COMPLEX_LEVEL = 1  AND DELETED_FLAG IS NULL  AND PRM_SEQNO =  (SELECT 
  MAX(PRM_SEQNO)   FROM PARAMETER_VALUE PV2  WHERE PV1.PRM_VALUE_ID = 
  PV2.PRM_VALUE_ID  AND PV1.PRM_VALID_FROM = PV2.PRM_VALID_FROM  AND 
  PV1.PRM_NO = PV2.PRM_NO ) ORDER BY PARAMETER_ID


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   4818      0.46       0.33          0          0          0           0
Fetch    10444      2.99      14.76       1188     214770          0        5626
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    15263      3.45      15.09       1188     214770          0        5626

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (UNIQUE)
      0    FILTER
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'PARAMETER_VALUE'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                 'IN_PRMVALUE_ID_REQ_SEQ' (NON-UNIQUE)
      0     SORT (AGGREGATE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'PARAMETER_VALUE'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'PK_PARAMETER_VALUE' (UNIQUE)

********************************************************************************

INSERT INTO CASHDETAIL ( CADXACT, CADOXACT, CADAMT_DOC,DOCUMENT_CURRENCY,
  CADAMT_GL,GL_CURRENCY,CADAMT_PAY,PAYMENT_CURRENCY,CADGLAR, CADASSOCXACT , 
  CADAMT_EXCHANGE_GL, CADGLAR_EXCHANGE, CADJCID_EXCHANGE, 
  CADCONVDATE_EXCHANGE_DOC, CADCONVDATE_EXCHANGE_GL, CADEXPCONVDATE_EXCHANGE) 
VALUES
 ( :cadxact,:cadoxact,:amount_doc,:doc_curr,:amount_gl,:gl_curr,:amount_pay,
  :pay_curr,:cadglar,:cadassocxact, :cadamt_exchange_gl, :cadglar_exchange, 
  DECODE( :jc,0,NULL,:jc ), TO_DATE( :convdate_doc, 'YYYY-MM-DD-HH24.MI.SS' ),
   TO_DATE( :convdate_gl, 'YYYY-MM-DD-HH24.MI.SS' ), TO_DATE( :expconvdate, 
  'YYYY-MM-DD-HH24.MI.SS' ) )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      1.00      12.59        919        281      45068        3614
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      1.00      12.59        919        281      45068        3614

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

   SELECT F.CUSTOMER_ID,                              
          F.SEQNO,                                    
          NVL ( F.AMOUNT       , 0 ),                 
          NVL ( F.AMOUNT_GROSS , 0 ),                 
          F.REMARK,                                   
          F.GLCODE,                                   
          F.PERIOD,                                   
          F.JOBCOST,                                  
          F.SERVCAT_CODE,                             
          F.SERV_CODE,                                
          F.SERV_TYPE,                                
          F.INCCODE,                                  
          F.REC_VERSION,                              
          F.BILL_FMT,                                 
          F.FEE_TYPE,                                 
          F.GLCODE_DISC,                              
          F.GLCODE_MINCOM,                            
          F.JOBCOST_ID_DISC,                          
          F.JOBCOST_ID_MINCOM,                        
          F.CURRENCY,                                 
          TO_CHAR( F.ENTDATE, 'YYYYMMDD' ),                                         
          NVL ( F.CO_ID , 0 )                       
     FROM BCH_PROCESS_CUST B,                         
          FEES             F                          
    WHERE B.CUSTOMER_ID             = F.CUSTOMER_ID   
      AND B.CUSTOMER_SET_ID         = :dolCustomerSet 
      AND B.BILLSEQNO               = :dolBillSeqNo   
      AND B.BCH_PACKAGE_NUM         = :dolPackageNum  
      AND B.CUSTOMER_PROCESS_STATUS = 'I'             
      AND F.VALID_FROM   < TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' )                         
      AND F.PERIOD       != 0                         
 ORDER BY F.CUSTOMER_ID, F.SEQNO                      
 FOR UPDATE                                                   

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      1.89      12.19       4097      33421       1005           0
Fetch       12      0.00       0.04          0          0          0         473
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       19      1.89      12.23       4097      33421       1005         473

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FOR UPDATE
      0    SORT (ORDER BY)
      0     HASH JOIN
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                 'BCH_PROCESS_CUST'
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'FEES'

********************************************************************************

INSERT INTO ORDERHDR_ALL ( OHXACT,      
OHBILLSEQNO, 
OHSTATUS,    
OHINVTYPE,   
OHENTDATE,   
CUSTOMER_ID, 
OHREFDATE,   
OHDUEDATE,   
GL_CURRENCY, 
DOCUMENT_CURRENCY, 
DOCUMENT_CONVRATETYPE_ID, 
OHINVAMT_GL, 
OHINVAMT_DOC,
OHOPNAMT_GL, 
OHOPNAMT_DOC,
OHDISAMT_DOC,
OHDISAMT_GL, 
OHDISDATE,   
OHIPP,       
OHPOSTGL,    
OHGLAR,      
OHGLEXACT,   
OHGLEXACT_TAX,     
TAX_ROUNDING_FLAG, 
TAXAMT_DIFF_GL,    
GLACODE_DIFF,      
JOBCOST_ID_DIFF,   
GL_CONVRATETYPE_ID,
CONVDATE_EXCHANGE, 
OHMOD,       
OHCOSTCENT,  
SECONDARY_CURRENCY,         
SECONDARY_CONVRATETYPE_ID ) 
VALUES ( :xact,               
1120,                 
:status,             
5,                  
TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),                  
:cd,                 
TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),                  
TO_DATE( :duedate, 'YYYY-MM-DD-HH24.MI.SS' ),                  
:gl_currency,        
:doc_currency,       
:doc_convrate_id,    
:invamt_gl,          
:invamt_doc,         
:opnamt_gl,          
:opnamt_doc,         
:disamt_doc,         
:disamt_gl,          
TO_DATE( :disdate, 'YYYY-MM-DD-HH24.MI.SS' ),                  
'200102',                
TO_DATE( '2006-12-18-10.22.12', 'YYYY-MM-DD-HH24.MI.SS' ),                  
'41110000',                
:ohglexact,          
:ohglexact_tax,      
'X',                 
:rounddiffamt,       
:glacode_diff,       
DECODE( :jc,0,NULL,:jc ),
:fc_convratetype_id, 
TO_DATE( :fc_convdate, 'YYYY-MM-DD-HH24.MI.SS' ),                  
'X',                 
:costcenterid,       
DECODE(:sec_currency,0,NULL,:sec_currency),
DECODE(:sec_convrate_id,0,NULL,:sec_convrate_id))

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute    468      0.90      11.34        863         88      15388         468
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      469      0.91      11.35        863         88      15388         468

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

insert into DOCUMENT_ALL (DOCUMENT_ID,SEQNO,TYPE_ID,CONTRACT_ID,SORT_CRITERIA,
  DOCUMENT_SIZE,DOCUMENT,DOC_FILE_CNT,MEDIUM) 
values
 (:b0,:b1,:b2,DECODE(:b3,0,null ,:b3),:b5,:b6,:b7,:b8,:b9)


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.01       0.01          0          0          0           0
Execute   2158      3.38       9.19        371      10051      65294        2158
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     2163      3.39       9.20        371      10051      65294        2158

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

begin Param_Dependent_Charges . BuildArrayOfPrmStrAndDes ( :loiContractIndex ,
   :lalContractId , :lalParamValueId , :lachStartDate , :lachEndDate , 
  :loiOutputArraySize , :laiStartWithElem , :lachParamStringOut , 
  :lachParamDescrOut , :lachParamDateOut , :laiNumberOfParamOut , 
  :laiMoreElementOut , :laiErrorCode , :loiNumContracts ) ; END ;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        6      0.01       0.00          0          0          0           0
Execute     69      8.28       8.94          0          0          0          69
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       75      8.29       8.94          0          0          0          69

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

select CSC.CO_ID ,DN.DN_ID ,CSC.DN_BLOCK_ID ,DECODE(DN.BLOCK_IND,'Y',1,0) ,
  DN.DN_NUM  
from
 BCH_PROCESS_CONTR BPC ,CONTR_SERVICES_CAP CSC ,DIRECTORY_NUMBER DN where 
  ((((((CSC.SEQNO=(select max(SEQNO)  from CONTR_SERVICES_CAP where ((((CO_ID=
  CSC.CO_ID and SNCODE=CSC.SNCODE) and CS_ACTIV_DATE<TO_DATE(:b0,
  'YYYY-MM-DD-HH24.MI.SS')) and (CS_DEACTIV_DATE is null  or CS_DEACTIV_DATE>=
  (TO_DATE(:b0,'YYYY-MM-DD-HH24.MI.SS')-:b2))) and CSC.MAIN_DIRNUM='X')) or 
  CSC.SEQNO=(select max(SEQNO)  from CONTR_SERVICES_CAP where ((((CO_ID=
  CSC.CO_ID and SNCODE=CSC.SNCODE) and CS_ACTIV_DATE<TO_DATE(:b0,
  'YYYY-MM-DD-HH24.MI.SS')) and (CS_DEACTIV_DATE is null  or CS_DEACTIV_DATE>=
  (TO_DATE(:b0,'YYYY-MM-DD-HH24.MI.SS')-:b2))) and CSC.MAIN_DIRNUM<>'X'))) 
  and BPC.CONTRACT_ID=CSC.CO_ID) and BPC.BCH_PACKAGE_NUM=:b6) and 
  BPC.BILLSEQNO=:b7) and BPC.CUSTOMER_SET_ID=:b8) and CSC.DN_ID=DN.DN_ID) 
  order by CSC.CO_ID,DECODE(CSC.MAIN_DIRNUM,'X',1,0) desc ,CSC.CS_ACTIV_DATE 
  desc             


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch       11      0.48       7.59        854       6209          0         673
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       18      0.49       7.59        854       6209          0         673

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (ORDER BY)
      0    FILTER
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_SERVICES_CAP'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'MYDNID_CNTR_SERV_CAP' (NON-UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'DIRECTORY_NUMBER'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                  'PKDIRECTORY_NUMBER' (UNIQUE)
      0     SORT (AGGREGATE)
      0      FILTER
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_SERVICES_CAP'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTR_SERVICES_CAP' (UNIQUE)
      0     SORT (AGGREGATE)
      0      FILTER
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_SERVICES_CAP'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTR_SERVICES_CAP' (UNIQUE)

********************************************************************************

SELECT I.CUSTOMER_ID, 
       NVL ( I.CUSTOMERCAT_CODE , -1 ), 
       NVL ( I.CUSTOMERGEO_CODE , -1 ), 
       TO_CHAR( I.VALID_FROM, 'YYYY-MM-DD-HH24.MI.SS' ) 
  FROM BCH_PROCESS_CUST    B, 
       INDIVIDUAL_TAXATION I, 
       CUSTOMER_ALL        C  
 WHERE B.CUSTOMER_ID             = I.CUSTOMER_ID   
   AND B.CUSTOMER_ID             = C.CUSTOMER_ID   
   AND B.CUSTOMER_SET_ID         = :dolCustomerSet 
   AND B.BILLSEQNO               = :dolBillSeqNo   
   AND B.BCH_PACKAGE_NUM         = :dolPackageNum  
   AND B.CUSTOMER_PROCESS_STATUS = 'I'             
   AND C.PAYMNTRESP              = 'X' 
   AND I.VALID_FROM  < TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ) 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          0          0           0
Fetch       22      0.66       7.05        672      22769         20        1013
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       27      0.66       7.05        672      22769         20        1013

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      0    NESTED LOOPS
      0     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'BCH_PROCESS_CUST'
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'CUSTOMER_ALL'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCUSTOMER_ALL' 
                 (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'INDIVIDUAL_TAXATION'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                'PKINDIVIDUAL_TAXATION' (UNIQUE)

********************************************************************************

INSERT INTO ORDERTRAILER_TAX_ITEMS
             ( OTXACT,
OTSEQ,
TAXCODE,
OTI_SEQNO,
TAX_SEQNO,
TAX_EXEMPTED,
REC_VERSION )
VALUES ( :xact,
:otseq,
:taxcode,
:oti_seqno,
:tax_seqno,
:tax_exempt, 
0 )

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute     29      2.18       6.34         53        891     207220       27549
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       30      2.18       6.34         53        891     207220       27549

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

DELETE FROM FEES          
WHERE CUSTOMER_ID = :cust
AND SEQNO       = :seq 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.45       6.30        615       1574       3693         363
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.45       6.30        615       1574       3693         363

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  DELETE STATEMENT   GOAL: CHOOSE
      0   DELETE OF 'FEES'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'FEES'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKFEES' (UNIQUE)

********************************************************************************

INSERT INTO CONTR_TURNOVER ( CO_ID,CUSTOMER_ID,CT_TU_DATE,CURRENCY,CT_AMOUNT,
  CT_AIRROAMER,CT_AIRNROAMER )  
VALUES
 ( :b1,:b2,TO_DATE('2006-12-01-00.00.00','YYYY-MM-DD-HH24.MI.SS'),:b3,:b4,:b5,
  :b6  )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute    528      0.45       5.71        464         92       7517         528
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      529      0.45       5.72        464         92       7517         528

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT OHXACT,  
OHINVTYPE,OHINVAMT_DOC,OHINVAMT_GL,NVL(OHOPNAMT_DOC,OHINVAMT_DOC),NVL(OHOPNAMT_GL,OHINVAMT_GL),
DOCUMENT_CURRENCY,GL_CURRENCY,to_char(OHREFDATE,'YYYYMMDD'),
to_char(OHENTDATE,'YYYYMMDD'),to_char(CONVDATE_EXCHANGE,'YYYYMMDD'),
OHGLAR,OHREFNUM,OHSTATUS,GL_CONVRATETYPE_ID,
0,0,0,0,0,0,0,'','',0,0,'','',
'',
'',0,0,0,0,'0'
FROM ORDERHDR_ALL 
WHERE CUSTOMER_ID  = :v1 
AND OHSTATUS = 'CM'          
AND (    OHENTDATE >= TO_DATE(:v2,'YYYYMMDD')  
OR OHOPNAMT_DOC  < 0 )
AND OHENTDATE < to_date(:v3,'YYYYMMDD') 
FOR UPDATE OF OHOPNAMT_DOC 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute    578      0.32       5.68        553       1836         24           0
Fetch      600      0.00       0.01          0        135          0          22
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1178      0.32       5.69        553       1971         24          22

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FOR UPDATE
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'ORDERHDR_ALL'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'OH_CUST_ID_1' 
                (NON-UNIQUE)

********************************************************************************

select RH.TMCODE ,B.CONTRACT_ID  
from
 RATEPLAN_HIST RH ,BCH_PROCESS_CONTR B where ((((RH.CO_ID=B.CONTRACT_ID and 
  B.CUSTOMER_SET_ID=:b0) and B.BILLSEQNO=:b1) and B.BCH_PACKAGE_NUM=:b2) and 
  RH.SEQNO=(select max(RH1.SEQNO)  from RATEPLAN_HIST RH1 where (RH1.CO_ID=
  B.CONTRACT_ID and RH1.TMCODE_DATE<TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS'))))   
          


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        6      0.00       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch       11      0.28       5.66        706       4273          0         673
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       23      0.28       5.66        706       4273          0         673

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
    114  NESTED LOOPS 
    115   INDEX RANGE SCAN (object id 8752)
    114   TABLE ACCESS BY INDEX ROWID RATEPLAN_HIST 
    228    INDEX UNIQUE SCAN (object id 10302)
    228     SORT AGGREGATE 
    176      TABLE ACCESS BY INDEX ROWID RATEPLAN_HIST 
    290       INDEX RANGE SCAN (object id 10302)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
    114   NESTED LOOPS
    115    INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PK_BCH_PROCESS_CONTR' 
               (UNIQUE)
    114    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'RATEPLAN_HIST'
    228     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKRATEPLAN_HIST' 
                (UNIQUE)
    228      SORT (AGGREGATE)
    176       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'RATEPLAN_HIST'
    290        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKRATEPLAN_HIST' (UNIQUE)

********************************************************************************

UPDATE CONTR_TURNOVER SET CT_AMOUNT=NVL(CT_AMOUNT,0) + :b1 ,CT_AIRROAMER=
  NVL(CT_AIRROAMER,0) + :b2 ,CT_AIRNROAMER=NVL(CT_AIRNROAMER,0) + :b3 ,
  REC_VERSION=REC_VERSION + 1  
WHERE
 CO_ID = :b4  AND CURRENCY = :b5  AND CT_TU_DATE = 
  TO_DATE('2006-12-01-00.00.00','YYYY-MM-DD-HH24.MI.SS')


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute    528      0.28       5.51        522       1717          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      529      0.29       5.51        522       1717          0           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'CONTR_TURNOVER'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCONTR_TURNOVER' 
               (UNIQUE)

********************************************************************************

INSERT INTO LBC_DATE_HIST 
            ( CUSTOMER_ID,
              BILLCYCLE,  
              LBC_DATE ) 
       VALUES ( :customer_id,
                '02',        
                 TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' )        )  

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.22       5.19        496         79       2873         494
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.22       5.19        496         79       2873         494

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT A.CUSTOMER_ID,
A.CCNAME,
A.CCLINE1,
A.CCLINE2,
A.CCLINE3,
A.CCLINE4,
A.CCLINE5,
A.CCLINE6,
A.CCCOUNTRY,
B.ISO,
A.CCBILL,
A.CCBILLDETAILS,
A.CCBILLTEMP,
A.CCCONTRACT,
A.CCUSER_INST,
A.CCLANGUAGE,
A.SORT_CRITERIA, 
A.CCINCCODE, 
A.CCSTATE, 
A.CCZIP  
FROM BCH_PROCESS_CUST BP,
CCONTACT         A,
COUNTRY          B 
WHERE A.CUSTOMER_ID              = BP.CUSTOMER_ID  
AND BP.CUSTOMER_SET_ID         = :dolCustomerSet 
AND BP.BILLSEQNO               = :dolBillSeqNo   
AND BP.BCH_PACKAGE_NUM         = :dolPackageNum  
AND BP.CUSTOMER_PROCESS_STATUS = 'I'             
AND A.COUNTRY                   = B.COUNTRY_ID   
AND A.CCLANGUAGE IS NOT NULL 
AND (    A.CCBILL       = 'X' 
OR A.CCBILLTEMP   = 'X' 
OR A.CCCONTRACT   = 'X' 
OR A.CCBILLDETAILS= 'X') 
UNION ALL 
SELECT A.CUSTOMER_ID,
A.CCNAME,
A.CCLINE1,
A.CCLINE2,
A.CCLINE3,
A.CCLINE4,
A.CCLINE5,
A.CCLINE6,
A.CCCOUNTRY,
B.ISO,
A.CCBILL,
A.CCBILLDETAILS,
A.CCBILLTEMP,
A.CCCONTRACT,
A.CCUSER_INST,
L.LNG_ID,
A.SORT_CRITERIA, 
A.CCINCCODE, 
A.CCSTATE, 
A.CCZIP  
FROM BCH_PROCESS_CUST BP,
CCONTACT A,
COUNTRY  B,
LANGUAGE L 
WHERE A.CUSTOMER_ID              = BP.CUSTOMER_ID  
AND BP.CUSTOMER_SET_ID         = :dolCustomerSet 
AND BP.BILLSEQNO               = :dolBillSeqNo   
AND BP.BCH_PACKAGE_NUM         = :dolPackageNum  
AND BP.CUSTOMER_PROCESS_STATUS = 'I'             
AND A.COUNTRY                  = B.COUNTRY_ID 
AND A.CCLANGUAGE IS NULL 
AND L.LNG_DEF = 'X' 
AND (    A.CCBILL       = 'X' 
OR A.CCBILLTEMP   = 'X' 
OR A.CCCONTRACT   = 'X' 
OR A.CCBILLDETAILS= 'X') 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      5      0.00       0.01          0          0          0           0
Fetch       14      0.88       4.74        345      23666         60         511
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       19      0.88       4.75        345      23666         60         511

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   UNION-ALL
      0    HASH JOIN
      0     NESTED LOOPS
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                 'BCH_PROCESS_CUST'
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CCONTACT_ALL'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PKCCONTACT_ALL' 
                  (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'COUNTRY'
      0    MERGE JOIN (CARTESIAN)
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                  'BCH_PROCESS_CUST'
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CCONTACT_ALL'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCCONTACT_ALL' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'COUNTRY'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCOUNTRY' 
                  (UNIQUE)
      0     SORT (JOIN)
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'LANGUAGE'

********************************************************************************

UPDATE CUSTOMER_TURNOVER SET AMOUNT=NVL(AMOUNT,0) + :b1 ,REC_VERSION=
  REC_VERSION + 1  
WHERE
 CUSTOMER_ID = :b2  AND CURRENCY = :b3  AND TU_DATE = 
  TO_DATE('2006-12-01-00.00.00','YYYY-MM-DD-HH24.MI.SS')


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    468      0.19       4.65        466       1442          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      469      0.19       4.65        466       1442          0           0

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'CUSTOMER_TURNOVER'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCUSTOMER_TURNOVER' 
               (UNIQUE)

********************************************************************************

SELECT PM.CUSTOMER_ID,
PM.BANKACCNO,
PM.ACCOUNTOWNER,
PM.BANK_ID,
PM.BANKSUBACCOUNT,
PM.BANKNAME,
PM.BANKZIP,
PM.BANKCITY, 
PT.PAYMENTCODE, 
PM.ORDERNUMBER 
FROM BCH_PROCESS_CUST BP,
PAYMENT_ALL PM, 
PAYMENTTYPE_INT PT 
WHERE PM.CUSTOMER_ID = BP.CUSTOMER_ID
AND BP.CUSTOMER_SET_ID         = :dolCustomerSet 
AND BP.BILLSEQNO               = :dolBillSeqNo   
AND BP.BCH_PACKAGE_NUM         = :dolPackageNum  
AND BP.CUSTOMER_PROCESS_STATUS = 'I'             
AND PM.ACT_USED    = 'X' 
AND PM.PAYMENT_TYPE = PT.PAYMENT_ID 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      5      0.01       0.09          0          0          0           0
Fetch       14      0.66       4.36        383      20856         80         494
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       19      0.67       4.45        383      20856         80         494

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   HASH JOIN
      0    NESTED LOOPS
      0     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'BCH_PROCESS_CUST'
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'PAYMENT_ALL'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PKPAYMENT' (UNIQUE)

      0    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'PAYMENTTYPE_ALL'

********************************************************************************

INSERT INTO CASHRECEIPTS_ALL ( CAXACT, CUSTOMER_ID,CATYPE,CAENTDATE,CARECDATE,
  CAPP,CAGLEXACT,CAREASONCODE,PAYMENT_CURRENCY,GL_CURRENCY,CURRENCY,
  CAUSERNAME)
VALUES
 ( :xact,:cd,'2',TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),
  TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),200102,:caglexact,
  21,:paycur,:glcur,:cur,'BCH')


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      5      0.40       4.37        382        233      13791        1807
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.41       4.38        382        233      13791        1807

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT COUNT(DISTINCT A.TMCODE)   
FROM
 RATEPLAN_HIST A  WHERE A.CO_ID = :b1  AND A.TMCODE_DATE < TO_DATE(:b2,
  'YYYY-MM-DD-HH24.MI.SS')  AND A.TMCODE_DATE >= TO_DATE(:b3,
  'YYYY-MM-DD-HH24.MI.SS')


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    690      0.08       0.05          0          0          0           0
Fetch      690      0.17       3.00        422       2071          0         690
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1381      0.25       3.05        422       2071          0         690

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (GROUP BY)
      0    FILTER
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'RATEPLAN_HIST'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                 'UIRATPLNHS_COID_TMDATE' (UNIQUE)

********************************************************************************

UPDATE BCH_PROCESS_CUST              
   SET CUSTOMER_PROCESS_STATUS ='S'  
 WHERE BILLSEQNO        = 1120        
   AND CUSTOMER_SET_ID  = :cust_set  
   AND BCH_PACKAGE_NUM  = :pack_num  
   AND CUSTOMER_ID      = :cust_id   

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute      5      0.27       3.00        348      11944        504         494
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.28       3.00        348      11944        504         494

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'BCH_PROCESS_CUST'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'BCH_PROCESS_CUST'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'CUSTIDF' (NON-UNIQUE)


********************************************************************************

INSERT INTO ORDERTRAILER
       ( OTXACT,
         OTSEQ,
         OTNAME,
         OTQBKORD,
         OTQORD,
         OTQTOSHP,
         OTQSHIP,
         GL_CURRENCY,
         DOCUMENT_CURRENCY,
         OTGPRICE_DOC,
         TAX_INCLUSIVE_IND,
         OTMERCH_GL,
         OTMERCH_DOC,
         OTMERCH_GROSS_GL,
         OTMERCH_GROSS_DOC,
         OTGLSALE,
         OTJOBCOST,
         OTSHIPDATE,
         OTTRANSACTION_DATE,
         SERVCAT_CODE,
         SERV_CODE,
         SERV_TYPE,
         OTGL_DISC,
         OTJCID_DISC,
         OTGL_MINCOM,
         OTJCID_MINCOM,
         OTAMT_REVENUE_GL,
         OTAMT_REVENUE_DOC,
         OTAMT_REVENUE_GROSS_GL,
         OTAMT_REVENUE_GROSS_DOC,
         OTAMT_DISC_GL,
         OTAMT_DISC_DOC,
         OTAMT_DISC_GROSS_GL,
         OTAMT_DISC_GROSS_DOC,
         OTAMT_MINCOM_GL,
         OTAMT_MINCOM_DOC,
         OTAMT_MINCOM_GROSS_GL,
         OTAMT_MINCOM_GROSS_DOC)
VALUES ( :xact,
         :seq,
         :name,
         0,
         :qt,
         :qt,
         :qt,
         :gl_currency,
         :doc_currency,
         :gross,
         'N',
         :merch_gl,
         :merch_doc,
         :merch_gross_gl,
         :merch_gross_doc,
         :glsale,
         DECODE( :jc,0,NULL,:jc ),
         TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),
         TO_DATE( :transaction_date, 'YYYY-MM-DD-HH24.MI.SS' ),
         :servcat_code,
         :serv_code,
         :serv_type,
         DECODE(:disc_gl,'',NULL,:disc_gl),
         DECODE(:disc_jc,0 ,NULL,:disc_jc),
         DECODE(:mincom_gl,'',NULL,:mincom_gl),
         DECODE(:mincom_jc,0 ,NULL,:mincom_jc),
         :otamt_revenue_gl,
         :otamt_revenue_doc,
         :otamt_revenue_gross_gl,
         :otamt_revenue_gross_doc,
         :otamt_disc_gl,
         :otamt_disc_doc,
         :otamt_disc_gross_gl,
         :otamt_disc_gross_doc,
         :otamt_mincom_gl,
         :otamt_mincom_doc,
         :otamt_mincom_gross_gl,
         :otamt_mincom_gross_doc)

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute     29      1.75       2.95         33        681      87518       14004
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       30      1.76       2.96         33        681      87518       14004

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

UPDATE CUSTOMER_ALL 
SET PREV_BALANCE = :pbal,
CSCURBALANCE = :cbal,
LBC_DATE     = TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),   
CSMOD        = 'X',  
REC_VERSION  = REC_VERSION + 1 
WHERE CUSTOMER_ID  = :cd   

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.18       2.58        267        998        526         494
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.18       2.58        267        998        526         494

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'CUSTOMER_ALL'
      0    FILTER
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCUSTOMER_ALL' 
                (UNIQUE)

********************************************************************************

SELECT USER   
FROM
 SYS.DUAL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute   8355      0.43       0.55          0          0          0           0
Fetch     8355      0.52       0.61          0       8355      33420        8355
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    16711      0.96       1.16          0       8355      33420        8355

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'DUAL'

********************************************************************************

DELETE FROM CONTR_SERVICES 
WHERE
 CO_ID = :b1  AND CS_SEQNO = :b2  AND TMCODE = :b3  AND SPCODE = :b4  AND 
  SNCODE = :b5  AND CS_PENDING_STATE IS NULL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute     15      0.06       1.16         94        102        283          15
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       16      0.07       1.16         94        102        283          15

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  DELETE STATEMENT   GOAL: CHOOSE
      0   DELETE OF 'CONTR_SERVICES'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'CONTR_SERVICES'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCONTR_SERVICES' 
                (UNIQUE)

********************************************************************************

UPDATE MPUUBTAB                                                 
   SET LAST_BILLING_DURATION = :MilliSecs,                      
       UNBILLED_AMOUNT       = NVL( UNBILLED_AMOUNT, 0 ) - :amt, 
       CONTRACT_NUM          = :co_num,                         
       RTX_NUM               = :cp_num,                         
       REC_VERSION           = REC_VERSION + 1                  
 WHERE CUSTOMER_ID = :cd                                        

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      5      0.07       1.15        123        999        554         494
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.07       1.16        123        999        554         494

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'MPUUBTAB'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKMPUUBTAB' (UNIQUE)

********************************************************************************

update BCH_PROCESS_CUST  set CUSTOMER_PROCESS_STATUS='I' 
where
 CUSTOMER_PROCESS_STATUS='D'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.01       0.00          0          0          0           0
Execute      5      0.44       1.14        357      19169         20           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       10      0.45       1.14        357      19169         20           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  UPDATE BCH_PROCESS_CUST 
      1   TABLE ACCESS FULL BCH_PROCESS_CUST 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      1   UPDATE OF 'BCH_PROCESS_CUST'
      1    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'BCH_PROCESS_CUST'

********************************************************************************

SELECT MAX(MPD.PRM_VALUE_NUMBER),MAX(MPD.PRM_VALUE_DATE),
  MAX(MPD.PRM_VALUE_STRING)   
FROM
 PARAMETER_VALUE PV1,MKT_PARAMETER_DOMAIN MPD  WHERE PV1.PRM_VALUE_ID = :b1  
  AND PV1.PRM_NO = :b2  AND MPD.SCCODE = :b3  AND PV1.PRM_VALUE_NUMBER = 
  MPD.PRM_VALUE_SEQNO  AND PV1.PARAMETER_ID = MPD.PARAMETER_ID  AND 
  PV1.PRM_VALID_FROM <= :b4  AND PV1.DELETED_FLAG IS NULL  AND PV1.PRM_SEQNO =
    (SELECT MAX(PRM_SEQNO)   FROM PARAMETER_VALUE PV2  WHERE PV1.PRM_VALUE_ID 
  = PV2.PRM_VALUE_ID  AND PV2.PRM_VALID_FROM <= :b4  AND PV1.PRM_NO = 
  PV2.PRM_NO )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute   3183      0.31       0.28          0          0          0           0
Fetch     3183      0.71       0.64          0      38447          0        3183
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     6367      1.02       0.93          0      38447          0        3183

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (AGGREGATE)
      0    NESTED LOOPS
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'PARAMETER_VALUE'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                 'PK_PARAMETER_VALUE' (UNIQUE)
      0       SORT (AGGREGATE)
      0        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                   'PARAMETER_VALUE'
      0         INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                    'PK_PARAMETER_VALUE' (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'MKT_PARAMETER_DOMAIN'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                 'PKMKT_PARAMETER_DOMAIN' (UNIQUE)

********************************************************************************

SELECT MIN(PRM_VALID_FROM)   
FROM
 PARAMETER_VALUE  WHERE PRM_VALUE_ID = :b1  AND PRM_VALID_FROM > :b2  AND 
  DELETED_FLAG IS NULL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   4818      0.31       0.31          0          0          0           0
Fetch     4818      0.42       0.61          0      38184          0        4818
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     9637      0.73       0.92          0      38184          0        4818

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (AGGREGATE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'PARAMETER_VALUE'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                'IN_PRMVALUE_ID_REQ_SEQ' (NON-UNIQUE)

********************************************************************************

SELECT MP.MULTIPLE_VALUES_IND,PT.PARAMETER_TYPE_ID,MP.PRM_DES,
  MP.RESOURCE_LIKE   
FROM
 MKT_PARAMETER MP,PARAMETER_AREA PA,PARAMETER_TYPE PT  WHERE MP.SCCODE = :b1  
  AND MP.PARAMETER_ID = :b2  AND MP.PARAMETER_AREA_ID = PA.PARAMETER_AREA_ID  
  AND PA.PARAMETER_TYPE_ID = PT.PARAMETER_TYPE_ID


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   5626      0.49       0.33          0          0          0           0
Fetch     5626      0.35       0.58          0      28130          0        5626
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    11253      0.84       0.91          0      28130          0        5626

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      0    NESTED LOOPS
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'MKT_PARAMETER'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKMKT_PARAMETER' 
                 (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'PARAMETER_AREA'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                 'PK_PARAMETER_AREA' (UNIQUE)
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_PARAMETER_TYPE' 
               (UNIQUE)

********************************************************************************

SELECT COUNT(DISTINCT A.VSCODE)   
FROM
 MPUTMTAB A,RATEPLAN_HIST B  WHERE B.CO_ID = :b1  AND A.TMCODE = B.TMCODE  
  AND A.VSDATE < TO_DATE(:b2,'YYYY-MM-DD-HH24.MI.SS')  AND A.VSDATE >= 
  TO_DATE(:b3,'YYYY-MM-DD-HH24.MI.SS')  AND A.STATUS = 'P'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    690      0.05       0.14          0          0          0           0
Fetch      690      0.72       0.76          0      38399       2760         690
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1381      0.77       0.90          0      38399       2760         690

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (GROUP BY)
      0    FILTER
      0     NESTED LOOPS
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'MPUTMTAB'
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'RATEPLAN_HIST'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PKRATEPLAN_HIST' 
                  (UNIQUE)

********************************************************************************

SELECT SCCODE   
FROM
 CONTRACT_ALL  WHERE CO_ID = :b1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   2288      0.14       0.12          0          0          0           0
Fetch     2288      0.09       0.61         54       9152          0        2288
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     4577      0.23       0.73         54       9152          0        2288

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
              'CONTRACT_ALL'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCONTRACT_ALL' 
               (UNIQUE)

********************************************************************************

INSERT INTO GLENTRY ( GLEXACT,GLESEQ,GLECODE,GLEENTDATE,GLECD,GLEAMT,CURRENCY,
  GLESOURCE,GLESOURCETIME,GLEREM,GLEPP,GLCOSTCENT,GLJOBCOST,GLEMOD,
  REC_VERSION )  
VALUES
 ( :b1,:b2,:b3,TO_DATE('2006-12-16-00.00.00','YYYY-MM-DD-HH24.MI.SS'),:b4,:b5,
  :b6,:b7,TO_DATE('2006-12-18-10.22.12','YYYY-MM-DD-HH24.MI.SS'),'Billcycle 
  02, BCH_id 1','200102',DECODE(:b8,0, NULL ,:b8),DECODE(:b10,0, NULL ,:b10),
  'X',0  )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    103      0.07       0.61         62         32       1400         103
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      104      0.07       0.61         62         32       1400         103

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT PRM_VALUE_NUMBER,PRM_VALUE_DATE,PRM_VALUE_STRING,PRM_DESCRIPTION   
FROM
 PARAMETER_VALUE PV1  WHERE PRM_VALUE_ID = :b1  AND PRM_NO = :b2  AND 
  PRM_VALID_FROM <= :b3  AND DELETED_FLAG IS NULL  AND PRM_SEQNO =  (SELECT 
  MAX(PRM_SEQNO)   FROM PARAMETER_VALUE PV2  WHERE PV1.PRM_VALUE_ID = 
  PV2.PRM_VALUE_ID  AND PV2.PRM_VALID_FROM <= :b3  AND PV1.PRM_NO = 
  PV2.PRM_NO )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute   2443      0.18       0.16          0          0          0           0
Fetch     2443      0.46       0.40          0      29971          0        2443
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     4887      0.64       0.57          0      29971          0        2443

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
              'PARAMETER_VALUE'
      0    INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PK_PARAMETER_VALUE' 
               (UNIQUE)
      0     SORT (AGGREGATE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'PARAMETER_VALUE'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'PK_PARAMETER_VALUE' (UNIQUE)

********************************************************************************

SELECT C.CUSTOMER_ID,                              
       C.CUSTOMER_ID_HIGH,                         
       C.CUSTCODE,                                 
       C.BILLCYCLE,                                
       TO_CHAR ( C.CSACTIVATED   , 'YYYY-MM-DD-HH24.MI.SS' ),         
       TO_CHAR ( C.CSDEACTIVATED , 'YYYY-MM-DD-HH24.MI.SS' ),         
       C.CSLEVEL,                                  
       C.CSLVLNAME,                                
       C.PRGCODE,                                  
       C.TERMCODE,                                 
       C.PAYMNTRESP,                               
       C.CSSUMADDR,                                
       C.CSCURBALANCE,                             
       C.PREV_BALANCE,                             
       TO_CHAR ( C.LBC_DATE , 'YYYY-MM-DD-HH24.MI.SS' ),              
       C.CSBILLMEDIUM,                             
       C.CSITEMBILLMEDIUM,                         
       C.CSRESELLER,                               
       C.COSTCENTER_ID,                            
       TO_CHAR ( C.BIRTHDATE , 'YYYY-MM-DD-HH24.MI.SS' ),             
       C.CSDRIVELICENCE,                           
       C.CSSOCIALSECNO,                            
       C.CURRENCY,                                 
       C.PRIMARY_DOC_CURRENCY,                     
       C.PRIM_CONVRATETYPE_DOC,                    
       C.SECONDARY_DOC_CURRENCY,                   
       C.SEC_CONVRATETYPE_DOC,                     
       C.EXPECT_PAY_CURR_ID,                       
       C.CONVRATETYPE_PAYMENT                      
  FROM BCH_PROCESS_CUST B,                         
       CUSTOMER_ALL     C                          
 WHERE B.CUSTOMER_ID             = C.CUSTOMER_ID   
   AND B.CUSTOMER_SET_ID         = :dolCustomerSet 
   AND B.BILLSEQNO               = :dolBillSeqNo   
   AND B.BCH_PACKAGE_NUM         = :dolPackageNum  
   AND B.CUSTOMER_PROCESS_STATUS = 'I'             
 ORDER BY C.CUSTCODE                               
   FOR UPDATE

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      5      0.55       0.56          0      20586       1045           0
Fetch        9      0.00       0.00          0          0          0         494
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       14      0.55       0.56          0      20586       1045         494

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FOR UPDATE
      0    SORT (ORDER BY)
      0     NESTED LOOPS
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                 'BCH_PROCESS_CUST'
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CUSTOMER_ALL'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCUSTOMER_ALL' 
                  (UNIQUE)

********************************************************************************

SELECT C.CO_ID,
A.CCNAME,
A.CCLINE1,
A.CCLINE2,
A.CCLINE3,
A.CCLINE4,
A.CCLINE5,
A.CCLINE6,
A.CCCOUNTRY,
B.ISO,
A.CCBILL,
A.CCBILLDETAILS,
A.CCBILLTEMP,
A.CCCONTRACT,
A.CCUSER_INST,
A.CCLANGUAGE,
A.SORT_CRITERIA, 
A.CCINCCODE, 
A.CCSTATE, 
A.CCZIP  
FROM BCH_PROCESS_CONTR BP,
CCONTACT_ALL      A, 
COUNTRY           B, 
CONTRACT_CONTACT  C, 
CONTRACT_ALL      D  
WHERE C.CO_ID             = BP.CONTRACT_ID 
AND C.CUSTOMER_ID       = BP.CUSTOMER_ID 
AND A.CUSTOMER_ID       = C.CUSTOMER_ID 
AND A.CCSEQ             = C.CCSEQ 
AND D.CO_ID             = C.CO_ID 
AND BP.CUSTOMER_SET_ID  = :dolCustomerSet 
AND BP.BILLSEQNO        = :dolBillSeqNo   
AND BP.BCH_PACKAGE_NUM  = :dolPackageNum  
AND A.COUNTRY           = B.COUNTRY_ID   
AND A.CCUSER_INST       = 'X' 
AND D.CO_ADDR_ON_IBILL  = 'X'  
AND A.CCLANGUAGE IS NOT NULL 
UNION ALL 
SELECT C.CO_ID,
A.CCNAME,
A.CCLINE1,
A.CCLINE2,
A.CCLINE3,
A.CCLINE4,
A.CCLINE5,
A.CCLINE6,
A.CCCOUNTRY,
B.ISO,
A.CCBILL,
A.CCBILLDETAILS,
A.CCBILLTEMP,
A.CCCONTRACT,
A.CCUSER_INST,
L.LNG_ID,
A.SORT_CRITERIA, 
A.CCINCCODE, 
A.CCSTATE, 
A.CCZIP  
FROM BCH_PROCESS_CONTR BP,
CCONTACT_ALL       A,
COUNTRY            B,
CONTRACT_CONTACT   C,
CONTRACT_ALL       D,
LANGUAGE           L 
WHERE C.CO_ID            = BP.CONTRACT_ID 
AND C.CUSTOMER_ID      = BP.CUSTOMER_ID 
AND A.CUSTOMER_ID      = C.CUSTOMER_ID 
AND A.CCSEQ            = C.CCSEQ 
AND D.CO_ID            = C.CO_ID 
AND BP.CUSTOMER_SET_ID = :dolCustomerSet 
AND BP.BILLSEQNO       = :dolBillSeqNo   
AND BP.BCH_PACKAGE_NUM = :dolPackageNum  
AND A.COUNTRY          = B.COUNTRY_ID 
AND L.LNG_DEF          = 'X' 
AND A.CCUSER_INST      = 'X'  
AND D.CO_ADDR_ON_IBILL = 'X'  
AND A.CCLANGUAGE IS NULL 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch        6      0.50       0.53          2        162         96           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       13      0.50       0.54          2        162         96           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   UNION-ALL
      0    NESTED LOOPS
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       MERGE JOIN (CARTESIAN)
      0        TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'COUNTRY'
      0        SORT (JOIN)
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'BCH_PROCESS_CONTR'
      0          INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                     'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'PKCONTRACT_CONTACT' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CCONTACT_ALL'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCCONTACT_ALL' 
                  (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'CONTRACT_ALL'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCONTRACT_ALL' 
                 (UNIQUE)
      0    NESTED LOOPS
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        MERGE JOIN (CARTESIAN)
      0         TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'LANGUAGE'
      0         SORT (JOIN)
      0          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'BCH_PROCESS_CONTR'
      0           INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                      'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTRACT_CONTACT' (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CCONTACT_ALL'
      0        INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                   'PKCCONTACT_ALL' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CONTRACT_ALL'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCONTRACT_ALL' 
                  (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'COUNTRY'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKCOUNTRY' 
                 (UNIQUE)

********************************************************************************

begin bchlib . CheckTmVsChangesForContract ( :loiContractIndex , 
  :lachBillingStartDate , :lalContractId , :lachEndDate , 
  :lachActiveStartDateOut , :lalTmVsChangedOut ) ; END ;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        6      0.00       0.00          0          0          0           0
Execute     11      0.58       0.52          0          0          0          11
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       17      0.58       0.52          0          0          0          11

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

INSERT INTO CUSTOMER_TURNOVER ( CUSTOMER_ID,CURRENCY,TU_DATE,AMOUNT )  
VALUES
 ( :b1,:b2,TO_DATE('2006-12-01-00.00.00','YYYY-MM-DD-HH24.MI.SS'),:b3  )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    468      0.20       0.46         12          8       3849         468
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      469      0.20       0.46         12          8       3849         468

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT NVL(A.CH_STATUS,'?') CH_STATUS,NVL(A.CH_VALIDFROM,TO_DATE('0001-01-01',
  'YYYY-MM-DD')) CH_VALIDFROM   
FROM
 CONTRACT_HISTORY A  WHERE A.CO_ID = :b1  AND A.CH_PENDING IS NULL  AND 
  A.CH_VALIDFROM < TO_DATE(:b2,'YYYY-MM-DD-HH24.MI.SS')  AND A.CH_VALIDFROM >=
    (SELECT NVL(MAX(X.CH_VALIDFROM),TO_DATE('0001-01-01','YYYY-MM-DD'))   
  FROM CONTRACT_HISTORY X  WHERE X.CO_ID = :b1  AND X.CH_PENDING IS NULL  AND 
  X.CH_VALIDFROM <= TO_DATE(:b4,'YYYY-MM-DD-HH24.MI.SS') ) ORDER BY CH_SEQNO 
  DESC


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute    673      0.07       0.02          0          0          0           0
Fetch     1423      0.25       0.38         15      17128          0         750
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     2097      0.33       0.41         15      17128          0         750

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FILTER
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'CONTRACT_HISTORY'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN DESCENDING) OF 
                'PKCONTRACT_HISTORY' (UNIQUE)
      0    SORT (AGGREGATE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'CONTRACT_HISTORY'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                 'PKCONTRACT_HISTORY' (UNIQUE)

********************************************************************************

SELECT PARAMETER_TYPE_ID   
FROM
 PARAMETER_TYPE  WHERE PARAMETER_TYPE_CODE = 8192


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   4818      0.19       0.17          0          0          0           0
Fetch     4818      0.23       0.23          0       9636          0        4818
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     9637      0.42       0.40          0       9636          0        4818

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
              'PARAMETER_TYPE'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'UI_PARAMETER_TYPE' 
               (UNIQUE)

********************************************************************************

INSERT INTO DOCUMENT_REFERENCE 
( DOCUMENT_ID,
CUSTOMER_ID,
BILLSEQNO,
CONTR_GROUP,
DATE_CREATED,
OHXACT,
CSLEVEL,
TIMM_VERSION,
SPEC_CTRL_GRP, 
BILL_INS_CODE,  
BILL_INFORMATION, 
BILLCYCLE )  
VALUES ( :di,
:cd,
1120,
:cg,
TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),
DECODE( :oh,0,NULL,:oh ),
:CsLvl,
'600',
:scg, 
:ins , 
:bi, 
'02' )   

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    468      0.30       0.39         15         20       6151         468
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      469      0.30       0.39         15         20       6151         468

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT PARAMETER_TYPE_ID   
FROM
 PARAMETER_TYPE  WHERE PARAMETER_TYPE_CODE = 2048


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute   4818      0.20       0.29          0          0          0           0
Fetch     4818      0.11       0.08          0       9636          0        4818
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     9637      0.31       0.37          0       9636          0        4818

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
              'PARAMETER_TYPE'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'UI_PARAMETER_TYPE' 
               (UNIQUE)

********************************************************************************

INSERT INTO ORDERTAX_ITEMS
             ( OTXACT,
OTI_SEQNO,
TAXCAT_ID,
GL_CURRENCY,
DOCUMENT_CURRENCY,
TAX_CURRENCY,
TAXRATE,
TAXCALCBASE,
GLACODE,
TAXAMT_GL,
TAXAMT_DOC,
TAXAMT_TAX_CURR,
TAXAMT_EXEMPTED_GL,
TAXAMT_EXEMPTED_DOC,
TAXAMT_EXEMPTED_TAX_CURR,
CHARGE_GL,
CHARGE_DOC,
CHARGE_TAX_CURR,
CHARGE_EXEMPTED_GL,
CHARGE_EXEMPTED_DOC,
CHARGE_EXEMPTED_TAX_CURR,
REC_VERSION )
VALUES ( :xact,
:oti_seqno,
:taxcat_id,
:gl_currency,
:doc_currency,
:tax_currency,
:taxrate,
:calbase, 
:taxglcode,
:taxamt_gl,
:taxamt_doc,
:taxamt_tax_curr,
:taxamt_exempt_gl,
:taxamt_exempt_doc,
:taxamt_exempt_tax_curr,
:charge_gl, 
:charge_doc, 
:charge_tax_curr, 
:charge_exempt_gl, 
:charge_exempt_doc, 
:charge_exempt_tax_curr,
0 )

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute     29      0.19       0.35         14         44      12801        1395
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       30      0.19       0.35         14         44      12801        1395

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

UPDATE FEES 
SET PERIOD      = PERIOD - 1,     
REC_VERSION = REC_VERSION + 1 
WHERE CUSTOMER_ID = :cust
AND SEQNO       = :seq 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.02       0.31         28         39         29          27
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.02       0.31         28         39         29          27

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'FEES'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKFEES' (UNIQUE)

********************************************************************************

select A.CO_ID ,A.FFCODE ,B.LNG_ID ,A.DES ,A.SHDES ,A.SCALEFACTOR ,1  
from
 MPUFFTAB A ,LANGUAGE B ,BCH_PROCESS_CONTR BP where ((((A.CO_ID=
  BP.CONTRACT_ID and BP.CUSTOMER_SET_ID=:b0) and BP.BILLSEQNO=:b1) and 
  BP.BCH_PACKAGE_NUM=:b2) and B.LNG_DEF='X') union all select  /*+ Rule  +*/ 
  A.CO_ID ,A.FFCODE ,B.LNG_ID ,B.TRANSLATION ,A.SHDES ,A.SCALEFACTOR ,0  from 
  MPUFFTAB A ,NLS_DICT B ,LANGUAGE D ,NLS_RELEASE E ,BCH_PROCESS_CONTR BP 
  where (((((((((((A.CO_ID=BP.CONTRACT_ID and BP.CUSTOMER_SET_ID=:b0) and 
  BP.BILLSEQNO=:b1) and BP.BCH_PACKAGE_NUM=:b2) and A.FFCODE=B.KEY_VALUE) and 
  B.BASE_TAB='MPUFFTAB') and B.BASE_TAB=E.BASE_TAB) and B.TRAN_COL='DES') and 
  B.LNG_ID=D.LNG_ID) and B.LNG_ID=E.LNG_ID) and E.RELEASE_FLAG='Y') and 
  D.LNG_DEF<>'X') order by 1,2            


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch        6      0.02       0.30         37        823         72          69
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       13      0.02       0.30         37        823         72          69

Misses in library cache during parse: 0
Optimizer goal: RULE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: HINT: RULE
      0   SORT (ORDER BY)
      0    UNION-ALL
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'LANGUAGE'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'MPUFFTAB'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'FKIFKIFFCO' 
                  (NON-UNIQUE)
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        NESTED LOOPS
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'NLS_DICT'
      0          INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                     'FKIFKNLDIC' (NON-UNIQUE)
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'LANGUAGE'
      0          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKLANGUAGE' (UNIQUE)
      0        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                   'MPUFFTAB'
      0         INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKMPUFFTAB' 
                    (UNIQUE)
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                  'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'NLS_RELEASE'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PKNLS_RELEASE' 
                  (UNIQUE)

********************************************************************************

BEGIN                                        
UPDATE CONTR_TURNOVER 
SET CT_AMOUNT     = NVL( CT_AMOUNT,     0 ) + :amt,  
CT_AIRROAMER  = NVL( CT_AIRROAMER,  0 ) + :airr,  
CT_AIRNROAMER = NVL( CT_AIRNROAMER, 0 ) + :airnr, 
REC_VERSION   = REC_VERSION + 1 
WHERE CO_ID      = :co   
AND CURRENCY   = :curr 
AND CT_TU_DATE = TO_DATE( '2006-12-01-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' )  ; 
IF SQL%NOTFOUND THEN                                  
INSERT INTO CONTR_TURNOVER ( CO_ID,      
CUSTOMER_ID,
CT_TU_DATE, 
CURRENCY, 
CT_AMOUNT,  
CT_AIRROAMER,  
CT_AIRNROAMER )
VALUES ( :co,   
:cd,   
TO_DATE( '2006-12-01-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),    
:curr, 
:amt,  
:airr, 
:airnr )   ;   
END IF ;                                              
END ;                                                 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.01          0          0          0           0
Execute      6      0.25       0.27          0          0          0         528
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        7      0.26       0.28          0          0          0         528

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

update ORDERHDR_ALL  set OHREFNUM=:b1 
where
 (OHXACT=:b2 and 0<>:b2)


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.00       0.00          0          0          0           0
Execute      5      0.13       0.27         13       1124       1942         468
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       10      0.13       0.27         13       1124       1942         468

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
     99  UPDATE ORDERHDR_ALL 
     99   FILTER 
     99    INDEX UNIQUE SCAN (object id 10077)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
     99   UPDATE OF 'ORDERHDR_ALL'
     99    FILTER
     99     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKORDERHDR_ALL' 
                (UNIQUE)

********************************************************************************

select servcat_code ,serv_code ,serv_type ,customercat_code ,customergeo_code 
  ,taxcode ,to_char(valid_from,'YYYYMMDD') ,to_char(invalid_from,'YYYYMMDD') ,
  nvl(taxrate,0.0) ,nvl(glacode,' ') ,nvl(taxtype_id,0) ,nvl(legalcode,' ') ,
  tax_seqno ,NVL(taxcode_version_des,'') ,taxcat_id ,NVL(taxcat_name,'') ,
  zero_tax_default  
from
 SERVICE_TAX_VIEW  order by 1,2,3,4,5,6,7 desc             


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch       40      0.03       0.15         12        138         96          39
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       42      0.03       0.16         12        138         96          39

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
     39  SORT ORDER BY 
     39   NESTED LOOPS 
     40    NESTED LOOPS 
     40     HASH JOIN 
      2      VIEW TAX_CODE_VIEW 
      2       SORT UNIQUE 
      2        UNION-ALL 
      2         FILTER 
      3          NESTED LOOPS 
      3           NESTED LOOPS 
      3            TABLE ACCESS FULL TAX_CODE_VERSION 
      4            TABLE ACCESS BY INDEX ROWID TAX_CATEGORY 
      4             INDEX UNIQUE SCAN (object id 10552)
      4           TABLE ACCESS BY INDEX ROWID TAX_CODE 
      4            INDEX UNIQUE SCAN (object id 10554)
      0         FILTER 
      3          NESTED LOOPS 
      3           NESTED LOOPS 
      3            HASH JOIN 
      2             TABLE ACCESS FULL TAX_CODE_VERSION 
      2             TABLE ACCESS FULL TAX_CODE_VERSION 
      4            TABLE ACCESS BY INDEX ROWID TAX_CATEGORY 
      4             INDEX UNIQUE SCAN (object id 10552)
      4           TABLE ACCESS BY INDEX ROWID TAX_CODE 
      4            INDEX UNIQUE SCAN (object id 10554)
     39      TABLE ACCESS FULL SERVICE_TAX_CODE 
     78     TABLE ACCESS BY INDEX ROWID SERVICE_TAXATION 
     78      INDEX UNIQUE SCAN (object id 10474)
     39    TABLE ACCESS BY INDEX ROWID SERVICECATCODE 
     78     INDEX UNIQUE SCAN (object id 10453)
      4          SORT AGGREGATE 
      0           TABLE ACCESS FULL TAX_CODE_VERSION 
      4          SORT AGGREGATE 
      2           TABLE ACCESS FULL TAX_CODE_VERSION 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
     39   SORT (ORDER BY)
     39    NESTED LOOPS
     40     NESTED LOOPS
     40      HASH JOIN
      2       VIEW OF 'TAX_CODE_VIEW'
      2        SORT (UNIQUE)
      2         UNION-ALL
      2          FILTER
      3           NESTED LOOPS
      3            NESTED LOOPS
      3             TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                        'TAX_CODE_VERSION'
      4             TABLE ACCESS   GOAL: ANALYZED (BY INDEX 
                        ROWID) OF 'TAX_CATEGORY'
      4              INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                         'PKTAX_CATEGORY' (UNIQUE)
      4            TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) 
                       OF 'TAX_CODE'
      4             INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                        'PKTAX_CODE' (UNIQUE)
      4           SORT (AGGREGATE)
      2            TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                       'TAX_CODE_VERSION'
      0          FILTER
      3           NESTED LOOPS
      3            NESTED LOOPS
      3             HASH JOIN
      2              TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                         'TAX_CODE_VERSION'
      2              TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                         'TAX_CODE_VERSION'
      4             TABLE ACCESS   GOAL: ANALYZED (BY INDEX 
                        ROWID) OF 'TAX_CATEGORY'
      4              INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                         'PKTAX_CATEGORY' (UNIQUE)
      4            TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) 
                       OF 'TAX_CODE'
      4             INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                        'PKTAX_CODE' (UNIQUE)
      4           SORT (AGGREGATE)
      0            TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                       'TAX_CODE_VERSION'
     39       TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                  'SERVICE_TAX_CODE'
     78      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'SERVICE_TAXATION'
     78       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                  'PKSERVICE_TAXATION' (UNIQUE)
     39     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'SERVICECATCODE'
     78      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                 'SERVCAT_SERVCAT_ID' (UNIQUE)

********************************************************************************

insert into BCH_PROCESS_CONTR (CUSTOMER_SET_ID,BILLSEQNO,BCH_PACKAGE_NUM,
  CUSTOMER_ID,CONTRACT_ID) 
values
 (:s1 ,:s2 ,:s3 ,:s4 ,:s5 )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        6      0.01       0.01          0          0          0           0
Execute      6      0.02       0.13          8         23       2054         673
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       12      0.03       0.14          8         23       2054         673

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

UPDATE GLENTRY SET GLEAMT=NVL(GLEAMT,0) + :b1  
WHERE
 GLEXACT = :b2  AND GLECODE = :b3  AND GLESOURCE = :b4  AND GLECD = :b5  AND 
  CURRENCY = :b6  AND NVL(GLCOSTCENT,0) = :b7  AND NVL(GLJOBCOST,0) = :b8


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    231      0.13       0.13          6        973        128         128
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      232      0.13       0.13          6        973        128         128

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'GLENTRY_ALL'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'GLENTRY_ALL'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'GLENTRYINDEX' 
                (UNIQUE)

********************************************************************************

BEGIN                                        
UPDATE CUSTOMER_TURNOVER 
SET AMOUNT      = NVL( AMOUNT, 0 ) + :amt, 
REC_VERSION = REC_VERSION + 1 
WHERE CUSTOMER_ID = :cd 
AND CURRENCY    = :curr 
AND TU_DATE     = TO_DATE( '2006-12-01-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ) ; 
IF SQL%NOTFOUND THEN                        
INSERT INTO CUSTOMER_TURNOVER ( CUSTOMER_ID, 
CURRENCY,    
TU_DATE,     
AMOUNT )     
VALUES ( :cd,         
:curr,       
TO_DATE( '2006-12-01-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),          
:amt );      
END IF ;                                     
END ;                                        

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      0.08       0.11          0          0          0         468
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        7      0.08       0.11          0          0          0         468

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

BEGIN                                       
    UPDATE GLENTRY                              
       SET GLEAMT = NVL( GLEAMT, 0 ) + :amt      
     WHERE GLEXACT   = :glexact                 
       AND GLECODE   = :code                    
       AND GLESOURCE = :source                  
       AND GLECD     = :glecd                   
       AND CURRENCY  = :gl_curr                 
       AND NVL( GLCOSTCENT, 0 ) = :cc            
       AND NVL( GLJOBCOST,  0 ) = :jc;           
    IF SQL%NOTFOUND THEN                        
        INSERT INTO GLENTRY ( GLEXACT,              
                              GLESEQ,               
                              GLECODE,              
                              GLEENTDATE,           
                              GLECD,                
                              GLEAMT,               
                              CURRENCY,             
                              GLESOURCE,            
                              GLESOURCETIME,        
                              GLEREM,               
                              GLEPP,                
                              GLCOSTCENT,           
                              GLJOBCOST,            
                              GLEMOD,               
                              REC_VERSION )         
                     VALUES ( :glexact,             
                              :seq,                 
                              :code,                
                              TO_DATE( '2006-12-16-00.00.00', 'YYYY-MM-DD-HH24.MI.SS' ),                   
                              :glecd,               
                              :amt,                 
                              :gl_curr,             
                              :source,              
                              TO_DATE( '2006-12-18-10.22.12', 'YYYY-MM-DD-HH24.MI.SS' ),                   
                              'Billcycle 02, BCH_id 1',                 
                              '200102',                 
                              DECODE( :cc,0,NULL,:cc ), 
                              DECODE( :jc,0,NULL,:jc ), 
                              'X',                  
                              0 )  ;                
    END IF;                                     
END;                                        

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute      6      0.05       0.10          0          0          0         231
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        7      0.06       0.10          0          0          0         231

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

delete  from BCH_PROCESS_CONTR  
where
 ((CUSTOMER_SET_ID=:b0 and BILLSEQNO=:b1) and BCH_PACKAGE_NUM=:b2)


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.00       0.00          0          0          0           0
Execute      5      0.04       0.09          4         87        593         561
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       10      0.04       0.09          4         87        593         561

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  DELETE BCH_PROCESS_CONTR 
    115   TABLE ACCESS BY INDEX ROWID BCH_PROCESS_CONTR 
    115    INDEX RANGE SCAN (object id 8752)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  DELETE STATEMENT   GOAL: CHOOSE
      1   DELETE OF 'BCH_PROCESS_CONTR'
    115    INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'PK_BCH_PROCESS_CONTR' 
               (UNIQUE)

********************************************************************************

SELECT
RT.RULE_TEMPLATE_ID,
TO_CHAR(RTV.VERSION_DATE,'YYYY MM DD HH24 MI SS'),
RTV.COMPILED_IND,
RTC.RULE_NAME,
RTC.APPL_MECHANISM_NUM,
RTC.EVAL_MECHANISM_NUM
FROM
RULE_TEMPLATE               RT,
RULE_TEMPLATE_VERSION       RTV,
RULE_TEMPLATE_COMPILED      RTC
WHERE
RT.RULE_PURPOSE_CODE   = 2           AND
RTV.WORK_STATE       = 'P'                    AND
RTV.COMPILED_IND     = 'Y'                    AND
RT.RULE_TEMPLATE_ID  = RTV.RULE_TEMPLATE_ID   AND
RTV.RULE_NAME_ID     = RTC.RULE_NAME_ID

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        8      0.00       0.07          5         23         36           7
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       10      0.00       0.07          5         23         36           7

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      7  HASH JOIN 
     27   TABLE ACCESS FULL RULE_TEMPLATE_VERSION 
    147   MERGE JOIN CARTESIAN 
      8    TABLE ACCESS FULL RULE_TEMPLATE 
    147    SORT JOIN 
     21     TABLE ACCESS FULL RULE_TEMPLATE_COMPILED 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      7   HASH JOIN
     27    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
               'RULE_TEMPLATE_VERSION'
    147    MERGE JOIN (CARTESIAN)
      8     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'RULE_TEMPLATE'
    147     SORT (JOIN)
     21      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                 'RULE_TEMPLATE_COMPILED'

********************************************************************************

select count(1) 
from
 "SYSADM"."CUG_ADMINISTRATION" where "PAYMENT_CUSTOMER_ID" = :1 and 
  "FEE_SEQNO" = :2


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute    363      0.04       0.01          0          0          0           0
Fetch      363      0.12       0.06          0        726       1452         363
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      727      0.16       0.07          0        726       1452         363

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)
********************************************************************************

select file# 
from
 file$ where ts#=:1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       50      0.00       0.04          0          0          0           0
Execute     50      0.00       0.02          0          0          0           0
Fetch      100      0.00       0.00          0        150          0          50
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      200      0.00       0.06          0        150          0          50

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY INDEX ROWID FILE$ 
      2   INDEX RANGE SCAN (object id 39)

********************************************************************************

SELECT MIN(PRM_VALID_FROM)   
FROM
 PARAMETER_VALUE  WHERE PRM_VALUE_ID = :b1  AND DELETED_FLAG IS NULL


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute     11      0.00       0.00          0          0          0           0
Fetch       11      0.00       0.06          7         44          0          11
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       23      0.00       0.06          7         44          0          11

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (AGGREGATE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'PARAMETER_VALUE'
      0     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                'IN_PRMVALUE_ID_REQ_SEQ' (NON-UNIQUE)

********************************************************************************

SELECT RA.REFNUM_ID,REFNUM_MAINTENANCE_TYPE,RANGE_AUTOEXTENSION_TYPE,
  REFNUM_VERSION,VALID_FROM,PERIOD_TYPE,FIRST_REF_VALUE,REFNUM_PREFIX,
  REFNUM_SUFFIX,VALUE_LENGTH,RANGE_LENGTH   
FROM
 REFNUM_ACCESS RA,REFNUM_BASE RB,REFNUM_VERSION RV  WHERE REFERENCE_TABLE = 
  :b1  AND REFERENCE_COLUMN = :b2  AND REFERENCE_CHAR_CONDITION = :b3  AND 
  REFERENCE_INT_CONDITION = :b4  AND RA.REFNUM_ID = RB.REFNUM_ID  AND 
  RB.REFNUM_ID = RV.REFNUM_ID  AND VALID_FROM =  (SELECT MAX(VALID_FROM)   
  FROM REFNUM_VERSION  WHERE REFNUM_ID = RB.REFNUM_ID  AND VALID_FROM <= :b5 )
  


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          0          0           0
Fetch        5      0.00       0.06          5         35          0           5
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       11      0.00       0.06          5         35          0           5

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      0    NESTED LOOPS
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'REFNUM_ACCESS'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_REFNUM_ACCESS' 
                 (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'REFNUM_BASE'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_REFNUM_BASE' 
                 (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'REFNUM_VERSION'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'UK_REFNUM_VERSION' 
                (UNIQUE)
      0      SORT (AGGREGATE)
      0       FIRST ROW
      0        INDEX   GOAL: ANALYZED (RANGE SCAN (MIN/MAX)) OF 
                   'UK_REFNUM_VERSION' (UNIQUE)

********************************************************************************

update tsq$ set blocks=:3,maxblocks=:4,grantor#=:5,priv1=:6,priv2=:7,priv3=:8 
where
 ts#=:1 and user#=:2


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       50      0.00       0.00          0          0          0           0
Execute     50      0.01       0.05          0        300         50          50
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      100      0.01       0.05          0        300         50          50

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  UPDATE TSQ$ 
      2   TABLE ACCESS CLUSTER TSQ$ 
      2    INDEX UNIQUE SCAN (object id 11)

********************************************************************************

update DOCUMENT_REFERENCE  set INVOICE_REFNUM=:b1,OHXACT=DECODE(:b2,0,OHXACT,
  :b2) 
where
 DOCUMENT_ID=:b4


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.00       0.00          0          0          0           0
Execute      5      0.07       0.05          0        486       1882         468
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       10      0.07       0.05          0        486       1882         468

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
     99  UPDATE DOCUMENT_REFERENCE 
     99   INDEX UNIQUE SCAN (object id 9103)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
     99   UPDATE OF 'DOCUMENT_REFERENCE'
     99    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
               'PK_DOCUMENT_REFERENCE' (UNIQUE)

********************************************************************************

SELECT MIN(RANGE_CNT)   
FROM
 REFNUM_VALUE  WHERE REFNUM_ID = :b1  AND REFNUM_VERSION = :b2  AND 
  PERIOD_CNT = :b3  AND RANGE_ACTIVE_IND = 'Y'  AND (LAST_REFERENCE_DATE <= 
  :b4  OR :b5 = 0 )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          0          0           0
Fetch        5      0.00       0.05          2          5         20           5
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       11      0.00       0.05          2          5         20           5

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (AGGREGATE)
      0    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'REFNUM_VALUE'

********************************************************************************

UPDATE DIRECTORY_NUMBER DN SET DN.DN_STATUS='d' 
WHERE
 DN.DN_ID IN (SELECT DISTINCT DN_ID   FROM CONTR_SERVICES_CAP CSC  WHERE 
  CSC.CO_ID = :b1  AND CSC.SNCODE = :b2  AND NOT EXISTS  (SELECT 1   FROM 
  CONTR_SERVICES CS  WHERE CS.CO_ID = :b1  AND CS.SNCODE = :b2 )   AND NOT 
  EXISTS  (SELECT 1   FROM CONTR_SERVICES_CAP CSC1  WHERE CSC.DN_ID = 
  CSC1.DN_ID  AND (CSC1.CO_ID != :b1  OR CSC1.SNCODE != :b2 ))  )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute     15      0.01       0.04          4         87          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       16      0.01       0.04          4         87          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'DIRECTORY_NUMBER'
      0    NESTED LOOPS
      0     VIEW OF 'VW_NSO_1'
      0      SORT (UNIQUE)
      0       FILTER
      0        FILTER
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'CONTR_SERVICES_CAP'
      0          INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                     'PKCONTR_SERVICES_CAP' (UNIQUE)
      0         INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                    'PKCONTR_SERVICES' (UNIQUE)
      0        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                   'CONTR_SERVICES_CAP'
      0         INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                    'FKICONSCAP_DN_ID' (NON-UNIQUE)
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKDIRECTORY_NUMBER' 
                (UNIQUE)

********************************************************************************

select condition 
from
 cdef$ where rowid=:1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       21      0.00       0.00          0          0          0           0
Execute     29      0.00       0.00          0          0          0           0
Fetch       29      0.00       0.03          2         61          0          29
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       79      0.00       0.03          2         61          0          29

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 2)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY USER ROWID CDEF$ 

********************************************************************************

select B.MLG_ID ,B.CUSTOMER_ID ,B.TEXT_ID ,T.SHDES ,B.DN_NUM ,B.GEOCODE ,
  B.ZIP ,B.BILLCYCLE ,C.CA_AGE_LOW_BND ,C.CA_AGE_UPP_BND ,B.FIRST_BILL ,
  B.LAST_BILL ,B.HU_MODE ,B.HU_ALL_CONTRACTS ,B.HU_CASH_THRESH ,B.CURRENCY ,
  B.HU_CLICK_THRESH ,B.HU_UNIT_THRESH ,B.HU_UNIT_QUALIFIER ,A.DESCRIPTION ,
  B.TMCODE ,B.SPCODE ,B.SNCODE ,P.PRGCODE ,B.PR ,B.POSOPNAMT ,B.NEGOPNAMT ,
  A.LNG_ID  
from
 BLUIFTAB B ,BLUTXTAB_ALL T ,ADVERTISING_TEXT A ,PRICEGROUP P ,LANGUAGE L ,
  ES_CUST_AGE C ,BCH_PROCESS_CUST X where ((((((((((B.PRGSEQNUM=P.PRGSEQNUM(+)
   and B.LNG_ID=L.LNG_ID) and B.TEXT_ID=T.TEXT_ID) and (T.REWARD<>'X' or 
  T.REWARD is null )) and B.CUST_AGE=C.CA_ID(+)) and B.TEXT_ID=A.TEXT_ID(+)) 
  and X.CUSTOMER_ID=B.CUSTOMER_ID) and X.CUSTOMER_SET_ID=:dolCustomerSet) and 
  X.BILLSEQNO=:dolBillSeqNo) and X.BCH_PACKAGE_NUM=:dolPackageNo) and 
  X.CUSTOMER_PROCESS_STATUS='I') order by T.MLG_ID,B.CUSTOMER_ID,B.TEXT_ID,
  B.DN_NUM,B.GEOCODE,B.ZIP,B.BILLCYCLE,B.CUST_AGE,B.HU_MODE,
  B.HU_ALL_CONTRACTS,B.HU_CASH_THRESH,B.HU_CLICK_THRESH,B.HU_UNIT_THRESH,
  B.HU_UNIT_QUALIFIER,B.TMCODE,B.SPCODE,B.SNCODE,B.PR,B.POSOPNAMT,B.NEGOPNAMT,
  B.LNG_ID 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          0          0           0
Fetch        5      0.00       0.03          3          5         20           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       15      0.00       0.03          3          5         20           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  SORT ORDER BY 
      0   NESTED LOOPS 
      1    HASH JOIN OUTER 
      0     NESTED LOOPS 
      1      NESTED LOOPS 
      1       NESTED LOOPS OUTER 
      1        NESTED LOOPS OUTER 
      1         TABLE ACCESS FULL BLUIFTAB 
      0         TABLE ACCESS BY INDEX ROWID PRICEGROUP_ALL 
      0          INDEX UNIQUE SCAN (object id 10172)
      0        TABLE ACCESS BY INDEX ROWID ES_CUST_AGE 
      0         INDEX UNIQUE SCAN (object id 9161)
      0       INDEX UNIQUE SCAN (object id 9331)
      0      TABLE ACCESS BY INDEX ROWID BLUTXTAB_ALL 
      0       INDEX UNIQUE SCAN (object id 8814)
      0     TABLE ACCESS FULL ADVERTISING_TEXT 
      0    TABLE ACCESS BY INDEX ROWID BCH_PROCESS_CUST 
      0     INDEX UNIQUE SCAN (object id 8754)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (ORDER BY)
      0    NESTED LOOPS
      1     HASH JOIN (OUTER)
      0      NESTED LOOPS
      1       NESTED LOOPS
      1        NESTED LOOPS (OUTER)
      1         NESTED LOOPS (OUTER)
      1          TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                     'BLUIFTAB'
      0          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'PRICEGROUP_ALL'
      0           INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                      'PRICEGRPSEQINDEX' (UNIQUE)
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'ES_CUST_AGE'
      0          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKES_CUST_AGE' (UNIQUE)
      0        INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKLANGUAGE' 
                   (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'BLUTXTAB_ALL'
      0        INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                   'PKBLUTXTAB_ALL' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                 'ADVERTISING_TEXT'
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'BCH_PROCESS_CUST'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                 'PK_BCH_PROCESS_CUST' (UNIQUE)

********************************************************************************

BEGIN                                                                            
    UPDATE BCH_CONTROL                                                           
       SET AMOUNT             = NVL (AMOUNT, 0.0)          + :amount,             
           SUBSCR_CONT        = NVL (SUBSCR_CONT ,0)       + :subscr_cont,        
           NO_OF_UNDEF_CALLS  = NVL (NO_OF_UNDEF_CALLS,0)  + :no_of_undef_calls,  
           NO_OF_UNDEF_CLICKS = NVL (NO_OF_UNDEF_CLICKS,0) + :no_of_undef_clicks, 
           UNDEF_RATED_VOLUME = NVL (UNDEF_RATED_VOLUME,0) + :undef_rated_volume, 
           UNDEF_ROUND_VOLUME = NVL (UNDEF_ROUND_VOLUME,0) + :undef_round_volume, 
           UNDEF_AMOUNT       = NVL (UNDEF_AMOUNT, 0.0)    + :undef_amount,       
           CUSTOMER_NUM       = NVL (CUSTOMER_NUM, 0)      + :customer_num,       
           CONTRACT_NUM       = NVL (CONTRACT_NUM, 0)      + :contract_num,       
           RTX_NUM            = NVL (RTX_NUM, 0)           + :rtx_num,            
           BILLING_DURATION   = NVL (BILLING_DURATION, 0)  + :billing_duration    
     WHERE CUSTOMER_SET_ID = :customer_set_id                                    
       AND BILLSEQNO       = :billseqno                                          
       AND BCH_CONTROL_ID  = :bch_control_id;                                    
    IF SQL%NOTFOUND THEN                                                        
        INSERT INTO BCH_CONTROL                                                  
                    ( AMOUNT,              
                      SUBSCR_CONT,         
                      NO_OF_UNDEF_CALLS,   
                      NO_OF_UNDEF_CLICKS,  
                      UNDEF_RATED_VOLUME,  
                      UNDEF_ROUND_VOLUME,  
                      UNDEF_AMOUNT,        
                      CUSTOMER_NUM,        
                      CONTRACT_NUM,        
                      RTX_NUM,             
                      BILLING_DURATION,    
                      BCH_PROCESS_ID,      
                      END_DATE,            
                      CURRENCY,            
                      CUSTOMER_SET_ID,     
                      BILLSEQNO,           
                      BCH_CONTROL_ID )     
             VALUES ( :amount,             
                      :subscr_cont,        
                      :no_of_undef_calls,  
                      :no_of_undef_clicks, 
                      :undef_rated_volume, 
                      :undef_round_volume, 
                      :undef_amount,       
                      :customer_num,       
                      :contract_num,       
                      :rtx_num,            
                      :billing_duration,   
                      :bch_process_id,     
                      NULL,                
                      :currency,           
                      :customer_set_id,    
                      :billseqno,          
                      :bch_control_id );   
    END IF;                                
END;                                       

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      5      0.01       0.02          0          0          0           5
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.01       0.03          0          0          0           5

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

INSERT INTO BCH_CONTROL ( AMOUNT,SUBSCR_CONT,NO_OF_UNDEF_CALLS,
  NO_OF_UNDEF_CLICKS,UNDEF_RATED_VOLUME,UNDEF_ROUND_VOLUME,UNDEF_AMOUNT,
  CUSTOMER_NUM,CONTRACT_NUM,RTX_NUM,BILLING_DURATION,BCH_PROCESS_ID,END_DATE,
  CURRENCY,CUSTOMER_SET_ID,BILLSEQNO,BCH_CONTROL_ID )  
VALUES
 ( :b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9,:b10,:b11,:b12, NULL ,:b13,:b14,:b15,
  :b16  )


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      1      0.00       0.02          3          1          5           1
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.03          3          1          5           1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  INSERT STATEMENT   GOAL: CHOOSE

********************************************************************************

SELECT
RT.RULE_TEMPLATE_ID,
TO_CHAR(RTV.VERSION_DATE,'YYYY MM DD HH24 MI SS'),
RTV.COMPILED_IND,
RTI.RULE_TEMPLATE_TEXT,
RT.APPL_MECHANISM_NUM,
RT.EVAL_MECHANISM_NUM
FROM
RULE_TEMPLATE               RT,
RULE_TEMPLATE_VERSION       RTV,
RULE_TEMPLATE_INTERPRETED   RTI
WHERE
RT.RULE_PURPOSE_CODE   = 2           AND
RTV.WORK_STATE       = 'P'                    AND
RTV.COMPILED_IND     = 'N'                    AND
RT.RULE_TEMPLATE_ID  = RTV.RULE_TEMPLATE_ID   AND
RTV.INTERPRETED_ID = RTI.INTERPRETED_ID          

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.02          2          5         12           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.02          2          5         12           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  NESTED LOOPS 
      1   NESTED LOOPS 
      1    TABLE ACCESS FULL RULE_TEMPLATE_VERSION 
      0    TABLE ACCESS BY INDEX ROWID RULE_TEMPLATE_INTERPRETED 
      0     INDEX UNIQUE SCAN (object id 10440)
      0   TABLE ACCESS BY INDEX ROWID RULE_TEMPLATE 
      0    INDEX UNIQUE SCAN (object id 10435)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      1    NESTED LOOPS
      1     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                'RULE_TEMPLATE_VERSION'
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'RULE_TEMPLATE_INTERPRETED'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                 'PK_RULE_TEMPLATE_INTERPRETED' (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'RULE_TEMPLATE'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_RULE_TEMPLATE' 
                (UNIQUE)

********************************************************************************

SELECT COUNT(*) 
FROM
 GLENTRY WHERE GLEXACT= 1058


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.02          2          3          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.02          2          3          0           1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  SORT AGGREGATE 
      0   TABLE ACCESS BY INDEX ROWID GLENTRY_ALL 
      1    INDEX RANGE SCAN (object id 9221)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      1   SORT (AGGREGATE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'GLENTRY_ALL'
      1     INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'GLENTRYINDEX' 
                (UNIQUE)

********************************************************************************

begin ReferenceNumber . AllocRefnums ( :basetab , :basecol , :status , :typ , 
  :count1 , :vdate , :retvalue , :refarr ) ; END ;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.00       0.00          0          0          0           0
Execute      5      0.01       0.02          0          0          0           5
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       10      0.01       0.02          0          0          0           5

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

BEGIN
    DELETE FROM CONTR_SERVICES 
     WHERE CO_ID    = :co 
       AND CS_SEQNO = :seq 
       AND TMCODE   = :tm 
       AND SPCODE   = :sp 
       AND SNCODE   = :sn 
       AND CS_PENDING_STATE IS NULL; 
    IF SQL%FOUND THEN 
        UPDATE DIRECTORY_NUMBER DN 
           SET DN.DN_STATUS = 'd' 
         WHERE DN.DN_ID IN 
             ( SELECT DISTINCT DN_ID 
                 FROM CONTR_SERVICES_CAP CSC 
                WHERE CSC.CO_ID  = :co 
                  AND CSC.SNCODE = :sn 
                  AND NOT EXISTS 
                      ( SELECT 1 
                          FROM CONTR_SERVICES CS 
                         WHERE CS.CO_ID  = :co 
                           AND CS.SNCODE = :sn ) 
                  AND NOT EXISTS 
                      ( SELECT 1 
                          FROM CONTR_SERVICES_CAP CSC1 
                         WHERE CSC.DN_ID = CSC1.DN_ID 
                           AND ( CSC1.CO_ID  <> :co OR 
                                 CSC1.SNCODE <> :sn ))); 
    END IF; 
END; 

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      0.01       0.02          0          0          0          15
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        7      0.01       0.02          0          0          0          15

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

UPDATE BCH_CONTROL SET AMOUNT=NVL(AMOUNT,0.0) + :b1 ,SUBSCR_CONT=
  NVL(SUBSCR_CONT,0) + :b2 ,NO_OF_UNDEF_CALLS=NVL(NO_OF_UNDEF_CALLS,0) + :b3 ,
  NO_OF_UNDEF_CLICKS=NVL(NO_OF_UNDEF_CLICKS,0) + :b4 ,UNDEF_RATED_VOLUME=
  NVL(UNDEF_RATED_VOLUME,0) + :b5 ,UNDEF_ROUND_VOLUME=NVL(UNDEF_ROUND_VOLUME,
  0) + :b6 ,UNDEF_AMOUNT=NVL(UNDEF_AMOUNT,0.0) + :b7 ,CUSTOMER_NUM=
  NVL(CUSTOMER_NUM,0) + :b8 ,CONTRACT_NUM=NVL(CONTRACT_NUM,0) + :b9 ,RTX_NUM=
  NVL(RTX_NUM,0) + :b10 ,BILLING_DURATION=NVL(BILLING_DURATION,0) + :b11  
WHERE
 CUSTOMER_SET_ID = :b12  AND BILLSEQNO = :b13  AND BCH_CONTROL_ID = :b14


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      5      0.00       0.01          1          5          4           4
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.00       0.02          1          5          4           4

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'BCH_CONTROL'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_BCH_CONTROL' 
               (UNIQUE)

********************************************************************************

SELECT PERIOD_CNT,PERIOD_ACTIVE_IND   
FROM
 REFNUM_PERIOD  WHERE REFNUM_ID = :b1  AND REFNUM_VERSION = :b2  AND 
  PERIOD_START_DATE = :b3


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          0          0           0
Fetch        5      0.00       0.02          2         10          0           5
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       11      0.00       0.02          2         10          0           5

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
              'REFNUM_PERIOD'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'UK_REFNUM_PERIOD' 
               (UNIQUE)

********************************************************************************

select user# 
from
 sys.user$ where name = 'OUTLN'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.01          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          3          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          0          3          0           1

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 2)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY INDEX ROWID USER$ 
      1   INDEX UNIQUE SCAN (object id 41)

********************************************************************************

select taxcode ,to_char(valid_from,'YYYYMMDD') ,to_char(invalid_from,
  'YYYYMMDD') ,nvl(taxrate,0.0) ,nvl(glacode,' ') ,nvl(taxtype_id,0) ,
  nvl(legalcode,' ') ,tax_seqno ,NVL(taxcode_version_des,'') ,taxcat_id ,
  NVL(taxcat_name,'') ,zero_tax_default  
from
 TAX_CODE_VIEW where zero_tax_default='X' order by 1,2 desc             


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.01       0.01          1         38         72           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.01       0.01          1         38         72           1

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  SORT ORDER BY 
      1   VIEW TAX_CODE_VIEW 
      1    SORT UNIQUE 
      1     UNION-ALL 
      1      FILTER 
      2       NESTED LOOPS 
      2        NESTED LOOPS 
      3         TABLE ACCESS FULL TAX_CODE_VERSION 
      3         TABLE ACCESS BY INDEX ROWID TAX_CATEGORY 
      4          INDEX UNIQUE SCAN (object id 10552)
      2        TABLE ACCESS BY INDEX ROWID TAX_CODE 
      2         INDEX UNIQUE SCAN (object id 10554)
      0      FILTER 
      2       NESTED LOOPS 
      2        HASH JOIN 
      2         MERGE JOIN CARTESIAN 
      2          TABLE ACCESS FULL TAX_CATEGORY 
      2          SORT JOIN 
      2           TABLE ACCESS FULL TAX_CODE_VERSION 
      2         TABLE ACCESS FULL TAX_CODE_VERSION 
      2        TABLE ACCESS BY INDEX ROWID TAX_CODE 
      2         INDEX UNIQUE SCAN (object id 10554)
      2       SORT AGGREGATE 
      0        TABLE ACCESS FULL TAX_CODE_VERSION 
      2       SORT AGGREGATE 
      1        TABLE ACCESS FULL TAX_CODE_VERSION 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      1   SORT (ORDER BY)
      1    VIEW OF 'TAX_CODE_VIEW'
      1     SORT (UNIQUE)
      1      UNION-ALL
      1       FILTER
      2        NESTED LOOPS
      2         NESTED LOOPS
      3          TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                     'TAX_CODE_VERSION'
      3          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'TAX_CATEGORY'
      4           INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                      'PKTAX_CATEGORY' (UNIQUE)
      2         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'TAX_CODE'
      2          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKTAX_CODE' (UNIQUE)
      2        SORT (AGGREGATE)
      1         TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                    'TAX_CODE_VERSION'
      0       FILTER
      2        NESTED LOOPS
      2         HASH JOIN
      2          MERGE JOIN (CARTESIAN)
      2           TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                      'TAX_CATEGORY'
      2           SORT (JOIN)
      2            TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                       'TAX_CODE_VERSION'
      2          TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                     'TAX_CODE_VERSION'
      2         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'TAX_CODE'
      2          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKTAX_CODE' (UNIQUE)
      2        SORT (AGGREGATE)
      0         TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                    'TAX_CODE_VERSION'

********************************************************************************

select TE.customer_id ,TE.TAXTYPE_ID ,TE.SEQ_NO ,to_char(TE.EXPIRATION_DATE,
  'YYYYMMDD') ,to_char(TE.VALID_FROM,'YYYYMMDD') ,TT.DESCRIPTION  
from
 TAX_EXEMPT TE ,TAXTYPE TT where TE.TAXTYPE_ID=TT.TAXTYPE_ID order by 
  TE.customer_id,TE.TAXTYPE_ID,TE.VALID_FROM            


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.01       0.00          0          0          0           0
Fetch        6      0.00       0.01          0          7         16         267
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        8      0.01       0.01          0          7         16         267

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
    267  SORT ORDER BY 
    267   HASH JOIN 
      2    TABLE ACCESS FULL TAXTYPE 
    267    TABLE ACCESS FULL TAX_EXEMPT 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
    267   SORT (ORDER BY)
    267    HASH JOIN
      2     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'TAXTYPE'
    267     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'TAX_EXEMPT'

********************************************************************************

ALTER SESSION SET PARTITION_VIEW_ENABLED = TRUE 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.01          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.01          0          0          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

SELECT
 A.RULE_PACK_ID,
TO_CHAR(B.VALID_FROM,'YYYY MM DD HH24 MI SS')
FROM RULE_PACK A,
     GL_PACK B
WHERE A.WORK_STATE = 'P' AND
STATE_DATE <  TO_DATE( '2006-12-16-00-00-00', 'YYYY-MM-DD-HH24-MI-SS' )
AND A.RULE_PURPOSE_CODE =
2
AND A.RULE_PACK_ID = B.RULE_PACK_ID
ORDER BY B.VALID_FROM DESC

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.01          1          1          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          1          1          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  NESTED LOOPS 
      1   TABLE ACCESS BY INDEX ROWID GL_PACK 
      1    INDEX FULL SCAN DESCENDING (object id 9232)
      0   TABLE ACCESS BY INDEX ROWID RULE_PACK 
      0    INDEX UNIQUE SCAN (object id 10431)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      1    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'GL_PACK'
      1     INDEX   GOAL: ANALYZED (FULL SCAN DESCENDING) OF 
                'PK_GL_PACK' (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'RULE_PACK'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_RULE_PACK' 
                (UNIQUE)

********************************************************************************

SELECT
 RULE_MODEL_ID
FROM RULE_MODEL
WHERE  WORK_STATE = 'P' AND
STATE_DATE <  TO_DATE( '2006-12-16-00-00-00', 'YYYY-MM-DD-HH24-MI-SS' )
  AND RULE_PURPOSE_CODE =
2

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.01          1          0          4           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          1          0          4           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  TABLE ACCESS FULL RULE_MODEL 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'RULE_MODEL'

********************************************************************************

SELECT DISTINCT
RE.RULE_ELEMENT_ID,
RE.RULE_TEMPLATE_ID
FROM
RULE_ELEMENT           RE,
RULE_ELEMENT_VERSION   REV
WHERE
RE.RULE_PURPOSE_CODE   = 2           AND
REV.WORK_STATE       = 'P'  AND
REV.VERSION_DATE <  TO_DATE( '2006-12-16-00-00-00', 'YYYY-MM-DD-HH24-MI-SS' )
AND RE.RULE_ELEMENT_ID   = REV.RULE_ELEMENT_ID

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.01          1          0          4           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          1          0          4           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  SORT UNIQUE 
      0   NESTED LOOPS 
      1    TABLE ACCESS FULL RULE_ELEMENT 
      0    TABLE ACCESS BY INDEX ROWID RULE_ELEMENT_VERSION 
      0     INDEX RANGE SCAN (object id 10412)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (UNIQUE)
      0    NESTED LOOPS
      1     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'RULE_ELEMENT'
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'RULE_ELEMENT_VERSION'
      0      INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                 'PK_RULE_ELEMENT_VERSION' (UNIQUE)

********************************************************************************

SELECT
A.RULE_PACK_ID,
A.RULE_MODEL_ID
FROM RULE_MODEL_PACK A,
     RULE_PACK B
WHERE A.RULE_PACK_ID = B.RULE_PACK_ID
  AND B.RULE_PURPOSE_CODE =
2

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.01          1          1          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          1          1          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  NESTED LOOPS 
      1   INDEX FULL SCAN (object id 10429)
      0   TABLE ACCESS BY INDEX ROWID RULE_PACK 
      0    INDEX UNIQUE SCAN (object id 10431)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      1    INDEX   GOAL: ANALYZED (FULL SCAN) OF 'PK_RULE_PACK_MODEL' 
               (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'RULE_PACK'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_RULE_PACK' 
                (UNIQUE)

********************************************************************************

SELECT
A.RULE_MODEL_ID,
A.PRIORITY_NUM,
A.RULE_ELEMENT_ID
FROM RULE_ENTRY A,
     RULE_MODEL B
WHERE A.RULE_MODEL_ID = B.RULE_MODEL_ID
  AND B.RULE_PURPOSE_CODE =
2

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.01          1          0          4           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          1          0          4           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  NESTED LOOPS 
      1   TABLE ACCESS FULL RULE_ENTRY 
      0   TABLE ACCESS BY INDEX ROWID RULE_MODEL 
      0    INDEX UNIQUE SCAN (object id 10427)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      1    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'RULE_ENTRY'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'RULE_MODEL'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_RULE_MODEL' 
                (UNIQUE)

********************************************************************************

SELECT
A.RULE_ELEMENT_ID,
A.RULE_MECH_ID,
A.TEMPLATE_POSITION,
B.LOGIC_SUBTYPE_ID,
A.EVAL_OR_APPL
FROM RULE_MECH_ELEMENT    A,
     RULE_MECH            B
WHERE A.RULE_MECH_ID = B.RULE_MECH_ID
  AND B.RULE_PURPOSE_CODE =
2

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.01          1          0          4           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.01          1          0          4           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  NESTED LOOPS 
      1   TABLE ACCESS FULL RULE_MECH_ELEMENT 
      0   TABLE ACCESS BY INDEX ROWID RULE_MECH 
      0    INDEX UNIQUE SCAN (object id 10423)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      1    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'RULE_MECH_ELEMENT'
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'RULE_MECH'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKRULE_MECH' 
                (UNIQUE)

********************************************************************************

select text 
from
 view$ where rowid=:1


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        3      0.00       0.00          0          0          0           0
Execute      3      0.00       0.00          0          0          0           0
Fetch        3      0.00       0.01          1          6          0           3
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        9      0.00       0.01          1          6          0           3

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 1)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY USER ROWID VIEW$ 

********************************************************************************

SELECT NEXT_REF_VALUE   
FROM
 REFNUM_VALUE  WHERE REFNUM_ID = :b1  AND REFNUM_VERSION = :b2  AND 
  PERIOD_CNT = :b3  AND RANGE_CNT = :b4 FOR UPDATE


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.00       0.01          1         10          5           0
Fetch        5      0.00       0.00          0          0          0           5
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       11      0.00       0.01          1         10          5           5

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   FOR UPDATE
      0    FILTER
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'REFNUM_VALUE'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_REFNUM_VALUE' 
                 (UNIQUE)

********************************************************************************

select taxcode ,tax_seqno ,to_char(valid_from,'YYYYMMDD') ,
  to_char(invalid_from,'YYYYMMDD') ,taxrate ,glacode ,taxtype_id ,
  nvl(legalcode,' ') ,NVL(taxcode_version_des,'') ,taxcat_id ,NVL(taxcat_name,
  '')  
from
 TAX_CODE_VIEW  order by 1,2            


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        3      0.00       0.00          0         51         84           2
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        5      0.00       0.00          0         51         84           2

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      2  SORT ORDER BY 
      2   VIEW TAX_CODE_VIEW 
      2    SORT UNIQUE 
      2     UNION-ALL 
      2      FILTER 
      3       NESTED LOOPS 
      3        NESTED LOOPS 
      3         TABLE ACCESS FULL TAX_CODE_VERSION 
      4         TABLE ACCESS BY INDEX ROWID TAX_CATEGORY 
      4          INDEX UNIQUE SCAN (object id 10552)
      4        TABLE ACCESS BY INDEX ROWID TAX_CODE 
      4         INDEX UNIQUE SCAN (object id 10554)
      0      FILTER 
      3       NESTED LOOPS 
      3        NESTED LOOPS 
      3         HASH JOIN 
      2          TABLE ACCESS FULL TAX_CODE_VERSION 
      2          TABLE ACCESS FULL TAX_CODE_VERSION 
      4         TABLE ACCESS BY INDEX ROWID TAX_CATEGORY 
      4          INDEX UNIQUE SCAN (object id 10552)
      4        TABLE ACCESS BY INDEX ROWID TAX_CODE 
      4         INDEX UNIQUE SCAN (object id 10554)
      4       SORT AGGREGATE 
      0        TABLE ACCESS FULL TAX_CODE_VERSION 
      4       SORT AGGREGATE 
      2        TABLE ACCESS FULL TAX_CODE_VERSION 


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      2   SORT (ORDER BY)
      2    VIEW OF 'TAX_CODE_VIEW'
      2     SORT (UNIQUE)
      2      UNION-ALL
      2       FILTER
      3        NESTED LOOPS
      3         NESTED LOOPS
      3          TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                     'TAX_CODE_VERSION'
      4          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'TAX_CATEGORY'
      4           INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                      'PKTAX_CATEGORY' (UNIQUE)
      4         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'TAX_CODE'
      4          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKTAX_CODE' (UNIQUE)
      4        SORT (AGGREGATE)
      2         TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                    'TAX_CODE_VERSION'
      0       FILTER
      3        NESTED LOOPS
      3         NESTED LOOPS
      3          HASH JOIN
      2           TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                      'TAX_CODE_VERSION'
      2           TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                      'TAX_CODE_VERSION'
      4          TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                     'TAX_CATEGORY'
      4           INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                      'PKTAX_CATEGORY' (UNIQUE)
      4         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'TAX_CODE'
      4          INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                     'PKTAX_CODE' (UNIQUE)
      4        SORT (AGGREGATE)
      0         TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                    'TAX_CODE_VERSION'

********************************************************************************

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD-HH24.MI.SS' 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

ALTER SESSION SET NLS_LANGUAGE = AMERICAN 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '. ' 


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.01       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2      0.01       0.00          0          0          0           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)
********************************************************************************

SELECT
A.RULE_MECH_ID,
C.EVAL_OR_APPL,
C.LOGIC_TYPE_ID,
A.LOGIC_SUBTYPE_ID,
B.LOGIC_SUBTYPE_CODE
FROM RULE_MECH          A,
     RULE_LOGIC_SUBTYPE B,
     RULE_LOGIC_TYPE C
WHERE WORK_STATE = 'P' AND
STATE_DATE <  TO_DATE( '2006-12-16-00-00-00', 'YYYY-MM-DD-HH24-MI-SS' )
AND A.LOGIC_SUBTYPE_ID = B.LOGIC_SUBTYPE_ID
AND B.LOGIC_TYPE_ID    = C.LOGIC_TYPE_ID
 AND A.RULE_PURPOSE_CODE =
2

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          1          0          4           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          1          0          4           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      0  NESTED LOOPS 
      1   NESTED LOOPS 
      1    TABLE ACCESS FULL RULE_MECH 
      0    TABLE ACCESS BY INDEX ROWID RULE_LOGIC_SUBTYPE 
      0     INDEX UNIQUE SCAN (object id 10416)
      0   TABLE ACCESS BY INDEX ROWID RULE_LOGIC_TYPE 
      0    INDEX UNIQUE SCAN (object id 10419)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      1    NESTED LOOPS
      1     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'RULE_MECH'
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'RULE_LOGIC_SUBTYPE'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                 'PK_RULE_LOGIC_SUBTYPE' (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
               'RULE_LOGIC_TYPE'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_RULE_LOGIC_TYPE' 
                (UNIQUE)

********************************************************************************

select ULCFF1 ,ULCFF2 into :b0:b1,:b2:b3  
from
 USERLBL where ULTAG='ARRDDFT'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY INDEX ROWID USERLBL 
      2   INDEX UNIQUE SCAN (object id 10676)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      1   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'USERLBL'
      2    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKUSERLBL' (UNIQUE)

********************************************************************************

select ulcff1 ,ulcff2 ,ulcff3 ,ulcff4 into :b0:b1,:b2:b3,:b4:b5,:b6:b7  
from
 USERLBL where ULTAG='AR_FC_BALANCE_GL'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY INDEX ROWID USERLBL 
      1   INDEX UNIQUE SCAN (object id 10676)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      1   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'USERLBL'
      1    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKUSERLBL' (UNIQUE)

********************************************************************************

select uldtff1 into :b0:b1  
from
 USERLBL where ULTAG='AR_FC_BALANCE'


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        1      0.00       0.00          0          2          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        3      0.00       0.00          0          2          0           1

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS BY INDEX ROWID USERLBL 
      1   INDEX UNIQUE SCAN (object id 10676)


Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      1   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'USERLBL'
      1    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKUSERLBL' (UNIQUE)

********************************************************************************

select blocks,maxblocks,grantor#,priv1,priv2,priv3 
from
 tsq$ where ts#=:1 and user#=:2


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        2      0.00       0.00          0          0          0           0
Execute      2      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.00          0          8          0           2
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.00       0.00          0          8          0           2

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: SYS   (recursive depth: 2)

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  TABLE ACCESS CLUSTER TSQ$ 
      1   INDEX UNIQUE SCAN (object id 11)

********************************************************************************

SELECT
SCOPE,
nvl(SCCODE,0),
INT_LEVEL,
INT_EXPONENT,
INT_LENGTH,
INT_MINLENGTH,
INT_RND_MINLENGTH,
FORCURR_ID,
INVOICE_SCALE
FROM ROUNDING_STRATEGY
ORDER BY FORCURR_ID DESC,
SCOPE

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        3      0.00       0.00          0          5         12           2
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        5      0.00       0.00          0          5         12           2

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (ORDER BY)
      0    TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'ROUNDING_STRATEGY'

********************************************************************************

SELECT STOPIND                               
  FROM BCH_MONITOR_TABLE                     
 WHERE BILLCYCLE            = :BillCycle     
   AND CONTROL_GROUP_IND    = :CntrlGroupInd 
   AND BILL_INFORMATION_IND = :BillInfoInd   

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        0      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          0          0           0
Fetch       10      0.00       0.00          0         10          0           5
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       15      0.00       0.00          0         10          0           5

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
              'BCH_MONITOR_TABLE'
      0    INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_BCH_MONITOR_TABLE' 
               (UNIQUE)

********************************************************************************

select C.CO_ID ,C.SNCODE ,C.QUANTITY ,TO_CHAR(C.VALIDFROM,'YYYYMMDD') ,
  TO_CHAR(C.CBB_DATE,'YYYYMMDD')  
from
 CONTR_VAS C ,BCH_PROCESS_CONTR B where (((B.CONTRACT_ID=C.CO_ID and 
  B.CUSTOMER_SET_ID=:b0) and B.BILLSEQNO=:b1) and B.BCH_PACKAGE_NUM=:b2) 
  order by C.CO_ID asc ,C.SNCODE asc ,C.VALIDFROM asc ,C.SEQNO asc            
   


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch        6      0.00       0.00          0          0         24           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       13      0.00       0.00          0          0         24           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (ORDER BY)
      0    NESTED LOOPS
      0     TABLE ACCESS   GOAL: ANALYZED (FULL) OF 'CONTR_VAS'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                'PK_BCH_PROCESS_CONTR' (UNIQUE)

********************************************************************************

select DNB.DN_ID ,DNB.DN_BLOCK_ID ,DNB.LOWER_EXTENSION ,DNB.UPPER_EXTENSION  
from
 BCH_PROCESS_CONTR BPC ,CONTR_SERVICES_CAP CSC ,DIRECTORY_NUMBER_BLOCK DNB 
  where (((((((CSC.SEQNO=(select max(SEQNO)  from CONTR_SERVICES_CAP where 
  ((((CO_ID=CSC.CO_ID and SNCODE=CSC.SNCODE) and CS_ACTIV_DATE<TO_DATE(:b0,
  'YYYY-MM-DD-HH24.MI.SS')) and (CS_DEACTIV_DATE is null  or CS_DEACTIV_DATE>=
  (TO_DATE(:b0,'YYYY-MM-DD-HH24.MI.SS')-:b2))) and CSC.MAIN_DIRNUM='X')) or 
  CSC.SEQNO=(select max(SEQNO)  from CONTR_SERVICES_CAP where ((((CO_ID=
  CSC.CO_ID and SNCODE=CSC.SNCODE) and CS_ACTIV_DATE<TO_DATE(:b0,
  'YYYY-MM-DD-HH24.MI.SS')) and (CS_DEACTIV_DATE is null  or CS_DEACTIV_DATE>=
  (TO_DATE(:b0,'YYYY-MM-DD-HH24.MI.SS')-:b2))) and CSC.MAIN_DIRNUM<>'X'))) 
  and BPC.CONTRACT_ID=CSC.CO_ID) and BPC.BCH_PACKAGE_NUM=:b6) and 
  BPC.BILLSEQNO=:b7) and BPC.CUSTOMER_SET_ID=:b8) and CSC.DN_ID=DNB.DN_ID) 
  and CSC.DN_BLOCK_ID=DNB.DN_BLOCK_ID) order by CSC.CO_ID,CSC.CS_ACTIV_DATE   
           


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      6      0.00       0.00          0          0          0           0
Fetch        6      0.00       0.00          0          0         24           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total       13      0.00       0.00          0          0         24           0

Misses in library cache during parse: 0
Optimizer goal: CHOOSE
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   SORT (ORDER BY)
      0    FILTER
      0     NESTED LOOPS
      0      MERGE JOIN (CARTESIAN)
      0       TABLE ACCESS   GOAL: ANALYZED (FULL) OF 
                  'DIRECTORY_NUMBER_BLOCK'
      0       SORT (JOIN)
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PK_BCH_PROCESS_CONTR' (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'CONTR_SERVICES_CAP'
      0       INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                  'MYDNID_CNTR_SERV_CAP' (NON-UNIQUE)
      0     SORT (AGGREGATE)
      0      FILTER
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_SERVICES_CAP'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTR_SERVICES_CAP' (UNIQUE)
      0     SORT (AGGREGATE)
      0      FILTER
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'CONTR_SERVICES_CAP'
      0        INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                   'PKCONTR_SERVICES_CAP' (UNIQUE)

********************************************************************************

SELECT
TO_CHAR(REV.VERSION_DATE,'YYYY MM DD HH24 MI SS'),
REVA.LINE_NUM,
REVA.EVAL_OR_APPL,
REVA.TEMPLATE_POSITION,
REVA.RULE_VALUE,
NVL( RME.CURRENCY, -1 ),
DT.DATA_TYPE_CODE
FROM
RULE_ELEMENT_VERSION    REV,
RULE_ELEMENT_VALUE      REVA,
RULE_MECH_ELEMENT       RME,
RULE_MECH               RM,
RULE_LOGIC_SUBTYPE      RLS,
DATA_CLASS              DC,
DATA_TYPE               DT
WHERE
  REV.RULE_ELEMENT_ID = :rule_element_id
                                                AND
REV.WORK_STATE         = 'P'                    AND
REV.RULE_ELEMENT_ID    = REVA.RULE_ELEMENT_ID   AND
REV.VERSION            = REVA.VERSION           AND
REVA.RULE_ELEMENT_ID   = RME.RULE_ELEMENT_ID    AND
REVA.EVAL_OR_APPL      = RME.EVAL_OR_APPL       AND
REVA.TEMPLATE_POSITION = RME.TEMPLATE_POSITION  AND
RME.RULE_MECH_ID       = RM.RULE_MECH_ID        AND
RM.LOGIC_SUBTYPE_ID    = RLS.LOGIC_SUBTYPE_ID   AND
RLS.DATA_CLASS_ID      = DC.DATA_CLASS_ID       AND
DC.DATA_TYPE_ID        = DT.DATA_TYPE_ID

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      0      0.00       0.00          0          0          0           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        1      0.00       0.00          0          0          0           0

Misses in library cache during parse: 0
Parsing user id: 50  (BCH)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT   GOAL: CHOOSE
      0   NESTED LOOPS
      0    NESTED LOOPS
      0     NESTED LOOPS
      0      NESTED LOOPS
      0       NESTED LOOPS
      0        NESTED LOOPS
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'RULE_ELEMENT_VERSION'
      0          INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                     'PK_RULE_ELEMENT_VERSION' (UNIQUE)
      0         TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                    'RULE_ELEMENT_VALUE'
      0          INDEX   GOAL: ANALYZED (RANGE SCAN) OF 
                     'PK_RULE_ELEMENT_VALUE' (UNIQUE)
      0        TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                   'RULE_MECH_ELEMENT'
      0         INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_RUME_EL' 
                    (UNIQUE)
      0       TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                  'RULE_MECH'
      0        INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PKRULE_MECH' 
                   (UNIQUE)
      0      TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                 'RULE_LOGIC_SUBTYPE'
      0       INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 
                  'PK_RULE_LOGIC_SUBTYPE' (UNIQUE)
      0     TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 
                'DATA_CLASS'
      0      INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_DATA_CLASS' 
                 (UNIQUE)
      0    TABLE ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF 'DATA_TYPE'
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_DATA_TYPE' 
                (UNIQUE)

********************************************************************************

UPDATE REFNUM_VALUE SET NEXT_REF_VALUE=NEXT_REF_VALUE + :b1 ,
  LAST_REFERENCE_DATE=:b2 
WHERE
 REFNUM_ID = :b3  AND REFNUM_VERSION = :b4  AND PERIOD_CNT = :b5  AND 
  RANGE_CNT = :b6


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      5      0.00       0.00          0          5          5           5
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        6      0.00       0.00          0          5          5           5

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 256  (SYSADM)   (recursive depth: 1)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  UPDATE STATEMENT   GOAL: CHOOSE
      0   UPDATE OF 'REFNUM_VALUE'
      0    FILTER
      0     INDEX   GOAL: ANALYZED (UNIQUE SCAN) OF 'PK_REFNUM_VALUE' 
                (UNIQUE)




********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      110      0.13       0.13          0          0          0           0
Execute   5217     39.16     482.25      41069     206148     508011       67493
Fetch     6378     15.48     270.32      27728     295345        792       19647
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    11705     54.77     752.70      68797     501493     508803       87140

Misses in library cache during parse: 21


OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse      157      0.04       0.11          0          0          0           0
Execute  48393      4.41      21.23       1635       4774      13246        1302
Fetch    52402      8.33      57.38       5007     456573      37652       46861
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   100952     12.78      78.72       6642     461347      50898       48163

Misses in library cache during parse: 29

  147  user  SQL statements in session.
  128  internal SQL statements in session.
  275  SQL statements in session.
   87  statements EXPLAINed in this session.
********************************************************************************
Trace file: sty_prod_ora_11020.trc
Trace file compatibility: 8.00.04
Sort options: prsela  fchela  exeela  
       1  session in tracefile.
     147  user  SQL statements in trace file.
     128  internal SQL statements in trace file.
     275  SQL statements in trace file.
     106  unique SQL statements in trace file.
      87  SQL statements EXPLAINed using schema:
           SYSADM.prof$plan_table
             Default table was used.
             Table was created.
             Table was dropped.
  115282  lines in trace file.


