SAR_IDOPTION_SEQRE_SAR_OPMT(SQL View) |
Index Back |
|---|---|
Real Estate Option Instance NmGet the Option Name and Mail Template based on the Business Unit of the Lease. |
| SELECT A.SAR_ID , A.OPTION_SEQ , C.INSTANCE_NAME , C.MAIL_TEMPLATE FROM PS_RE_SAR_OPTION A , PS_RE_SAR_DETAIL B , PS_RE_OPTION C , PS_SET_CNTRL_REC D WHERE A.SAR_ID = B.SAR_ID 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' |
| # | 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 | 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 |