View: ASO_I_RETURN_TYPES_V

Product:	ASO - Order Capture
Description:	view is used as an LOV for available return references
Implementation/DBA Data:	APPS.ASO_I_RETURN_TYPES_V

View Text

SELECT MEANING RETURN_REFERENCE_TYPE
, LOOKUP_CODE RETURN_REFERENCE_TYPE_CODE
, DESCRIPTION
FROM OE_LOOKUPS
WHERE LOOKUP_TYPE = 'REFERENCE_TYPE'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns