LS_KEYLS_OPTION_SEQLANGUAGE_CDRE_OPTION1_LG(SQL View) |
Index Back |
|---|---|
Real Estate Option Instance NmReal Estate Option Instance Name and Mail template language record |
| SELECT A.LS_KEY , A.LS_OPTION_SEQ , E.LANGUAGE_CD , E.INSTANCE_NAME , E.MAIL_TEMPLATE FROM PS_RE_OPT_RECIP A , PS_RE_LS_OPTION B , PS_SET_CNTRL_REC C , PS_RE_LS D , PS_RE_OPT_LG E WHERE A.LS_KEY = B.LS_KEY AND A.LS_OPTION_SEQ = B.LS_OPTION_SEQ AND A.LS_KEY = D.LS_KEY AND C.RECNAME = 'RE_OPTION' AND C.SETCNTRLVALUE = D.BUSINESS_UNIT AND C.SETID = E.SETID AND B.OPTION_CD = E.OPTION_CD AND E.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RE_OPTION E1 WHERE E.SETID = E1.SETID AND E.OPTION_CD = E1.OPTION_CD AND E1.EFFDT <= %CurrentDateIn) |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | INSTANCE_NAME | Character(60) | VARCHAR2(60) NOT NULL | Instance Name |
| 5 | MAIL_TEMPLATE | Long Character(300) | VARCHAR2(300) | Mail Template Field to store Lease Options Mail Template |