Results for “selected_for_receipt_batch_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AR_BOE_AUTO_RECEIPTS_V is an Oracle Receivables (AR) dictionary view owned by the APPS schema. It is documented in the ETRM reference as a Release 11.5-only object, and its view text makes clear that it was built to support the Bill of Exchange (BOE) automatic receipt creation process. The view presents a flattened, receipt-shaped projection of payment schedule and transaction data so that the BOE batch mechanism could treat selected invoices and their installments as if they were already cash receipts.
Structurally, the view emulates the column layout of an AR receipt/application result set. It supplies constants and placeholders for identifiers that do not yet exist at selection time — notably CASH_RECEIPT_ID = -1, RECEIVABLE_APPLICATION_ID = -1, and APPLIED_PAYMENT_SCHEDULE_ID = -1 — while populating real values from payment schedules, transactions, customers, banks, and batch sources. This makes it an integration and batch-processing view rather than an operational inquiry view. In 12.1.1 and 12.2.2 the object is retained for backward compatibility and defined over the current AR and IBY synonyms listed in the metadata.
Underlying Base Objects
The documented base objects include the core AR transaction and payment schedule tables — AR_PAYMENT_SCHEDULES, RA_CUSTOMER_TRX, RA_CUST_TRX_TYPES, RA_BATCH_SOURCES, AR_BATCHES, AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_RECEIVABLE_APPLICATIONS, and AR_CONS_INV. Customer and party data comes from HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES, and HZ_PARTIES; bank and payment instrument data is drawn from the IBY tables IBY_EXT_BANK_ACCOUNTS, IBY_CREDITCARD, IBY_PMT_INSTR_USES_ALL, IBY_FNDCPT_PMT_CHNNLS_B, IBY_FNDCPT_PMT_CHNNLS_TL, and IBY_FNDCPT_TX_EXTENSIONS. FND_APPLICATION provides application context. The view joins payment schedule rows (PS) to their customer transactions (CT) and enriches them with customer, bank, and batch attributes.
Key Columns
- TERM_DUE_DATE — sourced from
AR_PAYMENT_SCHEDULES.DUE_DATE. This is the column most relevant to the search term term_due_date; it carries the installment due date for each payment schedule and is the basis for BOE maturity and receipt dating. - CASH_RECEIPT_ID / RECEIVABLE_APPLICATION_ID / APPLIED_PAYMENT_SCHEDULE_ID — synthetic placeholders set to -1, signalling that no receipt or application exists yet.
- TRX_NUMBER / DOCUMENT_NUMBER — transaction and document identifiers from
RA_CUSTOMER_TRX. - TERMS_SEQUENCE_NUMBER — the installment sequence on the payment schedule.
- AMOUNT_APPLIED — mapped from
PS.AMOUNT_DUE_REMAINING, the open balance to be received. - CURRENCY_CODE, CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_NUMBER — currency and customer identification.
- BANK_NAME, BANK_BRANCH_NAME, BANK_ACCOUNT_NUMBER — instrument details, masked per decoded instrument type.
- SELECTED_FOR_RECEIPT_BATCH_ID, BATCH_ID, BATCH_NAME, BATCH_DATE, BATCH_APPLIED_STATUS — batch context linking the candidate receipt to a BOE receipt batch.
Common Use Cases and Queries
Typical usage is to identify payment schedule installments eligible for automatic BOE receipt generation and to reconcile them by due date. A representative query retrieves open installments with their term due date:
SELECT customer_trx_id, trx_number, term_due_date, amount_applied, currency_code, customer_name FROM apps.ar_boe_auto_receipts_v WHERE term_due_date BETWEEN :p_from AND :p_to AND batch_applied_status IS NULL ORDER BY term_due_date;
Analysts also use it to group unresolved balances by batch and customer, or to verify instrument and bank attributes before creating receipts. Because the view is 11.5-era and largely retained for compatibility, new development should confirm column availability in the target 12.1.1/12.2.2 instance; where TERM_DUE_DATE drives maturity logic, joining back to AR_PAYMENT_SCHEDULES ensures consistency with current AR data.
-
View: AR_BOE_AUTO_RECEIPTS_V 12.2.2
(Release 11.5 Only)
APPS.AR_BOE_AUTO_RECEIPTS_V·↳ AR_BATCHES·↳ AR_CASH_RECEIPTS·↳ AR_CASH_RECEIPT_HISTORY·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V·↳ AR_MC_PAYMENT_SCHEDULES·↳ AR_PAYMENT_SCHEDULES_ALL·Explore AR module →
-
View: AR_BOE_AUTO_RECEIPTS_V 12.1.1
(Release 11.5 Only)
APPS.AR_BOE_AUTO_RECEIPTS_V·↳ AR_BATCHES·↳ AR_CASH_RECEIPTS·↳ AR_CASH_RECEIPT_HISTORY·Explore AR module →
-
Descriptive Flexfields for payment schedules
APPS.AR_PAYMENT_SCHEDULES_FLEX_VIEW·↳ AR_CASH_RECEIPTS·↳ AR_PAYMENT_SCHEDULES·↳ RA_CUSTOMER_TRX·Explore AR module →
-
All transactions except adjustments and miscellaneous cash receipts
-
View: AR_MASS_APPLICATIONS_V 12.2.2
APPS.AR_MASS_APPLICATIONS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_DEDUCTION·↳ ARP_VIEW_CONSTANTS·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_MRC_V·↳ AR_MC_PAYMENT_SCHEDULES·↳ AR_PAYMENT_SCHEDULES_ALL·Explore AR module →
-
View: AR_RA_SELECTED_TRX_V 12.2.2
(Release 11.5 Only)
APPS.AR_RA_SELECTED_TRX_V·↳ AR_CASH_RECEIPTS·↳ AR_CONS_INV·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_OPEN_TRX_V 12.2.2
(Release 115 Only)
APPS.AR_OPEN_TRX_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV·Explore AR module →
-
View: AR_OPEN_ITEMS_V 12.1.1
(Release 115 Only)
APPS.AR_OPEN_ITEMS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_DEDUCTION·↳ AR_CASH_RECEIPTS·Explore AR module →
-
(Release 11.5 Only)
APPS.AR_RECEIVABLE_APPLICATIONS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_DEDUCTION·↳ AR_CASH_RECEIPTS·Explore AR module →
-
View: AR_PAYMENT_SCHEDULES_V 12.1.1
APPS.AR_PAYMENT_SCHEDULES_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
(Release 115 Only )
APPS.AR_PAYMENT_SCHEDULES_PMT_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
Descriptive Flexfields for payment schedules
APPS.AR_PAYMENT_SCHEDULES_FLEX_VIEW·↳ AR_CASH_RECEIPTS·↳ AR_PAYMENT_SCHEDULES·↳ RA_CUSTOMER_TRX·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_ALL_MRC_V·↳ AR_MC_PAYMENT_SCHEDULES·↳ AR_PAYMENT_SCHEDULES_ALL·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_MRC_V·↳ AR_MC_PAYMENT_SCHEDULES·↳ AR_PAYMENT_SCHEDULES_ALL·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_TRX2_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV_ALL·Explore AR module →
-
(Release 115 Only )
APPS.AR_PAYMENT_SCHEDULES_PMT_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
View: AR_RA_SELECTED_TRX_V 12.1.1
(Release 11.5 Only)
APPS.AR_RA_SELECTED_TRX_V·↳ AR_CASH_RECEIPTS·↳ AR_CONS_INV·↳ AR_LOOKUPS·Explore AR module →
-
View: AR_OPEN_TRX_V 12.1.1
(Release 115 Only)
APPS.AR_OPEN_TRX_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV·Explore AR module →
-
APPS.AR_PAYMENT_SCHEDULES_TRX2_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_CONS_INV_ALL·Explore AR module →
-
View: AR_MASS_APPLICATIONS_V 12.1.1
APPS.AR_MASS_APPLICATIONS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_DEDUCTION·↳ ARP_VIEW_CONSTANTS·Explore AR module →
-
View: AR_OPEN_ITEMS_V 12.2.2
(Release 115 Only)
APPS.AR_OPEN_ITEMS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_DEDUCTION·↳ AR_CASH_RECEIPTS·Explore AR module →
-
(Release 11.5 Only)
APPS.AR_RECEIVABLE_APPLICATIONS_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_DEDUCTION·↳ AR_CASH_RECEIPTS·Explore AR module →
-
All transactions except adjustments and miscellaneous cash receipts
-
View: AR_PAYMENT_SCHEDULES_V 12.2.2
APPS.AR_PAYMENT_SCHEDULES_V·↳ ARPT_SQL_FUNC_UTIL·↳ ARP_VIEW_CONSTANTS·↳ AR_BATCHES_ALL·Explore AR module →
-
PACKAGE: APPS.JL_BR_SPED_PKG 12.1.1
-
VIEW: APPS.AR_OPEN_TRX_V 12.2.2
-
VIEW: APPS.AR_OPEN_ITEMS_V 12.1.1
-
VIEW: APPS.AR_OPEN_ITEMS_V 12.2.2