Results for “global_attribute10”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JL_BR_AR_PAYMENT_SCH_IOB_V is a read-only view owned by the APPS schema within the JL – Latin America Localizations product, specifically targeting the Brazilian receivables localization. It is documented in the ETRM as a VALID database object. The view consolidates payment schedule information with the Brazilian borderô (bank collection remittance) framework, exposing installment-level receivable data alongside the corresponding bordero record, customer party, and bank account usage.
Its principal role is to support reporting and integration scenarios in which a payment schedule line must be examined together with the collection or factoring bordero that submitted it to a bank. Because the view joins payables flow documents to the borderô tables, it is used by localization reports and interfaces that require a trade-note reference in the format TRX_NUMBER-TERMS_SEQUENCE_NUMBER and related attributes, without requiring the consumer to manually reproduce the joins across the underlying AR and JL tables.
Underlying Base Objects
The view is defined over the following documented objects: AR_PAYMENT_SCHEDULES_ALL, JL_BR_AR_COLLECTION_DOCS_ALL, JL_BR_AR_BORDEROS, RA_CUSTOMER_TRX_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES, and CE_BANK_ACCT_USES_ALL. All are referenced through synonyms in the APPS schema.
- AR_PAYMENT_SCHEDULES_ALL — the primary driver of the view, supplying payment schedule identifiers, due dates, remaining amounts due, and transaction numbers.
- JL_BR_AR_COLLECTION_DOCS_ALL — links each payment schedule to its borderô collection document.
- JL_BR_AR_BORDEROS — the borderô header, filtered by
BORDERO_TYPE IN ('COLLECTION','FACTORING'), and the source of ORG_ID and bank account usage. - RA_CUSTOMER_TRX_ALL — supplies the transaction number and bill-to customer identifier.
- HZ_CUST_ACCOUNTS and HZ_PARTIES — provide the customer account and the customer name (
PARTY_NAME). - CE_BANK_ACCT_USES_ALL — validates the bank account use associated with the collection document.
The join is a conjunction of schedule, collection document, bordero, transaction, account, party, and bank account use, all restricted to the borderô type COLLECTION or FACTORING, and constrained throughout on ORG_ID.
Key Columns
- ROW_ID — the ROWID of the underlying payment schedule row, used as the distinct key.
- PAYMENT_SCHEDULE_ID — the installment identifier from AR_PAYMENT_SCHEDULES_ALL.
- DUE_DATE — the installment due date.
- AMOUNT_DUE_REMAINING — the open amount still outstanding on the installment.
- CUSTOMER_ID — the bill-to customer account identifier.
- CUSTOMER_TRX_ID and TRX_NUMBER — the transaction identifier and number of the originating invoice.
- GLOBAL_ATTRIBUTE10 and GLOBAL_ATTRIBUTE11 — the descriptive flexfield attributes used by the Brazilian localization.
- CUSTOMER_NAME — the customer party name.
- ORG_ID — the operating unit identifier (multi-org security key).
- TRADE_NOTE_NUMBER — concatenation of TRX_NUMBER and TERMS_SEQUENCE_NUMBER, formatted with a hyphen; the trade-note reference.
Common Use Cases and Queries
The view is typically queried to list bordero-submitted installments with their remaining balance and customer details for a given operating unit. A minimal query follows:
SELECT TRADE_NOTE_NUMBER, TRX_NUMBER, CUSTOMER_NAME,
DUE_DATE, AMOUNT_DUE_REMAINING, GLOBAL_ATTRIBUTE10
FROM APPS.JL_BR_AR_PAYMENT_SCH_IOB_V
WHERE ORG_ID = :org_id
AND TRUNC(DUE_DATE) BETWEEN :start_date AND :end_date
ORDER BY DUE_DATE;
Typical scenarios include reconciliation of borderô submissions against outstanding receivables, aging and collection reporting for Brazilian legal entities, factoring analysis, and reconciliation of bank account usage against collection documents. Because the view filters to COLLECTION and FACTORING borderô types, results exclude borderôs of other categories, and the DISTINCT clause eliminates duplicates arising from the multi-table join. Queries should be scoped by ORG_ID to respect operating unit security.
-
APPS.JL_BR_AR_PAYMENT_SCH_IOB_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ CE_BANK_ACCT_USES_ALL·↳ HZ_CUST_ACCOUNTS·Explore JL module →
-
APPS.JL_BR_AR_PAYMENT_SCH_IOB_V·↳ AR_PAYMENT_SCHEDULES_ALL·↳ CE_BANK_ACCT_USES_ALL·↳ HZ_CUST_ACCOUNTS·Explore JL module →
-
View: OE_ORG_FREIGHT_V 12.1.1
No longer used
-
View: OE_FND_CURRENCIES_V 12.2.2
This view is based on fnd_currencies.
APPS.OE_FND_CURRENCIES_V·↳ FND_CURRENCIES·Explore ONT module →
-
View: OE_ORG_FREIGHT_V 12.2.2
No longer used
-
View: JTF_PARTIES_ALL_V 12.1.1
Party information of the Caller, Customer and Relationship
-
View: ASO_I_ITEMS_V 12.1.1
This is a view based on MTL_SYSTEM_ITEMS_VL which has System Items multilingual view with concatenated segments column
APPS.ASO_I_ITEMS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
View: IBY_EXT_FD_DOC_1_0_V 12.2.2
APPS.IBY_EXT_FD_DOC_1_0_V·↳ FND_GLOBAL·↳ IBY_EXT_FD_DOC_1_0_VT·↳ IBY_FD_EXTRACT_GEN_PVT·Explore IBY module →
-
View: JTF_PARTIES_ALL_V 12.2.2
Party information of the Caller, Customer and Relationship
-
View: IGI_CIS_AWT_TAX_RATES 12.2.2
Displays CIS WIthholding Certificate records coupled with NI Number details.
APPS.IGI_CIS_AWT_TAX_RATES·↳ AP_AWT_TAX_RATES·↳ IGI_CIS_CERT_NI_NUMBERS·Explore IGI module →
-
JTF_CUST_ACCOUNT_ROLES retrieves information about the roles that parties perform in customer accounts.
APPS.JTF_CUST_ACCOUNTS_ROLES_V·↳ HZ_CUST_ACCOUNT_ROLES·Explore JTF module →
-
View: ASO_I_ITEMS_V 12.2.2
This is a view based on MTL_SYSTEM_ITEMS_VL which has System Items multilingual view with concatenated segments column
APPS.ASO_I_ITEMS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore ASO module →
-
View: AR_CASH_RECEIPTS_MRC_V 12.1.1
APPS.AR_CASH_RECEIPTS_MRC_V·↳ AR_CASH_RECEIPTS·↳ AR_MC_CASH_RECEIPTS·Explore AR module →
-
Party relationship view
APPS.AS_PARTY_RELATIONSHIPS_V·↳ HZ_RELATIONSHIPS·Explore AS module →
-
View: OE_FND_CURRENCIES_V 12.1.1
This view is based on fnd_currencies.
APPS.OE_FND_CURRENCIES_V·↳ FND_CURRENCIES·Explore ONT module →
-
Additional attributes of order line schedule details
-
View: HR_LOCATIONS_NO_JOIN 12.1.1
USed to support user interface.
APPS.HR_LOCATIONS_NO_JOIN·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·Explore PER module →
-
Non-Permanent inventory accounts information
-
View: OPM_SITE_USES_ALL 12.2.2
OPM site uses view
-
Party relationship view
APPS.AS_PARTY_RELATIONSHIPS_V·↳ HZ_RELATIONSHIPS·Explore AS module →
-
Additional attributes of order headers
-
View: AR_CASH_RECEIPTS_MRC_V 12.2.2
APPS.AR_CASH_RECEIPTS_MRC_V·↳ AR_CASH_RECEIPTS·↳ AR_MC_CASH_RECEIPTS·Explore AR module →
-
View: PO_HR_LOCATIONS 12.1.1
- Retrofitted
APPS.PO_HR_LOCATIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
View: AP_PAYMENT_SCHEDULES_V 12.2.2
APPS.AP_PAYMENT_SCHEDULES_V·↳ AP_BATCHES_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_PKG·Explore AR module →
-
JTF_CUSTOMER_PROFILES_V retrieves credit information for your customer accounts and customer account sites.
APPS.JTF_CUSTOMER_PROFILES_V·↳ HZ_CUSTOMER_PROFILES·Explore JTF module →
-
- Retrofitted
APPS.AR_ADJUSTMENTS_ALL_MRC_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_MC_ADJUSTMENTS·Explore AR module →
-
- Retrofitted
APPS.AR_ADJUSTMENTS_ALL_MRC_V·↳ AR_ADJUSTMENTS_ALL·↳ AR_MC_ADJUSTMENTS·Explore AR module →
-
This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
APPS.ASO_I_OE_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ASO module →
-
View: AP_PAYMENT_SCHEDULES_V 12.2.2
APPS.AP_PAYMENT_SCHEDULES_V·↳ AP_BATCHES_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_PKG·Explore AP module →
-
View: JTF_CUST_ACCT_SITES_V 12.2.2
JTF_CUST_ACCT_SITES retrieves information about customer sites. One customer account can have multiple sites.
APPS.JTF_CUST_ACCT_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·Explore JTF module →
-
JTF_CUST_ACCOUNT_ROLES retrieves information about the roles that parties perform in customer accounts.
APPS.JTF_CUST_ACCOUNTS_ROLES_V·↳ HZ_CUST_ACCOUNT_ROLES·Explore JTF module →
-
View: IGI_CIS_AWT_TAX_RATES 12.1.1
Displays CIS WIthholding Certificate records coupled with NI Number details.
APPS.IGI_CIS_AWT_TAX_RATES·↳ AP_AWT_TAX_RATES·↳ IGI_CIS_CERT_NI_NUMBERS·Explore IGI module →
-
View: PO_HR_LOCATIONS 12.2.2
- Retrofitted
APPS.PO_HR_LOCATIONS·↳ HR_GENERAL·↳ HR_LOCATIONS_ALL·↳ HR_LOCATIONS_ALL_TL·Explore PO module →
-
Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object.
APPS.JTF_CUST_ACCOUNTS_ALL_V·↳ HZ_CUST_ACCOUNTS·Explore JTF module →
-
Account information of a Party. This view is identical to the underlying table HZ_CUST_ACCOUNTS. View is created so that it serves as a single poing of interface to the AR schema object.
APPS.JTF_CUST_ACCOUNTS_ALL_V·↳ HZ_CUST_ACCOUNTS·Explore JTF module →
-
Additional attributes of order headers
-
APPS.FA_ADDITIONS_NON_SEC_VL·↳ FA_ADDITIONS_B·↳ FA_ADDITIONS_TL·Explore OFA module →
-
Displays records of invoice payments coupled with CIS Payment Voucher details.
APPS.IGI_CIS_INVOICE_PAYMENTS·↳ AP_INVOICE_PAYMENTS·↳ IGI_CIS_PAYMENT_VOUCHERS·Explore IGI module →
-
View: JTF_CUST_ACCT_SITES_V 12.1.1
JTF_CUST_ACCT_SITES retrieves information about customer sites. One customer account can have multiple sites.
APPS.JTF_CUST_ACCT_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·Explore JTF module →
-
View: JTF_HZ_PARTIES_V 12.2.2
JTF_HZ_PARTIES_V retrieves information about parties such as organizations, people, and groups, including the identifying address information for the party.
-
View: AMS_ORGANIZATION_V 12.2.2
This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
-
View: AP_PAYMENT_SCHEDULES_V 12.1.1
APPS.AP_PAYMENT_SCHEDULES_V·↳ AP_BATCHES_ALL·↳ AP_INVOICES_ALL·↳ AP_INVOICE_PAYMENTS_PKG·Explore AR module →
-
View: AMS_P_PERSON_V 12.2.2
This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.
-
View: AMS_P_PERSON_V 12.1.1
This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.
-
Additional attributes of imported order headers
-
APPS.ZX_REC_NREC_DIST_QUOTE_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_REC_NREC_DIST·↳ ZX_REC_NREC_DIST_GT·Explore FND module →
-
View: GL_SETS_OF_BOOKS_V 12.1.1
APPS.GL_SETS_OF_BOOKS_V·↳ FND_ID_FLEX_STRUCTURES_TL·↳ GL_DAILY_CONVERSION_TYPES·↳ GL_LEDGERS·Explore GL module →
-
APPS.ZX_REC_NREC_DIST_QUOTE_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_REC_NREC_DIST·↳ ZX_REC_NREC_DIST_GT·Explore FND module →
-
View: OE_CRM_ORDER_HEADERS_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_CRM_ORDER_HEADERS_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →