RE_LS_NBRBU_VND (SQL View)	Index Back
Lease view by Number and BU View from PS_RE_LS containing lease Number and Name by Obligation. This view selects the lease with a Customer associated defined as supplier.

RE_LS_NBRBU_VND

(SQL View)

Lease view by Number and BU

View from PS_RE_LS containing lease Number and Name by Obligation. This view selects the lease with a Customer associated defined as supplier.

SELECT DISTINCT A.LEASE_OBLG , A.LS_NBR , A.BUSINESS_UNIT , A.LEASE_NAME FROM PS_RE_LS A , PS_SET_CNTRL_REC B WHERE LEASE_STATUS IN ('2', '5', '6') AND B.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.RECNAME = 'CUSTOMER' AND EXISTS ( SELECT 'X' FROM PS_VENDOR_AR C WHERE C.CUST_SETID = B.SETID AND C.CUST_ID = A.PRINCIPAL_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LEASE_OBLG Character(1) VARCHAR2(1) NOT NULL Lease Obligation either Payables or Receivables Lease
1=Payables
2=Receivables

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

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

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

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