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


TABLE: AP.AP_INTERFACE_CONTROLS

Object Details
Object Name: AP_INTERFACE_CONTROLS
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_INTERFACE_CONTROLS
Subobject Name:
Status: VALID


AP_INTERFACE_CONTROLS is a temporary table that holds
control information about segregated data in the
AP_INVOICES_INTERFACE table during the Payables Open
Interface Import. The table ensures that each import must be
unique with respect to the combination of SOURCE and
GROUP_ID. This allows the submission of multiple imports at the
same time.
.
Your Oracle Payables application deletes the information from
this table when you complete an import.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_INTERFACE_CONTROLS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnSOURCE
ColumnGROUP_ID
Columns
Name Datatype Length Mandatory Comments
SOURCE VARCHAR2 (80)
Source of invoice
GROUP_ID VARCHAR2 (80)
Group identifier
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
Query Text

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


SELECT SOURCE
,      GROUP_ID
,      REQUEST_ID
FROM AP.AP_INTERFACE_CONTROLS;

Dependencies

[top of page]

AP.AP_INTERFACE_CONTROLS does not reference any database object

AP.AP_INTERFACE_CONTROLS is referenced by following:

SchemaAPPS
SynonymAP_INTERFACE_CONTROLS