View: ASO_I_SERVICE_TYPES_V

Product:	ASO - Order Capture
Description:	view gives the reference information for service supported by Order Management
Implementation/DBA Data:	APPS.ASO_I_SERVICE_TYPES_V

View Text

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

Columns