RE_LEASE_SRCH (SQL View)	Index Back
Custom Lease Maint search This view will be used in Lease Custom Search page. The search Results Grid will be based on this view

RE_LEASE_SRCH

(SQL View)

Custom Lease Maint search

This view will be used in Lease Custom Search page. The search Results Grid will be based on this view

SELECT A.BUSINESS_UNIT ,A.LS_NBR ,A.LS_KEY ,A.LEASE_OBLG ,A.LEASE_STATUS ,A.LEASE_NAME ,A.REGION_CD ,B.DESCR ,A.LS_ADMIN ,LA_NAME.OPRDEFNDESC ,PRTFL_MGR ,PM_NAME.OPRDEFNDESC ,A.LSE_TYPE_CD FROM %Table(RE_LS) A LEFT OUTER JOIN ( %Table(RE_EFF_REGION) B JOIN %Table(SET_CNTRL_REC) C ON B.SETID = C.SETID AND C.RECNAME = 'RE_REGION' ) ON B.REGION_CD = A.REGION_CD AND C.SETCNTRLVALUE = A.BUSINESS_UNIT LEFT OUTER JOIN (%Table(RE_INT_PARTY) LA JOIN %Table(PSOPRDEFN_VW) LA_NAME ON LA.OPRID=LA_NAME.OPRID ) ON A.LS_ADMIN=LA.PARTY_KEY LEFT OUTER JOIN (%Table(RE_INT_PARTY) PM JOIN %Table(PSOPRDEFN_VW) PM_NAME ON PM.OPRID=PM_NAME.OPRID) ON A.PRTFL_MGR=PM.PARTY_KEY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RE_NONVW

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

3 LS_KEY Number(15,0) DECIMAL(15) NOT NULL Lease Key, Unique Key

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

5 LEASE_STATUS Character(1) VARCHAR2(1) NOT NULL Lease Status
1=Pending
2=Active
3=Canceled
4=Disputed
5=Expired
6=Holdover
7=Closed
8=Transferred

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

7 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

9 LS_ADMIN Number(10,0) DECIMAL(10) NOT NULL Lease Administrator

10 LS_ADMIN_DESC Character(30) VARCHAR2(30) NOT NULL Lease Admin Description
Prompt Table: RE_LEASE_ADMIN

11 PRTFL_MGR Number(10,0) DECIMAL(10) NOT NULL Portfolio Manager

12 PRTFL_MGR_DESC Character(30) VARCHAR2(30) NOT NULL Portfolio Manager Description
Prompt Table: RE_PORTFL_MGR

13 LSE_TYPE_CD Character(10) VARCHAR2(10) NOT NULL This field contains the code for the Lease Types

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RE_NONVW
2	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number
3	LS_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
4	LEASE_OBLG	Character(1)	VARCHAR2(1) NOT NULL	Lease Obligation either Payables or Receivables Lease 1=Payables 2=Receivables
5	LEASE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Lease Status 1=Pending 2=Active 3=Canceled 4=Disputed 5=Expired 6=Holdover 7=Closed 8=Transferred
6	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name
7	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	LS_ADMIN	Number(10,0)	DECIMAL(10) NOT NULL	Lease Administrator
10	LS_ADMIN_DESC	Character(30)	VARCHAR2(30) NOT NULL	Lease Admin Description Prompt Table: RE_LEASE_ADMIN
11	PRTFL_MGR	Number(10,0)	DECIMAL(10) NOT NULL	Portfolio Manager
12	PRTFL_MGR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Portfolio Manager Description Prompt Table: RE_PORTFL_MGR
13	LSE_TYPE_CD	Character(10)	VARCHAR2(10) NOT NULL	This field contains the code for the Lease Types