VIEW: APPS.FA_LEASE_PAYMENT_ITEMS_V

Source

View Text - Preformatted

SELECT FLPI.Rowid Row_ID, FLPI.Lease_ID Lease_ID, FL.Lease_Number Lease_Number, FLPI.Payment_Schedule_ID Payment_Schedule_ID, FLPI.Schedule_Amort_Line_Num Schedule_Amort_Line_Num, FAS.Payment_Amount Payment_Amount, FAS.Payment_Date Payment_Date, FLPI.Export_Status Export_Status, FLPI.Lessor_Site_ID Lessor_Site_ID, FLPI.Dist_Code_Combination_ID Dist_Code_Combination_ID, FLPI.Invoice_ID Invoice_ID, FLPI.Invoice_Number Invoice_Number, FLPI.Invoice_Line_ID Invoice_Line_ID, FL.Currency_Code Currency_Code, PVS.Vendor_Site_Code Lessor_Site_Name, PVS.Vendor_ID Lessor_ID, PV.Vendor_Name Lessor_Name, PV.Segment1 Lessor_Num, FLPI.Last_Update_Date Last_Update_Date, FLPI.Last_Updated_by Last_Updated_by, FLPI.Created_by Created_by, FLPI.Creation_Date Creation_Date, FLPI.Last_Update_Login Last_Update_Login, FLPI.Request_ID Request_ID, FLPI.Terms_ID Terms_ID FROM FA_Lease_Payment_Items FLPI, FA_Leases FL, FA_Amort_Schedules FAS, PO_Vendors PV, PO_Vendor_Sites_All PVS WHERE FLPI.Lease_ID = FL.Lease_ID AND FLPI.Payment_Schedule_ID = FAS.Payment_Schedule_ID AND FLPI.Schedule_Amort_Line_Num = FAS.Amortization_Line_Num AND FLPI.Lessor_Site_ID = PVS.Vendor_Site_ID AND PVS.Vendor_ID = PV.Vendor_ID

View Text - HTML Formatted

SELECT FLPI.ROWID ROW_ID
, FLPI.LEASE_ID LEASE_ID
, FL.LEASE_NUMBER LEASE_NUMBER
, FLPI.PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, FLPI.SCHEDULE_AMORT_LINE_NUM SCHEDULE_AMORT_LINE_NUM
, FAS.PAYMENT_AMOUNT PAYMENT_AMOUNT
, FAS.PAYMENT_DATE PAYMENT_DATE
, FLPI.EXPORT_STATUS EXPORT_STATUS
, FLPI.LESSOR_SITE_ID LESSOR_SITE_ID
, FLPI.DIST_CODE_COMBINATION_ID DIST_CODE_COMBINATION_ID
, FLPI.INVOICE_ID INVOICE_ID
, FLPI.INVOICE_NUMBER INVOICE_NUMBER
, FLPI.INVOICE_LINE_ID INVOICE_LINE_ID
, FL.CURRENCY_CODE CURRENCY_CODE
, PVS.VENDOR_SITE_CODE LESSOR_SITE_NAME
, PVS.VENDOR_ID LESSOR_ID
, PV.VENDOR_NAME LESSOR_NAME
, PV.SEGMENT1 LESSOR_NUM
, FLPI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FLPI.LAST_UPDATED_BY LAST_UPDATED_BY
, FLPI.CREATED_BY CREATED_BY
, FLPI.CREATION_DATE CREATION_DATE
, FLPI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FLPI.REQUEST_ID REQUEST_ID
, FLPI.TERMS_ID TERMS_ID
FROM FA_LEASE_PAYMENT_ITEMS FLPI
, FA_LEASES FL
, FA_AMORT_SCHEDULES FAS
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
WHERE FLPI.LEASE_ID = FL.LEASE_ID
AND FLPI.PAYMENT_SCHEDULE_ID = FAS.PAYMENT_SCHEDULE_ID
AND FLPI.SCHEDULE_AMORT_LINE_NUM = FAS.AMORTIZATION_LINE_NUM
AND FLPI.LESSOR_SITE_ID = PVS.VENDOR_SITE_ID
AND PVS.VENDOR_ID = PV.VENDOR_ID