View: OKL_EXT_PAY_INVS_V

Product:	OKL - Leasing and Finance Management
Description:	Header information about invoices exported to AP
Implementation/DBA Data:	APPS.OKL_EXT_PAY_INVS_V

View Text

SELECT XPIB.ROWID ROW_ID
, XPIB.ID ID
, XPIB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XPIT.SFWT_FLAG SFWT_FLAG
, XPIB.TRX_STATUS_CODE TRX_STATUS_CODE
, XPIB.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, XPIB.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, XPIB.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, XPIB.INVOICE_ID INVOICE_ID
, XPIB.INVOICE_NUM INVOICE_NUM
, XPIB.INVOICE_TYPE INVOICE_TYPE
, XPIB.INVOICE_DATE INVOICE_DATE
, XPIB.VENDOR_ID VENDOR_ID
, XPIB.VENDOR_SITE_ID VENDOR_SITE_ID
, XPIB.VENDOR_INVOICE_NUMBER VENDOR_INVOICE_NUMBER
, XPIB.INVOICE_AMOUNT INVOICE_AMOUNT
, XPIB.INVOICE_CURRENCY_CODE INVOICE_CURRENCY_CODE
, XPIB.PAY_GROUP_LOOKUP_CODE PAY_GROUP_LOOKUP_CODE
, XPIB.NETTABLE_YN NETTABLE_YN
, XPIB.TERMS_ID TERMS_ID
, XPIT.DESCRIPTION DESCRIPTION
, XPIT.SOURCE SOURCE
, XPIB.WORKFLOW_FLAG WORKFLOW_FLAG
, XPIB.DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, XPIB.PAYMENT_METHOD PAYMENT_METHOD
, XPIB.GL_DATE GL_DATE
, XPIB.ACCTS_PAY_CC_ID ACCTS_PAY_CC_ID
, XPIB.PAY_ALONE_FLAG PAY_ALONE_FLAG
, XPIB.WAIT_VENDOR_INVOICE_YN WAIT_VENDOR_INVOICE_YN
, XPIT.STREAM_TYPE STREAM_TYPE
, XPIB.PAYABLES_INVOICE_ID PAYABLES_INVOICE_ID
, XPIB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, XPIB.ATTRIBUTE1 ATTRIBUTE1
, XPIB.ATTRIBUTE2 ATTRIBUTE2
, XPIB.ATTRIBUTE3 ATTRIBUTE3
, XPIB.ATTRIBUTE4 ATTRIBUTE4
, XPIB.ATTRIBUTE5 ATTRIBUTE5
, XPIB.ATTRIBUTE6 ATTRIBUTE6
, XPIB.ATTRIBUTE7 ATTRIBUTE7
, XPIB.ATTRIBUTE8 ATTRIBUTE8
, XPIB.ATTRIBUTE9 ATTRIBUTE9
, XPIB.ATTRIBUTE10 ATTRIBUTE10
, XPIB.ATTRIBUTE11 ATTRIBUTE11
, XPIB.ATTRIBUTE12 ATTRIBUTE12
, XPIB.ATTRIBUTE13 ATTRIBUTE13
, XPIB.ATTRIBUTE14 ATTRIBUTE14
, XPIB.ATTRIBUTE15 ATTRIBUTE15
, XPIB.REQUEST_ID REQUEST_ID
, XPIB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, XPIB.PROGRAM_ID PROGRAM_ID
, XPIB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, XPIB.ORG_ID ORG_ID
, XPIB.CREATED_BY CREATED_BY
, XPIB.CREATION_DATE CREATION_DATE
, XPIB.LAST_UPDATED_BY LAST_UPDATED_BY
, XPIB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XPIB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XPIB.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, XPIB.CNSLD_AP_INV_ID CNSLD_AP_INV_ID
FROM OKL_EXT_PAY_INVS_B XPIB
, OKL_EXT_PAY_INVS_TL XPIT
WHERE XPIB.ID = XPIT.ID
AND XPIT.LANGUAGE = USERENV('LANG')

Columns