[Home] [Help]
[Dependency Information]
| Object Name: | OE_LOOKUPS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | ONT.OE_LOOKUPS
|
| Subobject Name: | |
| Status: | VALID |
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.
| 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 |
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;
APPS
FND_LOOKUP_VALUES
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
|
|
|
|