[Home] [Help] [Dependency Information]
Object Name: | IGI_INT_FILE# |
---|---|
Object Type: | VIEW |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_TYPE | VARCHAR2 | (2) | Yes | |
INTERFACE_FILE_ID | NUMBER | Yes | ||
USER_JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | |
SOURCE_PERIOD_NAME | VARCHAR2 | (15) | Yes | |
TRANSMISSION_NUMBER | VARCHAR2 | (75) | Yes | |
FEEDER_BOOK_ID | VARCHAR2 | (25) | Yes | |
STATUS | VARCHAR2 | (1) | Yes | |
IGI_INT_FILE_FEEDER_BOOK_ID | VARCHAR2 | (25) |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, INTERFACE_FILE_ID
, USER_JE_SOURCE_NAME
, SOURCE_PERIOD_NAME
, TRANSMISSION_NUMBER
, FEEDER_BOOK_ID
, STATUS
, IGI_INT_FILE_FEEDER_BOOK_ID
FROM IGI.IGI_INT_FILE#;
|
|
|