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

VIEW: FUN.FUN_TRANSFERS#

Object Details
Object Name: FUN_TRANSFERS#
Object Type: VIEW
Owner: FUN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CURRENCY VARCHAR2 (15)
BATCH_NUMBER VARCHAR2 (20)
INITIATOR_NAME VARCHAR2 (360)
RECIPIENT_NAME VARCHAR2 (360)
TRX_TYPE_NAME VARCHAR2 (25)
TRX_TYPE_CODE VARCHAR2 (15)
PERIOD_NAME VARCHAR2 (15)
LEDGER_NAME VARCHAR2 (30)
TRX_STATUS VARCHAR2 (30)
AMOUNT_CR NUMBER

AMOUNT_DR NUMBER

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

BATCH_DATE DATE

CUSTOMER VARCHAR2 (50)
SUPPLIER VARCHAR2 (80)
INVOICE_NUMBER VARCHAR2 (50)
ORG_ID NUMBER (15)
ORG_NAME VARCHAR2 (360)
REQUEST_ID NUMBER (15)
TRX_ID NUMBER (15)
INITIATOR_ID NUMBER (15)
RECIPIENT_ID NUMBER (15)
LEDGER_ID NUMBER (15)
ERROR_CODE VARCHAR2 (30)
PAYABLES_CCID NUMBER (15)
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# references the following:

SchemaFUN
TableFUN_TRANSFERS
FUN.FUN_TRANSFERS# is referenced by following:

SchemaAPPS
SynonymFUN_TRANSFERS