RE_LS_ACT_VW (SQL View)	Index Back
Lease view by Number for BU View from PS_RE_LS containing lease Number and Name by Obligation

RE_LS_ACT_VW

(SQL View)

Lease view by Number for BU

View from PS_RE_LS containing lease Number and Name by Obligation

SELECT LS_NBR , BUSINESS_UNIT , LEASE_NAME FROM PS_RE_LS WHERE LEASE_STATUS = '2' AND LS_CLASSIFICATION = 'O' AND LEASE_OBLG = '1'

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 LEASE_NAME Character(60) VARCHAR2(60) NOT NULL Lease Name

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name