RE_LS_STLN_SRCH (SQL View)	Index Back
Straight Line Search Straight Line Search

RE_LS_STLN_SRCH

(SQL View)

Straight Line Search

SELECT L.BUSINESS_UNIT , L.LS_KEY ,L.LS_NBR , L.LEASE_NAME FROM PS_RE_LS L , PS_RE_LS_PPTY P , PS_INSTALLATION_RE R WHERE P.LS_KEY = L.LS_KEY AND L.LEASE_STATUS IN ('2','5','6') AND P.ASSET_CLASSIFY = 'O' AND ( ((R.NEW_ACCT_RULE = 'Y' AND L.LEASE_OBLG = '2') OR (R.NEW_ACCT_RULE = 'Y' AND L.RECOGNITION_EXEMPT = 'Y' AND L.LEASE_OBLG = '1')) OR (R.NEW_ACCT_RULE = 'N' AND L.LEASE_OBLG IN ('1','2')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 LS_NBR Character(10) VARCHAR2(10) NOT NULL Lease Number, User Enterable or Generated Sequence Number
Prompt Table: RE_LS_STL_PRMPT
Set Control Field: LS_NBR

4 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_KEY	Number(15,0)	DECIMAL(15) NOT NULL	Lease Key, Unique Key
3	LS_NBR	Character(10)	VARCHAR2(10) NOT NULL	Lease Number, User Enterable or Generated Sequence Number Prompt Table: RE_LS_STL_PRMPT Set Control Field: LS_NBR
4	LEASE_NAME	Character(60)	VARCHAR2(60) NOT NULL	Lease Name