VIEW: APPS.IGI_INT_FILE_V

Source

View Text - Preformatted

SELECT record_type , interface_file_id , user_je_source_name , source_period_name , transmission_number , feeder_book_id , status FROM igi_int_file UNION SELECT 'FH' , -1 , 'All' , 'XXX' , 'All' , '-1' , 'V' FROM IGI_INT_FILE

View Text - HTML Formatted

SELECT RECORD_TYPE
, INTERFACE_FILE_ID
, USER_JE_SOURCE_NAME
, SOURCE_PERIOD_NAME
, TRANSMISSION_NUMBER
, FEEDER_BOOK_ID
, STATUS
FROM IGI_INT_FILE UNION SELECT 'FH'
, -1
, 'ALL'
, 'XXX'
, 'ALL'
, '-1'
, 'V'
FROM IGI_INT_FILE