DBA Data[Home] [Help]

VIEW: FUN.FUN_TRANSFERS#

Source

View Text - Preformatted

select CURRENCY CURRENCY, BATCH_NUMBER BATCH_NUMBER, INITIATOR_NAME INITIATOR_NAME, RECIPIENT_NAME RECIPIENT_NAME, TRX_TYPE_NAME TRX_TYPE_NAME, TRX_TYPE_CODE TRX_TYPE_CODE, PERIOD_NAME PERIOD_NAME, LEDGER_NAME LEDGER_NAME, TRX_STATUS TRX_STATUS, AMOUNT_CR AMOUNT_CR, AMOUNT_DR AMOUNT_DR, DESCRIPTION DESCRIPTION, PARTY_TYPE_FLAG PARTY_TYPE_FLAG, ERROR_MSG ERROR_MSG, APPROVER APPROVER, GL_DATE GL_DATE, BATCH_DATE BATCH_DATE, CUSTOMER CUSTOMER, SUPPLIER SUPPLIER, INVOICE_NUMBER INVOICE_NUMBER, ORG_ID ORG_ID, ORG_NAME ORG_NAME, REQUEST_ID REQUEST_ID, TRX_ID TRX_ID, INITIATOR_ID INITIATOR_ID, RECIPIENT_ID RECIPIENT_ID, LEDGER_ID LEDGER_ID, ERROR_CODE ERROR_CODE, PAYABLES_CCID PAYABLES_CCID, BATCH_ID BATCH_ID, LE_ID LE_ID from "FUN"."FUN_TRANSFERS"
View Text - HTML Formatted

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