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


VIEW: APPS.WSH_LOOKUPS

Object Details
Object Name: WSH_LOOKUPS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSH_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
LOOKUP_CODE VARCHAR2 (30) Yes
MEANING VARCHAR2 (80) Yes
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Yes
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

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.WSH_LOOKUPS;

Dependencies

[top of page]

APPS.WSH_LOOKUPS references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
APPS.WSH_LOOKUPS is referenced by following:

SchemaAPPS
ViewCSD_WSH_LINE_STATUS_V
Package BodyFTE_FREIGHT_PRICING - show dependent code
Package BodyFTE_TENDER_WF - show dependent code
ViewIBE_SHIP_DETAIL_V
ViewIBE_SHIP_DLVY_DTL_V
ViewIBE_SHIP_DLVY_V
ViewMST_ACT_ADD_SHIP_LTLP_V
ViewMST_ACT_ANALYZE_CREATE_CM_V
ViewMST_ACT_ASTL_OPTIONS_V
ViewMST_ACT_BEFORE_AFTER_TL_V
ViewMST_ACT_BEFORE_AFTER_V
ViewMST_ACT_CARRIER_SERVICE_V
ViewMST_ACT_EMPTY_TRIPS_V
ViewMST_ACT_LOCATION_TRIPS_V
ViewMST_ACT_MODE_CSV_V
ViewMST_ACT_OPPLOADS_V
ViewMST_ACT_OPP_DELIVERY_V
ViewMST_ACT_OPP_LTL_V
ViewMST_ACT_REASSIGN_DELIVERY_V
ViewMST_AL_AP_LOADS_V
ViewMST_AT_LOADS_V
ViewMST_CARR_COMMIT_UNDERUTIL_V
ViewMST_CM_IMPROPER_TIME_V
ViewMST_CM_LOADS_V
ViewMST_CM_V
ViewMST_CR_SERVICES_V
ViewMST_CUST_CUST_INCOMP_V
ViewMST_DD_DELIVERY_LEGS_V
ViewMST_DD_LOAD_SUMMARY_V
ViewMST_EMPTY_TRIPS_V
ViewMST_EXCEED_CAR_VEH_LOADS_V
ViewMST_FACILITY_MODE_INCOMP_V
ViewMST_FAC_FAC_INCOMP_TRIP_V
ViewMST_FAC_VEHICLE_INCOMP_V
ViewMST_INCONSISTENT_TIME_V
ViewMST_ITEM_CARRIER_INCOMP_V
ViewMST_ITEM_MODE_INCOMP_V
ViewMST_LAYOVER_CHARGES_INCUR_V
ViewMST_LOW_COST_CAR_AVAILABLE_V
ViewMST_POOL_FAC_CAR_INCOMP_V
Package BodyMST_RELEASE - show dependent code
ViewMST_RELRL_V
ViewMST_REL_CM_V
ViewMST_REL_HIGH_UTIL_TL_V
ViewMST_REL_LTLP_V
ViewMST_REL_TIME_CRIT_LTLP_V
ViewMST_REL_TIME_CRIT_TL_V
ViewMST_REL_TL_V
ViewMST_R_MASTER_ORDER_DET_V
ViewMST_SR_LOADS_V
ViewMST_SR_SUMMARY_V
ViewMST_TL_SUMMARY_V
ViewMST_TRADE_PART_CAR_INCOMP_V
ViewMST_TS_SUMMARY_V
ViewMST_UTILIZATION_VEHICLE_CAP_V
ViewMST_VIO_CAR_RULE_CM_V
ViewMST_VIO_CAR_RULE_DISTANCE_V
ViewMST_VIO_CAR_RULE_PKUPDROP_V
ViewMST_VIO_CAR_RULE_STOPS_V
ViewMST_VIO_CAR_RULE_TIME_V
Package BodyMST_WB_UTIL - show dependent code
Package BodyONT_CHARGE_UTIL - show dependent code
Package BodyONT_OIP_COMMON - show dependent code
Package BodyQA_ERES_PKG - show dependent code
ViewQA_ERES_WSH_DELIVERABLES_V
ViewQA_ERES_WSH_NEW_DELIVERIES_V
ViewWSH_BOLS_DB_V
Package BodyWSH_CARRIERS_GRP - show dependent code
ViewWSH_CARRIER_CLASSIFICATIONS_V
ViewWSH_CONSOL_BATCHES_V
Package BodyWSH_DELIVERY_DETAILS_ACTIONS - show dependent code
ViewWSH_DELIVERY_DETAILS_OE_V
ViewWSH_DELIVERY_LINE_STATUS_V
Package BodyWSH_DELIVERY_VALIDATIONS - show dependent code
ViewWSH_DLVB_DLVY_V
ViewWSH_DLVY_DELIVERABLES_V
ViewWSH_DOC_SEQUENCE_CATEGORIES_V
ViewWSH_FREIGHT_COSTS_V
ViewWSH_FREIGHT_COST_TYPES_V
ViewWSH_ITM_RESPONSE_RULES_V
ViewWSH_NEW_DELIVERIES_V
ViewWSH_PURGE_SET_V
ViewWSH_PURGE_SOURCE_TYPES_V
Package BodyWSH_RU_ACTIONS - show dependent code
ViewWSH_SHIPPING_DETAILS_V
Package BodyWSH_SHIPPING_INFO - show dependent code
ViewWSH_TRIPS_V
ViewWSH_TRIP_STOPS_V
Package BodyWSH_UTIL_CORE - show dependent code
Package BodyWSH_WF_STD - show dependent code
Package BodyWSH_WSHRDBDR_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDOPN_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDSDL_XMLP_PKG - show dependent code