[Home] [Help]
[Dependency Information]
VIEW: APPS.OE_LOOKUPS
Object Details
Object Name: | OE_LOOKUPS |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ONT.OE_LOOKUPS
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
OE_LOOKUPS stores information about the QuickCode values for Order Management.
[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) |
|
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 |
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
FROM APPS.OE_LOOKUPS;
Dependencies
[top of page]
APPS.OE_LOOKUPS references the following:
-
APPS
-
FND_LOOKUP_VALUES
APPS.OE_LOOKUPS is referenced by following:
-
APPS
-
AML_LEAD_PROCESSING_STAGES_V
-
ASO_ATP_INT
- show dependent code
-
ASO_DEF_UTIL
- show dependent code
-
ASO_I_CREDIT_CARDS_V
-
ASO_I_INVOICES_V
-
ASO_I_RETURN_TYPES_V
-
ASO_I_SALES_CHANNELS_V
-
ASO_I_SERVICE_TYPES_V
-
ASO_ORDER_INT
- show dependent code
-
ASO_VALIDATE_PVT
- show dependent code
-
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_LM_OPP_EXPANDED_V
-
AST_LM_OPP_EXP_CR_TYPE_V
-
AST_LM_OPP_QUICK_CAMP_V
-
AST_LM_OPP_QUICK_INTTYPES_V
-
AST_LM_OPP_QUICK_RESULTS_V
-
AST_LM_OPP_QUICK_SGRP_V
-
AST_LM_OPP_QUICK_SREP_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_OPPORTUNITIES_BALI_V
-
AST_OPPORTUNITY_CONTACT_V
-
AST_OPPORTUNITY_DET_V
-
AST_OPPORTUNITY_LOGS_V
-
AST_OPPORTUNITY_LOG_V
-
AST_ORDER_HEADERS_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
-
AS_OPPORTUNITY_DETAILS_V
-
AS_OPPORTUNITY_VUHK
- show dependent code
-
AS_OPP_HEADER_PVT
- show dependent code
-
AS_SALES_LEAD_OPP_PVT
- show dependent code
-
BIL_DIMV_SLS_CHANNELS
-
BIM_DIMV_SALES_CHANNELS
-
CSC_ORDER_HEADERS_V
-
CSD_LOGISTICS_UTIL
- show dependent code
-
CSP_EOO_CANCEL_RECOMM_V
-
CS_CHARGE_DETAILS_PVT
- show dependent code
-
ECEPOI
- show dependent code
-
HZ_ACCOUNT_VALIDATE_V2PUB
- show dependent code
-
IBE_ORDER_DETAIL_V
-
IBE_ORDER_HEADER_ADV_V
-
IBE_ORDER_HEADER_V
-
IBE_ORDER_ITEMS_ADV_V
-
IBE_ORDER_LINE_DTL_V
-
IBE_ORDER_SUM_V
-
IBE_RETURN_DETAIL_V
-
IBE_RETURN_SUM_V
-
IBE_SHIP_DETAIL_V
-
IBE_SHIP_DLVY_V
-
INVPVDR4
- show dependent code
-
INV_MEANING_SEL
- show dependent code
-
JTM_OE_ORDER_LINES_ALL_V
-
MSC_X_VMI_POREQ
- show dependent code
-
OE_ACKNOWLEDGMENT_PUB
- show dependent code
-
OE_AK_DEFAULT_FULFILMENT_SET_V
-
OE_AK_DEFAULT_LINE_SET_V
-
OE_AK_DEMAND_CLASS_V
-
OE_AK_FOB_POINT_V
-
OE_AK_FREIGHT_TERMS_V
-
OE_AK_IB_CURR_LOC_V
-
OE_AK_IB_INSTALL_LOC_V
-
OE_AK_IB_OWNER_V
-
OE_AK_ITEM_IDENTIFIER_TYPE_V
-
OE_AK_ORDER_CATEGORY_V
-
OE_AK_ORDER_DATE_TYPE_V
-
OE_AK_PRIMARY_UOM_V
-
OE_AK_SALES_CHANNEL_V
-
OE_AK_SHIP_PRIORITIES_V
-
OE_AK_SOURCE_TYPE_V
-
OE_AK_TAX_POINT_V
-
OE_AK_TRXN_PHASE_V
-
OE_AK_T_EXEMPT_REASON_V
-
OE_APPROVALS_WF
- show dependent code
-
OE_AS_ORDER_HEADERS_V
-
OE_AUDIT_ATTR_DESC_V
-
OE_AUDIT_HISTORY_PVT
- show dependent code
-
OE_BLANKET_FORM_CONTROL
- show dependent code
-
OE_BLANKET_HDRS_HIST_V
-
OE_BLANKET_HEADERS_V
-
OE_BLANKET_LINES_HIST_V
-
OE_BLANKET_LINES_V
-
OE_BLKTPRT_LINES_V
-
OE_BLKT_HEADERS_HIST_V
-
OE_BLKT_LINES_HIST_V
-
OE_BULK_ACK_PVT
- show dependent code
-
OE_BULK_CACHE
- show dependent code
-
OE_BULK_PROCESS_HEADER
- show dependent code
-
OE_BULK_VALIDATE
- show dependent code
-
OE_BULK_VALUE_TO_ID
- show dependent code
-
OE_CNCL_VALIDATE
- show dependent code
-
OE_CNCL_VALUE_TO_ID
- show dependent code
-
OE_CREDIT_CHECK_RPT
- show dependent code
-
OE_CREDIT_CHECK_UTIL
- show dependent code
-
OE_CUSTACCEPTREP_PVT
- show dependent code
-
OE_DROP_SHIP_GRP
- show dependent code
-
OE_DROP_SHIP_LINKS_V
-
OE_ERROR_WF
- show dependent code
-
OE_EXT_CREDIT_EXPOSURE_PVT
- show dependent code
-
OE_FRGHT_TERMS_ACTIVE_V
-
OE_HEADER_ADJ_UTIL
- show dependent code
-
OE_HOLDS_PVT
- show dependent code
-
OE_HOLD_SOURCES_PVT
- show dependent code
-
OE_ID_TO_VALUE
- show dependent code
-
OE_ITORD_PUB
- show dependent code
-
OE_ITORD_UTIL
- show dependent code
-
OE_LINE_ADJ_UTIL
- show dependent code
-
OE_OE_FORM_HEADER
- show dependent code
-
OE_OE_FORM_LINE
- show dependent code
-
OE_OE_HTML_HEADER
- show dependent code
-
OE_OE_PRICING_AVAILABILITY
- show dependent code
-
OE_ORDER_HEADERS_HIST_V
-
OE_ORDER_WF_UTIL
- show dependent code
-
OE_PARAMETERS_DEF_UTIL
- show dependent code
-
OE_PRICE_ORDER_PVT
- show dependent code
-
OE_RMA_GRP
- show dependent code
-
OE_SCH_ORDER_LINES_V
-
OE_SCH_RSV_SET_LINES_V
-
OE_TRANSACTION_TYPES_V
-
OE_VALIDATE
- show dependent code
-
OE_VALIDATE_ADJ
- show dependent code
-
OE_VALIDATE_LINE
- show dependent code
-
OE_VALUE_TO_ID
- show dependent code
-
OE_VERSION_BLANKET_COMP
- show dependent code
-
OE_VERSION_COMP
- show dependent code
-
OKC_REP_SEARCH_UTIL_PVT
- show dependent code
-
ONT_DEF_UTIL
- show dependent code
-
ONT_OEXAUCRC_XMLP_PKG
- show dependent code
-
ONT_OEXCEXP_XMLP_PKG
- show dependent code
-
ONT_OEXCRDIS_XMLP_PKG
- show dependent code
-
ONT_OEXIODIS_XMLP_PKG
- show dependent code
-
ONT_OEXOEACK_XMLP_PKG
- show dependent code
-
ONT_OEXOECCH_XMLP_PKG
- show dependent code
-
ONT_OEXOECCL_XMLP_PKG
- show dependent code
-
ONT_OEXOECOD_XMLP_PKG
- show dependent code
-
ONT_OEXOEIOD_XMLP_PKG
- show dependent code
-
ONT_OEXOEITR_XMLP_PKG
- show dependent code
-
ONT_OEXOEOCR_XMLP_PKG
- show dependent code
-
ONT_OEXOEOCS_XMLP_PKG
- show dependent code
-
ONT_OEXOEORD_XMLP_PKG
- show dependent code
-
ONT_OEXOEORR_XMLP_PKG
- show dependent code
-
ONT_OEXOEORS_XMLP_PKG
- show dependent code
-
ONT_OEXOEOSR_XMLP_PKG
- show dependent code
-
ONT_OEXOEPCL_XMLP_PKG
- show dependent code
-
ONT_OEXOESOS_XMLP_PKG
- show dependent code
-
ONT_OEXOEUBD_XMLP_PKG
- show dependent code
-
ONT_OEXOEUBK_XMLP_PKG
- show dependent code
-
ONT_OEXOHHSA_XMLP_PKG
- show dependent code
-
ONT_OEXOHOHS_XMLP_PKG
- show dependent code
-
ONT_OEXPRPRD_XMLP_PKG
- show dependent code
-
ONT_OEXPRPRS_XMLP_PKG
- show dependent code
-
PJM_INQUIRY
- show dependent code
-
PV_OPPORTUNITY_VHUK
- show dependent code
-
PV_PRGM_PMT_MODE_PVT
- show dependent code
-
RLM_EXTINTERFACE_SV
- show dependent code
-
WSH_ECE_VIEWS_DEF
- show dependent code
-
WSH_PICKING_BATCHES_V
-
WSH_PICKING_RULES_V
-
WSH_UTIL_VALIDATE
- show dependent code
-
WSH_WSHRDOPN_XMLP_PKG
- show dependent code
-
WSH_WSHRDPIK_XMLP_PKG
- show dependent code