Results for “as_script_ans_act_ee_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AS_SCRIPT_ANS_ACT_EE_V is a reporting view in the Oracle E-Business Suite Sales Foundation (AS) module, documented under the ETRM 12.2.2 repository as "Event answer actions view." It presents a filtered, denormalized projection of scripted answer actions associated with event-based promotions, joining promotion records to their originating event facilities so that event geography and scheduling context are available alongside the answer action definition. The view is restricted to answer actions whose type code equals 'EE', i.e., those tied to an event, which prevents generic (non-event) answer actions from appearing in the result set. Its principal role is to support reporting, inquiry, and downstream integration logic that must reconcile scripted question responses with the promotional events they influence. ETRM records the object as not implemented in the sampled database, meaning the definition is documented from the data dictionary but the compiled object was not present in that environment; deployments should verify existence before depending on it.

Underlying Base Objects

The documented view text is defined over three Sales Foundation base tables:

• AS_SCRIPT_ANSWER_ACTIONS — the primary table (aliased AA), holding the script answer action rows, their type, predefined answer reference, and promotion linkage.
• AS_PROMOTIONS — the promotion master (aliased P), supplying the promotion code, description, event start date, and the event facility foreign key.
• AS_EVENT_FACILITIES — the event facility master (aliased EF), supplying city information for the event venue.

Joins are equi-joins on P.PROMOTION_ID = AA.PROMOTION_ID and EF.EVENT_FACILITY_ID = P.EVENT_FACILITY_ID, combined with the static predicate AA.TYPE = 'EE'. ETRM lists no other referenced base objects, and the view exposes the underlying ROWID of AS_SCRIPT_ANSWER_ACTIONS, which supports diagnostics and row-level identification of the driving table.

Key Columns

• ROW_ID — ROWID of the AS_SCRIPT_ANSWER_ACTIONS row; useful for uniqueness checks and DBA troubleshooting.
• SCRIPT_ANSWER_ACTION_ID — primary key of the answer action record.
• PRE_DEF_ANSWER_ID — identifier of the predefined scripted answer that triggers the action.
• PROMOTION_ID — foreign key to the associated event promotion.
• EVENT_CODE / DESCRIPTION — promotion code and description sourced from AS_PROMOTIONS.
• EVENT_CITY — city of the event facility from AS_EVENT_FACILITIES.
• EVENT_DATE — promotion event start date.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, inherited from AS_SCRIPT_ANSWER_ACTIONS.

Common Use Cases and Queries

Typical uses include auditing which promotions carry event-type answer actions, verifying that scripted answers map to scheduled events, and feeding downstream event or trade-promotion analytics. A representative query:

• SELECT SCRIPT_ANSWER_ACTION_ID, PROMOTION_ID, EVENT_CODE, DESCRIPTION, EVENT_CITY, EVENT_DATE FROM AS_SCRIPT_ANS_ACT_EE_V WHERE EVENT_DATE >= SYSDATE ORDER BY EVENT_DATE;
• SELECT EVENT_CODE, COUNT(*) FROM AS_SCRIPT_ANS_ACT_EE_V GROUP BY EVENT_CODE;

Because the view enforces the 'EE' type predicate internally, consumers need not filter on type; they should instead confirm the object exists and that the AS promotions and event facilities are populated.