View: FV_INV_HISTSTAT_V

Product:	FV - Federal Financials
Description:	Stores invoice status history
Implementation/DBA Data:	APPS.FV_INV_HISTSTAT_V

View Text

SELECT CUSTOMER_TRX_ID
, STATUS
, START_DATE
, END_DATE
, INVOICE_STATUS_ID
, COMMENTS
, ORG_ID
, SET_OF_BOOKS_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM FV_INVOICE_STATUSES UNION SELECT CUSTOMER_TRX_ID
, STATUS
, START_DATE
, END_DATE
, INVOICE_HISTORY_ID INVOICE_STATUS_ID
, COMMENTS
, ORG_ID
, SET_OF_BOOKS_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
FROM FV_INVOICE_STATUSES_HIST

Columns