SAR_IDOPTION_SEQLANGUAGE_CDRE_SAR_OPMT_LG(SQL View) |
Index Back |
|---|---|
Real Estate Option Instance NmReal Estate Option Instance Name and Mail template language record |
| SELECT A.SAR_ID , A.OPTION_SEQ , E.LANGUAGE_CD , E.INSTANCE_NAME , E.MAIL_TEMPLATE FROM PS_RE_SAR_OPTRECIP A , PS_RE_SAR_OPTION B , PS_SET_CNTRL_REC C , PS_RE_SAR_DETAIL D , PS_RE_OPT_LG E WHERE A.SAR_ID = B.SAR_ID AND A.OPTION_SEQ = B.OPTION_SEQ AND A.SAR_ID = D.SAR_ID 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 | SAR_ID |
Character(15) | VARCHAR2(15) NOT NULL | SAR ID |
| 2 | 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 |