LEASENOMONTH_VW

(SQL View)
Index Back

SELECT DISTINCT LEASE_SCHED.BUSINESS_UNIT , LEASE_SCHED.ASSET_ID FROM PS_LEASE_SCHED LEASE_SCHED , PS_LEASE LEASE , PS_LEASE_SCH_ID LEASE_SCH_ID WHERE LEASE_SCHED.BUSINESS_UNIT = LEASE.BUSINESS_UNIT AND LEASE_SCHED.ASSET_ID = LEASE.ASSET_ID AND LEASE_SCHED.PYMNT_FREQUENCY <> 'M' AND ((LEASE_SCHED.PYMNT_FREQUENCY <> ' ') OR (LEASE_SCHED.PYMNT_FREQUENCY = ' ' AND LEASE_SCH_ID.PRORATE_LEASE_SW = 'Y')) AND LEASE_SCH_ID.PYMNT_SCHED_ID = LEASE.PYMNT_SCHED_ID AND LEASE_SCH_ID.SETID IN %Sql(GET_SETID, LEASE.BUSINESS_UNIT, 'LEASE_SCH_ID')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification