[Home] [Help]
VIEW: APPS.OPI_TIME_STRUCTURES_ITD_V
Source
View Text - Preformatted
SELECT report_date , time_id , period_type_id , record_type_id , xtd_flag from fii_time_structures WHERE bitand(record_type_id,512) = 512 and xtd_flag = 'Y'
View Text - HTML Formatted
SELECT REPORT_DATE
, TIME_ID
, PERIOD_TYPE_ID
, RECORD_TYPE_ID
, XTD_FLAG
FROM FII_TIME_STRUCTURES
WHERE BITAND(RECORD_TYPE_ID
, 512) = 512
AND XTD_FLAG = 'Y'