DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AS_SALES_LEAD_QUALS_VL

Object Details
Object Name: AS_SALES_LEAD_QUALS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAS.AS_SALES_LEAD_QUALS_VL
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

MultiLingual view (a language resolved view of the data.)


AS_SALES_LEAD_QUALS_VL is a view of
AS_SALES_LEAD_QUALS_B and
AS_SALES_LEAD_QUALS_TL with MLS
columns (i.e.MEANING, DESCRIPTION)


[View Source]

Columns
Name Datatype Length Mandatory Comments
SEED_QUAL_ID NUMBER
Yes Unique identifier for Qualified Col
CREATION_DATE DATE
Yes Creation Date
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Last Updated By
CREATED_BY NUMBER
Yes Created By
LAST_UPDATE_LOGIN NUMBER

Last Update Login
ENABLED_FLAG VARCHAR2 (1) Yes Enabled Flag
LOV_SQL VARCHAR2 (2000) Yes Sql Statement
DESCRIPTION VARCHAR2 (240)
Description
RANGE_FLAG VARCHAR2 (1) Yes Range Flag
DATA_TYPE VARCHAR2 (10) Yes Data Type
MEANING VARCHAR2 (60) Yes Meaning
SOURCE_TABLE_NAME VARCHAR2 (30)
SOURCE_COLUMN_NAME VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEED_QUAL_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ENABLED_FLAG
,      LOV_SQL
,      DESCRIPTION
,      RANGE_FLAG
,      DATA_TYPE
,      MEANING
,      SOURCE_TABLE_NAME
,      SOURCE_COLUMN_NAME
FROM APPS.AS_SALES_LEAD_QUALS_VL;

Dependencies

[top of page]

APPS.AS_SALES_LEAD_QUALS_VL references the following:

SchemaAPPS
SynonymAS_SALES_LEAD_QUALS_B
SynonymAS_SALES_LEAD_QUALS_TL
APPS.AS_SALES_LEAD_QUALS_VL is referenced by following:

SchemaAPPS
Package BodyAS_SCORECARD_RULES_PVT - show dependent code