Search Results new_party_flag




Overview
Explore in AI Chat

Overview

APPS.AS_IMP_SL_V is a reporting and integration view in Oracle E-Business Suite (documented for 12.2.2, applicable to 12.1.1) used by the Sales Lead / Sales List import process within the Oracle Sales (AS) module. It exposes the staging contents of the sales lead import interface, presenting a flattened, query-ready projection of imported lead and contact data. The view is typically consumed to inspect, validate, or report on records that are pending or have completed import into the sales lead tables. Because the view exposes the NEW_PARTY_FLAG column — the term the user searched on — it is the recommended object for identifying whether an imported sales lead record references a newly created party versus an existing party already registered in the Trading Community Architecture (TCA) model. It is an APPS-owned view, meaning it is referenced through the standard APPS schema synonym layer used across EBS reporting, Discoverer workbooks, and custom concurrent programs.

Underlying Base Objects

Per the documented view metadata, AS_IMP_SL_V is defined over a single referenced base object: AS_IMPORT_INTERFACE (referenced through a synonym). AS_IMPORT_INTERFACE is the interface (staging) table populated by the sales lead import program before validation and transfer into the production lead, contact, and party tables. The view does not introduce additional joins documented in the metadata; it presents a selecting projection over that interface table, alongside ROWID for record identification. Consequently, the view is a filtered/projected representation of the staging rows rather than a consolidated multi-table join. This makes it a low-overhead access path for reviewing interface data before or after the import concurrent program executes.

Key Columns

The view exposes a broad set of columns spanning lead, contact, party, address, phone, and import-control attributes. Notable columns include:

Common Use Cases and Queries

Typical uses include verifying which staged leads will create new parties, diagnosing import errors, and reconciling batch loads. The NEW_PARTY_FLAG is frequently used to segment records for follow-up processing.

  • Identify records flagged for new party creation:
    SELECT IMPORT_INTERFACE_ID, LEAD_NUMBER, NEW_PARTY_FLAG, LOAD_STATUS
    FROM APPS.AS_IMP_SL_V
    WHERE NEW_PARTY_FLAG = 'Y';
  • Review failed or unprocessed interface rows within a batch:
    SELECT BATCH_ID, LEAD_NUMBER, LOAD_STATUS, LOAD_ERROR_MESSAGE
    FROM APPS.AS_IMP_SL_V
    WHERE LOAD_STATUS = 'ERROR';
  • Summarize new-entity creation across a load:
    SELECT NEW_PARTY_FLAG, NEW_CON_FLAG, COUNT(*)
    FROM APPS.AS_IMP_SL_V
    GROUP BY NEW_PARTY_FLAG, NEW_CON_FLAG;

Because the view is a projection over AS_IMPORT_INTERFACE, queries return staging data and reflect the current state of the interface table at query time, making it suitable for both pre-import validation and post-import auditing in 12.1.1 and 12.2.2 environments.