DBA Data[Home] [Help]

VIEW: APPS.ASO_I_ATP_ERRORS_V

Source

View Text - Preformatted

SELECT lookup_type , lookup_code , meaning from MFG_LOOKUPS WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS' and nvl(start_date_active,sysdate) <= sysdate and nvl(end_date_active,sysdate) >= sysdate
View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'MTL_DEMAND_INTERFACE_ERRORS'
AND NVL(START_DATE_ACTIVE
, SYSDATE) <= SYSDATE
AND NVL(END_DATE_ACTIVE
, SYSDATE) >= SYSDATE