eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OE_SHIP_METHODS_V

Object Details

Object Name:	OE_SHIP_METHODS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_SHIP_METHODS_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This is a view for ship methods.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LOOKUP_TYPE	VARCHAR2	(30)	Yes	Lookup type holds a unique name for which various codes can be created.
LOOKUP_CODE	VARCHAR2	(30)	Yes	It is an internal code value for the lookup.
MEANING	VARCHAR2	(80)	Yes	Meaning of the look up.
DESCRIPTION	VARCHAR2	(240)		Details of the lookup code.
ENABLED_FLAG	VARCHAR2	(1)	Yes	This indicated whether the lookup code is enabled or not.
START_DATE_ACTIVE	DATE			This holds the activation date for the lookup code.
END_DATE_ACTIVE	DATE			This holds the value of deactivation 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.OE_SHIP_METHODS_V;

Dependencies

[top of page]

APPS.OE_SHIP_METHODS_V references the following:

APPS: FND_LOOKUP_VALUES

APPS.OE_SHIP_METHODS_V is referenced by following:

APPS: ASO_I_SHIPPING_METHODS_V; ASO_WORKFLOW_PVT - show dependent code; ASO_WORKFLOW_QUOTE_PVT - show dependent code; CSP_SCH_INT_PVT - show dependent code; FUN_RULE_UTILITY_PKG - show dependent code; FUN_RULE_VALIDATE_PKG - show dependent code; HZ_ACCOUNT_VALIDATE_V2PUB - show dependent code; HZ_REGISTRY_VALIDATE_V2PUB - show dependent code; HZ_UTILITY_V2PUB - show dependent code; IBE_MSITE_INFORMATION_PVT - show dependent code; IBE_ORDER_HEADER_V; IBE_ORDER_LINE_DTL_V; IBE_SHIP_DETAIL_V; IBE_SHIP_DLVY_DTL_V; IBE_SHIP_DLVY_V; IBE_WORKFLOW_PVT - show dependent code; INV_LABEL_PVT10 - show dependent code; OE_AK_SHIPPING_METHOD_V; OE_BLANKET_FORM_CONTROL - show dependent code; OE_BULK_CACHE - 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_FREIGHT_CHOICES_PVT - show dependent code; OE_HEADER_UTIL - show dependent code; OE_HOLDS_PVT - show dependent code; OE_ID_TO_VALUE - show dependent code; OE_LINE_UTIL - show dependent code; OE_OE_FORM_HEADER - show dependent code; OE_OE_FORM_LINE - show dependent code; OE_OE_PRICING_AVAILABILITY - show dependent code; OE_VALIDATE - show dependent code; OE_VALUE_TO_ID - show dependent code; QPFV_AGREEMENTS; QPFV_PRICE_LISTS; QPR_SR_OFFADJ_HIER_V; QPR_SR_OM_QUOTE_LINES_V; QPR_SR_QUOTE_LINES_V; QP_BULK_VALIDATE - show dependent code; QP_BULK_VALUE_TO_ID - show dependent code; QP_ID_TO_VALUE - show dependent code; QP_VALIDATE - show dependent code; QP_VALUE_TO_ID - show dependent code