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


VIEW: APPS.OE_LOOKUPS

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

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.OE_LOOKUPS is referenced by following:

SchemaAPPS
ViewAML_LEAD_PROCESSING_STAGES_V
Package BodyASO_ATP_INT - show dependent code
Package BodyASO_DEF_UTIL - show dependent code
ViewASO_I_CREDIT_CARDS_V
ViewASO_I_INVOICES_V
ViewASO_I_RETURN_TYPES_V
ViewASO_I_SALES_CHANNELS_V
ViewASO_I_SERVICE_TYPES_V
Package BodyASO_ORDER_INT - show dependent code
Package BodyASO_VALIDATE_PVT - show dependent code
ViewAST_LM_LEADS_QUICK_CAMPAIGN_V
ViewAST_LM_LEADS_QUICK_GROUP_V
ViewAST_LM_LEADS_QUICK_INTEREST_V
ViewAST_LM_LEADS_QUICK_INT_PC_V
ViewAST_LM_LEADS_QUICK_V
ViewAST_LM_OPP_EXPANDED_V
ViewAST_LM_OPP_EXP_CR_TYPE_V
ViewAST_LM_OPP_QUICK_CAMP_V
ViewAST_LM_OPP_QUICK_INTTYPES_V
ViewAST_LM_OPP_QUICK_RESULTS_V
ViewAST_LM_OPP_QUICK_SGRP_V
ViewAST_LM_OPP_QUICK_SREP_V
ViewAST_LS_SALES_LEADS_BSC_V
ViewAST_LS_SALES_LEADS_CONTACT_V
ViewAST_LS_SALES_LEADS_V
ViewAST_MYTEAM_SALESLEAD_UWQ_V
ViewAST_MYTEAM_SALESOPP_CODE_UWQ_V
ViewAST_MYTEAM_SALESOPP_NAME_UWQ_V
ViewAST_MYTEAM_SALESOPP_UWQ_V
ViewAST_OPPORTUNITIES_BALI_V
ViewAST_OPPORTUNITY_CONTACT_V
ViewAST_OPPORTUNITY_DET_V
ViewAST_OPPORTUNITY_LOGS_V
ViewAST_OPPORTUNITY_LOG_V
ViewAST_ORDER_HEADERS_V
ViewAST_PLIST_OPP_UWQ_V
ViewAST_SALESLEAD_UWQ_V
ViewAST_SALESOPP_CODE_UWQ_V
ViewAST_SALESOPP_NAME_UWQ_V
ViewAST_SALESOPP_UWQ_V
ViewAST_SALES_LEADS_BALI_V
ViewAST_SALES_LEADS_EBC_V
ViewAST_SALES_LEADS_REL_BALI_V
ViewAST_SALES_LEADS_V
ViewAS_OPPORTUNITY_DETAILS_V
Package BodyAS_OPPORTUNITY_VUHK - show dependent code
Package BodyAS_OPP_HEADER_PVT - show dependent code
Package BodyAS_SALES_LEAD_OPP_PVT - show dependent code
ViewBIL_DIMV_SLS_CHANNELS
ViewBIM_DIMV_SALES_CHANNELS
ViewCSC_ORDER_HEADERS_V
Package BodyCSD_LOGISTICS_UTIL - show dependent code
ViewCSP_EOO_CANCEL_RECOMM_V
Package BodyCS_CHARGE_DETAILS_PVT - show dependent code
Package BodyECEPOI - show dependent code
Package BodyHZ_ACCOUNT_VALIDATE_V2PUB - show dependent code
ViewIBE_ORDER_DETAIL_V
ViewIBE_ORDER_HEADER_ADV_V
ViewIBE_ORDER_HEADER_V
ViewIBE_ORDER_ITEMS_ADV_V
ViewIBE_ORDER_LINE_DTL_V
ViewIBE_ORDER_SUM_V
ViewIBE_RETURN_DETAIL_V
ViewIBE_RETURN_SUM_V
ViewIBE_SHIP_DETAIL_V
ViewIBE_SHIP_DLVY_V
Package BodyINVPVDR4 - show dependent code
Package BodyINV_MEANING_SEL - show dependent code
ViewJTM_OE_ORDER_LINES_ALL_V
Package BodyMSC_X_VMI_POREQ - show dependent code
Package BodyOE_ACKNOWLEDGMENT_PUB - show dependent code
ViewOE_AK_DEFAULT_FULFILMENT_SET_V
ViewOE_AK_DEFAULT_LINE_SET_V
ViewOE_AK_DEMAND_CLASS_V
ViewOE_AK_FOB_POINT_V
ViewOE_AK_FREIGHT_TERMS_V
ViewOE_AK_IB_CURR_LOC_V
ViewOE_AK_IB_INSTALL_LOC_V
ViewOE_AK_IB_OWNER_V
ViewOE_AK_ITEM_IDENTIFIER_TYPE_V
ViewOE_AK_ORDER_CATEGORY_V
ViewOE_AK_ORDER_DATE_TYPE_V
ViewOE_AK_PRIMARY_UOM_V
ViewOE_AK_SALES_CHANNEL_V
ViewOE_AK_SHIP_PRIORITIES_V
ViewOE_AK_SOURCE_TYPE_V
ViewOE_AK_TAX_POINT_V
ViewOE_AK_TRXN_PHASE_V
ViewOE_AK_T_EXEMPT_REASON_V
Package BodyOE_APPROVALS_WF - show dependent code
ViewOE_AS_ORDER_HEADERS_V
ViewOE_AUDIT_ATTR_DESC_V
Package BodyOE_AUDIT_HISTORY_PVT - show dependent code
Package BodyOE_BLANKET_FORM_CONTROL - show dependent code
ViewOE_BLANKET_HDRS_HIST_V
ViewOE_BLANKET_HEADERS_V
ViewOE_BLANKET_LINES_HIST_V
ViewOE_BLANKET_LINES_V
ViewOE_BLKTPRT_LINES_V
ViewOE_BLKT_HEADERS_HIST_V
ViewOE_BLKT_LINES_HIST_V
Package BodyOE_BULK_ACK_PVT - show dependent code
Package BodyOE_BULK_CACHE - show dependent code
Package BodyOE_BULK_PROCESS_HEADER - show dependent code
Package BodyOE_BULK_VALIDATE - show dependent code
Package BodyOE_BULK_VALUE_TO_ID - show dependent code
Package BodyOE_CNCL_VALIDATE - show dependent code
Package BodyOE_CNCL_VALUE_TO_ID - show dependent code
Package BodyOE_CREDIT_CHECK_RPT - show dependent code
Package BodyOE_CREDIT_CHECK_UTIL - show dependent code
Package BodyOE_CUSTACCEPTREP_PVT - show dependent code
Package BodyOE_DROP_SHIP_GRP - show dependent code
ViewOE_DROP_SHIP_LINKS_V
Package BodyOE_ERROR_WF - show dependent code
Package BodyOE_EXT_CREDIT_EXPOSURE_PVT - show dependent code
ViewOE_FRGHT_TERMS_ACTIVE_V
Package BodyOE_HEADER_ADJ_UTIL - show dependent code
Package BodyOE_HOLDS_PVT - show dependent code
Package BodyOE_HOLD_SOURCES_PVT - show dependent code
Package BodyOE_ID_TO_VALUE - show dependent code
Package BodyOE_ITORD_PUB - show dependent code
Package BodyOE_ITORD_UTIL - show dependent code
Package BodyOE_LINE_ADJ_UTIL - show dependent code
Package BodyOE_OE_FORM_HEADER - show dependent code
Package BodyOE_OE_FORM_LINE - show dependent code
Package BodyOE_OE_HTML_HEADER - show dependent code
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
ViewOE_ORDER_HEADERS_HIST_V
Package BodyOE_ORDER_WF_UTIL - show dependent code
Package BodyOE_PARAMETERS_DEF_UTIL - show dependent code
Package BodyOE_PRICE_ORDER_PVT - show dependent code
Package BodyOE_RMA_GRP - show dependent code
ViewOE_SCH_ORDER_LINES_V
ViewOE_SCH_RSV_SET_LINES_V
ViewOE_TRANSACTION_TYPES_V
Package BodyOE_VALIDATE - show dependent code
Package BodyOE_VALIDATE_ADJ - show dependent code
Package BodyOE_VALIDATE_LINE - show dependent code
Package BodyOE_VALUE_TO_ID - show dependent code
Package BodyOE_VERSION_BLANKET_COMP - show dependent code
Package BodyOE_VERSION_COMP - show dependent code
Package BodyOKC_REP_SEARCH_UTIL_PVT - show dependent code
Package BodyONT_DEF_UTIL - show dependent code
Package BodyONT_OEXAUCRC_XMLP_PKG - show dependent code
Package BodyONT_OEXCEXP_XMLP_PKG - show dependent code
Package BodyONT_OEXCRDIS_XMLP_PKG - show dependent code
Package BodyONT_OEXIODIS_XMLP_PKG - show dependent code
Package BodyONT_OEXOEACK_XMLP_PKG - show dependent code
Package BodyONT_OEXOECCH_XMLP_PKG - show dependent code
Package BodyONT_OEXOECCL_XMLP_PKG - show dependent code
Package BodyONT_OEXOECOD_XMLP_PKG - show dependent code
Package BodyONT_OEXOEIOD_XMLP_PKG - show dependent code
Package BodyONT_OEXOEITR_XMLP_PKG - show dependent code
Package BodyONT_OEXOEOCR_XMLP_PKG - show dependent code
Package BodyONT_OEXOEOCS_XMLP_PKG - show dependent code
Package BodyONT_OEXOEORD_XMLP_PKG - show dependent code
Package BodyONT_OEXOEORR_XMLP_PKG - show dependent code
Package BodyONT_OEXOEORS_XMLP_PKG - show dependent code
Package BodyONT_OEXOEOSR_XMLP_PKG - show dependent code
Package BodyONT_OEXOEPCL_XMLP_PKG - show dependent code
Package BodyONT_OEXOESOS_XMLP_PKG - show dependent code
Package BodyONT_OEXOEUBD_XMLP_PKG - show dependent code
Package BodyONT_OEXOEUBK_XMLP_PKG - show dependent code
Package BodyONT_OEXOHHSA_XMLP_PKG - show dependent code
Package BodyONT_OEXOHOHS_XMLP_PKG - show dependent code
Package BodyONT_OEXPRPRD_XMLP_PKG - show dependent code
Package BodyONT_OEXPRPRS_XMLP_PKG - show dependent code
Package BodyPJM_INQUIRY - show dependent code
Package BodyPV_OPPORTUNITY_VHUK - show dependent code
Package BodyPV_PRGM_PMT_MODE_PVT - show dependent code
Package BodyRLM_EXTINTERFACE_SV - show dependent code
Package BodyWSH_ECE_VIEWS_DEF - show dependent code
ViewWSH_PICKING_BATCHES_V
ViewWSH_PICKING_RULES_V
Package BodyWSH_UTIL_VALIDATE - show dependent code
Package BodyWSH_WSHRDOPN_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDPIK_XMLP_PKG - show dependent code