eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AS_LOOKUPS

Object Details

Object Name:	AS_LOOKUPS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AS.AS_LOOKUPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

AS_LOOKUPS stores miscellaneous lookup values used throughout Oracle
Sales and Marketing. Each row includes a lookup type, a language-
independent code, a language-dependent description, a language-
dependent meaning, and effectivity dates.
.
The records in this table are the source for QuickCodes used
in Oracle Sales and Marketing. QuickCodes provide a list of valid
values available for many of the fields throughout Oracle Sales and
Marketing.
.
Each value in the LOOKUP_CODE column must be unique within the lookup
type to which it belongs. These codes are usually hidden from the user
both in the QuickCode pop-up windows and in the forms. The user will
usually see the value entered in the MEANING column. It is therefore
important when adding lookup codes, to make sure that the value
entered in the MEANING column is brief and meaningful. Another column,
DESCRIPTION is available for the user to enter a longer description of
the lookup code.
.
If the value in the column ENABLED_FLAG is 'N' (No), then this lookup
code will not be available for use. It will not be displayed when a
user uses a QuickCode to look at codes of the type to which it belongs
and if entered in the field, the user will be informed that it is not
a valid code. Similarly, if the system date is not between the start
and end date for the code, it will not be displayed or accepted as a
valid code.
.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOOKUP_TYPE	VARCHAR2	(30)	Yes	The lookup type for this lookup code
LOOKUP_CODE	VARCHAR2	(30)	Yes	A code for this lookup. Codes must be unique within a lookup type.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
CREATED_BY	NUMBER	(15)	Yes	Standard who column.
MEANING	VARCHAR2	(80)	Yes	A description of the meaning of the lookup code. This meaning will be displayed in QuickCode pop-up windows and on the screen when the lookup code is hidden from the user.
ENABLED_FLAG	VARCHAR2	(1)	Yes	A flag indicating if this lookup code is enabled
DESCRIPTION	VARCHAR2	(240)		A description, up to 240 characters, of the lookup code.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment

Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      MEANING
,      ENABLED_FLAG
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.AS_LOOKUPS;

Dependencies

[top of page]

APPS.AS_LOOKUPS references the following:

APPS: FND_LOOKUP_VALUES

APPS.AS_LOOKUPS is referenced by following:

APPS: AML_MONITOR_WF - show dependent code; AML_TIMEFRAME_PVT - show dependent code; AMS_DS_SALES_LEADS_V; AMS_LOOKUP_SALES_V; AST_CONTACT_CLASSIFICATION_V; AST_CONT_CLASSIFICATION_INT_V; AST_LM_LEADS_QUICK_CAMPAIGN_V; AST_LM_LEADS_QUICK_GROUP_V; AST_LM_LEADS_QUICK_INTEREST_V; AST_LM_LEADS_QUICK_INT_PC_V; AST_LM_LEADS_QUICK_V; AST_LS_SALES_LEADS_BSC_V; AST_LS_SALES_LEADS_CONTACT_V; AST_LS_SALES_LEADS_V; AST_MYTEAM_SALESLEAD_UWQ_V; AST_MYTEAM_SALESOPP_CODE_UWQ_V; AST_MYTEAM_SALESOPP_NAME_UWQ_V; AST_MYTEAM_SALESOPP_UWQ_V; AST_PLIST_OPP_UWQ_V; AST_SALESLEAD_UWQ_V; AST_SALESOPP_CODE_UWQ_V; AST_SALESOPP_NAME_UWQ_V; AST_SALESOPP_UWQ_V; AST_SALES_LEADS_BALI_V; AST_SALES_LEADS_EBC_V; AST_SALES_LEADS_REL_BALI_V; AST_SALES_LEADS_V; AST_SALES_LEAD_CONTACTS_V; AST_SALES_TEAM_EMP_V; AST_SALES_TEAM_PTR_V; AS_ACCESSES_ACTIVE_V; AS_ACCESS_TERRITORIES_SUM_V; AS_COMPETITOR_PROD_PVT - show dependent code; AS_CURRENT_ENVIRONMENT_V; AS_DECISION_FACTOR_PVT - show dependent code; AS_FOUNDATION_PVT - show dependent code; AS_IMPORT_SL_PVT - show dependent code; AS_INTERESTS_V; AS_INTEREST_PUB - show dependent code; AS_INTEREST_STATUSES_ACTIVE_V; AS_INTEREST_STATUSES_V; AS_LANGUAGES_ACTIVE_V; AS_OPPORTUNITY_DETAILS_V; AS_OPPORTUNITY_OBSTACLES_V; AS_OPP_CLASSIFICATION_V; AS_OPP_CONTACT_PVT - show dependent code; AS_OPP_HEADER_PVT - show dependent code; AS_OPP_OBSTACLE_PVT - show dependent code; AS_SALES_LEADS_PVT - show dependent code; AS_SALES_LEADS_V; AS_SALES_LEAD_CONTACTS_PVT - show dependent code; AS_SALES_LEAD_CONTACTS_V; AS_SALES_LEAD_REFERRAL - show dependent code; AS_SALES_OPP_UWQ_V; AS_SALES_TEAM_DISTINCT_V; AS_SALES_TEAM_EMP_V; AS_SALES_TEAM_PTR_V; AS_SALES_TEAM_V; AS_SC_DENORM - show dependent code; AS_SC_DENORM_TRG - show dependent code; AS_SITE_CLASSIFICATION_V; AS_TERRITORY_ACCESSES_V; AS_VALIDATE_SETUP - show dependent code; ICX_AS_EVENT_FACILITIES_V; PA_AS_PERSON_ROLES_V; PA_PROJ_REQUEST_DIRECTORY_V; PV_SQL_UTILITY - show dependent code