ASO — Order Capture
44 documented tables · 103 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
ASO_QUOTE_HEADERS_ALL |
This table holds header level Order Capture quotation data. | hub |
ASO_QUOTE_LINES_ALL |
ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line | hub-leaning |
ASO_QUOTE_STATUSES_B |
ASO_QUOTE_STATUSES_B stores the pre-defined and user-definable statuses for a quote header or a quote line. | hub-leaning |
ASO_SHIPMENTS |
ASO_SHIPMENTS store shipping information for a quote at header level or line level. | hub-leaning |
ASO_APR_RULES_B |
Obsolete, not used in 11i. | hub-leaning |
ASO_APR_RULE_GROUPS_B |
Obsolete, not used in 11i. | hub-leaning |
ASO_PRICE_ADJUSTMENTS |
Table to Store the Price Adjustments | satellite-leaning |
ASO_APR_APPROVAL_DET_B |
Obsolete, not used in 11i. | satellite-leaning |
ASO_APR_RULE_STEPS_B |
Obsolete, not used in 11i. | satellite-leaning |
ASO_APR_FUNCTION |
Obsolete, not used in 11i. | hub-leaning |
ASO_APR_OBJ_APPROVALS |
This table stores information about all instances of approvals for each approval object. | satellite-leaning |
ASO_APR_RULE_GRP_MEMBER |
Obsolete, not used in 11i. | satellite-leaning |
ASO_ER_QTE_LINES_FACT |
Granular aggregate information about quote lines for a given period. | satellite-leaning |
ASO_PARTY_RELATIONSHIPS |
ASO_PARTY_RELATIONSHIPS links one quote or a quote line to a party and records the type of relationship. | link |
ASO_ER_REFRESH_LOG |
Materialized view refresh history log table. | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
ASO_QUOTE_PUB |
PUB | 26 | 100 packages |
ASO_DEBUG_PUB |
PUB | 14 | 95 packages |
ASO_OPP_QTE_PUB |
PUB | 4 | 10 packages |
ASO_COPY_QUOTE_PUB |
PUB | 3 | 8 packages |
ASO_ORDER_FEEDBACK_PUB |
PUB | 4 | 5 packages |
ASO_CFG_PUB |
PUB | 6 | 5 packages |
ASO_APR_PUB |
PUB | 6 | 4 packages |
ASO_RLTSHIP_PUB |
PUB | 15 | 3 packages |
ASO_PA_APR_PUB |
PUB | 4 | 2 packages |
ASO_CREDIT_CHECK_PUB |
PUB | 1 | 1 packages |