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: AP.AP_INTERFACE_REJECTIONS

Object Details

Object Name:	AP_INTERFACE_REJECTIONS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_INTERFACE_REJECTIONS
Subobject Name:
Status:	VALID

AP_INTERFACE_REJECTIONS stores information about invoice
data from the AP_INVOICES_INTERFACE and
AP_INVOICE_LINES_INTERFACE tables which could not be processed by
Payables Open Interface Import.
.
If you use Oracle e-Commerce Gateway, you can pass information from this
table to your suppliers by submitting the Payables Open Interface
Outbound Advice for rejected data.
.
You can purge data in this table by using the Payables Open
Interface Purge.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_INTERFACE_REJECTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARENT_ID

Columns

Name	Datatype	Length	Comments
PARENT_TABLE	VARCHAR2	(30)	Reference to table in which the rejection occurred (AP_INVOICES_INTERFACE or AP_INVOICE_LINES_INTERFACE)
PARENT_ID	NUMBER	(15)	Reference to invoice or invoice line identifier which was rejected (INVOICE_ID or INVOICE_LINE_ID)
REJECT_LOOKUP_CODE	VARCHAR2	(30)	Invoice rejection reason
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
TOKEN_NAME1	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME2	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME3	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME4	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME5	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME6	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME7	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME8	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME9	VARCHAR2	(30)	Stores contextual information
TOKEN_NAME10	VARCHAR2	(30)	Stores contextual information
TOKEN_VALUE1	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE2	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE3	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE4	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE5	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE6	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE7	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE8	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE9	VARCHAR2	(240)	Stores contextual information
TOKEN_VALUE10	VARCHAR2	(240)	Stores contextual information
NOTIFY_VENDOR_FLAG	VARCHAR2	(1)	Rejections to be notified to Suppliers when invoices imported through XML Gateway

Query Text

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


SELECT PARENT_TABLE
,      PARENT_ID
,      REJECT_LOOKUP_CODE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TOKEN_NAME1
,      TOKEN_NAME2
,      TOKEN_NAME3
,      TOKEN_NAME4
,      TOKEN_NAME5
,      TOKEN_NAME6
,      TOKEN_NAME7
,      TOKEN_NAME8
,      TOKEN_NAME9
,      TOKEN_NAME10
,      TOKEN_VALUE1
,      TOKEN_VALUE2
,      TOKEN_VALUE3
,      TOKEN_VALUE4
,      TOKEN_VALUE5
,      TOKEN_VALUE6
,      TOKEN_VALUE7
,      TOKEN_VALUE8
,      TOKEN_VALUE9
,      TOKEN_VALUE10
,      NOTIFY_VENDOR_FLAG
FROM AP.AP_INTERFACE_REJECTIONS;

Dependencies

[top of page]

AP.AP_INTERFACE_REJECTIONS does not reference any database object

AP.AP_INTERFACE_REJECTIONS is referenced by following:

APPS: AP_INTERFACE_REJECTIONS