RE_RECV_REFUND (SQL View)	Index Back
Receivables Lease View Receivable Leases with Active or Expired Status.

RE_RECV_REFUND

(SQL View)

Receivables Lease View

Receivable Leases with Active or Expired Status.

SELECT BUSINESS_UNIT , LS_NBR , LEASE_NAME FROM PS_RE_LS WHERE LEASE_OBLG = '2' AND LEASE_STATUS = '5' AND EXISTS( SELECT 'X' FROM PS_RE_DEPOSIT WHERE PS_RE_DEPOSIT.LS_KEY = PS_RE_LS.LS_KEY AND SEC_DEPOSIT_STATUS = '2')

# 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