Results for “draw_cust_global_attr9”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_DRAWEE_CUSTOMERS_H_V is a reporting view owned by the APPS schema in Oracle E-Business Suite Receivables (AR). It is documented as a "drawee customer header extract," meaning it denormalizes drawee-side customer information that is required for XLA (Subledger Accounting) event extraction and downstream reporting. The view is relevant to both Oracle EBS 12.1.1 and 12.2.2, where subledger accounting and the AR_XLA_LINES_EXTRACT mechanism are used to build accounting events for Receivables transactions such as bills receivable, remittances, and other instruments involving a drawee party. Its columns are exposed with the DRAW_CUST_ prefix, distinguishing them from the drawer-side customer fields in companion views. The view carries a VALID status and is intended for read-only access; customers typically use it as a query source for custom reports, extracts, and reconciliation of drawee customer header details against XLA extraction data.

The view is particularly relevant to searches involving "sic_code_type," because the column P2.SIC_CODE_TYPE is projected as DRAW_CUST_PROVINCE in the documented view text — a notable naming quirk where the underlying HZ_PARTIES SIC code type is aliased as a province-style attribute. This deserves scrutiny in any query or report relying on the SIC_CODE_TYPE source attribute.

Underlying Base Objects

The view is defined over three documented referenced objects, all presented in the ETRM metadata as synonyms:

• AR_XLA_LINES_EXTRACT — the XLA extraction staging table. The view filters this table on LEVEL_FLAG = 'H' (header level) and joins its DRAWEE_CUSTOMER_ID to HZ_CUST_ACCOUNTS. The projection includes HE.EVENT_ID, tying every row to a specific XLA accounting event.
• HZ_CUST_ACCOUNTS (aliased CA2) — provides the customer account context: ACCOUNT_NUMBER, CUSTOMER_TYPE, CUST_ACCOUNT_ID, NPA_NUMBER, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE12, and GLOBAL_ATTRIBUTE_CATEGORY.
• HZ_PARTIES (aliased P2) — provides party-level attributes: CATEGORY_CODE, CITY, COUNTRY, COUNTY, GROUP_TYPE, GSA_INDICATOR_FLAG, JGZZ_FISCAL_CODE, KNOWN_AS, PARTY_ID, PARTY_NAME, PARTY_NUMBER, PARTY_TYPE, POSTAL_CODE, SIC_CODE_TYPE, STATE, and TAX_REFERENCE.

The join is HZ_CUST_ACCOUNTS.CUST_ACCOUNT_ID = AR_XLA_LINES_EXTRACT.DRAWEE_CUSTOMER_ID and HZ_CUST_ACCOUNTS.PARTY_ID = HZ_PARTIES.PARTY_ID. A hint (INDEX(HE AR_XLA_LINES_EXTRACT_N1)) drives access to the XLA lines extract table, reflecting that this view is optimized for event-driven extraction rather than general customer master browsing.

Key Columns

• EVENT_ID — the XLA accounting event identifier linking the drawee customer header to subledger journals.
• DRAW_CUST_ACCOUNT_ID / DRAW_CUST_ACCOUNT_NUMBER — the drawee customer account identifier and number.
• DRAW_CUST_PARTY_ID / DRAW_CUST_PARTY_NAME / DRAW_CUST_PARTY_NUMBER / DRAW_CUST_PARTY_TYPE — party identity attributes of the drawee.
• DRAW_CUST_PROVINCE — documented as sourced from HZ_PARTIES.SIC_CODE_TYPE, an important mapping note for any SIC_CODE_TYPE-related inquiry.
• DRAW_CUST_STATE, DRAW_CUST_CITY, DRAW_CUST_COUNTRY, DRAW_CUST_COUNTY, DRAW_CUST_POSTAL_CODE — geographic attributes.
• DRAW_CUST_GSA_FLAG, DRAW_CUST_FISCAL_CODE, DRAW_CUST_TAX_REFERENCE, DRAW_CUST_CAT_CODE, DRAW_CUST_GROUP_TYPE, DRAW_CUST_ALTERNATE_NAME — regulatory, classification, and identification attributes.
• DRAW_CUST_GLOBAL_ATTR1, DRAW_CUST_GLOBAL_ATTR9, DRAW_CUST_GLOBAL_ATTR10, DRAW_CUST_GLOBAL_ATTR12, DRAW_CUST_GLOBAL_ATTR_CAT — descriptive flexfield context and segment values.

Common Use Cases and Queries

Typical uses include reconciling drawee header data against XLA event extracts, building custom reports on drawee parties for bills receivable or remittance processing, and cross-validating customer account attributes exposed through DRAW_CUST_GLOBAL_ATTRn. The following query retrieves drawee header details for a specific accounting event:

SELECT EVENT_ID,
       DRAW_CUST_ACCOUNT_NUMBER,
       DRAW_CUST_PARTY_NAME,
       DRAW_CUST_SIC_CODE_TYPE_PLACEHOLDER
FROM   APPS.AR_DRAWEE_CUSTOMERS_H_V
WHERE  EVENT_ID = :p_event_id;

Because the extracted view text aliases SIC_CODE_TYPE as DRAW_CUST_PROVINCE, users investigating "sic_code_type" should query DRAW_CUST_PROVINCE and treat the value as the SIC code type, not a geographic province. A representative SIC-type extract query is:

SELECT EVENT_ID,
       DRAW_CUST_PARTY_NAME,
       DRAW_CUST_PROVINCE SIC_CODE_TYPE
FROM   APPS.AR_DRAWEE_CUSTOMERS_H_V
WHERE  DRAW_CUST_PARTY_NUMBER = :p_party_number;

These queries should always be filtered by EVENT_ID or by drawee customer identifiers to limit read cost against the underlying AR_XLA_LINES_EXTRACT table.