[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 |