Table : tmp_rep_sum
  ---------------------- 
    
  
  P_ID               NUMBER, 
  PR_GLBL_ID         VARCHAR2 (50)  NOT NULL, 
  SC_GLBL_ID         VARCHAR2 (50)  NOT NULL, 
  PR_RX_ID           NUMBER 
  SC_RX_ID           NUMBER 
  PR_RX_GE_ID        NUMBER 
  SC_RX_GE_ID        NUMBER 
  PR_PH_ID           NUMBER 
  SC_PH_ID           NUMBER 
  PR_STRT_DT         DATE 
  SC_STRT_DT         DATE 
  PR_END_DT          DATE 
  SC_END_DT          DATE 
  PR_PS_PK_ID        NUMBER 
  SC_PS_PK_ID        NUMBER 
  PR_DS_PK_ID        NUMBER 
  SC_DS_PK_ID        NUMBER 
  PR_ID              VARCHAR2 (20) 
  SC_ID              VARCHAR2 (20) 
  PR_EX_ID           VARCHAR2 (20) 
  SC_EX_ID           VARCHAR2 (20) 
  SUM_CD             VARCHAR2 (20) 
  DET_CD             VARCHAR2 (20))
  
 Index1
 ---------
 AK1TMP_REP_SUM ON TMP_REP_SUM(PR_GLBL_ID); 

Index2
----------
 AK2TMP_REP_SUM ON TMP_REP_SUM(SC_GLBL_ID)  


Index3
--------
AK4TMP_REP_SUM ON TMP_REP_SUM(DET_CD)  
 

Index4
---------
AK3TMP_REP_SUM ON TMP_REP_SUM (P_ID,SC_ID, SC_STRT_DT, SC_END_DT)