VIEW: APPS.CN_HIERARCHY_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 ERROR_MSG, RECORD_NUM RECORD_NUM, COL1 HIERARCHY_TYPE, COL2 BASE_TABLE_NAME, COL3 PRIMARY_KEY, COL4 HIERARCHY_VALUE, COL5 HIERARCHY_NAME, COL6 START_DATE, COL7 END_DATE, COL8 DEFAULT_NODE_FLAG, COL9 PARENT_NODE_NAME, COL10 NODE_NAME, COL11 LEVEL_NUM, UNMAP UNMAP1, UNMAP UNMAP2, UNMAP UNMAP3, UNMAP UNMAP4, UNMAP UNMAP5, UNMAP UNMAP6, UNMAP UNMAP7, UNMAP UNMAP8, UNMAP UNMAP9, UNMAP UNMAP10, UNMAP UNMAP11, UNMAP UNMAP12, UNMAP UNMAP13, UNMAP UNMAP14, UNMAP UNMAP15, UNMAP UNMAP16, UNMAP UNMAP17, UNMAP UNMAP18, UNMAP UNMAP19, UNMAP UNMAP20, UNMAP UNMAP21, UNMAP UNMAP22, UNMAP UNMAP23, UNMAP UNMAP24, UNMAP UNMAP25, UNMAP UNMAP26, UNMAP UNMAP27, UNMAP UNMAP28, UNMAP UNMAP29, UNMAP UNMAP30, UNMAP UNMAP31, UNMAP UNMAP32, UNMAP UNMAP33, UNMAP UNMAP34, UNMAP UNMAP35, UNMAP UNMAP36, UNMAP UNMAP37, UNMAP UNMAP38, UNMAP UNMAP39, UNMAP UNMAP40, UNMAP UNMAP41, UNMAP UNMAP42, UNMAP UNMAP43, UNMAP UNMAP44, UNMAP UNMAP45, UNMAP UNMAP46, UNMAP UNMAP47, UNMAP UNMAP48, UNMAP UNMAP49, UNMAP UNMAP50 FROM CN_IMP_LINES WHERE import_type_code = 'HIERARCHY'

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 ERROR_MSG
, RECORD_NUM RECORD_NUM
, COL1 HIERARCHY_TYPE
, COL2 BASE_TABLE_NAME
, COL3 PRIMARY_KEY
, COL4 HIERARCHY_VALUE
, COL5 HIERARCHY_NAME
, COL6 START_DATE
, COL7 END_DATE
, COL8 DEFAULT_NODE_FLAG
, COL9 PARENT_NODE_NAME
, COL10 NODE_NAME
, COL11 LEVEL_NUM
, UNMAP UNMAP1
, UNMAP UNMAP2
, UNMAP UNMAP3
, UNMAP UNMAP4
, UNMAP UNMAP5
, UNMAP UNMAP6
, UNMAP UNMAP7
, UNMAP UNMAP8
, UNMAP UNMAP9
, UNMAP UNMAP10
, UNMAP UNMAP11
, UNMAP UNMAP12
, UNMAP UNMAP13
, UNMAP UNMAP14
, UNMAP UNMAP15
, UNMAP UNMAP16
, UNMAP UNMAP17
, UNMAP UNMAP18
, UNMAP UNMAP19
, UNMAP UNMAP20
, UNMAP UNMAP21
, UNMAP UNMAP22
, UNMAP UNMAP23
, UNMAP UNMAP24
, UNMAP UNMAP25
, UNMAP UNMAP26
, UNMAP UNMAP27
, UNMAP UNMAP28
, UNMAP UNMAP29
, UNMAP UNMAP30
, UNMAP UNMAP31
, UNMAP UNMAP32
, UNMAP UNMAP33
, UNMAP UNMAP34
, UNMAP UNMAP35
, UNMAP UNMAP36
, UNMAP UNMAP37
, UNMAP UNMAP38
, UNMAP UNMAP39
, UNMAP UNMAP40
, UNMAP UNMAP41
, UNMAP UNMAP42
, UNMAP UNMAP43
, UNMAP UNMAP44
, UNMAP UNMAP45
, UNMAP UNMAP46
, UNMAP UNMAP47
, UNMAP UNMAP48
, UNMAP UNMAP49
, UNMAP UNMAP50
FROM CN_IMP_LINES
WHERE IMPORT_TYPE_CODE = 'HIERARCHY'