Search Results hz_cust_site_uses_all
Here's a detailed description of the HZ_CUST_SITE_USES_ALL table in Oracle E-Business Suite:
Table Name: HZ_CUST_SITE_USES_ALL
Purpose: Stores customer site use information across different operating units
Key Columns:
1. SITE_USE_ID (Primary Key)
- Unique identifier for each customer site use
- Typically a sequenced number
2. SITE_USE_CODE
- Defines the purpose of the site use
- Common values:
- BILL_TO
- SHIP_TO
- SOLD_TO
- PAYING
3. CUST_ACCT_SITE_ID
- Foreign key linking to HZ_CUST_ACCT_SITES_ALL
- Identifies the specific customer site
4. ORGANIZATION_ID
- Operating unit identifier
- Allows tracking site uses across different business units
5. STATUS
- Current status of the site use
- Values like ACTIVE, INACTIVE
6. PRIMARY_FLAG
- Indicates if this is the primary site use for the customer
7. CREATION_DATE
- Timestamp of record creation
8. CREATED_BY
- User who created the record
Additional Attributes:
- Supports multiple site uses per customer
- Used in Order Management, Receivables, and Purchasing modules
- Allows for complex customer site configurations
Typical Use Cases:
- Defining billing and shipping addresses
- Managing customer site relationships
- Supporting multi-organization setups
-
Table: HZ_CUST_SITE_USES_ALL
12.2.2
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
-
Table: HZ_CUST_SITE_USES_ALL
12.1.1
owner:AR, object_type:TABLE, fnd_design_data:AR.HZ_CUST_SITE_USES_ALL, object_name:HZ_CUST_SITE_USES_ALL, status:VALID, product: AR - Receivables , description: Stores business purposes assigned to customer account sites. , implementation_dba_data: AR.HZ_CUST_SITE_USES_ALL ,
-
APPS.IBE_ATP_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.AR_RECEIPT_LIB_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_TPA_SELECTOR_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ARP_CMERGE_ARCUS dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_WSHRDPAK_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKL_QA_DATA_INTEGRITY dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.INV_MGD_MVT_SO_MDTR dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKL_ARINTF_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_PAYMENT_TRXN_UTIL dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.POA_EDW_TRD_PNTR_M_SIZE dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.RLM_FORECAST_SV dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_VALIDATE_LINE dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_TCM_CONTROL_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_PURCHASE_RELEASE_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKL_TXS_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_ITORD_UTIL dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OKS_TAX_UTIL_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSD_PROCESS_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSI_INTERFACE_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.FTE_LOCATION_PARAMETERS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_EXTERNAL_CREDIT_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.FUN_XML_REPORT_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_ITORD_PUB dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ONT_OEXOECCH_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSL_CSP_LOCATIONS_ACC_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.JA_JAINPLA_XMLP_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.INV_MGD_MVT_UTILS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_DSNO dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.ZX_VTX_USER_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_UPG_INSTALL_DETAILS dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.WSH_PROCESS_INTERFACED_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.1.1
-
APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.CSP_PART_SEARCH_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.JAI_AR_TRX_HEADERS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.WSH_OTM_OUTBOUND dependencies on HZ_CUST_SITE_USES_ALL
12.2.2
-
APPS.WSH_LOCATIONS_PKG dependencies on HZ_CUST_SITE_USES_ALL
12.2.2