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


VIEW: APPS.AMS_LOOKUPS

Object Details
Object Name: AMS_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_LOOKUPS
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

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes QuickCode lookup type
LOOKUP_CODE VARCHAR2 (30) Yes QuickCode code
MEANING VARCHAR2 (80) Yes Quickcode meaning
DESCRIPTION VARCHAR2 (240)
Quickcode description
ENABLED_FLAG VARCHAR2 (1) Yes Enabled flag
START_DATE_ACTIVE DATE

The date when the QuickCode becomes active
END_DATE_ACTIVE DATE

The date when the QuickCode becomes inactive
TAG VARCHAR2 (150)
Optional additional category for lookup values
Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      MEANING
,      DESCRIPTION
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      TAG
FROM APPS.AMS_LOOKUPS;

Dependencies

[top of page]

APPS.AMS_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.AMS_LOOKUPS is referenced by following:

SchemaAPPS
Package BodyAMS_ACTMETRICS_ENGINE_PVT - show dependent code
Package BodyAMS_ACTMETRIC_PVT - show dependent code
ViewAMS_ACT_ATTACHMENTS_V
ViewAMS_ACT_CAMPAIGNS_V
ViewAMS_ACT_DELIVERABLES_V
ViewAMS_ACT_DELIVERY_METHODS_V
Package BodyAMS_ACT_MESSAGES_PVT - show dependent code
ViewAMS_ACT_PRODUCTS_V
ViewAMS_ACT_RESOURCES_V
ViewAMS_APPROVAL_DETAILS_V
ViewAMS_CAMPAIGN_FORECASTS_ALL_V
ViewAMS_CAMPAIGN_TEAM_V
ViewAMS_CHANNELS_VL
ViewAMS_CUSTOM_SETUP_SCR_V
Package BodyAMS_DCF_LEADS_TITLE - show dependent code
Package BodyAMS_DCF_TITLE - show dependent code
ViewAMS_DM_SCORE_HISTORY_V
ViewAMS_EVENT_HEADERS_V
ViewAMS_EVENT_OFFERS_ONLY_V
ViewAMS_EVENT_OFFERS_OV_V
ViewAMS_EVENT_OFFERS_REG_V
ViewAMS_EVENT_OFFERS_V
ViewAMS_EVENT_REGISTRATIONS_V
Package BodyAMS_LISTIMPORT_PVT - show dependent code
Package BodyAMS_LISTSOURCETYPE_PVT - show dependent code
Package BodyAMS_LIST_PURGE_PVT - show dependent code
Package BodyAMS_LIST_SRC_TYPES_PKG - show dependent code
ViewAMS_MEDIA_VL
ViewAMS_MESSAGES_V
ViewAMS_METRICS_INFO_V
Package BodyAMS_METRIC_FORMULA_PVT - show dependent code
Package BodyAMS_METRIC_PVT - show dependent code
Package BodyAMS_METRIC_TEMPLATE_PVT - show dependent code
Package BodyAMS_MET_TPL_ASSOC_PVT - show dependent code
ViewAMS_P_ACT_ATTACHMENTS_V
ViewAMS_P_CAMPAIGN_SCHEDS_V
ViewAMS_P_LIST_HEADERS_V
ViewAMS_P_METRICS_V
ViewAMS_P_OSO_SOURCE_CODES_V
Package BodyAMS_SCHEDULERULES_PVT - show dependent code
Package BodyAMS_SETUP_ATTR_PVT - show dependent code
Package BodyAMS_SOURCECODE_PVT - show dependent code
Package BodyAMS_STATUS_PVT - show dependent code
ViewAMS_TASKS_V
ViewAMS_USER_STATUSES_V
Package BodyAMS_UTILITY_PVT - show dependent code
Package BodyAMS_UWQ_LIST_ENUM_PVT - show dependent code
Package BodyAMS_WFCMPAPR_PVT - show dependent code
Package BodyAMS_WFTRIG_PVT - show dependent code
ViewASO_I_MKTG_SRC_CODES_V
ViewAST_EVENT_ENROLLEES_V
ViewAST_EVENT_HISTORY_V
ViewAST_EV_HIS_ORG_V
ViewAST_EV_HIS_PER_V
ViewAST_LM_EVENTS_SRC_V
ViewAST_LM_EVENTS_V
ViewAST_LM_ORG_EXP_V
ViewAST_LS_CAMPAIGNS_V
ViewAST_SOURCE_CODES_LOV_V
ViewAST_TARGET_CAMPAIGNS_V
ViewBIM_DIMV_CHANNELS
ViewBIM_DIMV_EVENT_HIER
ViewBIM_DIMV_EVENT_TYPES
ViewBIM_DIMV_MEDIA
ViewBIM_DIMV_MEDIA_CHANNELS
Materialized ViewBIM_I_OBJ_NAME_MV
Package BodyBIM_RESPONSE_IMPORT_PUB - show dependent code
ViewIEC_LIST_STATUSES_V
ViewIEX_LM_ORG_EXP_V
Package BodyIGR_IMP_003 - show dependent code
ViewIGR_I_APPL_V
Package BodyOZF_ACTMETRIC_PVT - show dependent code