Search Results forecasted_complete_date

Overview

AST_CAMP_DELV_ASSOCIATIONS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AST (TeleSales) product family. Its documented status is VALID. The view exposes the association between campaign source codes and deliverables, joining the source-code registry to the deliverable master so that downstream reports, concurrent programs, and integration interfaces can resolve deliverable-level attributes — including financial and cost fields — without navigating the underlying AMS association model directly. It is frequently reached when users investigate budget, cost, and chargeback-related metrics, since the CHARGEBACK_AMOUNT and CHARGEBACK_AMOUNT_CURR_CODE columns are surfaced here. The view is applicable to both 12.1.1 and 12.2.2 environments.

Underlying Base Objects

The documented base objects referenced by the view definition are:

• AMS_DELIVERABLES_VL (VIEW) — the multi-language deliverable master, aliased as B.
• AMS_OBJECT_ASSOCIATIONS (SYNONYM) — the association table linking master and using objects, aliased as C.
• AMS_SOURCE_CODES (SYNONYM) — the source-code registry, aliased as A.

The join logic is: C.MASTER_OBJECT_ID = A.SOURCE_CODE_FOR_ID AND C.USING_OBJECT_TYPE = 'DELV' AND C.USING_OBJECT_ID = B.DELIVERABLE_ID. This restricts the result set to associations whose using object is a deliverable, tying each source code to its associated deliverable record.

Key Columns

• SOURCE_CODE / SOURCE_CODE_ID — source-code identifier and its surrogate key.
• DELIVERABLE_ID, DELIVERABLE_NAME, DELIVERABLE_CODE, DESCRIPTION — deliverable identity and descriptive attributes.
• CHARGEBACK_AMOUNT, CHARGEBACK_AMOUNT_CURR_CODE, CHARGEBACK_UOM — chargeback value, its currency, and its unit of measure.
• BUDGET_AMOUNT_TC, BUDGET_AMOUNT_FC, TRANSACTION_CURRENCY_CODE, FUNCTIONAL_CURRENCY_CODE — budget amounts and currency context.
• FORECASTED_COST, ACTUAL_COST — cost tracking fields.
• FORECASTED_RESPONSES, ACTUAL_RESPONSES — response/response-rate metrics.
• ACTIVE_FLAG, PRIVATE_FLAG, KIT_FLAG, INVENTORY_FLAG, STATUS_CODE, STATUS_DATE, OWNER_USER_ID — lifecycle and control attributes.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — flexfield supporting columns for extensibility.

Common Use Cases and Queries

A typical driver for querying this view is a search on chargeback_amount, used to reconcile chargeback values against associated campaign source codes and deliverables:

• Chargeback reconciliation:

SELECT source_code, deliverable_name, chargeback_amount, chargeback_amount_curr_code FROM apps.ast_camp_delv_associations_v WHERE chargeback_amount IS NOT NULL ORDER BY chargeback_amount DESC;

• Budget vs. cost analysis by deliverable:

SELECT deliverable_name, budget_amount_tc, forecasted_cost, actual_cost FROM apps.ast_camp_delv_associations_v WHERE active_flag = 'Y';

• Source-code to deliverable mapping for integration extracts: select the identity and control columns (source code, deliverable id, status) for feeding downstream interfaces or BI reports, filtering by status and date range.

Because the view is read-only and joins the multi-language deliverable view, it respects the session language for descriptive columns. Filtering by ACTIVE_FLAG and relevant date columns is recommended to limit result volume in large campaign datasets.