VIEW: IMC.IMC_CSV_LOAD_DETAILS#

Source

View Text - Preformatted

select LOAD_ID LOAD_ID, LOAD_NAME LOAD_NAME, LOAD_DESC LOAD_DESC, SOURCE_FILE_LOCATION SOURCE_FILE_LOCATION, SOURCE_SYSTEM SOURCE_SYSTEM, HEADER_EXISTS_FLAG HEADER_EXISTS_FLAG, COLUMN_DELIMITER COLUMN_DELIMITER, FIELD_ENCLOSED_BY FIELD_ENCLOSED_BY, DATE_FORMAT DATE_FORMAT, PARTY_TYPE PARTY_TYPE, ADDRESS_FLAG ADDRESS_FLAG, CONTACT_POINTS_FLAG CONTACT_POINTS_FLAG, CLASSIFICATION_FLAG CLASSIFICATION_FLAG, BATCH_ID BATCH_ID, CSV_REQ_ID CSV_REQ_ID, NO_OF_FILE_LOAD_RECS NO_OF_FILE_LOAD_RECS, NO_OF_PARTIES_FOR_EXPT NO_OF_PARTIES_FOR_EXPT, NO_OF_PARTIES_WITH_ERR NO_OF_PARTIES_WITH_ERR, NO_OF_ATTRIBS_WITH_ERR NO_OF_ATTRIBS_WITH_ERR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "IMC"."IMC_CSV_LOAD_DETAILS"

View Text - HTML Formatted

SELECT LOAD_ID LOAD_ID
, LOAD_NAME LOAD_NAME
, LOAD_DESC LOAD_DESC
, SOURCE_FILE_LOCATION SOURCE_FILE_LOCATION
, SOURCE_SYSTEM SOURCE_SYSTEM
, HEADER_EXISTS_FLAG HEADER_EXISTS_FLAG
, COLUMN_DELIMITER COLUMN_DELIMITER
, FIELD_ENCLOSED_BY FIELD_ENCLOSED_BY
, DATE_FORMAT DATE_FORMAT
, PARTY_TYPE PARTY_TYPE
, ADDRESS_FLAG ADDRESS_FLAG
, CONTACT_POINTS_FLAG CONTACT_POINTS_FLAG
, CLASSIFICATION_FLAG CLASSIFICATION_FLAG
, BATCH_ID BATCH_ID
, CSV_REQ_ID CSV_REQ_ID
, NO_OF_FILE_LOAD_RECS NO_OF_FILE_LOAD_RECS
, NO_OF_PARTIES_FOR_EXPT NO_OF_PARTIES_FOR_EXPT
, NO_OF_PARTIES_WITH_ERR NO_OF_PARTIES_WITH_ERR
, NO_OF_ATTRIBS_WITH_ERR NO_OF_ATTRIBS_WITH_ERR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "IMC"."IMC_CSV_LOAD_DETAILS"