Results for “b_status”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKX_PAYABLES_TERMS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite. It belongs to the OKX product family, which handles Contracts Integration, and its documented purpose is to expose supplier payment term definitions in a normalized form suitable for consumption by Oracle Contracts and related integration flows. The view is marked VALID, indicating that its underlying dependency chain resolves cleanly in both Oracle EBS 12.1.1 and 12.2.2 environments. Its role is to translate the multilingual, flag-based payment terms data held in Oracle Payables into a language-filtered result set with a simplified status indicator, avoiding the need for downstream code or reports to interpret the Y/N enabled flag directly.
Underlying Base Objects
The view is defined over a single documented base object: AP_TERMS_TL, referenced in the APPS schema through a synonym. AP_TERMS_TL is the translatable (TL) table that stores payment term names and descriptions in each installed language, keyed by TERM_ID and LANGUAGE. Because it is a TL table, the view applies a language filter using USERENV('LANG') so that each session returns term text in its own language. The view does not join to AP_TERMS_B; instead it relies on the TL table alone, since the columns required for integration—name, description, active dates, and enabled status—reside in the TL structure. No additional base tables are documented for this view.
Key Columns
The view exposes the following columns:
- NAME — the payment term name in the session language, taken from AP_TERMS_TL.NAME.
- DESCRIPTION — the descriptive text for the payment term in the session language.
- START_DATE_ACTIVE — the date from which the payment term becomes usable.
- END_DATE_ACTIVE — the date on which the payment term ceases to be usable.
- B_STATUS — the raw ENABLED_FLAG value ('Y' or 'N') from AP_TERMS_TL, preserved for consumers that require the underlying flag.
- STATUS — a decoded value derived via DECODE(PT.ENABLED_FLAG, 'Y', 'A', 'I'), mapping an enabled term to 'A' (Active) and any other value to 'I' (Inactive).
Internally the view also projects ID1 (TERM_ID) and a literal '#' as ID2, which are used by the OKX integration framework for keying and lookup purposes rather than for direct user reporting.
Common Use Cases and Queries
Typical scenarios include validating which payment terms are available for contract or supplier integration, synchronizing term definitions into external systems, and generating reports on active versus inactive terms. Because the view filters on the session language, queries return text consistent with the user's environment.
A basic listing of active payment terms:
SELECT name, description, start_date_active, end_date_active FROM apps.okx_payables_terms_v WHERE status = 'A';
Identifying terms that have been disabled for integration purposes:
SELECT name, b_status FROM apps.okx_payables_terms_v WHERE b_status = 'N';
Filtering by an effective date window for point-in-time validation:
SELECT name, start_date_active, end_date_active FROM apps.okx_payables_terms_v WHERE SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE);
Because the view is a thin projection over AP_TERMS_TL, query performance is generally efficient, and users should be aware that results are constrained by the session language and by the enabled flag as recorded in Oracle Payables.
-
View: OKX_PAYABLES_TERMS_V 12.1.1
Supplier payment term definitions
APPS.OKX_PAYABLES_TERMS_V·↳ AP_TERMS_TL·Explore OKX module →
-
View: PV_PARTNER_VENDORS_V 12.1.1
APPS.PV_PARTNER_VENDORS_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore PV module →
-
View: PV_PARTNER_VENDORS_V 12.2.2
APPS.PV_PARTNER_VENDORS_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·Explore PV module →
-
View: OKX_LOOKUPS_V 12.1.1
QuickCode values
APPS.OKX_LOOKUPS_V·↳ FND_GLOBAL·↳ FND_LOOKUP_VALUES·Explore OKX module →
-
View: OKX_CATEGORY_SETS_V 12.2.2
Category sets
APPS.OKX_CATEGORY_SETS_V·↳ MTL_CATEGORY_SETS_B·↳ MTL_CATEGORY_SETS_TL·Explore OKX module →
-
View: PV_PARTNER_CONTACTS_V 12.2.2
APPS.PV_PARTNER_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore PV module →
-
View: OKX_CATEGORIES_V 12.1.1
Item categories
APPS.OKX_CATEGORIES_V·↳ MTL_CATEGORIES_B_KFV·↳ MTL_CATEGORIES_TL·Explore OKX module →
-
Customer accounts information
APPS.OKE_CUSTOMER_ACCOUNTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKE module →
-
View: OKX_LIST_HEADERS_V 12.2.2
Header information for all types of lists
APPS.OKX_LIST_HEADERS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore OKX module →
-
View: OKX_SALESREPS_V 12.1.1
Information about sales reps
APPS.OKX_SALESREPS_V·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_SALESREPS_MO_V·Explore OKX module →
-
View: OKX_ORG_PARTIES_V 12.2.2
Parties
APPS.OKX_ORG_PARTIES_V·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES·Explore OKX module →
-
View: OKX_LIST_HEADERS_V 12.1.1
Header information for all types of lists
APPS.OKX_LIST_HEADERS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore OKX module →
-
View: OKX_LOOKUPS_V 12.2.2
QuickCode values
APPS.OKX_LOOKUPS_V·↳ FND_GLOBAL·↳ FND_LOOKUP_VALUES·Explore OKX module →
-
View: OKX_TAX_CODES_V 12.2.2
Tax codes
APPS.OKX_TAX_CODES_V·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·Explore OKX module →
-
View: OKL_LA_BILL_TO_UV 12.2.2
View for BILL_TO LOV
APPS.OKL_LA_BILL_TO_UV·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCT_SITES_ALL·↳ OKX_CUST_SITE_USES_V·Explore OKL module →
-
View: OKX_TAX_CODES_V 12.1.1
Tax codes
APPS.OKX_TAX_CODES_V·↳ AR_VAT_TAX_ALL_B·↳ AR_VAT_TAX_ALL_TL·Explore OKX module →
-
View: OKL_LA_BILL_TO_UV 12.1.1
View for BILL_TO LOV
APPS.OKL_LA_BILL_TO_UV·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCT_SITES_ALL·↳ OKX_CUST_SITE_USES_V·Explore OKL module →
-
View: OKX_PARTY_CONTACTS_V 12.1.1
Party contacts
APPS.OKX_PARTY_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore OKX module →
-
View: OKE_SYSTEM_ITEMS_V 12.1.1
View of Inventory Items
APPS.OKE_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKE module →
-
View: OKX_TAX_EXEMPTIONS_V 12.1.1
Tax exemptions
APPS.OKX_TAX_EXEMPTIONS_V·↳ RA_TAX_EXEMPTIONS_ALL·Explore OKX module →
-
View: OKX_PAYABLES_TERMS_V 12.2.2
Supplier payment term definitions
APPS.OKX_PAYABLES_TERMS_V·↳ AP_TERMS_TL·Explore OKX module →
-
View: OKX_VENDORS_V 12.2.2
Suppliers
-
View: OKX_VENDORS_V 12.1.1
Suppliers
-
View: PV_PARTNERS_LOV_V 12.1.1
APPS.PV_PARTNERS_LOV_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore PV module →
-
View: OKX_CATEGORIES_V 12.2.2
Item categories
APPS.OKX_CATEGORIES_V·↳ MTL_CATEGORIES_B_KFV·↳ MTL_CATEGORIES_TL·Explore OKX module →
-
Customer accounts information
APPS.OKE_CUSTOMER_ACCOUNTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKE module →
-
View: OKX_QUOTE_HEADERS_V 12.1.1
Quote header information
APPS.OKX_QUOTE_HEADERS_V·↳ ASO_QUOTE_HEADERS_ALL·↳ ASO_QUOTE_STATUSES_B·Explore OKX module →
-
View: PV_PARTNER_CONTACTS_V 12.1.1
APPS.PV_PARTNER_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore PV module →
-
View: OKX_SALESREPS_V 12.2.2
Information about sales reps
APPS.OKX_SALESREPS_V·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ JTF_RS_SALESREPS_MO_V·Explore OKX module →
-
Parties
APPS.OKX_PARTIES_WITH_ACCTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKX module →
-
View: OKX_QUOTE_HEADERS_V 12.2.2
Quote header information
APPS.OKX_QUOTE_HEADERS_V·↳ ASO_QUOTE_HEADERS_ALL·↳ ASO_QUOTE_STATUSES_B·Explore OKX module →
-
View: OKX_CUST_SITE_USES_V 12.2.2
Customer site uses
APPS.OKX_CUST_SITE_USES_V·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES·Explore OKX module →
-
View: OKX_PARTY_CONTACTS_V 12.2.2
Party contacts
APPS.OKX_PARTY_CONTACTS_V·↳ HZ_ORG_CONTACTS·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore OKX module →
-
View: OKX_RULES_V 12.2.2
Receivables invoicing and accounting rules
-
View: OKX_CATEGORY_SETS_V 12.1.1
Category sets
APPS.OKX_CATEGORY_SETS_V·↳ MTL_CATEGORY_SETS_B·↳ MTL_CATEGORY_SETS_TL·Explore OKX module →
-
View: OKX_RULES_V 12.1.1
Receivables invoicing and accounting rules
-
View: OKX_TAX_EXEMPTIONS_V 12.2.2
Tax exemptions
APPS.OKX_TAX_EXEMPTIONS_V·↳ RA_TAX_EXEMPTIONS_ALL·Explore OKX module →
-
View: OKE_SYSTEM_ITEMS_V 12.2.2
View of Inventory Items
APPS.OKE_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKE module →
-
View: PV_PARTNERS_LOV_V 12.2.2
APPS.PV_PARTNERS_LOV_V·↳ HZ_ORGANIZATION_PROFILES·↳ HZ_PARTIES·↳ HZ_RELATIONSHIPS·Explore PV module →
-
View: OKX_SYSTEM_ITEMS_V 12.1.1
Inventory item definitions
APPS.OKX_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKX module →
-
Parties
APPS.OKX_PARTIES_WITH_ACCTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKX module →
-
View: OKX_ORG_PARTIES_V 12.1.1
Parties
APPS.OKX_ORG_PARTIES_V·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES·Explore OKX module →
-
Customer accounts
APPS.OKX_CUSTOMER_ACCOUNTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKX module →
-
Customer accounts
APPS.OKX_CUSTOMER_ACCOUNTS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore OKX module →
-
View: OKX_PARTIES_V 12.1.1
Parties
-
View: OKX_RESOURCES_V 12.2.2
Information about resources
APPS.OKX_RESOURCES_V·↳ FND_GLOBAL·↳ FND_USER·↳ HZ_PARTIES·Explore OKX module →
-
View: OKX_RESOURCES_V 12.1.1
Information about resources
APPS.OKX_RESOURCES_V·↳ FND_USER·↳ HZ_PARTIES·↳ JTF_RS_RESOURCE_EXTNS·Explore OKX module →
-
View: OKE_CUST_SITE_USES_V 12.2.2
Customer sites and usage information
APPS.OKE_CUST_SITE_USES_V·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore OKE module →
-
View: OKX_PARTIES_V 12.2.2
Parties
-
View: OKX_CUST_SITE_USES_V 12.1.1
Customer site uses
APPS.OKX_CUST_SITE_USES_V·↳ ARP_ADDR_LABEL_PKG·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES·Explore OKX module →