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


VIEW: APPS.CE_XLA_EXT_HEADERS_V

Object Details
Object Name: CE_XLA_EXT_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_XLA_EXT_HEADERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (15) Yes
CASHFLOW_NUMBER NUMBER (15) Yes
CASHFLOW_HIST_IDENTIFIER VARCHAR2 (18)
DISTRIBUTION_TYPE CHAR (8)
ACCOUNTING_EVENT_TYPE VARCHAR2 (30) Yes
ACCOUNTING_DATE DATE
Yes
ACCOUNTING_EVENT_STATUS VARCHAR2 (30) Yes
REVERSAL_INDICATOR VARCHAR2 (1)
REVERSAL_DIST_TYPE CHAR (8)
REVERSAL_FIRST_DIST_ID NUMBER (15)
REVERSAL_SECOND_DIST_ID VARCHAR2 (18)
CF_LEDGER_NAME VARCHAR2 (30) Yes
CF_LE_NAME VARCHAR2 (240) Yes
CF_BANK_ACCOUNT_NUM VARCHAR2 (30)
CF_DIRECTION VARCHAR2 (30)
CF_CURRENCY VARCHAR2 (15) Yes
CF_DATE DATE
Yes
CF_AMOUNT NUMBER
Yes
CF_BANK_ACCOUNT_AMOUNT NUMBER

CF_DESCRIPTION VARCHAR2 (240)
CF_REFERENCE_TEXT VARCHAR2 (80)
CF_EXCHANGE_RATE NUMBER

CF_EXCHANGE_DATE DATE

CF_EXCHANGE_RATE_TYPE VARCHAR2 (30)
PAYMENT_TRX_REFERENCE_NUM NUMBER (15)
CF_BANK_TRX_NUMBER VARCHAR2 (100)
CF_SOURCE_TRX_TYPE VARCHAR2 (30) Yes
CF_TRX_SUB_TYPE VARCHAR2 (30)
CF_VALUE_DATE DATE

COUNTERPARTY_NAME VARCHAR2 (240)
COUNTERPARTY_BANK_ACCOUNT_NUM VARCHAR2 (30)
CF_OFFSET_CCID NUMBER (15)
CF_STATUS_CODE VARCHAR2 (30) Yes
CF_CLEARED_DATE DATE

CF_CLEARED_AMOUNT NUMBER

CF_CLEARED_EXCHANGE_RATE NUMBER

CF_CLEARED_EXCHANGE_DATE DATE

CF_CLEARED_EXC_RATE_TYPE VARCHAR2 (30)
CF_CLEARED_CHARGE_AMOUNT NUMBER

CF_CLEARED_ERROR_AMOUNT NUMBER

CF_FX_CHARGE_AMOUNT NUMBER

CF_LE_IDENTIFIER VARCHAR2 (30)
CF_LE_REG_NUMBER VARCHAR2 (30) Yes
CF_LE_ADDRESS_LINE_1 VARCHAR2 (240)
CF_LE_ADDRESS_LINE_2 VARCHAR2 (240)
CF_LE_ADDRESS_LINE_3 VARCHAR2 (240)
CF_LE_TOWN_OR_CITY VARCHAR2 (30)
CF_LE_POSTAL_CODE VARCHAR2 (30)
CF_LE_COUNTRY VARCHAR2 (60)
CF_BANK_NAME VARCHAR2 (360) Yes
CF_BANK_ALT_NAME VARCHAR2 (320)
CF_SHORT_BANK_NAME VARCHAR2 (240)
CF_BANK_NUMBER VARCHAR2 (30)
CF_BRANCH_NAME VARCHAR2 (360) Yes
CF_BRANCH_ALT_NAME VARCHAR2 (320)
CF_BRANCH_NUMBER VARCHAR2 (30)
CF_BRANCH_ADDRESS_LINE1 VARCHAR2 (240)
CF_BRANCH_ADDRESS_LINE2 VARCHAR2 (240)
CF_BRANCH_ADDRESS_LINE3 VARCHAR2 (240)
CF_BRANCH_ADDRESS_LINE4 VARCHAR2 (240)
CF_BRANCH_CITY VARCHAR2 (60)
CF_BRANCH_STATE VARCHAR2 (60)
CF_BRANCH_PROVINCE VARCHAR2 (60)
CF_BRANCH_ZIP VARCHAR2 (60)
CF_BRANCH_COUNTRY VARCHAR2 (60)
CF_BRANCH_DESCRIPTION VARCHAR2 (2000)
CF_BRANCH_EFT_SWIFT_CODE VARCHAR2 (30)
CP_BANK_NAME VARCHAR2 (360)
CP_BANK_NUMBER VARCHAR2 (30)
CP_BRANCH_NAME VARCHAR2 (360)
CP_BRANCH_NUMBER VARCHAR2 (30)
CF_BANK_ACCOUNT_NAME VARCHAR2 (100) Yes
CF_BA_CURRENCY VARCHAR2 (15)
CF_BA_DESCRIPTION VARCHAR2 (240)
CF_BA_ATTRIBUTE_CATEGORY VARCHAR2 (150)
CF_BA_ATTRIBUTE1 VARCHAR2 (150)
CF_BA_ATTRIBUTE2 VARCHAR2 (150)
CF_BA_ATTRIBUTE3 VARCHAR2 (150)
CF_BA_ATTRIBUTE4 VARCHAR2 (150)
CF_BA_ATTRIBUTE5 VARCHAR2 (150)
CF_BA_ATTRIBUTE6 VARCHAR2 (150)
CF_BA_ATTRIBUTE7 VARCHAR2 (150)
CF_BA_ATTRIBUTE8 VARCHAR2 (150)
CF_BA_ATTRIBUTE9 VARCHAR2 (150)
CF_BA_ATTRIBUTE10 VARCHAR2 (150)
CF_BA_ATTRIBUTE11 VARCHAR2 (150)
CF_BA_ATTRIBUTE12 VARCHAR2 (150)
CF_BA_ATTRIBUTE13 VARCHAR2 (150)
CF_BA_ATTRIBUTE14 VARCHAR2 (150)
CF_BA_ATTRIBUTE15 VARCHAR2 (150)
CF_BA_CASH_ACCT_CCID NUMBER (15)
CF_BA_CASH_CLEARING_CCID NUMBER (15)
CF_BA_BANK_CHARGE_CCID NUMBER (15)
CF_BA_BANK_ERROR_CCID NUMBER (15)
CF_BA_FX_CHARGE_CCID NUMBER (15)
CF_BA_GAIN_CODE_COMBINATION_ID NUMBER (15)
CF_BA_LOSS_CODE_COMBINATION_ID NUMBER (15)
CF_BA_NAME_ALT VARCHAR2 (320)
CF_BA_IBAN_NUMBER VARCHAR2 (50)
CF_BA_SHORT_ACCT_NAME VARCHAR2 (240)
CF_BA_MULTI_CUR_FLAG VARCHAR2 (1)
CF_BA_HOLDER_NAME_ALT VARCHAR2 (150)
CF_BA_HOLDER_NAME VARCHAR2 (240)
CP_BANK_ACCOUNT_NAME VARCHAR2 (100)
CP_BA_CURRENCY VARCHAR2 (15)
CP_BA_IBAN_NUMBER VARCHAR2 (50)
STMT_NUMBER VARCHAR2 (50)
STMT_DATE DATE

STMT_DOC_SEQUENCE_ID NUMBER

STMT_DOC_SEQUENCE_VALUE NUMBER

STMT_GL_DATE DATE

BAT_TRANSFER_DATE DATE

BAT_SETTLE_BY_SYSTEM_FLAG VARCHAR2 (1)
BAT_TRXN_STATUS_CODE VARCHAR2 (30)
BAT_ATTRIBUTE_CATEGORY VARCHAR2 (150)
BAT_ATTRIBUTE1 VARCHAR2 (150)
BAT_ATTRIBUTE2 VARCHAR2 (150)
BAT_ATTRIBUTE3 VARCHAR2 (150)
BAT_ATTRIBUTE4 VARCHAR2 (150)
BAT_ATTRIBUTE5 VARCHAR2 (150)
BAT_ATTRIBUTE6 VARCHAR2 (150)
BAT_ATTRIBUTE7 VARCHAR2 (150)
BAT_ATTRIBUTE8 VARCHAR2 (150)
BAT_ATTRIBUTE9 VARCHAR2 (150)
BAT_ATTRIBUTE10 VARCHAR2 (150)
BAT_ATTRIBUTE11 VARCHAR2 (150)
BAT_ATTRIBUTE12 VARCHAR2 (150)
BAT_ATTRIBUTE13 VARCHAR2 (150)
BAT_ATTRIBUTE14 VARCHAR2 (150)
BAT_ATTRIBUTE15 VARCHAR2 (150)
CF_MISC_CLEARED_EXCHANGE_RATE NUMBER

CF_MISC_CLEARED_EXC_RATE_TYPE VARCHAR2 (30)
Query Text

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


SELECT EVENT_ID
,      CASHFLOW_NUMBER
,      CASHFLOW_HIST_IDENTIFIER
,      DISTRIBUTION_TYPE
,      ACCOUNTING_EVENT_TYPE
,      ACCOUNTING_DATE
,      ACCOUNTING_EVENT_STATUS
,      REVERSAL_INDICATOR
,      REVERSAL_DIST_TYPE
,      REVERSAL_FIRST_DIST_ID
,      REVERSAL_SECOND_DIST_ID
,      CF_LEDGER_NAME
,      CF_LE_NAME
,      CF_BANK_ACCOUNT_NUM
,      CF_DIRECTION
,      CF_CURRENCY
,      CF_DATE
,      CF_AMOUNT
,      CF_BANK_ACCOUNT_AMOUNT
,      CF_DESCRIPTION
,      CF_REFERENCE_TEXT
,      CF_EXCHANGE_RATE
,      CF_EXCHANGE_DATE
,      CF_EXCHANGE_RATE_TYPE
,      PAYMENT_TRX_REFERENCE_NUM
,      CF_BANK_TRX_NUMBER
,      CF_SOURCE_TRX_TYPE
,      CF_TRX_SUB_TYPE
,      CF_VALUE_DATE
,      COUNTERPARTY_NAME
,      COUNTERPARTY_BANK_ACCOUNT_NUM
,      CF_OFFSET_CCID
,      CF_STATUS_CODE
,      CF_CLEARED_DATE
,      CF_CLEARED_AMOUNT
,      CF_CLEARED_EXCHANGE_RATE
,      CF_CLEARED_EXCHANGE_DATE
,      CF_CLEARED_EXC_RATE_TYPE
,      CF_CLEARED_CHARGE_AMOUNT
,      CF_CLEARED_ERROR_AMOUNT
,      CF_FX_CHARGE_AMOUNT
,      CF_LE_IDENTIFIER
,      CF_LE_REG_NUMBER
,      CF_LE_ADDRESS_LINE_1
,      CF_LE_ADDRESS_LINE_2
,      CF_LE_ADDRESS_LINE_3
,      CF_LE_TOWN_OR_CITY
,      CF_LE_POSTAL_CODE
,      CF_LE_COUNTRY
,      CF_BANK_NAME
,      CF_BANK_ALT_NAME
,      CF_SHORT_BANK_NAME
,      CF_BANK_NUMBER
,      CF_BRANCH_NAME
,      CF_BRANCH_ALT_NAME
,      CF_BRANCH_NUMBER
,      CF_BRANCH_ADDRESS_LINE1
,      CF_BRANCH_ADDRESS_LINE2
,      CF_BRANCH_ADDRESS_LINE3
,      CF_BRANCH_ADDRESS_LINE4
,      CF_BRANCH_CITY
,      CF_BRANCH_STATE
,      CF_BRANCH_PROVINCE
,      CF_BRANCH_ZIP
,      CF_BRANCH_COUNTRY
,      CF_BRANCH_DESCRIPTION
,      CF_BRANCH_EFT_SWIFT_CODE
,      CP_BANK_NAME
,      CP_BANK_NUMBER
,      CP_BRANCH_NAME
,      CP_BRANCH_NUMBER
,      CF_BANK_ACCOUNT_NAME
,      CF_BA_CURRENCY
,      CF_BA_DESCRIPTION
,      CF_BA_ATTRIBUTE_CATEGORY
,      CF_BA_ATTRIBUTE1
,      CF_BA_ATTRIBUTE2
,      CF_BA_ATTRIBUTE3
,      CF_BA_ATTRIBUTE4
,      CF_BA_ATTRIBUTE5
,      CF_BA_ATTRIBUTE6
,      CF_BA_ATTRIBUTE7
,      CF_BA_ATTRIBUTE8
,      CF_BA_ATTRIBUTE9
,      CF_BA_ATTRIBUTE10
,      CF_BA_ATTRIBUTE11
,      CF_BA_ATTRIBUTE12
,      CF_BA_ATTRIBUTE13
,      CF_BA_ATTRIBUTE14
,      CF_BA_ATTRIBUTE15
,      CF_BA_CASH_ACCT_CCID
,      CF_BA_CASH_CLEARING_CCID
,      CF_BA_BANK_CHARGE_CCID
,      CF_BA_BANK_ERROR_CCID
,      CF_BA_FX_CHARGE_CCID
,      CF_BA_GAIN_CODE_COMBINATION_ID
,      CF_BA_LOSS_CODE_COMBINATION_ID
,      CF_BA_NAME_ALT
,      CF_BA_IBAN_NUMBER
,      CF_BA_SHORT_ACCT_NAME
,      CF_BA_MULTI_CUR_FLAG
,      CF_BA_HOLDER_NAME_ALT
,      CF_BA_HOLDER_NAME
,      CP_BANK_ACCOUNT_NAME
,      CP_BA_CURRENCY
,      CP_BA_IBAN_NUMBER
,      STMT_NUMBER
,      STMT_DATE
,      STMT_DOC_SEQUENCE_ID
,      STMT_DOC_SEQUENCE_VALUE
,      STMT_GL_DATE
,      BAT_TRANSFER_DATE
,      BAT_SETTLE_BY_SYSTEM_FLAG
,      BAT_TRXN_STATUS_CODE
,      BAT_ATTRIBUTE_CATEGORY
,      BAT_ATTRIBUTE1
,      BAT_ATTRIBUTE2
,      BAT_ATTRIBUTE3
,      BAT_ATTRIBUTE4
,      BAT_ATTRIBUTE5
,      BAT_ATTRIBUTE6
,      BAT_ATTRIBUTE7
,      BAT_ATTRIBUTE8
,      BAT_ATTRIBUTE9
,      BAT_ATTRIBUTE10
,      BAT_ATTRIBUTE11
,      BAT_ATTRIBUTE12
,      BAT_ATTRIBUTE13
,      BAT_ATTRIBUTE14
,      BAT_ATTRIBUTE15
,      CF_MISC_CLEARED_EXCHANGE_RATE
,      CF_MISC_CLEARED_EXC_RATE_TYPE
FROM APPS.CE_XLA_EXT_HEADERS_V;

Dependencies

[top of page]

APPS.CE_XLA_EXT_HEADERS_V references the following:

SchemaAPPS
PL/SQL PackageCEP_STANDARD - show dependent code
SynonymCE_BANK_ACCOUNTS
ViewCE_BANK_BRANCHES_V
SynonymCE_CASHFLOWS
SynonymCE_CASHFLOW_ACCT_H
SynonymCE_PAYMENT_TRANSACTIONS
SynonymCE_STATEMENT_HEADERS
SynonymCE_STATEMENT_LINES
SynonymCE_SYSTEM_PARAMETERS
SynonymCE_TRXNS_SUBTYPE_CODES
SynonymGL_LEDGERS
SynonymHZ_PARTY_SITES
ViewXLE_FIRSTPARTY_INFORMATION_V
APPS.CE_XLA_EXT_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyXLA_00260_AAD_S_000001_PKG - show dependent code