eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_INV_SELECTED_DUEDATE_TEMP

Object Details

Object Name:	FV_INV_SELECTED_DUEDATE_TEMP
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_INV_SELECTED_DUEDATE_TEMP
Subobject Name:
Status:	VALID

FV_INV_SELECTED_DUEDATE_TEMP is a temporary table that stores information about invoices selected for due date payments.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FV_INV_SELECTED_DUEDATE_TEMP_U	NORMAL	UNIQUE	APPS_TS_INTERFACE	INVOICE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
INVOICE_NUM	VARCHAR2	(50)		Invoice number
TERMS_DATE	DATE			Date used with payment terms to calculate payment schedule of invoice
ORG_DUE_DATE	DATE			Original due date
NEW_DUE_DATE	DATE			Calculated due date
VENDOR_ID	NUMBER			Vendor identifier
SET_OF_BKS_NAME	VARCHAR2	(30)		Set of Books name
ORG_DISCOUNT_DATE	DATE			Original discount date based on terms date
NEW_DISCOUNT_DATE	DATE			Updated discount date based on Due Date Calculation process
ORG_SECOND_DISC_DATE	DATE			Second discount date based on invoice date
NEW_SECOND_DISC_DATE	DATE			Updated second discount date based on Due Date Calculation process
ORG_THIRD_DISC_DATE	DATE			Third discount date based on invoice date
NEW_THIRD_DISC_DATE	DATE			Updated third discount date based on Due Date Calculation process

Query Text

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


SELECT INVOICE_ID
,      SET_OF_BOOKS_ID
,      INVOICE_NUM
,      TERMS_DATE
,      ORG_DUE_DATE
,      NEW_DUE_DATE
,      VENDOR_ID
,      SET_OF_BKS_NAME
,      ORG_DISCOUNT_DATE
,      NEW_DISCOUNT_DATE
,      ORG_SECOND_DISC_DATE
,      NEW_SECOND_DISC_DATE
,      ORG_THIRD_DISC_DATE
,      NEW_THIRD_DISC_DATE
FROM FV.FV_INV_SELECTED_DUEDATE_TEMP;

Dependencies

[top of page]

FV.FV_INV_SELECTED_DUEDATE_TEMP does not reference any database object

FV.FV_INV_SELECTED_DUEDATE_TEMP is referenced by following:

APPS: FV_INV_SELECTED_DUEDATE_TEMP