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

VIEW: APPS.CE_INTRA_STMT_HDRS_LINES_V

Object Details
Object Name: CE_INTRA_STMT_HDRS_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCE.CE_INTRA_STMT_HDRS_LINES_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
STATEMENT_HEADER_ID NUMBER (15) Yes Statement header identifier
BANK_ACCOUNT_ID NUMBER (15) Yes Bank account identifier
STATEMENT_NUMBER VARCHAR2 (50) Yes Statement number
STATEMENT_DATE DATE
Yes Statement date
HEADER_CREATED_BY NUMBER (15) Yes Standard WHO column
HEADER_CREATION_DATE DATE
Yes Standard WHO column
HEADER_LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
HEADER_LAST_UPDATE_DATE DATE
Yes Standard WHO column
AUTO_LOADED_FLAG VARCHAR2 (1) Yes Flag to indicate whether the statement was loaded automatically via open interface, Y or N
GL_DATE DATE

Date used for GL accounting entries generated during the reconciliation process
CONTROL_BEGIN_BALANCE NUMBER

Beginning balance of the bank statement for control purpose
CONTROL_TOTAL_DR NUMBER

Total payment amount of the bank statement that can be compared to the actual payment entry totals for control purpose
CONTROL_TOTAL_CR NUMBER

Total receipt amount of the bank statement that can be compared to the actual receipt entry totals for control purpose
CONTROL_END_BALANCE NUMBER

Ending balance of the statement for control purpose (CONTROL_BEGIN_BALANCE - CONTROL_TOTAL_DR + CONTROL_TOTAL_CR)
CONTROL_DR_LINE_COUNT NUMBER

Total payment line count of the statement that can be compared to the actual number of payments entered for control purposes
CONTROL_CR_LINE_COUNT NUMBER

Total receipt line count of the statement that can be compared to the actual number of receipts entered for control purposes
HEADER_CURRENCY_CODE VARCHAR2 (15)
Bank statement currency code
HEADER_LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
HEADER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield structure defining column
HEADER_ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
HEADER_ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
STATEMENT_COMPLETE_FLAG VARCHAR2 (1)
Flag to indicate whether the statement is complete or not, Y or N
DOC_SEQUENCE_ID NUMBER

Document sequence identifier
DOC_SEQUENCE_VALUE NUMBER

Interest Calculated Balance
CHECK_DIGITS VARCHAR2 (30)
Holds any check digits that result from bank account number validation in FBS
CASHFLOW_BALANCE NUMBER

Cashflow Balance
INT_CALC_BALANCE NUMBER

STATEMENT_LINE_ID NUMBER (15) Yes System-assigned statement line identifier
LINE_NUMBER NUMBER (15) Yes Statement line number
TRX_DATE DATE
Yes Line transaction date, used to update AP check's cleared date and AR receipt's cleared date if EFFECTIVE_DATE is null
TRX_TYPE VARCHAR2 (30) Yes Transaction type, lookup type BANK_TRX_TYPE
AMOUNT NUMBER
Yes Statement line amount
SIGNED_AMOUNT NUMBER

STATUS VARCHAR2 (30)
LINE_CREATED_BY NUMBER (15) Yes
LINE_CREATION_DATE DATE
Yes
LINE_LAST_UPDATED_BY NUMBER (15) Yes
LINE_LAST_UPDATE_DATE DATE
Yes
TRX_CODE_ID NUMBER (15)
EFFECTIVE_DATE DATE

BANK_TRX_NUMBER VARCHAR2 (240)
TRX_TEXT VARCHAR2 (255)
CUSTOMER_TEXT VARCHAR2 (80)
INVOICE_TEXT VARCHAR2 (70)
BANK_ACCOUNT_TEXT VARCHAR2 (60)
LINE_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_RATE NUMBER

EXCHANGE_RATE_DATE DATE

ORIGINAL_AMOUNT NUMBER

CHARGES_AMOUNT NUMBER

LINE_LAST_UPDATE_LOGIN NUMBER (15)
RECONCILE_TO_STATEMENT_FLAG VARCHAR2 (1)
LINE_ATTRIBUTE_CATEGORY VARCHAR2 (30)
LINE_ATTRIBUTE1 VARCHAR2 (150)
LINE_ATTRIBUTE2 VARCHAR2 (150)
LINE_ATTRIBUTE3 VARCHAR2 (150)
LINE_ATTRIBUTE4 VARCHAR2 (150)
LINE_ATTRIBUTE5 VARCHAR2 (150)
LINE_ATTRIBUTE6 VARCHAR2 (150)
LINE_ATTRIBUTE7 VARCHAR2 (150)
LINE_ATTRIBUTE8 VARCHAR2 (150)
LINE_ATTRIBUTE9 VARCHAR2 (150)
LINE_ATTRIBUTE10 VARCHAR2 (150)
LINE_ATTRIBUTE11 VARCHAR2 (150)
LINE_ATTRIBUTE12 VARCHAR2 (150)
LINE_ATTRIBUTE13 VARCHAR2 (150)
LINE_ATTRIBUTE14 VARCHAR2 (150)
LINE_ATTRIBUTE15 VARCHAR2 (150)
BANK_ACCOUNT_NUM VARCHAR2 (30)
BANK_ACCOUNT_NAME VARCHAR2 (100) Yes
BANK_ACCOUNT_CURRENCY_CODE VARCHAR2 (15)
BANK_NAME VARCHAR2 (360) Yes
BANK_BRANCH_NAME VARCHAR2 (360) Yes
BANK_BRANCH_ID NUMBER (15) Yes
TRX_TYPE_DSP VARCHAR2 (80) Yes
TRX_CODE VARCHAR2 (30)
TRX_CODE_DESC VARCHAR2 (240)
STATEMENT_TYPE CHAR (9)
Query Text

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


SELECT STATEMENT_HEADER_ID
,      BANK_ACCOUNT_ID
,      STATEMENT_NUMBER
,      STATEMENT_DATE
,      HEADER_CREATED_BY
,      HEADER_CREATION_DATE
,      HEADER_LAST_UPDATED_BY
,      HEADER_LAST_UPDATE_DATE
,      AUTO_LOADED_FLAG
,      GL_DATE
,      CONTROL_BEGIN_BALANCE
,      CONTROL_TOTAL_DR
,      CONTROL_TOTAL_CR
,      CONTROL_END_BALANCE
,      CONTROL_DR_LINE_COUNT
,      CONTROL_CR_LINE_COUNT
,      HEADER_CURRENCY_CODE
,      HEADER_LAST_UPDATE_LOGIN
,      HEADER_ATTRIBUTE_CATEGORY
,      HEADER_ATTRIBUTE1
,      HEADER_ATTRIBUTE2
,      HEADER_ATTRIBUTE3
,      HEADER_ATTRIBUTE4
,      HEADER_ATTRIBUTE5
,      HEADER_ATTRIBUTE6
,      HEADER_ATTRIBUTE7
,      HEADER_ATTRIBUTE8
,      HEADER_ATTRIBUTE9
,      HEADER_ATTRIBUTE10
,      HEADER_ATTRIBUTE11
,      HEADER_ATTRIBUTE12
,      HEADER_ATTRIBUTE13
,      HEADER_ATTRIBUTE14
,      HEADER_ATTRIBUTE15
,      STATEMENT_COMPLETE_FLAG
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      CHECK_DIGITS
,      CASHFLOW_BALANCE
,      INT_CALC_BALANCE
,      STATEMENT_LINE_ID
,      LINE_NUMBER
,      TRX_DATE
,      TRX_TYPE
,      AMOUNT
,      SIGNED_AMOUNT
,      STATUS
,      LINE_CREATED_BY
,      LINE_CREATION_DATE
,      LINE_LAST_UPDATED_BY
,      LINE_LAST_UPDATE_DATE
,      TRX_CODE_ID
,      EFFECTIVE_DATE
,      BANK_TRX_NUMBER
,      TRX_TEXT
,      CUSTOMER_TEXT
,      INVOICE_TEXT
,      BANK_ACCOUNT_TEXT
,      LINE_CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_DATE
,      ORIGINAL_AMOUNT
,      CHARGES_AMOUNT
,      LINE_LAST_UPDATE_LOGIN
,      RECONCILE_TO_STATEMENT_FLAG
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      BANK_ACCOUNT_NUM
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_CURRENCY_CODE
,      BANK_NAME
,      BANK_BRANCH_NAME
,      BANK_BRANCH_ID
,      TRX_TYPE_DSP
,      TRX_CODE
,      TRX_CODE_DESC
,      STATEMENT_TYPE
FROM APPS.CE_INTRA_STMT_HDRS_LINES_V;

Dependencies

[top of page]

APPS.CE_INTRA_STMT_HDRS_LINES_V references the following:

SchemaAPPS
SynonymCE_BANK_ACCOUNTS
ViewCE_BANK_BRANCHES_V
SynonymCE_INTRA_STMT_HEADERS
SynonymCE_INTRA_STMT_LINES
ViewCE_LOOKUPS
SynonymCE_TRANSACTION_CODES
APPS.CE_INTRA_STMT_HDRS_LINES_V is referenced by following:

SchemaAPPS
ViewXTR_INTRADAY_STATEMENTS_V