VIEW: APPS.CN_EXP_API_IMP_V

Source

View Text - Preformatted

SELECT IMP_LINE_ID IMP_LINE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, IMP_HEADER_ID IMP_HEADER_ID, IMPORT_TYPE_CODE IMPORT_TYPE_CODE, STATUS_CODE STATUS_CODE, ERROR_CODE ERROR_CODE, ERROR_MSG, RECORD_NUM, COL1 EXPRESSION_NAME, COL2 DESCRIPTION, COL3 SQL_SELECT, COL100 ATTRIBUTE_CATEGORY, COL101 ATTRIBUTE1, COL102 ATTRIBUTE2, COL103 ATTRIBUTE3, COL104 ATTRIBUTE4, COL105 ATTRIBUTE5, COL106 ATTRIBUTE6, COL107 ATTRIBUTE7, COL108 ATTRIBUTE8, COL109 ATTRIBUTE9, COL110 ATTRIBUTE10, COL111 ATTRIBUTE11, COL112 ATTRIBUTE12, COL113 ATTRIBUTE13, COL114 ATTRIBUTE14, COL115 ATTRIBUTE15, UNMAP UNMAP1, UNMAP UNMAP2, UNMAP UNMAP3, UNMAP UNMAP4, UNMAP UNMAP5, UNMAP UNMAP6, UNMAP UNMAP7, UNMAP UNMAP8, UNMAP UNMAP9, UNMAP UNMAP10 FROM CN_IMP_LINES WHERE import_type_code = 'CALCEXP'

View Text - HTML Formatted

SELECT IMP_LINE_ID IMP_LINE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IMP_HEADER_ID IMP_HEADER_ID
, IMPORT_TYPE_CODE IMPORT_TYPE_CODE
, STATUS_CODE STATUS_CODE
, ERROR_CODE ERROR_CODE
, ERROR_MSG
, RECORD_NUM
, COL1 EXPRESSION_NAME
, COL2 DESCRIPTION
, COL3 SQL_SELECT
, COL100 ATTRIBUTE_CATEGORY
, COL101 ATTRIBUTE1
, COL102 ATTRIBUTE2
, COL103 ATTRIBUTE3
, COL104 ATTRIBUTE4
, COL105 ATTRIBUTE5
, COL106 ATTRIBUTE6
, COL107 ATTRIBUTE7
, COL108 ATTRIBUTE8
, COL109 ATTRIBUTE9
, COL110 ATTRIBUTE10
, COL111 ATTRIBUTE11
, COL112 ATTRIBUTE12
, COL113 ATTRIBUTE13
, COL114 ATTRIBUTE14
, COL115 ATTRIBUTE15
, UNMAP UNMAP1
, UNMAP UNMAP2
, UNMAP UNMAP3
, UNMAP UNMAP4
, UNMAP UNMAP5
, UNMAP UNMAP6
, UNMAP UNMAP7
, UNMAP UNMAP8
, UNMAP UNMAP9
, UNMAP UNMAP10
FROM CN_IMP_LINES
WHERE IMPORT_TYPE_CODE = 'CALCEXP'