AS — Sales Foundation
203 documented tables · 285 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
AS_LEADS_ALL |
Holds sales opportunities | hub-leaning |
AS_INTEREST_TYPES_B |
Define Interest types - base table | hub-leaning |
AS_PROMOTIONS_ALL |
Defines promotions | hub |
AS_INTEREST_CODES_B |
Define Interest code - Base table | hub-leaning |
AS_SALES_LEADS |
Holds sales leads | hub-leaning |
AS_FORECAST_PROB_ALL_B |
AS_FORECAST_PROB_ALL defines win probability values for sales | hub |
AS_IMPORT_INTERFACE |
staging table to hold data to be imported | hub-leaning |
AS_REF_DELIVERABLES |
No Longer Used | hub-leaning |
AS_STATUSES_B |
Hold three types of status, opportunity, lead and quote | hub |
AS_SALESFORCE |
Obsolete Defines the salesforce | satellite-leaning |
AS_TERRITORY_GROUPS_ALL |
Obsolete Defines territory groups | hub-leaning |
AS_EVENT_FACILITIES_ALL |
Contains event facilities | hub-leaning |
AS_LEAD_LINES_ALL |
Holds sales opportunity lines | satellite-leaning |
AS_SALES_STAGES_ALL_B |
Defines sales stages | hub |
AS_INTEREST_TYPES_ALL |
Defines interest types with multi-org flag columns | hub-leaning |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AS_UTILITY_PUB |
PUB | 1 | 60 packages |
AS_SALES_MEMBER_PUB |
PUB | 2 | 42 packages |
AS_ACCESS_PUB |
PUB | 16 | 37 packages |
AS_OPPORTUNITY_PUB |
PUB | 31 | 24 packages |
AS_SALES_LEADS_PUB |
PUB | 25 | 23 packages |
AS_INTEREST_PUB |
PUB | 5 | 6 packages |
AS_OSI_LEAD_PUB |
PUB | 12 | 2 packages |
AS_FOUNDATION_PUB |
PUB | 4 | 2 packages |
AS_SCORECARD_RULES_PUB |
PUB | 9 | 2 packages |
AS_SALES_LEAD_RANKS_PUB |
PUB | 3 | 2 packages |