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_HEADERS

Object Details

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

/*#
* This is the open interface table for Intercompany Transaction Headers.
* @rep:scope public
* @rep:lifecycle active
* @rep:displayname Intercompany Transaction Headers 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_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRX_ID	NUMBER	(15)	Yes	/# Primary key based on sequence fun_trx_headers_s. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
TRX_NUMBER	VARCHAR2	(15)		/# User entered number for the transaction. Transaction Number must be unique for the batch. * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Number * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
RECIPIENT_ID	NUMBER	(15)		/# hz_party.party_id of the Recipient Organization. Recipient Id or the Recipient Name must be provided. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
RECIPIENT_NAME	VARCHAR2	(360)		/# Name of the Recipient Organization. Recipient Id or the Recipient Name must be provided. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
TO_LE_ID	NUMBER	(15)		/# xle_entity_profiles.legal_entity_id assigned for the Recipient Organization. If none is provided, the Legal Entity Id will be derived from the Recipient Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Legal Entity Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
TO_LE_NAME	VARCHAR2	(240)		/# Legal Entity Name of the Recipient Organization. If none is provided, the Legal Entity Id will be derived from the Recipient Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Legal Entity Name * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
TO_LEDGER_ID	NUMBER	(15)		/# gl_ledgers.ledger_id of the Ledger assigned to Recipient Organization. If none is provided, the Ledger Id will be derived from the Recipient Id * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Ledger Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
BATCH_ID	NUMBER	(15)	Yes	/# Unique Id of the batch. Must be the same as fun_interface_batches.batch_id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Batch Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
INIT_AMOUNT_CR	NUMBER			/# Credit amount value for the Initiator * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Amount Credit * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
INIT_AMOUNT_DR	NUMBER			/# Debit amount value for the Initiator * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Amount Debit * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
INVOICING_RULE_FLAG	VARCHAR2	(1)	Yes	/# Flag to indicate if invoicing is required for the transaction * @rep:scope public * @rep:lifecycle active * @rep:displayname Invoicing Rule * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
FROM_RECURRING_TRX_ID	NUMBER	(15)		/# Recurring Transaction Id. * @rep:scope public * @rep:lifecycle active * @rep:displayname Recurring Transaction Id * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
INITIATOR_INSTANCE_FLAG	VARCHAR2	(1)		/# Initiator Instance Flag * @rep:scope public * @rep:lifecycle active * @rep:displayname Initiator Instance Flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
RECIPIENT_INSTANCE_FLAG	VARCHAR2	(1)		/# Recipient Instance Flag * @rep:scope public * @rep:lifecycle active * @rep:displayname Recipient Instance Flag * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
DESCRIPTION	VARCHAR2	(240)		/# Description for the Transaction * @rep:scope public * @rep:lifecycle active * @rep:displayname Transaction Description * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE1	VARCHAR2	(150)		/# Attribute 1 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute1 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE2	VARCHAR2	(150)		/# Attribute 2 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 2 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE3	VARCHAR2	(150)		/# Attribute 3 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 3 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE4	VARCHAR2	(150)		/# Attribute 4 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 4 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE5	VARCHAR2	(150)		/# Attribute 5 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 5 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE6	VARCHAR2	(150)		/# Attribute 6 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 6 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE7	VARCHAR2	(150)		/# Attribute 7 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 7 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE8	VARCHAR2	(150)		/# Attribute 8 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 8 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE9	VARCHAR2	(150)		/# Attribute 9 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 9 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE10	VARCHAR2	(150)		/# Attribute 10 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 10 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE11	VARCHAR2	(150)		/# Attribute 11 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 11 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE12	VARCHAR2	(150)		/# Attribute 12 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 12 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE13	VARCHAR2	(150)		/# Attribute 13 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 13 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE14	VARCHAR2	(150)		/# Attribute 14 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 14 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE15	VARCHAR2	(150)		/# Attribute 15 of the description flexfield. * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute 15 * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		/# Attribute Category of the descriptive flexfield * @rep:scope public * @rep:lifecycle active * @rep:displayname Attribute Category * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
CREATED_BY	NUMBER	(15)		/# Created By User Id * @rep:scope public * @rep:lifecycle active * @rep:displayname Created By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
CREATION_DATE	DATE			/# Creation Date * @rep:scope public * @rep:lifecycle active * @rep:displayname Creation Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
LAST_UPDATED_BY	NUMBER	(15)		/# Last Updated by User Id * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Updated By * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
LAST_UPDATE_DATE	DATE			/# Last Updated Date * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Date * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
LAST_UPDATE_LOGIN	NUMBER	(15)		/# Last Update Login * @rep:scope public * @rep:lifecycle active * @rep:displayname Last Update Login * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
IMPORT_STATUS_CODE	VARCHAR2	(15)		/# Import Program populates this with the status of Import. * @rep:scope public * @rep:lifecycle active * @rep:displayname Import Status Code * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */

Query Text

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


SELECT TRX_ID
,      TRX_NUMBER
,      RECIPIENT_ID
,      RECIPIENT_NAME
,      TO_LE_ID
,      TO_LE_NAME
,      TO_LEDGER_ID
,      BATCH_ID
,      INIT_AMOUNT_CR
,      INIT_AMOUNT_DR
,      INVOICING_RULE_FLAG
,      FROM_RECURRING_TRX_ID
,      INITIATOR_INSTANCE_FLAG
,      RECIPIENT_INSTANCE_FLAG
,      DESCRIPTION
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      IMPORT_STATUS_CODE
FROM FUN.FUN_INTERFACE_HEADERS;

Dependencies

[top of page]

FUN.FUN_INTERFACE_HEADERS does not reference any database object

FUN.FUN_INTERFACE_HEADERS is referenced by following:

APPS: FUN_INTERFACE_HEADERS