RE_OPEX_AGMT_VW

(SQL View)
 Index Back

View for Agreement No.


SELECT DISTINCT L.LS_NBR ,LT.AGREEMENT_NUM FROM PS_RE_LS_TRM LT ,PS_RE_LS_TXN LX ,PS_RE_LS_TRM_SCHED LS ,PS_RE_LS L WHERE L.LS_KEY = LT.LS_KEY AND LT.LS_KEY = LX.LS_KEY AND LX.LS_KEY = LS.LS_KEY AND LS.TERM_SCHED_ID = LX.LS_TXN_SRC_ID AND LS.TERM_ID = LT.TERM_ID AND LX.LS_TXN_STATUS = '5' AND LX.TXN_GRP = '4'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
2 AGREEMENT_NUM Character(10) VARCHAR2(10) NOT NULL Agreement Number