View: PN_PAYMENT_SCHEDULES_V

Product:	PN - Property Manager
Description:	Form view used to input payment schedules information
Implementation/DBA Data:	APPS.PN_PAYMENT_SCHEDULES_V

View Text

SELECT PS.ROWID ROW_ID
, PS.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, PS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY LAST_UPDATED_BY
, PS.CREATION_DATE CREATION_DATE
, PS.CREATED_BY CREATED_BY
, PS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PS.SCHEDULE_DATE SCHEDULE_DATE
, PS.LEASE_CHANGE_ID LEASE_CHANGE_ID
, PS.LEASE_ID LEASE_ID
, PS.APPROVED_BY_USER_ID APPROVED_BY_USER_ID
, PS.TRANSFERRED_BY_USER_ID TRANSFERRED_BY_USER_ID
, PS.PAYMENT_STATUS_LOOKUP_CODE PAYMENT_STATUS_LOOKUP_CODE
, PS.APPROVAL_DATE APPROVAL_DATE
, PS.TRANSFER_DATE TRANSFER_DATE
, PS.PERIOD_NAME PERIOD_NAME
, PS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PS.ATTRIBUTE1 ATTRIBUTE1
, PS.ATTRIBUTE2 ATTRIBUTE2
, PS.ATTRIBUTE3 ATTRIBUTE3
, PS.ATTRIBUTE4 ATTRIBUTE4
, PS.ATTRIBUTE5 ATTRIBUTE5
, PS.ATTRIBUTE6 ATTRIBUTE6
, PS.ATTRIBUTE7 ATTRIBUTE7
, PS.ATTRIBUTE8 ATTRIBUTE8
, PS.ATTRIBUTE9 ATTRIBUTE9
, PS.ATTRIBUTE10 ATTRIBUTE10
, PS.ATTRIBUTE11 ATTRIBUTE11
, PS.ATTRIBUTE12 ATTRIBUTE12
, PS.ATTRIBUTE13 ATTRIBUTE13
, PS.ATTRIBUTE14 ATTRIBUTE14
, PS.ATTRIBUTE15 ATTRIBUTE15
, PS.ON_HOLD ON_HOLD
, LEASE.NAME LEASE_NAME
, LEASE.LEASE_NUM LEASE_NUMBER
, FNA.USER_NAME USER_APPROVED_BY
, FNT.USER_NAME USER_TRANSFERRED_BY
, LEASE.LEASE_CLASS_CODE LEASE_CLASS_CODE
, PS.ORG_ID ORG_ID
FROM FND_USER FNA
, FND_USER FNT
, PN_LEASES_ALL LEASE
, PN_PAYMENT_SCHEDULES PS
WHERE NVL(PS.ORG_ID
, -99) = NVL(LEASE.ORG_ID
, -99)
AND FNA.USER_ID (+) = PS.APPROVED_BY_USER_ID
AND FNT.USER_ID (+) = PS.TRANSFERRED_BY_USER_ID
AND LEASE.LEASE_ID = PS.LEASE_ID

Columns