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

VIEW: APPS.OE_FRGHT_TERMS_ACTIVE_V

Object Details
Object Name: OE_FRGHT_TERMS_ACTIVE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_FRGHT_TERMS_ACTIVE_V
Subobject Name:
Status: VALID

View Type

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


This view gives active freight terms defined in the Order Management.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FREIGHT_TERMS VARCHAR2 (80) Yes Freight term
FREIGHT_TERMS_CODE VARCHAR2 (30) Yes Freight term code
START_DATE_ACTIVE DATE

The date freight term code becomes active
END_DATE_ACTIVE DATE

The date freight term code becomes inactive
DESCRIPTION VARCHAR2 (240)
Freight term description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FREIGHT_TERMS
,      FREIGHT_TERMS_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
FROM APPS.OE_FRGHT_TERMS_ACTIVE_V;

Dependencies

[top of page]

APPS.OE_FRGHT_TERMS_ACTIVE_V references the following:

SchemaAPPS
ViewOE_LOOKUPS
APPS.OE_FRGHT_TERMS_ACTIVE_V is referenced by following:

SchemaAPPS
Package BodyOE_OE_PRICING_AVAILABILITY - show dependent code
ViewQPFV_AGREEMENTS
ViewQPFV_PRICE_LISTS
Package BodyQP_BULK_VALIDATE - show dependent code
Package BodyQP_BULK_VALUE_TO_ID - show dependent code
Package BodyQP_QPXPRCST_XMLP_PKG - show dependent code
Package BodyQP_VALIDATE - show dependent code
Package BodyWMS_DIRECT_SHIP_PVT - show dependent code
Package BodyWMS_SHIPPING_TRANSACTION_PUB - show dependent code
Package BodyWSH_WSHRDMBL_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDPAK_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDPIK_XMLP_PKG - show dependent code