Search Results as_categories_all




Overview
Explore in AI Chat

Overview

The AS_CATEGORIES_ALL table is a core master data object within the Oracle E-Business Suite Sales Foundation (AS) module. It serves as the central repository for defining and storing collateral categories, which are classification structures used to organize marketing and sales collateral items. This table supports the multi-organization architecture of Oracle EBS, as indicated by the "_ALL" suffix, meaning it stores data for multiple operating units. Its primary role is to provide a controlled, reusable list of categories that can be assigned to various collateral assets, enabling systematic cataloging, retrieval, and management of sales materials across the enterprise.

Key Information Stored

While the provided metadata does not list specific columns, the structure is defined by its primary and foreign key relationships. The central column is CATEGORY_ID, which is the table's primary key and uniquely identifies each collateral category record. Based on standard Oracle EBS design patterns for category tables, other typical columns would include: a CATEGORY_NAME or DESCRIPTION for the textual name of the category; an ENABLED_FLAG to control active status; START_DATE_ACTIVE and END_DATE_ACTIVE for date-range control; and columns for creation and last update metadata (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). The presence of the "_ALL" suffix also implies the inclusion of an ORG_ID column to segregate data by operating unit.

Common Use Cases and Queries

This table is primarily accessed for setting up and maintaining the list of valid collateral categories within the Sales Foundation module. Common functional use cases include administrative tasks for defining new collateral types (e.g., "Brochures," "Whitepapers," "Case Studies") and generating reports on categorized collateral. A typical query to retrieve all active categories for a specific operating unit would be:

  • SELECT CATEGORY_ID, CATEGORY_NAME
  • FROM AS_CATEGORIES_ALL
  • WHERE ORG_ID = :p_org_id
  • AND ENABLED_FLAG = 'Y'
  • AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE);

Another frequent pattern is joining to the related collateral table to list all items within a specific category for reporting or data validation purposes.

Related Objects

The AS_CATEGORIES_ALL table has a direct and documented foreign key relationship with the AS_COLLATERAL_CAT_ALL table. This relationship is fundamental to the data model, linking the category definition to the specific collateral items classified under it.

  • AS_COLLATERAL_CAT_ALL: This table references AS_CATEGORIES_ALL via the foreign key column CATEGORY_ID. The join condition AS_COLLATERAL_CAT_ALL.CATEGORY_ID = AS_CATEGORIES_ALL.CATEGORY_ID is used to retrieve the category details for a given piece of collateral.

The primary key constraint AS_CATEGORIES_PK on the CATEGORY_ID column enforces the integrity of this relationship, ensuring that every category assigned to collateral exists in the master categories table.