Results for “cust_acct”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AR_TA_ESS_CREDIT_V is a Receivables module view in Oracle E-Business Suite 12.1.1 and 12.2.2 that consolidates customer credit information for use by the Territory Assignment (TA) engine and ESS-based credit processing. The view exposes organization, set of books, customer account, credit hold, and overall credit limit data in a single denormalized result set. In the ETRM documentation for 12.2.2 the object is listed without a documented owner and with no referenced base objects recorded, and the implementation notes state that it is not implemented in the reference database. Its role is therefore primarily definitional: it describes the shape of credit data expected by Receivables credit-checking and territory assignment logic rather than a physical table that DBAs tune directly.
Underlying Base Objects
Although no base objects are documented in the ETRM metadata, the view text reveals its construction. It is a UNION of two queries built over five tables:
- HZ_CUST_ACCOUNTS (aliased CUST_ACCT) — supplies the customer account number and joins on CUST_ACCOUNT_ID.
- HZ_CUSTOMER_PROFILES (aliased CP) — supplies CREDIT_HOLD and SITE_USE_ID; the view filters for account-level profiles where SITE_USE_ID IS NULL.
- HZ_CUST_PROFILE_AMTS (aliased CPA) — supplies the OVERALL_CREDIT_LIMIT amount at account level.
- GL_SETS_OF_BOOKS (aliased SOB) — provides the set of books and functional currency for matching profile amounts.
- AR_SYSTEM_PARAMETERS_ALL (aliased SP) — provides ORG_ID and SET_OF_BOOKS_ID to align the data with the operating unit.
The first branch of the UNION returns customers that have a matching profile amount row in the set of books currency. The second branch returns customers that exist at the account level but have no matching profile amount, using the SITE_USE_ID in place of a calculated limit and excluding combinations already returned by the first branch.
Key Columns
- ORG_ID — the operating unit identifier sourced from AR_SYSTEM_PARAMETERS_ALL, used for multi-org filtering.
- SET_OF_BOOKS_ID — the ledger/set of books associated with the operating unit.
- ACCOUNT_NUMBER / CUSTOMER_NUMBER — the customer account number from HZ_CUST_ACCOUNTS, matching the user search term "cust_acct".
- CREDIT_HOLD — the credit hold flag from HZ_CUSTOMER_PROFILES, indicating whether the account is on credit hold.
- OVERALL_CREDIT_LIMIT (CL) — derived via DECODE: where a profile amount exists it is divided by 1000; where it is NULL, CP.SITE_USE_ID is substituted.
Common Use Cases and Queries
The view is typically queried for credit exposure reporting and for validating the credit data consumed by Territory Assignment and ESS credit jobs. A representative query retrieves credit status for a single customer account:
- SELECT account_number, credit_hold, overall_credit_limit FROM ar_ta_ess_credit_v WHERE account_number = :cust_acct;
- SELECT org_id, set_of_books_id, account_number, credit_hold FROM ar_ta_ess_credit_v WHERE credit_hold = 'Y';
Because the definition is not implemented in the base database, references to AR_TA_ESS_CREDIT_V should be treated as documentation of the expected credit data interface rather than a guaranteed runtime object. In 12.1.1 and 12.2.2 environments where it is absent, equivalent logic must be reproduced from the underlying HZ and AR tables shown in the view text.
-
View: AR_TA_ESS_CREDIT_V 12.1.1
Not implemented in this database·Explore AR module →
-
View: AR_TA_ESS_CREDIT_V 12.2.2
Not implemented in this database·Explore AR module →
-
VIEW: APPS.FII_AR_REC_FCV 12.1.1
-
View: FII_AR_REC_FCV 12.1.1
FII_AR_REC_FCV is an internal view used to support Operations Indicators Portlet
APPS.FII_AR_REC_FCV·↳ AR_ADJUSTMENTS_ALL·↳ AR_DISTRIBUTIONS_ALL·↳ EDW_LOCAL_INSTANCE·Explore FII module →
-
View: FII_AR_REC_FCV 12.2.2
FII_AR_REC_FCV is an internal view used to support Operations Indicators Portlet
Not implemented in this database·Explore FII module →
-
VIEW: APPS.PA_CUSTOMERS_V 12.2.2
-
Lookup Type: REG_HOLD_DOMAIN 12.1.1
Registration Hold Domain
-
Lookup Type: REG_HOLD_DOMAIN 12.2.2
Registration Hold Domain
-
VIEW: APPS.PA_CUSTOMERS_V 12.1.1
-
VIEW: APPS.JAI_CUSTOMERS_V 12.2.2
-
VIEW: APPS.RLM_CUSTOMERS_V 12.1.1
-
View: OE_CUSTOMERS_ACTIVE_V 12.2.2
APPS.OE_CUSTOMERS_ACTIVE_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore ONT module →
-
View: PA_CUSTOMERS_V 12.1.1
10SC Only
APPS.PA_CUSTOMERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore PA module →
-
Customer and Vendor VAT/Tax Codes
APPS.AR_CUSTOMER_VENDOR_VAT_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ PO_VENDORS·Explore AR module →
-
Customer and Vendor VAT/Tax Codes
APPS.AR_CUSTOMER_VENDOR_VAT_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ PO_VENDORS·Explore AR module →
-
VIEW: APPS.RLM_CUSTOMERS_V 12.2.2
-
View: QA_CUSTOMERS_LOV_V 12.1.1
Customer collection element LOV validation view.
APPS.QA_CUSTOMERS_LOV_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·Explore QA module →
-
View: WSH_CUSTOMER_PHONE 12.2.2
APPS.WSH_CUSTOMER_PHONE·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ WSH_PRIMARY_CUSTOMER_PHONE_V·Explore WSH module →