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_PROMPT_PAY_TEMP

Object Details

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

FV_PROMPT_PAY_TEMP is used to store temporary reporting data during the execution of the Prompt Pay report.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
INVOICE_ID	NUMBER	(15)	Invoice identifier
PAY_INVOICE_ID	NUMBER	(15)	Payment invoice identifier
PAY_PAYMENT_NUMBER	NUMBER	(15)	Payment number
PAY_DUE_DATE	DATE		Due date
DISCOUNT_AMOUNT_AVAILABLE	NUMBER		Discount amount available
INVOICE_PAYMENT_ID	NUMBER	(15)	Invoice payment identifier
DISCOUNT_TAKEN	NUMBER		Discount amount
CHECK_DATE	DATE		Check date
INVOICE_AMOUNT	NUMBER		Invoice amount
INVOICE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Invoice type lookup code

Query Text

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


SELECT INVOICE_ID
,      PAY_INVOICE_ID
,      PAY_PAYMENT_NUMBER
,      PAY_DUE_DATE
,      DISCOUNT_AMOUNT_AVAILABLE
,      INVOICE_PAYMENT_ID
,      DISCOUNT_TAKEN
,      CHECK_DATE
,      INVOICE_AMOUNT
,      INVOICE_TYPE_LOOKUP_CODE
FROM FV.FV_PROMPT_PAY_TEMP;

Dependencies

[top of page]

FV.FV_PROMPT_PAY_TEMP does not reference any database object

FV.FV_PROMPT_PAY_TEMP is referenced by following:

APPS: FV_PROMPT_PAY_TEMP