Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_LEASE_PAYMENT_ITEMS_V |
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