FND Design Data [Home] [Help]

View: OKL_SUPP_INVOICE_DTLS_V

Product: OKL - Lease and Finance Management
Description: A contract line level table to record vendor invoice and shipping details for the line item.
Implementation/DBA Data: ViewAPPS.OKL_SUPP_INVOICE_DTLS_V
View Text

SELECT SID.ROWID ROW_ID
, SID.ID ID
, SID.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SID.CLE_ID CLE_ID
, SID.FA_CLE_ID FA_CLE_ID
, SID.INVOICE_NUMBER INVOICE_NUMBER
, SID.DATE_INVOICED DATE_INVOICED
, SID.DATE_DUE DATE_DUE
, SID.SHIPPING_ADDRESS_ID1 SHIPPING_ADDRESS_ID1
, SID.SHIPPING_ADDRESS_ID2 SHIPPING_ADDRESS_ID2
, SID.SHIPPING_ADDRESS_CODE SHIPPING_ADDRESS_CODE
, SID.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SID.ATTRIBUTE1 ATTRIBUTE1
, SID.ATTRIBUTE2 ATTRIBUTE2
, SID.ATTRIBUTE3 ATTRIBUTE3
, SID.ATTRIBUTE4 ATTRIBUTE4
, SID.ATTRIBUTE5 ATTRIBUTE5
, SID.ATTRIBUTE6 ATTRIBUTE6
, SID.ATTRIBUTE7 ATTRIBUTE7
, SID.ATTRIBUTE8 ATTRIBUTE8
, SID.ATTRIBUTE9 ATTRIBUTE9
, SID.ATTRIBUTE10 ATTRIBUTE10
, SID.ATTRIBUTE11 ATTRIBUTE11
, SID.ATTRIBUTE12 ATTRIBUTE12
, SID.ATTRIBUTE13 ATTRIBUTE13
, SID.ATTRIBUTE14 ATTRIBUTE14
, SID.ATTRIBUTE15 ATTRIBUTE15
, SID.CREATED_BY CREATED_BY
, SID.CREATION_DATE CREATION_DATE
, SID.LAST_UPDATED_BY LAST_UPDATED_BY
, SID.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SID.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_SUPP_INVOICE_DTLS SID

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
CLE_ID
FA_CLE_ID
INVOICE_NUMBER
DATE_INVOICED
DATE_DUE
SHIPPING_ADDRESS_ID1
SHIPPING_ADDRESS_ID2
SHIPPING_ADDRESS_CODE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN