DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FA_LEASE_PAYMENT_ITEMS_V

Object Details
Object Name: FA_LEASE_PAYMENT_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOFA.FA_LEASE_PAYMENT_ITEMS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LEASE_ID NUMBER (15) Yes
LEASE_NUMBER VARCHAR2 (15) Yes
PAYMENT_SCHEDULE_ID NUMBER (15) Yes
SCHEDULE_AMORT_LINE_NUM NUMBER (15) Yes
PAYMENT_AMOUNT NUMBER
Yes
PAYMENT_DATE DATE
Yes
EXPORT_STATUS VARCHAR2 (15) Yes
LESSOR_SITE_ID NUMBER (15) Yes
DIST_CODE_COMBINATION_ID NUMBER (15) Yes
INVOICE_ID NUMBER (15)
INVOICE_NUMBER VARCHAR2 (50)
INVOICE_LINE_ID NUMBER (15)
CURRENCY_CODE VARCHAR2 (5)
LESSOR_SITE_NAME VARCHAR2 (15) Yes
LESSOR_ID NUMBER
Yes
LESSOR_NAME VARCHAR2 (240)
LESSOR_NUM VARCHAR2 (30) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
TERMS_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      LEASE_ID
,      LEASE_NUMBER
,      PAYMENT_SCHEDULE_ID
,      SCHEDULE_AMORT_LINE_NUM
,      PAYMENT_AMOUNT
,      PAYMENT_DATE
,      EXPORT_STATUS
,      LESSOR_SITE_ID
,      DIST_CODE_COMBINATION_ID
,      INVOICE_ID
,      INVOICE_NUMBER
,      INVOICE_LINE_ID
,      CURRENCY_CODE
,      LESSOR_SITE_NAME
,      LESSOR_ID
,      LESSOR_NAME
,      LESSOR_NUM
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      TERMS_ID
FROM APPS.FA_LEASE_PAYMENT_ITEMS_V;

Dependencies

[top of page]

APPS.FA_LEASE_PAYMENT_ITEMS_V references the following:

SchemaAPPS
SynonymFA_AMORT_SCHEDULES
SynonymFA_LEASES
SynonymFA_LEASE_PAYMENT_ITEMS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.FA_LEASE_PAYMENT_ITEMS_V is not referenced by any database object