RE_OLS_PRINC_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.PRINCIPAL_ID , ( SELECT L.PRINCIPAL_NAME1 FROM PS_RE_LANDLORD_VW L WHERE A.PRINCIPAL_ID = L.VENDOR_ID) AS LANDLORD FROM PS_RE_LS A LEFT OUTER JOIN PS_RE_LS_PPTY B ON A.LS_KEY = B.LS_KEY LEFT OUTER JOIN PS_RE_LS_PRFCTG A1 ON A.LS_KEY = A1.LS_KEY AND A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND B.ASSET_ID = A1.ASSET_ID , PS_ASSET AT WHERE B.BUSINESS_UNIT_AM = AT.BUSINESS_UNIT AND B.ASSET_ID = AT.ASSET_ID AND A.LS_CLASSIFICATION = 'O' AND A.LEASE_OBLG = '1'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRINCIPAL_ID Character(15) VARCHAR2(15) NOT NULL Landlord/Tenant
3 PRINCIPAL_NAME1 Character(40) VARCHAR2(40) NOT NULL Used to hold Tenant/Landlord name when switching between VENDOR and CUSTOMER data

Prompt Table: RE_LANDLORD_VW