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


TABLE: FUN.FUN_TRANSFERS

Object Details
Object Name: FUN_TRANSFERS
Object Type: TABLE
Owner: FUN
FND Design Data: TableFUN.FUN_TRANSFERS
Subobject Name:
Status: VALID

This table is no longer used.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FUN_TRANSFERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
ColumnPARTY_TYPE_FLAG
FUN_TRANSFERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRX_ID
FUN_TRANSFERS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_TYPE_FLAG
FUN_TRANSFERS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
CURRENCY VARCHAR2 (15)
Deprecated
BATCH_NUMBER VARCHAR2 (15)
Deprecated
INITIATOR_NAME VARCHAR2 (360)
Deprecated
RECIPIENT_NAME VARCHAR2 (360)
Deprecated
TRX_TYPE_NAME VARCHAR2 (25)
Deprecated
TRX_TYPE_CODE VARCHAR2 (15)
Deprecated
PERIOD_NAME VARCHAR2 (15)
Deprecated
LEDGER_NAME VARCHAR2 (30)
Deprecated
TRX_STATUS VARCHAR2 (30)
Deprecated
AMOUNT_CR NUMBER

Deprecated
AMOUNT_DR NUMBER

Deprecated
DESCRIPTION VARCHAR2 (240)
Deprecated
PARTY_TYPE_FLAG VARCHAR2 (1)
Deprecated
ERROR_MSG VARCHAR2 (2000)
Deprecated
APPROVER VARCHAR2 (2000)
Deprecated
GL_DATE DATE

Deprecated
BATCH_DATE DATE

Deprecated
CUSTOMER VARCHAR2 (50)
Deprecated
SUPPLIER VARCHAR2 (80)
Deprecated
INVOICE_NUMBER VARCHAR2 (50)
Deprecated
ORG_ID NUMBER (15)
Deprecated
ORG_NAME VARCHAR2 (360)
Deprecated
REQUEST_ID NUMBER (15)
Deprecated
TRX_ID NUMBER (15)
Deprecated
INITIATOR_ID NUMBER (15)
Deprecated
RECIPIENT_ID NUMBER (15)
Deprecated
LEDGER_ID NUMBER (15)
Deprecated
ERROR_CODE VARCHAR2 (30)
Deprecated
PAYABLES_CCID NUMBER (15)
Deprecated
BATCH_ID NUMBER (15)
LE_ID NUMBER (15)
Query Text

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


SELECT CURRENCY
,      BATCH_NUMBER
,      INITIATOR_NAME
,      RECIPIENT_NAME
,      TRX_TYPE_NAME
,      TRX_TYPE_CODE
,      PERIOD_NAME
,      LEDGER_NAME
,      TRX_STATUS
,      AMOUNT_CR
,      AMOUNT_DR
,      DESCRIPTION
,      PARTY_TYPE_FLAG
,      ERROR_MSG
,      APPROVER
,      GL_DATE
,      BATCH_DATE
,      CUSTOMER
,      SUPPLIER
,      INVOICE_NUMBER
,      ORG_ID
,      ORG_NAME
,      REQUEST_ID
,      TRX_ID
,      INITIATOR_ID
,      RECIPIENT_ID
,      LEDGER_ID
,      ERROR_CODE
,      PAYABLES_CCID
,      BATCH_ID
,      LE_ID
FROM FUN.FUN_TRANSFERS;

Dependencies

[top of page]

FUN.FUN_TRANSFERS does not reference any database object

FUN.FUN_TRANSFERS is referenced by following:

SchemaAPPS
SynonymFUN_TRANSFERS