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: FUN.FUN_INTERFACE_CONTROLS

Object Details

Object Name:	FUN_INTERFACE_CONTROLS
Object Type:	TABLE
Owner:	FUN
FND Design Data:	FUN.FUN_INTERFACE_CONTROLS
Subobject Name:
Status:	VALID

/*#
* This is the open interface table for Intercompany Batches.
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Intercompany Control Interface
* @rep:product FUN
* @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH
*/

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FUN_INTERFACE_CONTROLS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SOURCE GROUP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_ID	NUMBER	(15)	Yes	/# Source and Group_id form the unique key. * Sequence to use for group_id is fun_interface_controls_s * @rep:scope public * @rep:lifecycle active * @rep:displayname Group Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
SOURCE	VARCHAR2	(25)	Yes	/# Source and Group Id form the unique key. * @rep:scope public * @rep:lifecycle active * @rep:displayname Source * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
REQUEST_ID	NUMBER	(15)		/# Import Program populates this column with the latest Request Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Request Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
DATE_PROCESSED	DATE			/# Import Program populates this column with latest date on which the request was run. * @rep:scope public * @rep:lifecycle active * @rep:displayname Date Processed * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

Query Text

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


SELECT GROUP_ID
,      SOURCE
,      REQUEST_ID
,      DATE_PROCESSED
FROM FUN.FUN_INTERFACE_CONTROLS;

Dependencies

[top of page]

FUN.FUN_INTERFACE_CONTROLS does not reference any database object

FUN.FUN_INTERFACE_CONTROLS is referenced by following:

APPS: FUN_INTERFACE_CONTROLS