View: ASO_I_SHIPPING_METHODS_V

Product:	ASO - Order Capture
Description:	view used to retrieve all valid shipping methods
Implementation/DBA Data:	APPS.ASO_I_SHIPPING_METHODS_V

View Text

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

Columns