AST — TeleSales
10 documented tables · 219 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
AST_ASSISTS |
Available directory assistances | hub-leaning |
AST_WEB_ASSISTS |
Available web directory assistance | standalone |
AST_CGI_SWITCHES |
Metadata for query string switches | standalone |
AST_QUERY_STRINGS |
CGI query string for a site | standalone |
AST_RS_CAMPAIGNS |
Used for assigning Campaigns to Resources | link |
AST_WEB_SEARCHES |
All available web searches | standalone |
AST_PHONE_ASSISTS |
Available phone directory assistance | satellite-leaning |
AST_GRP_CAMPAIGNS |
This table stores the information for the mapping of resource groups to campaigns | link |
AST_SWITCH_DATA |
Metadata for all data on a CGI switch | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
AST_DEBUG_PUB |
PUB | 3 | 6 packages |
AST_ROUTING_PUB |
PUB | 4 | 4 packages |
AST_RS_CAMP_PUB |
PUB | 4 | 1 packages |
AST_GRP_CAMP_PUB |
PUB | 4 | 1 packages |
AST_PARTY_LOCATIONS_V2PUB |
PUB | 2 | 0 packages |