[Home] [Help]
View: IGI_INT_FILE_V
Product: | IGI - Public Sector Financials International |
Description: | |
Implementation/DBA Data: |
APPS.IGI_INT_FILE_V
|
View Text
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
Columns
Name |
RECORD_TYPE |
INTERFACE_FILE_ID |
USER_JE_SOURCE_NAME |
SOURCE_PERIOD_NAME |
TRANSMISSION_NUMBER |
FEEDER_BOOK_ID |
STATUS |