DBA Data[Home] [Help]

VIEW: APPS.ASO_I_SHIPPING_METHODS_V

Source

View Text - Preformatted

SELECT meaning shipping_method, lookup_code shipping_method_code, description from oe_ship_methods_v where enabled_flag = 'Y' and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) AND trunc(nvl(end_date_active, sysdate))
View Text - HTML Formatted

SELECT MEANING SHIPPING_METHOD
, LOOKUP_CODE SHIPPING_METHOD_CODE
, DESCRIPTION
FROM OE_SHIP_METHODS_V
WHERE ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE))