Search Results bank_acc_bal_type

Overview

CE.CE_CP_WORKSHEET_LINES is a transactional detail table in the Oracle E-Business Suite Cash Management (CE) module. It stores the individual line-level criteria that make up a Cash Position worksheet. A Cash Position worksheet is the user-defined specification that determines which bank account balances, transactions, and external sources are aggregated into a Cash Position report or the Cash Positioning and Forecasting process. Each row in this table represents one selection line within a given worksheet header, capturing the filters and inclusion rules that the Cash Management engine applies when assembling cash position results.

The object resides in the CE schema, is registered under FND Design Data as CE.CE_CP_WORKSHEET_LINES, and has a status of VALID. Its physical storage is in the APPS_TS_TX_DATA tablespace, with indexes held in APPS_TS_TX_IDX. The table is not classified as a shared reference entity; from a Data Vault modeling perspective the metadata suggests a satellite classification, since its rows describe the mutable, descriptive criteria belonging to a worksheet header rather than serving as an independent business hub or a pure many-to-many link.

Key Information Stored

The table contains 43 documented columns. The most significant are summarized below.

• WORKSHEET_LINE_ID — the surrogate primary key, uniquely identifying each line. It is enforced by the unique index CE_CP_WORKSHEET_LINES_U1, which the metadata identifies as a business-key candidate.
• WORKSHEET_HEADER_ID — the foreign-key reference back to the Cash Position worksheet header, grouping lines under their parent worksheet. It is the leading column of the non-unique index CE_CP_WORKSHEET_LINES_N1.
• SOURCE_TYPE — identifies the transaction source being selected (for example, bank account balances, AR receipts, AP payments, payroll, or external open-interface data).
• INCLUDE_FLAG — controls whether the line is included in the Cash Position result.
• LEGAL_ENTITY_ID and BANK_ACCOUNT_ID — scope the line to a specific legal entity and bank account; BANK_NAME and DESCRIPTION provide descriptive context.
• BALANCE_TYPE, FLOAT_TYPE, and TRX_TYPE — filter criteria driven by CE lookup types such as BANK_ACC_BAL_TYPE and FLOAT_TYPE.
• PAYMENT_METHOD and RECEIPT_METHOD_ID — apply payment and receipt method filters for AP/PAY and AR sources respectively.
• CLEARED_TRX_FLAG, OVERDUE_TRX_FLAG, CUT_OFF_DAYS, and INDICATIVE_FLAG — refine which transactions qualify, including cleared or overdue items and indicative exposures.
• AMOUNT — holds the amount for user-defined transactions.
• CRITERIA_CATEGORY through CRITERIA15 — store descriptive flexfield structure and segment values for external source types.
• CASHPOOL_ID and TRXN_SUBTYPE_CODE_ID — associate the line with a cash pool and transaction subtype.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY audit each row.

Common Use Cases and Queries

Typical uses include auditing worksheet configurations, cloning worksheet criteria, and diagnosing why a cash position result excludes expected balances. A common query retrieves all lines for a worksheet:

• SELECT WORKSHEET_LINE_ID, SOURCE_TYPE, INCLUDE_FLAG, LEGAL_ENTITY_ID, BANK_ACCOUNT_ID, BALANCE_TYPE, FLOAT_TYPE FROM CE_CP_WORKSHEET_LINES WHERE WORKSHEET_HEADER_ID = :header_id ORDER BY WORKSHEET_LINE_ID;
• Identify active selection lines: ... WHERE INCLUDE_FLAG = 'Y'.
• Detect lines scoped to bank balances: ... WHERE BALANCE_TYPE IS NOT NULL.
• Trace external-interface criteria: ... WHERE EXT_SOURCE_TYPE IS NOT NULL AND CRITERIA_CATEGORY IS NOT NULL.

Related Objects

The following objects are most closely related, based on the documented foreign-key relationships:

• CE_CP_WORKSHEET_HEADERS — the parent header table; join on WORKSHEET_HEADER_ID.
• FV_LEGAL_ENTITIES — referenced by LEGAL_ENTITY_ID for legal entity validation.
• AR_RECEIPT_METHODS — referenced by RECEIPT_METHOD_ID for AR receipt method filtering.
• CE_BANK_ACCOUNTS — indirectly related via BANK_ACCOUNT_ID for bank account context.
• CE_CP_WORKSHEET_LINES_U1 and CE_CP_WORKSHEET_LINES_N1 — the unique and non-unique indexes supporting line and header access paths.