VIEW: APPS.BIX_DM_TIME_PARAM_V

Source

View Text - Preformatted

SELECT to_char(11) time_id , to_char(sysdate,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'mm/dd/yyyy')) time_name from dual union select to_char(12) time_id , to_char(sysdate - 1,nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'mm/dd/yyyy')) time_name from dual union select lookup_code time_id , meaning time_name from fnd_lookups where lookup_type = 'BIX_DM_TIME_PARAM' and to_number(lookup_code) > 10

View Text - HTML Formatted

SELECT TO_CHAR(11) TIME_ID
, TO_CHAR(SYSDATE
, NVL(FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
, 'MM/DD/YYYY')) TIME_NAME
FROM DUAL UNION SELECT TO_CHAR(12) TIME_ID
, TO_CHAR(SYSDATE - 1
, NVL(FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')
, 'MM/DD/YYYY')) TIME_NAME
FROM DUAL UNION SELECT LOOKUP_CODE TIME_ID
, MEANING TIME_NAME
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIX_DM_TIME_PARAM'
AND TO_NUMBER(LOOKUP_CODE) > 10