Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R18452'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R18452    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R18451'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R18451    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S46595'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S46595    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S49137    '                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B05329'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33812'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33812    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R23054'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R23054    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32142'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32142    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33812'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33812    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B46562'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B46562    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B18400'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B18400    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B18591    '                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B18591    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R04507'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R18453'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R18453    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R04507'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R18452'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R18452    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S32275'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S32275    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B57409'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B57409    
 Enter Hehe 4  : 
 gcErrormessage : 01~No Details exist for the Criteria Selected by You.
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R11711'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R11711    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B21378'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B21378    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B21378'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B21378    
 Enter Hehe 1  : 
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B21378'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B21378    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33812'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33812    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33813'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33813    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33812'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33812    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S4600'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S4600     
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S4690'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S4690     
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='S46215'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : S46215    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33813'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33813    
 Enter Hehe 4  : 
 gcErrormessage : 01~No Details exist for the Criteria Selected by You.
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B33812'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B33812    
 Enter Hehe 4  : 
 gcErrormessage : 01~No Details exist for the Criteria Selected by You.
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='C45001'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : C45001    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R18453'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R18453    
 Enter Hehe 4  : 
 gcErrormessage : 01~No Details exist for the Criteria Selected by You.
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B05693'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B05693    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B05693'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B05693    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B45A160'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B45A160   
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B45A160'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B45A160   
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='R54008'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : R54008    
 Enter Hehe 4  : 
 Enter Hehe 5  : 
 Enter Hehe 1  : 
 Enter Hehe 2  : 
 Enter Hehe 3  : 
     With tbltempclientid as         (Select distinct Cldp.Dpid as cClientid              From Cldp Cldp                 Inner join ldfibs Ldfibs                     On Cldp.Oowncode=Ldfibs.Oowncode                    and Cldp.Firmnumber=Ldfibs.Firmnumber                 Where Cldp.Firmnumber = 'REN-000001'                  and Ldfibs.Oowncode='B60278'                   and Cldp.cPowerofattorney='Y'          )         Select tblpledgeemst.CDPCODE as CDPCODE,             tblpledgeemst.CDPID as CDPID,             TRIM(tblpledgeemst.CPLEDGEENAME) as CPLEDGEENAME        from tblpledgeemst tblpledgeemst             Inner join tbltempclientid tbltempclientid                 On tblpledgeemst.cDpid=tbltempclientid.cClientid        Where tblpledgeemst.cFirmnumber= 'REN-000001'        And tblpledgeemst.nexchangemargin = 0         and tblpledgeemst.Nfundedstock=0          And TRIM(tblpledgeemst.CPLEDGEENAME) = 'TM - PLEDGE'      Order by CDPCODE 
 Enter Hehe 4  : 
 lcPledgeDpCode 00436243  
 lcPledgeDpId 12013700  
 lctermCode : B60278    
 Enter Hehe 4  : 
 Enter Hehe 5  :