[Home] [Help]
[Dependency Information]
VIEW: APPS.AMS_LOOKUPS
Object Details
Object Name: | AMS_LOOKUPS |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.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:
-
APPS
-
FND_LOOKUP_VALUES
APPS.AMS_LOOKUPS is referenced by following:
-
APPS
-
AMS_ACTMETRICS_ENGINE_PVT
- show dependent code
-
AMS_ACTMETRIC_PVT
- show dependent code
-
AMS_ACT_ATTACHMENTS_V
-
AMS_ACT_CAMPAIGNS_V
-
AMS_ACT_DELIVERABLES_V
-
AMS_ACT_DELIVERY_METHODS_V
-
AMS_ACT_MESSAGES_PVT
- show dependent code
-
AMS_ACT_PRODUCTS_V
-
AMS_ACT_RESOURCES_V
-
AMS_APPROVAL_DETAILS_V
-
AMS_CAMPAIGN_FORECASTS_ALL_V
-
AMS_CAMPAIGN_TEAM_V
-
AMS_CHANNELS_VL
-
AMS_CUSTOM_SETUP_SCR_V
-
AMS_DCF_LEADS_TITLE
- show dependent code
-
AMS_DCF_TITLE
- show dependent code
-
AMS_DM_SCORE_HISTORY_V
-
AMS_EVENT_HEADERS_V
-
AMS_EVENT_OFFERS_ONLY_V
-
AMS_EVENT_OFFERS_OV_V
-
AMS_EVENT_OFFERS_REG_V
-
AMS_EVENT_OFFERS_V
-
AMS_EVENT_REGISTRATIONS_V
-
AMS_LISTIMPORT_PVT
- show dependent code
-
AMS_LISTSOURCETYPE_PVT
- show dependent code
-
AMS_LIST_PURGE_PVT
- show dependent code
-
AMS_LIST_SRC_TYPES_PKG
- show dependent code
-
AMS_MEDIA_VL
-
AMS_MESSAGES_V
-
AMS_METRICS_INFO_V
-
AMS_METRIC_FORMULA_PVT
- show dependent code
-
AMS_METRIC_PVT
- show dependent code
-
AMS_METRIC_TEMPLATE_PVT
- show dependent code
-
AMS_MET_TPL_ASSOC_PVT
- show dependent code
-
AMS_P_ACT_ATTACHMENTS_V
-
AMS_P_CAMPAIGN_SCHEDS_V
-
AMS_P_LIST_HEADERS_V
-
AMS_P_METRICS_V
-
AMS_P_OSO_SOURCE_CODES_V
-
AMS_SCHEDULERULES_PVT
- show dependent code
-
AMS_SETUP_ATTR_PVT
- show dependent code
-
AMS_SOURCECODE_PVT
- show dependent code
-
AMS_STATUS_PVT
- show dependent code
-
AMS_TASKS_V
-
AMS_USER_STATUSES_V
-
AMS_UTILITY_PVT
- show dependent code
-
AMS_UWQ_LIST_ENUM_PVT
- show dependent code
-
AMS_WFCMPAPR_PVT
- show dependent code
-
AMS_WFTRIG_PVT
- show dependent code
-
ASO_I_MKTG_SRC_CODES_V
-
AST_EVENT_ENROLLEES_V
-
AST_EVENT_HISTORY_V
-
AST_EV_HIS_ORG_V
-
AST_EV_HIS_PER_V
-
AST_LM_EVENTS_SRC_V
-
AST_LM_EVENTS_V
-
AST_LM_ORG_EXP_V
-
AST_LS_CAMPAIGNS_V
-
AST_SOURCE_CODES_LOV_V
-
AST_TARGET_CAMPAIGNS_V
-
BIM_DIMV_CHANNELS
-
BIM_DIMV_EVENT_HIER
-
BIM_DIMV_EVENT_TYPES
-
BIM_DIMV_MEDIA
-
BIM_DIMV_MEDIA_CHANNELS
-
BIM_I_OBJ_NAME_MV
-
BIM_RESPONSE_IMPORT_PUB
- show dependent code
-
IEC_LIST_STATUSES_V
-
IEX_LM_ORG_EXP_V
-
IGR_IMP_003
- show dependent code
-
IGR_I_APPL_V
-
OZF_ACTMETRIC_PVT
- show dependent code