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

TABLE: FV.FV_IPAC_RECURRING_INV

Object Details
Object Name: FV_IPAC_RECURRING_INV
Object Type: TABLE
Owner: FV
FND Design Data: TableFV.FV_IPAC_RECURRING_INV
Subobject Name:
Status: VALID


FV_RECURRING_INV_ALL holds the recurring invoices found in the IPAC file during the Upload IPAC Disbursement process. The Automatic Payment Process refers to this table to find invoices to validate invoices and to create payments.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
BATCH_NAME VARCHAR2 (50)
Batch name contains the the payables invoice batch name of the associated batch created during the uploading of IPAC disbursements.
INVOICE_ID NUMBER

recurring invoice identifier
INVOICE_ACTION VARCHAR2 (1)
Contains either a V for validate or P for payment
ACCOMPLISH_DATE DATE

Accomplish date from IPAC file
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT BATCH_NAME
,      INVOICE_ID
,      INVOICE_ACTION
,      ACCOMPLISH_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
FROM FV.FV_IPAC_RECURRING_INV;

Dependencies

[top of page]

FV.FV_IPAC_RECURRING_INV does not reference any database object

FV.FV_IPAC_RECURRING_INV is referenced by following:

SchemaAPPS
SynonymFV_IPAC_RECURRING_INV