RE_LS_OPAY_NBR (SQL View)	Index Back
Lease view by Number and name View from PS_RE_LS containing lease Number and Name by Business unit and Obligation

RE_LS_OPAY_NBR

(SQL View)

Lease view by Number and name

View from PS_RE_LS containing lease Number and Name by Business unit and Obligation

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
3	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name