RE_OPTION1

(SQL View)
 Index Back

Real Estate Option Instance Nm

Get the Option Name and Mail Template based on the Business Unit of the Lease.

SELECT A.LS_KEY , A.LS_OPTION_SEQ , C.INSTANCE_NAME , C.MAIL_TEMPLATE FROM PS_RE_LS_OPTION A , PS_RE_LS B , PS_RE_OPTION C , PS_SET_CNTRL_REC D WHERE A.LS_KEY = B.LS_KEY AND D.RECNAME = 'RE_OPTION' AND D.SETCNTRLVALUE = B.BUSINESS_UNIT AND C.SETID = D.SETID AND A.OPTION_CD = C.OPTION_CD AND %CurrentDateIn BETWEEN C.EFFDT AND C.END_EFFDT AND C.EFF_STATUS = 'A'

  • Related Language Record: RE_OPTION1_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key
    2 LS_OPTION_SEQ Number(10,0) DECIMAL(10) NOT NULL Lease Option Sequence Key
    3 INSTANCE_NAME Character(60) VARCHAR2(60) NOT NULL Instance Name
    4 MAIL_TEMPLATE Long Character(300) VARCHAR2(300) Mail Template Field to store Lease Options Mail Template