VIEW: APPS.CN_COMMLINE_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 ERROR_MSG, RECORD_NUM RECORD_NUM, COL1 RESOURCE_NAME, COL2 EMPLOYEE_NUMBER, COL3 PROCESSED_DATE, COL4 TRANSACTION_AMOUNT, COL5 QUANTITY, COL6 ORDER_NUMBER, COL7 ORDER_DATE, COL8 INVOICE_NUMBER, COL9 INVOICE_DATE, COL10 REVENUE_TYPE, COL11 SALES_CHANNEL, COL12 REVENUE_CLASS_NAME, 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, COL116 ATTRIBUTE16, COL117 ATTRIBUTE17, COL118 ATTRIBUTE18, COL119 ATTRIBUTE19, COL120 ATTRIBUTE20, COL121 ATTRIBUTE21, COL122 ATTRIBUTE22, COL123 ATTRIBUTE23, COL124 ATTRIBUTE24, COL125 ATTRIBUTE25, COL126 ATTRIBUTE26, COL127 ATTRIBUTE27, COL128 ATTRIBUTE28, COL129 ATTRIBUTE29, COL130 ATTRIBUTE30, COL131 ATTRIBUTE31, COL132 ATTRIBUTE32, COL133 ATTRIBUTE33, COL134 ATTRIBUTE34, COL135 ATTRIBUTE35, COL136 ATTRIBUTE36, COL137 ATTRIBUTE37, COL138 ATTRIBUTE38, COL139 ATTRIBUTE39, COL140 ATTRIBUTE40, COL141 ATTRIBUTE41, COL142 ATTRIBUTE42, COL143 ATTRIBUTE43, COL144 ATTRIBUTE44, COL145 ATTRIBUTE45, COL146 ATTRIBUTE46, COL147 ATTRIBUTE47, COL148 ATTRIBUTE48, COL149 ATTRIBUTE49, COL150 ATTRIBUTE50, COL151 ATTRIBUTE51, COL152 ATTRIBUTE52, COL153 ATTRIBUTE53, COL154 ATTRIBUTE54, COL155 ATTRIBUTE55, COL156 ATTRIBUTE56, COL157 ATTRIBUTE57, COL158 ATTRIBUTE58, COL159 ATTRIBUTE59, COL160 ATTRIBUTE60, COL161 ATTRIBUTE61, COL162 ATTRIBUTE62, COL163 ATTRIBUTE63, COL164 ATTRIBUTE64, COL165 ATTRIBUTE65, COL166 ATTRIBUTE66, COL167 ATTRIBUTE67, COL168 ATTRIBUTE68, COL169 ATTRIBUTE69, COL170 ATTRIBUTE70, COL171 ATTRIBUTE71, COL172 ATTRIBUTE72, COL173 ATTRIBUTE73, COL174 ATTRIBUTE74, COL175 ATTRIBUTE75, COL176 ATTRIBUTE76, COL177 ATTRIBUTE77, COL178 ATTRIBUTE78, COL179 ATTRIBUTE79, COL180 ATTRIBUTE80, COL181 ATTRIBUTE81, COL182 ATTRIBUTE82, COL183 ATTRIBUTE83, COL184 ATTRIBUTE84, COL185 ATTRIBUTE85, COL186 ATTRIBUTE86, COL187 ATTRIBUTE87, COL188 ATTRIBUTE88, COL189 ATTRIBUTE89, COL190 ATTRIBUTE90, COL191 ATTRIBUTE91, COL192 ATTRIBUTE92, COL193 ATTRIBUTE93, COL194 ATTRIBUTE94, COL195 ATTRIBUTE95, COL196 ATTRIBUTE96, COL197 ATTRIBUTE97, COL198 ATTRIBUTE98, COL199 ATTRIBUTE99, COL200 ATTRIBUTE100, 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, COL13 COMMISSION_AMOUNT, COL14 EXCHANGE_RATE, COL15 TRANSACTION_CURRENCY_CODE, COL16 DISCOUNT_PERCENTAGE, COL17 MARGIN_PERCENTAGE, COL18 REASON_CODE, COL19 PRE_PROCESSED_CODE, COL20 COMPENSATION_GROUP_NAME, COL21 PLAN_ELEMENT_NAME, COL22 ROLE_NAME, COL23 ROLLUP_DATE, COL24 LINE_NUMBER, COL25 SPLIT_PCT, COL26 PRESERVE_CREDIT_OVERRIDE_FLAG, COL27 ADJUST_COMMENTS FROM cn_imp_lines WHERE import_type_code = 'TRXAPI'

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 RESOURCE_NAME
, COL2 EMPLOYEE_NUMBER
, COL3 PROCESSED_DATE
, COL4 TRANSACTION_AMOUNT
, COL5 QUANTITY
, COL6 ORDER_NUMBER
, COL7 ORDER_DATE
, COL8 INVOICE_NUMBER
, COL9 INVOICE_DATE
, COL10 REVENUE_TYPE
, COL11 SALES_CHANNEL
, COL12 REVENUE_CLASS_NAME
, 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
, COL116 ATTRIBUTE16
, COL117 ATTRIBUTE17
, COL118 ATTRIBUTE18
, COL119 ATTRIBUTE19
, COL120 ATTRIBUTE20
, COL121 ATTRIBUTE21
, COL122 ATTRIBUTE22
, COL123 ATTRIBUTE23
, COL124 ATTRIBUTE24
, COL125 ATTRIBUTE25
, COL126 ATTRIBUTE26
, COL127 ATTRIBUTE27
, COL128 ATTRIBUTE28
, COL129 ATTRIBUTE29
, COL130 ATTRIBUTE30
, COL131 ATTRIBUTE31
, COL132 ATTRIBUTE32
, COL133 ATTRIBUTE33
, COL134 ATTRIBUTE34
, COL135 ATTRIBUTE35
, COL136 ATTRIBUTE36
, COL137 ATTRIBUTE37
, COL138 ATTRIBUTE38
, COL139 ATTRIBUTE39
, COL140 ATTRIBUTE40
, COL141 ATTRIBUTE41
, COL142 ATTRIBUTE42
, COL143 ATTRIBUTE43
, COL144 ATTRIBUTE44
, COL145 ATTRIBUTE45
, COL146 ATTRIBUTE46
, COL147 ATTRIBUTE47
, COL148 ATTRIBUTE48
, COL149 ATTRIBUTE49
, COL150 ATTRIBUTE50
, COL151 ATTRIBUTE51
, COL152 ATTRIBUTE52
, COL153 ATTRIBUTE53
, COL154 ATTRIBUTE54
, COL155 ATTRIBUTE55
, COL156 ATTRIBUTE56
, COL157 ATTRIBUTE57
, COL158 ATTRIBUTE58
, COL159 ATTRIBUTE59
, COL160 ATTRIBUTE60
, COL161 ATTRIBUTE61
, COL162 ATTRIBUTE62
, COL163 ATTRIBUTE63
, COL164 ATTRIBUTE64
, COL165 ATTRIBUTE65
, COL166 ATTRIBUTE66
, COL167 ATTRIBUTE67
, COL168 ATTRIBUTE68
, COL169 ATTRIBUTE69
, COL170 ATTRIBUTE70
, COL171 ATTRIBUTE71
, COL172 ATTRIBUTE72
, COL173 ATTRIBUTE73
, COL174 ATTRIBUTE74
, COL175 ATTRIBUTE75
, COL176 ATTRIBUTE76
, COL177 ATTRIBUTE77
, COL178 ATTRIBUTE78
, COL179 ATTRIBUTE79
, COL180 ATTRIBUTE80
, COL181 ATTRIBUTE81
, COL182 ATTRIBUTE82
, COL183 ATTRIBUTE83
, COL184 ATTRIBUTE84
, COL185 ATTRIBUTE85
, COL186 ATTRIBUTE86
, COL187 ATTRIBUTE87
, COL188 ATTRIBUTE88
, COL189 ATTRIBUTE89
, COL190 ATTRIBUTE90
, COL191 ATTRIBUTE91
, COL192 ATTRIBUTE92
, COL193 ATTRIBUTE93
, COL194 ATTRIBUTE94
, COL195 ATTRIBUTE95
, COL196 ATTRIBUTE96
, COL197 ATTRIBUTE97
, COL198 ATTRIBUTE98
, COL199 ATTRIBUTE99
, COL200 ATTRIBUTE100
, 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
, COL13 COMMISSION_AMOUNT
, COL14 EXCHANGE_RATE
, COL15 TRANSACTION_CURRENCY_CODE
, COL16 DISCOUNT_PERCENTAGE
, COL17 MARGIN_PERCENTAGE
, COL18 REASON_CODE
, COL19 PRE_PROCESSED_CODE
, COL20 COMPENSATION_GROUP_NAME
, COL21 PLAN_ELEMENT_NAME
, COL22 ROLE_NAME
, COL23 ROLLUP_DATE
, COL24 LINE_NUMBER
, COL25 SPLIT_PCT
, COL26 PRESERVE_CREDIT_OVERRIDE_FLAG
, COL27 ADJUST_COMMENTS
FROM CN_IMP_LINES
WHERE IMPORT_TYPE_CODE = 'TRXAPI'