Results for “gsa_indicator”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WSH_CUSTOMERS_ACTIVE_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the WSH – Shipping Execution product family. Although it is catalogued under Shipping Execution, the view functions as a lightweight customer master reference that exposes a curated projection of active customer account data sourced from the Oracle Receivables / Trading Community Architecture (TCA) model. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and the definition is identical across both releases, making it a stable integration point for custom reports, concurrent programs, and external interfaces.
The view addresses a recurring requirement in shipping and order management flows: the need to resolve a customer identifier, customer number, display name, and GSA (General Services Administration) indicator without navigating the extensive join paths of the TCA tables. Because it pre-joins HZ_PARTIES and HZ_CUST_ACCOUNTS and restricts output to active accounts, it reduces the risk of returning obsolete or inactive customer records.
The user search term "gsa_indicator" corresponds directly to the GSA_INDICATOR column, which is the distinguishing attribute of this view. This column surfaces the GSA flag maintained on the party record, filtered by party type, and is used to identify customers eligible under U.S. federal GSA schedule purchasing arrangements.
Underlying Base Objects
The view is defined over two synonym-referenced base tables in the TCA model:
- HZ_PARTIES (alias PARTY) – the party master, supplying PARTY_NAME, PARTY_TYPE, PARTY_ID, and GSA_INDICATOR_FLAG.
- HZ_CUST_ACCOUNTS (alias CUST_ACCT) – the customer account layer, supplying ACCOUNT_NUMBER, CUST_ACCOUNT_ID, PARTY_ID, and STATUS.
The two objects are joined on CUST_ACCT.PARTY_ID = PARTY.PARTY_ID, with an additional predicate restricting results to rows where CUST_ACCT.STATUS = 'A' (active). This inner join means only parties that have at least one active customer account are returned; parties without a corresponding active account are excluded entirely. The synonym references indicate the view resolves through the APPS synonyms for the underlying HZ tables.
Key Columns
- CUSTOMER_NAME – derived via SUBSTRB(PARTY.PARTY_NAME, 1, 50). The byte-based substring enforces a maximum of 50 bytes, which can truncate multibyte customer names.
- CUSTOMER_NUMBER – the customer account number from HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER, the human-readable key commonly used in order entry and shipping documents.
- CUSTOMER_ID – the numeric CUST_ACCOUNT_ID, the primary identifier used for foreign-key relationships in shipping and order tables.
- GSA_INDICATOR – computed with NVL(DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.GSA_INDICATOR_FLAG,'N'),'N'). The flag is returned only for organization parties; person parties and null values resolve to 'N'.
Common Use Cases and Queries
Typical scenarios include populating customer list of values, validating GSA eligibility during order or shipment processing, and supplying reference data to outbound interfaces.
List active customers with their GSA status:
SELECT customer_id, customer_number, customer_name, gsa_indicator FROM apps.wsh_customers_active_v WHERE gsa_indicator = 'Y';
Resolve a name from a customer number:
SELECT customer_name FROM apps.wsh_customers_active_v WHERE customer_number = :p_number;
Because the view is not indexed itself, queries benefit from the indexes on HZ_CUST_ACCOUNTS and HZ_PARTIES. Note that the STATUS = 'A' filter means inactive accounts are never returned; applications requiring historical customers must query the base TCA tables directly.
-
View: WSH_CUSTOMERS_ACTIVE_V 12.2.2
APPS.WSH_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore WSH module →
-
View: WSH_CUSTOMER_SITES_V 12.2.2
APPS.WSH_CUSTOMER_SITES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore WSH module →
-
PACKAGE: APPS.QP_VALIDATE 12.2.2
-
PACKAGE: APPS.QP_VALIDATE 12.1.1
-
APPS.WSH_CUSTOMER_LOCATIONS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore WSH module →
-
View: OE_CUSTOMERS_ACTIVE_V 12.1.1
APPS.OE_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore ONT module →
-
View: WSH_CUSTOMERS_ACTIVE_V 12.1.1
APPS.WSH_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore WSH module →
-
View: OE_CUSTOMERS_ACTIVE_V 12.2.2
APPS.OE_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore ONT module →
-
View: WMS_SHIP_TO_SITES_V 12.2.2
Customer Ship to Site
APPS.WMS_SHIP_TO_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore WMS module →
-
View: OE_DISCOUNTS_V 12.2.2
Obsolete
APPS.OE_DISCOUNTS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP 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: AR_CUSTOMERS_ACTIVE_V 12.1.1
(Release 11.5 Only)
APPS.AR_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →
-
View: WSH_CUSTOMER_SITES_V 12.1.1
APPS.WSH_CUSTOMER_SITES_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore WSH module →
-
View: QP_LIST_SUMMARY_VL 12.2.2
This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer.
APPS.QP_LIST_SUMMARY_VL·↳ FND_USER_AP_PKG·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore QP module →
-
View: QP_LIST_SUMMARY_VL 12.1.1
This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer.
APPS.QP_LIST_SUMMARY_VL·↳ FND_USER_AP_PKG·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore QP module →
-
View: QP_LIST_HEADERS_V 12.2.2
This view gives details of all standard price lists setup in pricing.
APPS.QP_LIST_HEADERS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore QP module →
-
QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
-
QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
-
View: QP_LIST_ATTRIBUTES_V 12.1.1
View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns
APPS.QP_LIST_ATTRIBUTES_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
Internal view for Account Site Use
APPS.HZ_WSRVC_ACCT_SITE_USES_V·↳ HZ_CUSTOMER_PROFILES·↳ HZ_CUST_SITE_USES·↳ HZ_ORIG_SYS_REFERENCES·Explore AR module →
-
View: SO_MANUAL_DISCOUNTS_V 12.1.1
APPS.SO_MANUAL_DISCOUNTS_V·↳ QP_PRICE_LIST_PVT·↳ QP_VIEW_UTIL·↳ SO_DISCOUNTS·Explore OE module →
-
View: OE_RA_CUSTOMERS_V 12.1.1
APPS.OE_RA_CUSTOMERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore ONT module →
-
View: SO_MANUAL_DISCOUNTS_V 12.2.2
APPS.SO_MANUAL_DISCOUNTS_V·↳ QP_PRICE_LIST_PVT·↳ QP_VIEW_UTIL·↳ SO_DISCOUNTS·Explore OE module →
-
View: OE_DISCOUNTS_V 12.1.1
Obsolete
APPS.OE_DISCOUNTS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →
-
View: AR_SITE_USES_V 12.2.2
(Release 11.5 Only)
APPS.AR_SITE_USES_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLES_TRX·↳ FND_COMMON_LOOKUPS·Explore AR module →
-
View: OPM_SITE_USES_ALL 12.1.1
OPM site uses view
-
Discounts for use in price adjustments
-
View: AST_CUST_SITE_USES_V 12.2.2
APPS.AST_CUST_SITE_USES_V·↳ HZ_CUST_SITE_USES_ALL·Explore AST module →
-
View: AST_CUST_SITE_USES_V 12.1.1
APPS.AST_CUST_SITE_USES_V·↳ HZ_CUST_SITE_USES_ALL·Explore AST module →
-
Business purpose of a customer address
-
APPS.WSH_CUSTOMER_LOCATIONS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore WSH module →
-
View: QP_LIST_HEADERS_V 12.1.1
This view gives details of all standard price lists setup in pricing.
APPS.QP_LIST_HEADERS_V·↳ QP_LIST_HEADERS_B·↳ QP_LIST_HEADERS_TL·Explore QP module →
-
View: AR_CUSTOMERS_ALL_V 12.2.2
(Release 11.5 Only)
APPS.AR_CUSTOMERS_ALL_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →
-
View: AR_CUSTOMERS_ACTIVE_V 12.2.2
(Release 11.5 Only)
APPS.AR_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →
-
Discounts for use in price adjustments
-
View: WMS_SHIP_TO_SITES_V 12.1.1
Customer Ship to Site
APPS.WMS_SHIP_TO_SITES_V·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_LOCATIONS·Explore WMS module →
-
View: OPM_SITE_USES_ALL 12.2.2
OPM site uses view
-
View: QP_LIST_ATTRIBUTES_V 12.2.2
View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns
APPS.QP_LIST_ATTRIBUTES_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
View: OE_ORDER_HEADERS_V 12.2.2
View for Order header used in sales order form.
APPS.OE_ORDER_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: AR_CUSTOMERS 12.2.2
(Release 11.5 Only)
APPS.AR_CUSTOMERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →
-
View: AR_CUSTOMERS 12.1.1
(Release 11.5 Only)
APPS.AR_CUSTOMERS·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →
-
View: AR_CUSTOMERS_ALL_V 12.1.1
(Release 11.5 Only)
APPS.AR_CUSTOMERS_ALL_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore AR module →
-
QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.