CN_INT_TRANSACTIONS_ALL_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

SIMULATION_ID TRANSACTION_ID OBJECT_VERSION_NUMBER PARTICIPANT_ID SOURCE_EVENT_DATE SOURCE_EVENT_PERIOD_ID CREDIT_DATE ROLLUP_DATE TRANSACTION_AMT_SOURCE_CURR SOURCE_CURRENCY_CODE TRANSACTION_AMT_FUNC_CURR SOURCE_TO_FUNC_CURR_CNVRT DISCOUNT_PERCENTAGE MARGIN_PERCENTAGE TRANSACTION_QTY TRANSACTION_SUB_TYPE TRANSACTION_TYPE NEW_TRANSACTION_ID ELIGIBLE_CAT_ID SOURCE_TYPE OBJECT_STATUS COLLECTION_STATUS ADJUSTMENT_STATUS ADJUSTMENT_COMMENTS PROCESS_CODE SOURCE_ORG_ID ORG_ID SOURCE_TRX_NUMBER SOURCE_TRX_ID SOURCE_TRX_LINE_ID SOURCE_TRX_SALES_LINE_ID CUSTOMER_ID INVENTORY_ITEM_ID ORDER_NUMBER BOOKED_DATE INVOICE_NUMBER INVOICE_DATE BILL_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID BILL_TO_CONTACT_ID SHIP_TO_CONTACT_ID SALES_CHANNEL UOM_CODE REASON_CODE CLSFN_RULE_ID ROLE_ID TERR_ID TERR_NAME COUNTRY STATE CITY PROVINCE POSTAL_CODE AREA_CODE CHANGED_TRX_FLAG HOLD_FLAG PRESERVE_CREDIT_FLAG WORKER_ID REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_NUMBER21 ATTRIBUTE_NUMBER22 ATTRIBUTE_NUMBER23 ATTRIBUTE_NUMBER24 ATTRIBUTE_NUMBER25 ATTRIBUTE_NUMBER26 ATTRIBUTE_NUMBER27 ATTRIBUTE_NUMBER28 ATTRIBUTE_NUMBER29 ATTRIBUTE_NUMBER30 ATTRIBUTE31 ATTRIBUTE32 ATTRIBUTE33 ATTRIBUTE34 ATTRIBUTE35 ATTRIBUTE36 ATTRIBUTE37 ATTRIBUTE38 ATTRIBUTE39 ATTRIBUTE40 ATTRIBUTE41 ATTRIBUTE42 ATTRIBUTE43 ATTRIBUTE44 ATTRIBUTE45 ATTRIBUTE_NUMBER31 ATTRIBUTE_NUMBER32 ATTRIBUTE_NUMBER33 ATTRIBUTE_NUMBER34 ATTRIBUTE_NUMBER35 ATTRIBUTE_NUMBER36 ATTRIBUTE_NUMBER37 ATTRIBUTE_NUMBER38 ATTRIBUTE_NUMBER39 ATTRIBUTE_NUMBER40 ATTRIBUTE_NUMBER41 ATTRIBUTE_NUMBER42 ATTRIBUTE_NUMBER43 ATTRIBUTE_NUMBER44 ATTRIBUTE_NUMBER45 ATTRIBUTE_NUMBER46 ATTRIBUTE_NUMBER47 ATTRIBUTE_NUMBER48 ATTRIBUTE_NUMBER49 ATTRIBUTE_NUMBER50 ATTRIBUTE46 ATTRIBUTE47 ATTRIBUTE48 ATTRIBUTE49 ATTRIBUTE50 ATTRIBUTE51 ATTRIBUTE52 ATTRIBUTE53 ATTRIBUTE54 ATTRIBUTE55 ATTRIBUTE56 ATTRIBUTE57 ATTRIBUTE58 ATTRIBUTE59 ATTRIBUTE60 ATTRIBUTE61 ATTRIBUTE62 ATTRIBUTE63 ATTRIBUTE64 ATTRIBUTE65 ATTRIBUTE66 ATTRIBUTE67 ATTRIBUTE68 ATTRIBUTE69 ATTRIBUTE70 ATTRIBUTE71 ATTRIBUTE72 ATTRIBUTE73 ATTRIBUTE74 ATTRIBUTE75 ATTRIBUTE76 ATTRIBUTE77 ATTRIBUTE78 ATTRIBUTE79 ATTRIBUTE80 ATTRIBUTE81 ATTRIBUTE82 ATTRIBUTE83 ATTRIBUTE84 ATTRIBUTE85 ATTRIBUTE86 ATTRIBUTE87 ATTRIBUTE88 ATTRIBUTE89 ATTRIBUTE90 ATTRIBUTE91 ATTRIBUTE92 ATTRIBUTE93 ATTRIBUTE94 ATTRIBUTE95 ATTRIBUTE96 ATTRIBUTE97 ATTRIBUTE98 ATTRIBUTE99 ATTRIBUTE100 ATTRIBUTE101 ATTRIBUTE102 ATTRIBUTE103 ATTRIBUTE104 ATTRIBUTE105 ATTRIBUTE106 ATTRIBUTE107 ATTRIBUTE108 ATTRIBUTE109 ATTRIBUTE110 ATTRIBUTE111 ATTRIBUTE112 ATTRIBUTE113 ATTRIBUTE114 ATTRIBUTE115 ATTRIBUTE116 ATTRIBUTE117 ATTRIBUTE118 ATTRIBUTE119 ATTRIBUTE120 ATTRIBUTE121 ATTRIBUTE122 ATTRIBUTE123 ATTRIBUTE124 ATTRIBUTE125 ATTRIBUTE126 ATTRIBUTE127 ATTRIBUTE128 ATTRIBUTE129 ATTRIBUTE130 ATTRIBUTE131 ATTRIBUTE132 ATTRIBUTE133 ATTRIBUTE134 ATTRIBUTE135 ATTRIBUTE136 ATTRIBUTE137 ATTRIBUTE138 ATTRIBUTE139 ATTRIBUTE140 ATTRIBUTE141 ATTRIBUTE142 ATTRIBUTE143 ATTRIBUTE144 ATTRIBUTE145 ATTRIBUTE146 ATTRIBUTE147 ATTRIBUTE148 ATTRIBUTE149 ATTRIBUTE150 ERROR_CODE

Query

SQL_Statement

select simulation_id, TRANSACTION_ID, OBJECT_VERSION_NUMBER, PARTICIPANT_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, CREDIT_DATE, ROLLUP_DATE, TRANSACTION_AMT_SOURCE_CURR, SOURCE_CURRENCY_CODE, TRANSACTION_AMT_FUNC_CURR, SOURCE_TO_FUNC_CURR_CNVRT, DISCOUNT_PERCENTAGE, MARGIN_PERCENTAGE, TRANSACTION_QTY, TRANSACTION_SUB_TYPE, TRANSACTION_TYPE, NEW_TRANSACTION_ID, ELIGIBLE_CAT_ID, SOURCE_TYPE, OBJECT_STATUS, COLLECTION_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, PROCESS_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SOURCE_TRX_ID, SOURCE_TRX_LINE_ID, SOURCE_TRX_SALES_LINE_ID, CUSTOMER_ID, INVENTORY_ITEM_ID, ORDER_NUMBER, BOOKED_DATE, INVOICE_NUMBER, INVOICE_DATE, BILL_TO_ADDRESS_ID, SHIP_TO_ADDRESS_ID, BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID, SALES_CHANNEL, UOM_CODE, REASON_CODE, CLSFN_RULE_ID, ROLE_ID, TERR_ID, TERR_NAME, COUNTRY, STATE, CITY, PROVINCE, POSTAL_CODE, AREA_CODE, CHANGED_TRX_FLAG, HOLD_FLAG, PRESERVE_CREDIT_FLAG, WORKER_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_NUMBER1, ATTRIBUTE_NUMBER2, ATTRIBUTE_NUMBER3, ATTRIBUTE_NUMBER4, ATTRIBUTE_NUMBER5, ATTRIBUTE_NUMBER6, ATTRIBUTE_NUMBER7, ATTRIBUTE_NUMBER8, ATTRIBUTE_NUMBER9, ATTRIBUTE_NUMBER10, ATTRIBUTE_NUMBER11, ATTRIBUTE_NUMBER12, ATTRIBUTE_NUMBER13, ATTRIBUTE_NUMBER14, ATTRIBUTE_NUMBER15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ATTRIBUTE_NUMBER16, ATTRIBUTE_NUMBER17, ATTRIBUTE_NUMBER18, ATTRIBUTE_NUMBER19, ATTRIBUTE_NUMBER20, ATTRIBUTE_NUMBER21, ATTRIBUTE_NUMBER22, ATTRIBUTE_NUMBER23, ATTRIBUTE_NUMBER24, ATTRIBUTE_NUMBER25, ATTRIBUTE_NUMBER26, ATTRIBUTE_NUMBER27, ATTRIBUTE_NUMBER28, ATTRIBUTE_NUMBER29, ATTRIBUTE_NUMBER30, ATTRIBUTE31, ATTRIBUTE32, ATTRIBUTE33, ATTRIBUTE34, ATTRIBUTE35, ATTRIBUTE36, ATTRIBUTE37, ATTRIBUTE38, ATTRIBUTE39, ATTRIBUTE40, ATTRIBUTE41, ATTRIBUTE42, ATTRIBUTE43, ATTRIBUTE44, ATTRIBUTE45, ATTRIBUTE_NUMBER31, ATTRIBUTE_NUMBER32, ATTRIBUTE_NUMBER33, ATTRIBUTE_NUMBER34, ATTRIBUTE_NUMBER35, ATTRIBUTE_NUMBER36, ATTRIBUTE_NUMBER37, ATTRIBUTE_NUMBER38, ATTRIBUTE_NUMBER39, ATTRIBUTE_NUMBER40, ATTRIBUTE_NUMBER41, ATTRIBUTE_NUMBER42, ATTRIBUTE_NUMBER43, ATTRIBUTE_NUMBER44, ATTRIBUTE_NUMBER45, ATTRIBUTE_NUMBER46, ATTRIBUTE_NUMBER47, ATTRIBUTE_NUMBER48, ATTRIBUTE_NUMBER49, ATTRIBUTE_NUMBER50, ATTRIBUTE46, ATTRIBUTE47, ATTRIBUTE48, ATTRIBUTE49, ATTRIBUTE50, ATTRIBUTE51, ATTRIBUTE52, ATTRIBUTE53, ATTRIBUTE54, ATTRIBUTE55, ATTRIBUTE56, ATTRIBUTE57, ATTRIBUTE58, ATTRIBUTE59, ATTRIBUTE60, ATTRIBUTE61, ATTRIBUTE62, ATTRIBUTE63, ATTRIBUTE64, ATTRIBUTE65, ATTRIBUTE66, ATTRIBUTE67, ATTRIBUTE68, ATTRIBUTE69, ATTRIBUTE70, ATTRIBUTE71, ATTRIBUTE72, ATTRIBUTE73, ATTRIBUTE74, ATTRIBUTE75, ATTRIBUTE76, ATTRIBUTE77, ATTRIBUTE78, ATTRIBUTE79, ATTRIBUTE80, ATTRIBUTE81, ATTRIBUTE82, ATTRIBUTE83, ATTRIBUTE84, ATTRIBUTE85, ATTRIBUTE86, ATTRIBUTE87, ATTRIBUTE88, ATTRIBUTE89, ATTRIBUTE90, ATTRIBUTE91, ATTRIBUTE92, ATTRIBUTE93, ATTRIBUTE94, ATTRIBUTE95, ATTRIBUTE96, ATTRIBUTE97, ATTRIBUTE98, ATTRIBUTE99, ATTRIBUTE100, ATTRIBUTE101, ATTRIBUTE102, ATTRIBUTE103, ATTRIBUTE104, ATTRIBUTE105, ATTRIBUTE106, ATTRIBUTE107, ATTRIBUTE108, ATTRIBUTE109, ATTRIBUTE110, ATTRIBUTE111, ATTRIBUTE112, ATTRIBUTE113, ATTRIBUTE114, ATTRIBUTE115, ATTRIBUTE116, ATTRIBUTE117, ATTRIBUTE118, ATTRIBUTE119, ATTRIBUTE120, ATTRIBUTE121, ATTRIBUTE122, ATTRIBUTE123, ATTRIBUTE124, ATTRIBUTE125, ATTRIBUTE126, ATTRIBUTE127, ATTRIBUTE128, ATTRIBUTE129, ATTRIBUTE130, ATTRIBUTE131, ATTRIBUTE132, ATTRIBUTE133, ATTRIBUTE134, ATTRIBUTE135, ATTRIBUTE136, ATTRIBUTE137, ATTRIBUTE138, ATTRIBUTE139, ATTRIBUTE140, ATTRIBUTE141, ATTRIBUTE142, ATTRIBUTE143, ATTRIBUTE144, ATTRIBUTE145, ATTRIBUTE146, ATTRIBUTE147, ATTRIBUTE148, ATTRIBUTE149, ATTRIBUTE150, ERROR_CODE from ( select null simulation_id, 'N' simulation_delete_flag, TRANSACTION_ID, OBJECT_VERSION_NUMBER, PARTICIPANT_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, CREDIT_DATE, ROLLUP_DATE, TRANSACTION_AMT_SOURCE_CURR, SOURCE_CURRENCY_CODE, TRANSACTION_AMT_FUNC_CURR, SOURCE_TO_FUNC_CURR_CNVRT, DISCOUNT_PERCENTAGE, MARGIN_PERCENTAGE, TRANSACTION_QTY, TRANSACTION_SUB_TYPE, TRANSACTION_TYPE, NEW_TRANSACTION_ID, ELIGIBLE_CAT_ID, SOURCE_TYPE, OBJECT_STATUS, COLLECTION_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, PROCESS_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SOURCE_TRX_ID, SOURCE_TRX_LINE_ID, SOURCE_TRX_SALES_LINE_ID, CUSTOMER_ID, INVENTORY_ITEM_ID, ORDER_NUMBER, BOOKED_DATE, INVOICE_NUMBER, INVOICE_DATE, BILL_TO_ADDRESS_ID, SHIP_TO_ADDRESS_ID, BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID, SALES_CHANNEL, UOM_CODE, REASON_CODE, CLSFN_RULE_ID, ROLE_ID, TERR_ID, TERR_NAME, COUNTRY, STATE, CITY, PROVINCE, POSTAL_CODE, AREA_CODE, CHANGED_TRX_FLAG, HOLD_FLAG, PRESERVE_CREDIT_FLAG, WORKER_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_NUMBER1, ATTRIBUTE_NUMBER2, ATTRIBUTE_NUMBER3, ATTRIBUTE_NUMBER4, ATTRIBUTE_NUMBER5, ATTRIBUTE_NUMBER6, ATTRIBUTE_NUMBER7, ATTRIBUTE_NUMBER8, ATTRIBUTE_NUMBER9, ATTRIBUTE_NUMBER10, ATTRIBUTE_NUMBER11, ATTRIBUTE_NUMBER12, ATTRIBUTE_NUMBER13, ATTRIBUTE_NUMBER14, ATTRIBUTE_NUMBER15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ATTRIBUTE_NUMBER16, ATTRIBUTE_NUMBER17, ATTRIBUTE_NUMBER18, ATTRIBUTE_NUMBER19, ATTRIBUTE_NUMBER20, ATTRIBUTE_NUMBER21, ATTRIBUTE_NUMBER22, ATTRIBUTE_NUMBER23, ATTRIBUTE_NUMBER24, ATTRIBUTE_NUMBER25, ATTRIBUTE_NUMBER26, ATTRIBUTE_NUMBER27, ATTRIBUTE_NUMBER28, ATTRIBUTE_NUMBER29, ATTRIBUTE_NUMBER30, ATTRIBUTE31, ATTRIBUTE32, ATTRIBUTE33, ATTRIBUTE34, ATTRIBUTE35, ATTRIBUTE36, ATTRIBUTE37, ATTRIBUTE38, ATTRIBUTE39, ATTRIBUTE40, ATTRIBUTE41, ATTRIBUTE42, ATTRIBUTE43, ATTRIBUTE44, ATTRIBUTE45, ATTRIBUTE_NUMBER31, ATTRIBUTE_NUMBER32, ATTRIBUTE_NUMBER33, ATTRIBUTE_NUMBER34, ATTRIBUTE_NUMBER35, ATTRIBUTE_NUMBER36, ATTRIBUTE_NUMBER37, ATTRIBUTE_NUMBER38, ATTRIBUTE_NUMBER39, ATTRIBUTE_NUMBER40, ATTRIBUTE_NUMBER41, ATTRIBUTE_NUMBER42, ATTRIBUTE_NUMBER43, ATTRIBUTE_NUMBER44, ATTRIBUTE_NUMBER45, ATTRIBUTE_NUMBER46, ATTRIBUTE_NUMBER47, ATTRIBUTE_NUMBER48, ATTRIBUTE_NUMBER49, ATTRIBUTE_NUMBER50, ATTRIBUTE46, ATTRIBUTE47, ATTRIBUTE48, ATTRIBUTE49, ATTRIBUTE50, ATTRIBUTE51, ATTRIBUTE52, ATTRIBUTE53, ATTRIBUTE54, ATTRIBUTE55, ATTRIBUTE56, ATTRIBUTE57, ATTRIBUTE58, ATTRIBUTE59, ATTRIBUTE60, ATTRIBUTE61, ATTRIBUTE62, ATTRIBUTE63, ATTRIBUTE64, ATTRIBUTE65, ATTRIBUTE66, ATTRIBUTE67, ATTRIBUTE68, ATTRIBUTE69, ATTRIBUTE70, ATTRIBUTE71, ATTRIBUTE72, ATTRIBUTE73, ATTRIBUTE74, ATTRIBUTE75, ATTRIBUTE76, ATTRIBUTE77, ATTRIBUTE78, ATTRIBUTE79, ATTRIBUTE80, ATTRIBUTE81, ATTRIBUTE82, ATTRIBUTE83, ATTRIBUTE84, ATTRIBUTE85, ATTRIBUTE86, ATTRIBUTE87, ATTRIBUTE88, ATTRIBUTE89, ATTRIBUTE90, ATTRIBUTE91, ATTRIBUTE92, ATTRIBUTE93, ATTRIBUTE94, ATTRIBUTE95, ATTRIBUTE96, ATTRIBUTE97, ATTRIBUTE98, ATTRIBUTE99, ATTRIBUTE100, ATTRIBUTE101, ATTRIBUTE102, ATTRIBUTE103, ATTRIBUTE104, ATTRIBUTE105, ATTRIBUTE106, ATTRIBUTE107, ATTRIBUTE108, ATTRIBUTE109, ATTRIBUTE110, ATTRIBUTE111, ATTRIBUTE112, ATTRIBUTE113, ATTRIBUTE114, ATTRIBUTE115, ATTRIBUTE116, ATTRIBUTE117, ATTRIBUTE118, ATTRIBUTE119, ATTRIBUTE120, ATTRIBUTE121, ATTRIBUTE122, ATTRIBUTE123, ATTRIBUTE124, ATTRIBUTE125, ATTRIBUTE126, ATTRIBUTE127, ATTRIBUTE128, ATTRIBUTE129, ATTRIBUTE130, ATTRIBUTE131, ATTRIBUTE132, ATTRIBUTE133, ATTRIBUTE134, ATTRIBUTE135, ATTRIBUTE136, ATTRIBUTE137, ATTRIBUTE138, ATTRIBUTE139, ATTRIBUTE140, ATTRIBUTE141, ATTRIBUTE142, ATTRIBUTE143, ATTRIBUTE144, ATTRIBUTE145, ATTRIBUTE146, ATTRIBUTE147, ATTRIBUTE148, ATTRIBUTE149, ATTRIBUTE150, ERROR_CODE from cn_tp_transactions_all tp where sys_context('fusion_ic_cn', 'calc_mode') = 'R' or (sys_context('fusion_ic_cn', 'calc_mode') = 'S' and not exists ( select 1 from cn_sim_transactions_all sim where simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and tp.TRANSACTION_ID = sim.TRANSACTION_ID ) ) union all ( select simulation_id, simulation_delete_flag, TRANSACTION_ID, OBJECT_VERSION_NUMBER, PARTICIPANT_ID, SOURCE_EVENT_DATE, SOURCE_EVENT_PERIOD_ID, CREDIT_DATE, ROLLUP_DATE, TRANSACTION_AMT_SOURCE_CURR, SOURCE_CURRENCY_CODE, TRANSACTION_AMT_FUNC_CURR, SOURCE_TO_FUNC_CURR_CNVRT, DISCOUNT_PERCENTAGE, MARGIN_PERCENTAGE, TRANSACTION_QTY, TRANSACTION_SUB_TYPE, TRANSACTION_TYPE, NEW_TRANSACTION_ID, ELIGIBLE_CAT_ID, SOURCE_TYPE, OBJECT_STATUS, COLLECTION_STATUS, ADJUSTMENT_STATUS, ADJUSTMENT_COMMENTS, PROCESS_CODE, SOURCE_ORG_ID, ORG_ID, SOURCE_TRX_NUMBER, SOURCE_TRX_ID, SOURCE_TRX_LINE_ID, SOURCE_TRX_SALES_LINE_ID, CUSTOMER_ID, INVENTORY_ITEM_ID, ORDER_NUMBER, BOOKED_DATE, INVOICE_NUMBER, INVOICE_DATE, BILL_TO_ADDRESS_ID, SHIP_TO_ADDRESS_ID, BILL_TO_CONTACT_ID, SHIP_TO_CONTACT_ID, SALES_CHANNEL, UOM_CODE, REASON_CODE, CLSFN_RULE_ID, ROLE_ID, TERR_ID, TERR_NAME, COUNTRY, STATE, CITY, PROVINCE, POSTAL_CODE, AREA_CODE, CHANGED_TRX_FLAG, HOLD_FLAG, PRESERVE_CREDIT_FLAG, WORKER_ID, REQUEST_ID, JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE_NUMBER1, ATTRIBUTE_NUMBER2, ATTRIBUTE_NUMBER3, ATTRIBUTE_NUMBER4, ATTRIBUTE_NUMBER5, ATTRIBUTE_NUMBER6, ATTRIBUTE_NUMBER7, ATTRIBUTE_NUMBER8, ATTRIBUTE_NUMBER9, ATTRIBUTE_NUMBER10, ATTRIBUTE_NUMBER11, ATTRIBUTE_NUMBER12, ATTRIBUTE_NUMBER13, ATTRIBUTE_NUMBER14, ATTRIBUTE_NUMBER15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, ATTRIBUTE_NUMBER16, ATTRIBUTE_NUMBER17, ATTRIBUTE_NUMBER18, ATTRIBUTE_NUMBER19, ATTRIBUTE_NUMBER20, ATTRIBUTE_NUMBER21, ATTRIBUTE_NUMBER22, ATTRIBUTE_NUMBER23, ATTRIBUTE_NUMBER24, ATTRIBUTE_NUMBER25, ATTRIBUTE_NUMBER26, ATTRIBUTE_NUMBER27, ATTRIBUTE_NUMBER28, ATTRIBUTE_NUMBER29, ATTRIBUTE_NUMBER30, ATTRIBUTE31, ATTRIBUTE32, ATTRIBUTE33, ATTRIBUTE34, ATTRIBUTE35, ATTRIBUTE36, ATTRIBUTE37, ATTRIBUTE38, ATTRIBUTE39, ATTRIBUTE40, ATTRIBUTE41, ATTRIBUTE42, ATTRIBUTE43, ATTRIBUTE44, ATTRIBUTE45, ATTRIBUTE_NUMBER31, ATTRIBUTE_NUMBER32, ATTRIBUTE_NUMBER33, ATTRIBUTE_NUMBER34, ATTRIBUTE_NUMBER35, ATTRIBUTE_NUMBER36, ATTRIBUTE_NUMBER37, ATTRIBUTE_NUMBER38, ATTRIBUTE_NUMBER39, ATTRIBUTE_NUMBER40, ATTRIBUTE_NUMBER41, ATTRIBUTE_NUMBER42, ATTRIBUTE_NUMBER43, ATTRIBUTE_NUMBER44, ATTRIBUTE_NUMBER45, ATTRIBUTE_NUMBER46, ATTRIBUTE_NUMBER47, ATTRIBUTE_NUMBER48, ATTRIBUTE_NUMBER49, ATTRIBUTE_NUMBER50, ATTRIBUTE46, ATTRIBUTE47, ATTRIBUTE48, ATTRIBUTE49, ATTRIBUTE50, ATTRIBUTE51, ATTRIBUTE52, ATTRIBUTE53, ATTRIBUTE54, ATTRIBUTE55, ATTRIBUTE56, ATTRIBUTE57, ATTRIBUTE58, ATTRIBUTE59, ATTRIBUTE60, ATTRIBUTE61, ATTRIBUTE62, ATTRIBUTE63, ATTRIBUTE64, ATTRIBUTE65, ATTRIBUTE66, ATTRIBUTE67, ATTRIBUTE68, ATTRIBUTE69, ATTRIBUTE70, ATTRIBUTE71, ATTRIBUTE72, ATTRIBUTE73, ATTRIBUTE74, ATTRIBUTE75, ATTRIBUTE76, ATTRIBUTE77, ATTRIBUTE78, ATTRIBUTE79, ATTRIBUTE80, ATTRIBUTE81, ATTRIBUTE82, ATTRIBUTE83, ATTRIBUTE84, ATTRIBUTE85, ATTRIBUTE86, ATTRIBUTE87, ATTRIBUTE88, ATTRIBUTE89, ATTRIBUTE90, ATTRIBUTE91, ATTRIBUTE92, ATTRIBUTE93, ATTRIBUTE94, ATTRIBUTE95, ATTRIBUTE96, ATTRIBUTE97, ATTRIBUTE98, ATTRIBUTE99, ATTRIBUTE100, ATTRIBUTE101, ATTRIBUTE102, ATTRIBUTE103, ATTRIBUTE104, ATTRIBUTE105, ATTRIBUTE106, ATTRIBUTE107, ATTRIBUTE108, ATTRIBUTE109, ATTRIBUTE110, ATTRIBUTE111, ATTRIBUTE112, ATTRIBUTE113, ATTRIBUTE114, ATTRIBUTE115, ATTRIBUTE116, ATTRIBUTE117, ATTRIBUTE118, ATTRIBUTE119, ATTRIBUTE120, ATTRIBUTE121, ATTRIBUTE122, ATTRIBUTE123, ATTRIBUTE124, ATTRIBUTE125, ATTRIBUTE126, ATTRIBUTE127, ATTRIBUTE128, ATTRIBUTE129, ATTRIBUTE130, ATTRIBUTE131, ATTRIBUTE132, ATTRIBUTE133, ATTRIBUTE134, ATTRIBUTE135, ATTRIBUTE136, ATTRIBUTE137, ATTRIBUTE138, ATTRIBUTE139, ATTRIBUTE140, ATTRIBUTE141, ATTRIBUTE142, ATTRIBUTE143, ATTRIBUTE144, ATTRIBUTE145, ATTRIBUTE146, ATTRIBUTE147, ATTRIBUTE148, ATTRIBUTE149, ATTRIBUTE150, ERROR_CODE from cn_sim_transactions_all sim where sys_context('fusion_ic_cn', 'calc_mode') = 'S' and simulation_id = to_number(sys_context('fusion_ic_cn', 'calc_simulation_id')) and simulation_delete_flag = 'N' ) )