We had to pull the plug on a production deployment yesterday because of an anomaly discovered in the 11th hour in our Staging (pre-production) environment.
An Entity Query that works perfectly in our Dev and Test environments, was not returning all the expected records in the Staging environment.

We are using IdeaBlade DevForce for Silverlight (v5.2.4), Devart dotConnect for Oracle (v5.35.62), and the MS Entity Framework (.Net 3.5).

I have an entity query like so:

[code]public IEntityQuery ConfirmationsFilteredQuery(object[] parameters)
{
	var filter = (BasicFilter)parameters[0];
	var confirmationsQuery = this.ConfirmationsBaseQuery(null);

	return confirmationsQuery
		.Where(c => c.DealSnapShot.FlowDateEnd >= filter.FlowDateStart)
		.Where(c => c.DealSnapShot.FlowDateStart <= filter.FlowDateEnd)
		.Where(c => c.ConfStatusId == (long)filter.SelectedStatus)
		.With(QueryStrategy.DataSourceOnly);
}

private IEntityQuery<DealConfirmation> ConfirmationsBaseQuery(object[] parameters)
{
	var em = (ConfirmationEntityManager)this.PersistenceContext.EntityManager;
	return em.DealConfirmations
		.Include(DealConfirmation.EntityPropertyNames.DealConfContacts)
		.Include(DealConfirmation.EntityPropertyNames.DealConfContacts + "." + DealConfContact.EntityPropertyNames.Contact)
		.Include(DealConfirmation.EntityPropertyNames.DealSnapShot + "." + DealSnapShot.EntityPropertyNames.DealPricingSnapShots)
		.Include(DealConfirmation.EntityPropertyNames.DealSnapShot + "." + DealSnapShot.EntityPropertyNames.DealTrxPricingSnapShots)
		.Include(DealConfirmation.EntityPropertyNames.DealSnapShot + "." + DealSnapShot.EntityPropertyNames.DealTrxSnapShots);
}[/code]

When I execute this query, the generated SQL looks like (hold your nose) this:

[code]SELECT "UnionAll3".C2 AS C1,
   "UnionAll3".C3 AS C2,
   "UnionAll3".C4 AS C3,
   "UnionAll3".C5 AS C4,
   "UnionAll3".C6 AS C5,
   "UnionAll3".C7 AS C6,
   "UnionAll3".C8 AS C7,
   "UnionAll3".C9 AS C8,
   "UnionAll3".C10 AS C9,
   "UnionAll3".C11 AS C10,
   "UnionAll3".C12 AS C11,
   "UnionAll3".C13 AS C12,
   "UnionAll3".C14 AS C13,
   "UnionAll3".C15 AS C14,
   "UnionAll3".C16 AS C15,
   "UnionAll3".C17 AS C16,
   "UnionAll3".C18 AS C17,
   "UnionAll3".C19 AS C18,
   "UnionAll3".C20 AS C19,
   "UnionAll3".C21 AS C20,
   "UnionAll3".C22 AS C21,
   "UnionAll3".C23 AS C22,
   "UnionAll3".C24 AS C23,
   "UnionAll3".C25 AS C24,
   "UnionAll3".C26 AS C25,
   "UnionAll3".C27 AS C26,
   "UnionAll3".C28 AS C27,
   "UnionAll3".C29 AS C28,
   "UnionAll3".C30 AS C29,
   "UnionAll3".C31 AS C30,
   "UnionAll3".C32 AS C31,
   "UnionAll3".C33 AS C32,
   "UnionAll3".C34 AS C33,
   "UnionAll3".C35 AS C34,
   "UnionAll3".C36 AS C35,
   "UnionAll3".C37 AS C36,
   "UnionAll3".C38 AS C37,
   "UnionAll3".C39 AS C38,
   "UnionAll3".C40 AS C39,
   "UnionAll3".C41 AS C40,
   "UnionAll3".C42 AS C41,
   "UnionAll3".C43 AS C42,
   "UnionAll3".C44 AS C43,
   "UnionAll3".C45 AS C44,
   "UnionAll3".C46 AS C45,
   "UnionAll3".C47 AS C46,
   "UnionAll3".C48 AS C47,
   "UnionAll3".C49 AS C48,
   "UnionAll3".C50 AS C49,
   "UnionAll3".C51 AS C50,
   "UnionAll3".C52 AS C51,
   "UnionAll3".C53 AS C52,
   "UnionAll3".C54 AS C53,
   "UnionAll3".C55 AS C54,
   "UnionAll3".C56 AS C55,
   "UnionAll3".C57 AS C56,
   "UnionAll3".C58 AS C57,
   "UnionAll3".C59 AS C58,
   "UnionAll3".C60 AS C59,
   "UnionAll3".C61 AS C60,
   "UnionAll3".C62 AS C61,
   "UnionAll3".C63 AS C62,
   "UnionAll3".C64 AS C63,
   "UnionAll3".C65 AS C64,
   "UnionAll3".C66 AS C65,
   "UnionAll3".C67 AS C66,
   "UnionAll3".C68 AS C67,
   "UnionAll3".C69 AS C68,
   "UnionAll3".C70 AS C69,
   "UnionAll3".C71 AS C70,
   "UnionAll3".C1 AS C71,
   "UnionAll3".C72 AS C72,
   "UnionAll3".C73 AS C73,
   "UnionAll3".C74 AS C74,
   "UnionAll3".C75 AS C75,
   "UnionAll3".C76 AS C76,
   "UnionAll3".C77 AS C77,
   "UnionAll3".C78 AS C78,
   "UnionAll3".C79 AS C79,
   "UnionAll3".C80 AS C80,
   "UnionAll3".C81 AS C81,
   "UnionAll3".C82 AS C82,
   "UnionAll3".C83 AS C83,
   "UnionAll3".C84 AS C84,
   "UnionAll3".C85 AS C85,
   "UnionAll3".C86 AS C86,
   "UnionAll3".C87 AS C87,
   "UnionAll3".C88 AS C88,
   "UnionAll3".C89 AS C89,
   "UnionAll3".C90 AS C90,
   "UnionAll3".C91 AS C91,
   "UnionAll3".C92 AS C92,
   "UnionAll3".C93 AS C93,
   "UnionAll3".C94 AS C94,
   "UnionAll3".C95 AS C95,
   "UnionAll3".C96 AS C96,
   "UnionAll3".C97 AS C97,
   "UnionAll3".C98 AS C98,
   "UnionAll3".C99 AS C99,
   "UnionAll3".C100 AS C100,
   "UnionAll3".C101 AS C101,
   "UnionAll3".C102 AS C102,
   "UnionAll3".C103 AS C103,
   "UnionAll3".C104 AS C104,
   "UnionAll3".C105 AS C105,
   "UnionAll3".C106 AS C106,
   "UnionAll3".C107 AS C107,
   "UnionAll3".C108 AS C108,
   "UnionAll3".C109 AS C109,
   "UnionAll3".C110 AS C110,
   "UnionAll3".C111 AS C111,
   "UnionAll3".C112 AS C112,
   "UnionAll3".C113 AS C113,
   "UnionAll3".C114 AS C114,
   "UnionAll3".C115 AS C115,
   "UnionAll3".C116 AS C116,
   "UnionAll3".C117 AS C117,
   "UnionAll3".C118 AS C118,
   "UnionAll3".C119 AS C119,
   "UnionAll3".C120 AS C120,
   "UnionAll3".C121 AS C121,
   "UnionAll3".C122 AS C122,
   "UnionAll3".C123 AS C123,
   "UnionAll3".C124 AS C124,
   "UnionAll3".C125 AS C125,
   "UnionAll3".C126 AS C126,
   "UnionAll3".C127 AS C127,
   "UnionAll3".C128 AS C128,
   "UnionAll3".C129 AS C129,
   "UnionAll3".C130 AS C130,
   "UnionAll3".C131 AS C131,
   "UnionAll3".C132 AS C132,
   "UnionAll3".C133 AS C133,
   "UnionAll3".C134 AS C134,
   "UnionAll3".C135 AS C135,
   "UnionAll3".C136 AS C136,
   "UnionAll3".C137 AS C137,
   "UnionAll3".C138 AS C138,
   "UnionAll3".C139 AS C139,
   "UnionAll3".C140 AS C140,
   "UnionAll3".C141 AS C141,
   "UnionAll3".C142 AS C142,
   "UnionAll3".C143 AS C143,
   "UnionAll3".C144 AS C144,
   "UnionAll3".C145 AS C145,
   "UnionAll3".C146 AS C146,
   "UnionAll3".C147 AS C147,
   "UnionAll3".C148 AS C148,
   "UnionAll3".C149 AS C149,
   "UnionAll3".C150 AS C150,
   "UnionAll3".C151 AS C151,
   "UnionAll3".C152 AS C152,
   "UnionAll3".C153 AS C153,
   "UnionAll3".C154 AS C154,
   "UnionAll3".C155 AS C155,
   "UnionAll3".C156 AS C156,
   "UnionAll3".C157 AS C157,
   "UnionAll3".C158 AS C158,
   "UnionAll3".C159 AS C159,
   "UnionAll3".C160 AS C160,
   "UnionAll3".C161 AS C161,
   "UnionAll3".C162 AS C162,
   "UnionAll3".C163 AS C163,
   "UnionAll3".C164 AS C164,
   "UnionAll3".C165 AS C165,
   "UnionAll3".C166 AS C166,
   "UnionAll3".C167 AS C167,
   "UnionAll3".C168 AS C168,
   "UnionAll3".C169 AS C169,
   "UnionAll3".C170 AS C170,
   "UnionAll3".C171 AS C171,
   "UnionAll3".C172 AS C172,
   "UnionAll3".C173 AS C173,
   "UnionAll3".C174 AS C174,
   "UnionAll3".C175 AS C175,
   "UnionAll3".C176 AS C176,
   "UnionAll3".C177 AS C177,
   "UnionAll3".C178 AS C178,
   "UnionAll3".C179 AS C179,
   "UnionAll3".C180 AS C180,
   "UnionAll3".C181 AS C181
FROM (
   SELECT "UnionAll2".C1 AS C1,
      "UnionAll2".C2 AS C2,
      "UnionAll2".C3 AS C3,
      "UnionAll2".C4 AS C4,
      "UnionAll2".C5 AS C5,
      "UnionAll2".C6 AS C6,
      "UnionAll2".C7 AS C7,
      "UnionAll2".C8 AS C8,
      "UnionAll2".C9 AS C9,
      "UnionAll2".C10 AS C10,
      "UnionAll2".C11 AS C11,
      "UnionAll2".C12 AS C12,
      "UnionAll2".C13 AS C13,
      "UnionAll2".C14 AS C14,
      "UnionAll2".C15 AS C15,
      "UnionAll2".C16 AS C16,
      "UnionAll2".C17 AS C17,
      "UnionAll2".C18 AS C18,
      "UnionAll2".C19 AS C19,
      "UnionAll2".C20 AS C20,
      "UnionAll2".C21 AS C21,
      "UnionAll2".C22 AS C22,
      "UnionAll2".C23 AS C23,
      "UnionAll2".C24 AS C24,
      "UnionAll2".C25 AS C25,
      "UnionAll2".C26 AS C26,
      "UnionAll2".C27 AS C27,
      "UnionAll2".C28 AS C28,
      "UnionAll2".C29 AS C29,
      "UnionAll2".C30 AS C30,
      "UnionAll2".C31 AS C31,
      "UnionAll2".C32 AS C32,
      "UnionAll2".C33 AS C33,
      "UnionAll2".C34 AS C34,
      "UnionAll2".C35 AS C35,
      "UnionAll2".C36 AS C36,
      "UnionAll2".C37 AS C37,
      "UnionAll2".C38 AS C38,
      "UnionAll2".C39 AS C39,
      "UnionAll2".C40 AS C40,
      "UnionAll2".C41 AS C41,
      "UnionAll2".C42 AS C42,
      "UnionAll2".C43 AS C43,
      "UnionAll2".C44 AS C44,
      "UnionAll2".C45 AS C45,
      "UnionAll2".C46 AS C46,
      "UnionAll2".C47 AS C47,
      "UnionAll2".C48 AS C48,
      "UnionAll2".C49 AS C49,
      "UnionAll2".C50 AS C50,
      "UnionAll2".C51 AS C51,
      "UnionAll2".C52 AS C52,
      "UnionAll2".C53 AS C53,
      "UnionAll2".C54 AS C54,
      "UnionAll2".C55 AS C55,
      "UnionAll2".C56 AS C56,
      "UnionAll2".C57 AS C57,
      "UnionAll2".C58 AS C58,
      "UnionAll2".C59 AS C59,
      "UnionAll2".C60 AS C60,
      "UnionAll2".C61 AS C61,
      "UnionAll2".C62 AS C62,
      "UnionAll2".C63 AS C63,
      "UnionAll2".C64 AS C64,
      "UnionAll2".C65 AS C65,
      "UnionAll2".C66 AS C66,
      "UnionAll2".C67 AS C67,
      "UnionAll2".C68 AS C68,
      "UnionAll2".C69 AS C69,
      "UnionAll2".C70 AS C70,
      "UnionAll2".C71 AS C71,
      "UnionAll2".C72 AS C72,
      "UnionAll2".C73 AS C73,
      "UnionAll2".C74 AS C74,
      "UnionAll2".C75 AS C75,
      "UnionAll2".C76 AS C76,
      "UnionAll2".C77 AS C77,
      "UnionAll2".C78 AS C78,
      "UnionAll2".C79 AS C79,
      "UnionAll2".C80 AS C80,
      "UnionAll2".C81 AS C81,
      "UnionAll2".C82 AS C82,
      "UnionAll2".C83 AS C83,
      "UnionAll2".C84 AS C84,
      "UnionAll2".C85 AS C85,
      "UnionAll2".C86 AS C86,
      "UnionAll2".C87 AS C87,
      "UnionAll2".C88 AS C88,
      "UnionAll2".C89 AS C89,
      "UnionAll2".C90 AS C90,
      "UnionAll2".C91 AS C91,
      "UnionAll2".C92 AS C92,
      "UnionAll2".C93 AS C93,
      "UnionAll2".C94 AS C94,
      "UnionAll2".C95 AS C95,
      "UnionAll2".C96 AS C96,
      "UnionAll2".C97 AS C97,
      "UnionAll2".C98 AS C98,
      "UnionAll2".C99 AS C99,
      "UnionAll2".C100 AS C100,
      "UnionAll2".C101 AS C101,
      "UnionAll2".C102 AS C102,
      "UnionAll2".C103 AS C103,
      "UnionAll2".C104 AS C104,
      "UnionAll2".C105 AS C105,
      "UnionAll2".C106 AS C106,
      "UnionAll2".C107 AS C107,
      "UnionAll2".C108 AS C108,
      "UnionAll2".C109 AS C109,
      "UnionAll2".C110 AS C110,
      "UnionAll2".C111 AS C111,
      "UnionAll2".C112 AS C112,
      "UnionAll2".C113 AS C113,
      "UnionAll2".C114 AS C114,
      "UnionAll2".C115 AS C115,
      "UnionAll2".C116 AS C116,
      "UnionAll2".C117 AS C117,
      "UnionAll2".C118 AS C118,
      "UnionAll2".C119 AS C119,
      "UnionAll2".C120 AS C120,
      "UnionAll2".C121 AS C121,
      "UnionAll2".C122 AS C122,
      "UnionAll2".C123 AS C123,
      "UnionAll2".C124 AS C124,
      "UnionAll2".C125 AS C125,
      "UnionAll2".C126 AS C126,
      "UnionAll2".C127 AS C127,
      "UnionAll2".C128 AS C128,
      "UnionAll2".C129 AS C129,
      "UnionAll2".C130 AS C130,
      "UnionAll2".C131 AS C131,
      "UnionAll2".C132 AS C132,
      "UnionAll2".C133 AS C133,
      "UnionAll2".C134 AS C134,
      "UnionAll2".C135 AS C135,
      "UnionAll2".C136 AS C136,
      "UnionAll2".C137 AS C137,
      "UnionAll2".C138 AS C138,
      "UnionAll2".C139 AS C139,
      "UnionAll2".C140 AS C140,
      "UnionAll2".C141 AS C141,
      "UnionAll2".C142 AS C142,
      "UnionAll2".C143 AS C143,
      "UnionAll2".C144 AS C144,
      "UnionAll2".C145 AS C145,
      "UnionAll2".C146 AS C146,
      "UnionAll2".C147 AS C147,
      "UnionAll2".C148 AS C148,
      "UnionAll2".C149 AS C149,
      "UnionAll2".C150 AS C150,
      "UnionAll2".C151 AS C151,
      "UnionAll2".C152 AS C152,
      "UnionAll2".C153 AS C153,
      "UnionAll2".C154 AS C154,
      "UnionAll2".C155 AS C155,
      "UnionAll2".C156 AS C156,
      "UnionAll2".C157 AS C157,
      "UnionAll2".C158 AS C158,
      "UnionAll2".C159 AS C159,
      "UnionAll2".C160 AS C160,
      "UnionAll2".C161 AS C161,
      "UnionAll2".C162 AS C162,
      "UnionAll2".C163 AS C163,
      "UnionAll2".C164 AS C164,
      "UnionAll2".C165 AS C165,
      "UnionAll2".C166 AS C166,
      "UnionAll2".C167 AS C167,
      "UnionAll2".C168 AS C168,
      "UnionAll2".C169 AS C169,
      "UnionAll2".C170 AS C170,
      "UnionAll2".C171 AS C171,
      "UnionAll2".C172 AS C172,
      "UnionAll2".C173 AS C173,
      "UnionAll2".C174 AS C174,
      "UnionAll2".C175 AS C175,
      "UnionAll2".C176 AS C176,
      "UnionAll2".C177 AS C177,
      "UnionAll2".C178 AS C178,
      "UnionAll2".C179 AS C179,
      "UnionAll2".C180 AS C180,
      "UnionAll2".C181 AS C181
   FROM (
      SELECT "UnionAll1".C1 AS C1,
         "UnionAll1".DEAL_CONFIRM_ID AS C2,
         "UnionAll1".DEAL_ID AS C3,
         "UnionAll1".ACTION_DATE AS C4,
         "UnionAll1".CONF_STATUS_ID AS C5,
         "UnionAll1".CONF_SEND_STATUS_ID AS C6,
         "UnionAll1".CONF_SENT_DATE AS C7,
         "UnionAll1".CONF_SEND_METHOD_OTHER_DESC AS C8,
         "UnionAll1".CONF_RECEIVE_DATE AS C9,
         "UnionAll1".CONF_COMMENT AS C10,
         "UnionAll1".ENTERED_BY AS C11,
         "UnionAll1".LAST_UPDATE_USER AS C12,
         "UnionAll1".LAST_UPDATE_TMS AS C13,
         "UnionAll1".ROW_VERSION AS C14,
         "UnionAll1".PREVENT_SEND AS C15,
         "UnionAll1".DEAL_SS_ID AS C16,
         "UnionAll1".DEAL_SS_ID1 AS C17,
         "UnionAll1".C2 AS C18,
         "UnionAll1".C3 AS C19,
         "UnionAll1".DEAL_SS_ID2 AS C20,
         "UnionAll1".DEAL_ID1 AS C21,
         "UnionAll1".DATE_ENTERED AS C22,
         "UnionAll1".DATE_OF_DEAL AS C23,
         "UnionAll1".FLOW_DATE_START AS C24,
         "UnionAll1".FLOW_DATE_END AS C25,
         "UnionAll1".DEAL_NUMBER AS C26,
         "UnionAll1".BUS_ASSOCIATE_ID AS C27,
         "UnionAll1".BUS_ASSOCIATE_CD AS C28,
         "UnionAll1".BUS_ASSOCIATE_NAME AS C29,
         "UnionAll1".SUPPLY_CONTACT_ID AS C30,
         "UnionAll1".SUPPLY_CONTACT_NAME AS C31,
         "UnionAll1".CONTACT_OTHER AS C32,
         "UnionAll1".MO_CONTACT_ID AS C33,
         "UnionAll1".MO_CONTACT_NAME AS C34,
         "UnionAll1".PIPELINE_ID AS C35,
         "UnionAll1".PIPELINE_CD AS C36,
         "UnionAll1".ZONE_ID AS C37,
         "UnionAll1".ZONE_CD AS C38,
         "UnionAll1".LOCATION_ID AS C39,
         "UnionAll1".LOCATION_CD AS C40,
         "UnionAll1".DEAL_TYPE_ID AS C41,
         "UnionAll1".DEAL_TYPE AS C42,
         "UnionAll1".SUPPLY_CONTRACT_ID AS C43,
         "UnionAll1".SUPPLY_CONTRACT_NBR AS C44,
         "UnionAll1".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS C45,
         "UnionAll1".SUPPLY_CONTRACT_JURISDICTN_CD AS C46,
         "UnionAll1".SUPPLY_CONTRACT_TYPE AS C47,
         "UnionAll1".GMS_BROKER_ACCT_NBR AS C48,
         "UnionAll1".RATE_PLAN_ID AS C49,
         "UnionAll1".PROMOTED AS C50,
         "UnionAll1".DELIVERED AS C51,
         "UnionAll1".CANCELED AS C52,
         "UnionAll1".DEAL_TERMS_CHANGED AS C53,
         "UnionAll1".DEAL_COMMENT AS C54,
         "UnionAll1".ENTERED_BY1 AS C55,
         "UnionAll1".LAST_UPDATE_USER1 AS C56,
         "UnionAll1".LAST_UPDATE_TMS1 AS C57,
         "UnionAll1".NEED_ACCOUNT AS C58,
         "UnionAll1".RESUBMITTED AS C59,
         "UnionAll1".STORAGE_TRANSFER AS C60,
         "UnionAll1".MO_CONTACT_OTHER AS C61,
         "UnionAll1".SPECIAL_CONDITIONS AS C62,
         "UnionAll1".HAS_ATTACHED_SHEET AS C63,
         "UnionAll1".ROW_VERSION1 AS C64,
         "UnionAll1".DEAL552CODE_ID AS C65,
         "UnionAll1".FLOW_DATE_START_YEAR AS C66,
         "UnionAll1".FLOW_DATE_START_MONTH AS C67,
         "UnionAll1".SYNC_TO_GMS_FAILED AS C68,
         "UnionAll1".CONF_RECEIVE_METHOD_ID AS C69,
         "UnionAll1".CONF_SEND_METHOD_ID AS C70,
         "UnionAll1".DEAL_CONFIRM_ID1 AS C71,
         "UnionAll1".C4 AS C72,
         "UnionAll1".DEAL_CONF_CONTACTLIST_ID AS C73,
         "UnionAll1".REMOVED AS C74,
         "UnionAll1".CONF_SEND_METHOD_DESC AS C75,
         "UnionAll1".CONF_SENT_DATE1 AS C76,
         "UnionAll1".INCLUDE_BATCH AS C77,
         "UnionAll1".ENTERED_BY2 AS C78,
         "UnionAll1".LAST_UPDATE_USER2 AS C79,
         "UnionAll1".LAST_UPDATE_TMS2 AS C80,
         "UnionAll1".ROW_VERSION2 AS C81,
         "UnionAll1".DEAL_CONFIRM_ID2 AS C82,
         "UnionAll1".CONTACT_METHOD_ID AS C83,
         "UnionAll1".CONTACT_ID AS C84,
         "UnionAll1".CONTACT_DEPT_ID AS C85,
         "UnionAll1".LN_ID AS C86,
         "UnionAll1".STATUS AS C87,
         "UnionAll1".FIRST_NAME AS C88,
         "UnionAll1".LAST_NAME AS C89,
         "UnionAll1".NAME AS C90,
         "UnionAll1".TITLE AS C91,
         "UnionAll1".COMPANY AS C92,
         "UnionAll1".WORK_PHONE AS C93,
         "UnionAll1".CELL_PHONE AS C94,
         "UnionAll1".FAX AS C95,
         "UnionAll1".EMAIL AS C96,
         "UnionAll1".IM AS C97,
         "UnionAll1".STREET AS C98,
         "UnionAll1".CITY AS C99,
         "UnionAll1".STATE AS C100,
         "UnionAll1".ZIP AS C101,
         "UnionAll1".SEND_CONFIRM AS C102,
         "UnionAll1".AUTO_SEND AS C103,
         "UnionAll1".LN_FLAG AS C104,
         "UnionAll1"."COMMENT" AS C105,
         "UnionAll1".LAST_UPDATE_USER3 AS C106,
         "UnionAll1".LAST_UPDATE_TMS3 AS C107,
         "UnionAll1".ROW_VERSION3 AS C108,
         "UnionAll1".C5 AS C109,
         "UnionAll1".C6 AS C110,
         "UnionAll1".C7 AS C111,
         "UnionAll1".C8 AS C112,
         "UnionAll1".C9 AS C113,
         "UnionAll1".C10 AS C114,
         "UnionAll1".C11 AS C115,
         "UnionAll1".C12 AS C116,
         "UnionAll1".C13 AS C117,
         "UnionAll1".C14 AS C118,
         "UnionAll1".C15 AS C119,
         "UnionAll1".C16 AS C120,
         "UnionAll1".C17 AS C121,
         "UnionAll1".C18 AS C122,
         "UnionAll1".C19 AS C123,
         "UnionAll1".C20 AS C124,
         "UnionAll1".C21 AS C125,
         "UnionAll1".C22 AS C126,
         "UnionAll1".C23 AS C127,
         "UnionAll1".C24 AS C128,
         "UnionAll1".C25 AS C129,
         "UnionAll1".C26 AS C130,
         "UnionAll1".C27 AS C131,
         "UnionAll1".C28 AS C132,
         "UnionAll1".C29 AS C133,
         "UnionAll1".C30 AS C134,
         "UnionAll1".C31 AS C135,
         "UnionAll1".C32 AS C136,
         "UnionAll1".C33 AS C137,
         "UnionAll1".C34 AS C138,
         "UnionAll1".C35 AS C139,
         "UnionAll1".C36 AS C140,
         "UnionAll1".C37 AS C141,
         "UnionAll1".C38 AS C142,
         "UnionAll1".C39 AS C143,
         "UnionAll1".C40 AS C144,
         "UnionAll1".C41 AS C145,
         "UnionAll1".C42 AS C146,
         "UnionAll1".C43 AS C147,
         "UnionAll1".C44 AS C148,
         "UnionAll1".C45 AS C149,
         "UnionAll1".C46 AS C150,
         "UnionAll1".C47 AS C151,
         "UnionAll1".C48 AS C152,
         "UnionAll1".C49 AS C153,
         "UnionAll1".C50 AS C154,
         "UnionAll1".C51 AS C155,
         "UnionAll1".C52 AS C156,
         "UnionAll1".C53 AS C157,
         "UnionAll1".C54 AS C158,
         "UnionAll1".C55 AS C159,
         "UnionAll1".C56 AS C160,
         "UnionAll1".C57 AS C161,
         "UnionAll1".C58 AS C162,
         "UnionAll1".C59 AS C163,
         "UnionAll1".C60 AS C164,
         "UnionAll1".C61 AS C165,
         "UnionAll1".C62 AS C166,
         "UnionAll1".C63 AS C167,
         "UnionAll1".C64 AS C168,
         "UnionAll1".C65 AS C169,
         "UnionAll1".C66 AS C170,
         "UnionAll1".C67 AS C171,
         "UnionAll1".C68 AS C172,
         "UnionAll1".C69 AS C173,
         "UnionAll1".C70 AS C174,
         "UnionAll1".C71 AS C175,
         "UnionAll1".C72 AS C176,
         "UnionAll1".C73 AS C177,
         "UnionAll1".C74 AS C178,
         "UnionAll1".C75 AS C179,
         "UnionAll1".C76 AS C180,
         "UnionAll1".C77 AS C181
      FROM (
         SELECT "Project1".C1 AS C1,
            "Filter1".DEAL_CONFIRM_ID1 AS DEAL_CONFIRM_ID,
            "Filter1".DEAL_ID1 AS DEAL_ID,
            "Filter1".ACTION_DATE AS ACTION_DATE,
            "Filter1".CONF_STATUS_ID AS CONF_STATUS_ID,
            "Filter1".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
            "Filter1".CONF_SENT_DATE AS CONF_SENT_DATE,
            "Filter1".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
            "Filter1".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
            "Filter1".CONF_COMMENT AS CONF_COMMENT,
            "Filter1".ENTERED_BY1 AS ENTERED_BY,
            "Filter1".LAST_UPDATE_USER1 AS LAST_UPDATE_USER,
            "Filter1".LAST_UPDATE_TMS1 AS LAST_UPDATE_TMS,
            "Filter1".ROW_VERSION1 AS ROW_VERSION,
            "Filter1".PREVENT_SEND AS PREVENT_SEND,
            "Filter1".DEAL_SS_ID1 AS DEAL_SS_ID,
            "Extent4".DEAL_SS_ID AS DEAL_SS_ID1,
            1 AS C2,
            1 AS C3,
            "Extent5".DEAL_SS_ID AS DEAL_SS_ID2,
            "Extent5".DEAL_ID AS DEAL_ID1,
            "Extent5".DATE_ENTERED AS DATE_ENTERED,
            "Extent5".DATE_OF_DEAL AS DATE_OF_DEAL,
            "Extent5".FLOW_DATE_START AS FLOW_DATE_START,
            "Extent5".FLOW_DATE_END AS FLOW_DATE_END,
            "Extent5".DEAL_NUMBER AS DEAL_NUMBER,
            "Extent5".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
            "Extent5".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
            "Extent5".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
            "Extent5".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
            "Extent5".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
            "Extent5".CONTACT_OTHER AS CONTACT_OTHER,
            "Extent5".MO_CONTACT_ID AS MO_CONTACT_ID,
            "Extent5".MO_CONTACT_NAME AS MO_CONTACT_NAME,
            "Extent5".PIPELINE_ID AS PIPELINE_ID,
            "Extent5".PIPELINE_CD AS PIPELINE_CD,
            "Extent5".ZONE_ID AS ZONE_ID,
            "Extent5".ZONE_CD AS ZONE_CD,
            "Extent5".LOCATION_ID AS LOCATION_ID,
            "Extent5".LOCATION_CD AS LOCATION_CD,
            "Extent5".DEAL_TYPE_ID AS DEAL_TYPE_ID,
            "Extent5".DEAL_TYPE AS DEAL_TYPE,
            "Extent5".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
            "Extent5".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
            "Extent5".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
            "Extent5".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
            "Extent5".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
            "Extent5".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
            "Extent5".RATE_PLAN_ID AS RATE_PLAN_ID,
            "Extent5".PROMOTED AS PROMOTED,
            "Extent5".DELIVERED AS DELIVERED,
            "Extent5".CANCELED AS CANCELED,
            "Extent5".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
            "Extent5".DEAL_COMMENT AS DEAL_COMMENT,
            "Extent5".ENTERED_BY AS ENTERED_BY1,
            "Extent5".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
            "Extent5".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
            "Extent5".NEED_ACCOUNT AS NEED_ACCOUNT,
            "Extent5".RESUBMITTED AS RESUBMITTED,
            "Extent5".STORAGE_TRANSFER AS STORAGE_TRANSFER,
            "Extent5".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
            "Extent5".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
            "Extent5".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
            "Extent5".ROW_VERSION AS ROW_VERSION1,
            "Extent5".DEAL552CODE_ID AS DEAL552CODE_ID,
            "Extent5".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
            "Extent5".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
            "Extent5".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
            "Filter1".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
            "Filter1".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
            "Filter1".DEAL_CONFIRM_ID2 AS DEAL_CONFIRM_ID1,
            "Project1".C1 AS C4,
            "Project1".DEAL_CONF_CONTACTLIST_ID AS DEAL_CONF_CONTACTLIST_ID,
            "Project1".REMOVED AS REMOVED,
            "Project1".CONF_SEND_METHOD_DESC AS CONF_SEND_METHOD_DESC,
            "Project1".CONF_SENT_DATE AS CONF_SENT_DATE1,
            "Project1".INCLUDE_BATCH AS INCLUDE_BATCH,
            "Project1".ENTERED_BY AS ENTERED_BY2,
            "Project1".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
            "Project1".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
            "Project1".ROW_VERSION AS ROW_VERSION2,
            "Project1".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID2,
            "Project1".CONTACT_METHOD_ID AS CONTACT_METHOD_ID,
            "Project1".CONTACT_ID AS CONTACT_ID,
            "Project1".CONTACT_DEPT_ID AS CONTACT_DEPT_ID,
            "Project1".LN_ID AS LN_ID,
            "Project1".STATUS AS STATUS,
            "Project1".FIRST_NAME AS FIRST_NAME,
            "Project1".LAST_NAME AS LAST_NAME,
            "Project1".NAME AS NAME,
            "Project1".TITLE AS TITLE,
            "Project1".COMPANY AS COMPANY,
            "Project1".WORK_PHONE AS WORK_PHONE,
            "Project1".CELL_PHONE AS CELL_PHONE,
            "Project1".FAX AS FAX,
            "Project1".EMAIL AS EMAIL,
            "Project1".IM AS IM,
            "Project1".STREET AS STREET,
            "Project1".CITY AS CITY,
            "Project1".STATE AS STATE,
            "Project1".ZIP AS ZIP,
            "Project1".SEND_CONFIRM AS SEND_CONFIRM,
            "Project1".AUTO_SEND AS AUTO_SEND,
            "Project1".LN_FLAG AS LN_FLAG,
            "Project1"."COMMENT" AS "COMMENT",
            "Project1".LAST_UPDATE_USER1 AS LAST_UPDATE_USER3,
            "Project1".LAST_UPDATE_TMS1 AS LAST_UPDATE_TMS3,
            "Project1".ROW_VERSION1 AS ROW_VERSION3,
            FLOOR(CAST(NULL AS NUMBER)) AS C5,
            FLOOR(CAST(NULL AS NUMBER)) AS C6,
            FLOOR(CAST(NULL AS NUMBER)) AS C7,
            FLOOR(CAST(NULL AS NUMBER)) AS C8,
            FLOOR(CAST(NULL AS NUMBER)) AS C9,
            FLOOR(CAST(NULL AS NUMBER)) AS C10,
            FLOOR(CAST(NULL AS NUMBER)) AS C11,
            FLOOR(CAST(NULL AS NUMBER)) AS C12,
            TO_CHAR(NULL) AS C13,
            CAST(NULL AS NUMBER) AS C14,
            FLOOR(CAST(NULL AS NUMBER)) AS C15,
            TO_CHAR(NULL) AS C16,
            TO_CHAR(NULL) AS C17,
            TO_CHAR(NULL) AS C18,
            TO_CHAR(NULL) AS C19,
            TO_CHAR(NULL) AS C20,
            TO_CHAR(NULL) AS C21,
            FLOOR(CAST(NULL AS NUMBER)) AS C22,
            TO_CHAR(NULL) AS C23,
            TO_CHAR(NULL) AS C24,
            CAST(NULL AS NUMBER) AS C25,
            TO_CHAR(NULL) AS C26,
            TO_CHAR(NULL) AS C27,
            CAST(NULL AS TIMESTAMP(9)) AS C28,
            FLOOR(CAST(NULL AS NUMBER)) AS C29,
            FLOOR(CAST(NULL AS NUMBER)) AS C30,
            FLOOR(CAST(NULL AS NUMBER)) AS C31,
            FLOOR(CAST(NULL AS NUMBER)) AS C32,
            FLOOR(CAST(NULL AS NUMBER)) AS C33,
            FLOOR(CAST(NULL AS NUMBER)) AS C34,
            FLOOR(CAST(NULL AS NUMBER)) AS C35,
            FLOOR(CAST(NULL AS NUMBER)) AS C36,
            FLOOR(CAST(NULL AS NUMBER)) AS C37,
            FLOOR(CAST(NULL AS NUMBER)) AS C38,
            TO_CHAR(NULL) AS C39,
            FLOOR(CAST(NULL AS NUMBER)) AS C40,
            FLOOR(CAST(NULL AS NUMBER)) AS C41,
            CAST(NULL AS NUMBER) AS C42,
            CAST(NULL AS NUMBER) AS C43,
            FLOOR(CAST(NULL AS NUMBER)) AS C44,
            TO_CHAR(NULL) AS C45,
            TO_CHAR(NULL) AS C46,
            TO_CHAR(NULL) AS C47,
            TO_CHAR(NULL) AS C48,
            TO_CHAR(NULL) AS C49,
            TO_CHAR(NULL) AS C50,
            FLOOR(CAST(NULL AS NUMBER)) AS C51,
            TO_CHAR(NULL) AS C52,
            TO_CHAR(NULL) AS C53,
            CAST(NULL AS NUMBER) AS C54,
            TO_CHAR(NULL) AS C55,
            TO_CHAR(NULL) AS C56,
            CAST(NULL AS TIMESTAMP(9)) AS C57,
            FLOOR(CAST(NULL AS NUMBER)) AS C58,
            TO_CHAR(NULL) AS C59,
            TO_CHAR(NULL) AS C60,
            FLOOR(CAST(NULL AS NUMBER)) AS C61,
            FLOOR(CAST(NULL AS NUMBER)) AS C62,
            FLOOR(CAST(NULL AS NUMBER)) AS C63,
            FLOOR(CAST(NULL AS NUMBER)) AS C64,
            FLOOR(CAST(NULL AS NUMBER)) AS C65,
            FLOOR(CAST(NULL AS NUMBER)) AS C66,
            FLOOR(CAST(NULL AS NUMBER)) AS C67,
            FLOOR(CAST(NULL AS NUMBER)) AS C68,
            CAST(NULL AS TIMESTAMP(9)) AS C69,
            FLOOR(CAST(NULL AS NUMBER)) AS C70,
            FLOOR(CAST(NULL AS NUMBER)) AS C71,
            CAST(NULL AS NUMBER) AS C72,
            TO_CHAR(NULL) AS C73,
            TO_CHAR(NULL) AS C74,
            CAST(NULL AS TIMESTAMP(9)) AS C75,
            FLOOR(CAST(NULL AS NUMBER)) AS C76,
            FLOOR(CAST(NULL AS NUMBER)) AS C77
         FROM (
            SELECT "Extent1".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID1,
               "Extent1".DEAL_ID AS DEAL_ID1,
               "Extent1".ACTION_DATE AS ACTION_DATE,
               "Extent1".CONF_STATUS_ID AS CONF_STATUS_ID,
               "Extent1".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
               "Extent1".CONF_SENT_DATE AS CONF_SENT_DATE,
               "Extent1".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
               "Extent1".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
               "Extent1".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
               "Extent1".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
               "Extent1".CONF_COMMENT AS CONF_COMMENT,
               "Extent1".ENTERED_BY AS ENTERED_BY1,
               "Extent1".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
               "Extent1".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
               "Extent1".ROW_VERSION AS ROW_VERSION1,
               "Extent1".PREVENT_SEND AS PREVENT_SEND,
               "Extent1".DEAL_SS_ID AS DEAL_SS_ID2,
               "Extent2".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID2,
               "Extent2".CONFIRMATION_PDF AS CONFIRMATION_PDF,
               "Extent2".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
               "Extent2".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
               "Extent2".ROW_VERSION AS ROW_VERSION2,
               "Extent3".DEAL_SS_ID AS DEAL_SS_ID1,
               "Extent3".DEAL_ID AS DEAL_ID2,
               "Extent3".DATE_ENTERED AS DATE_ENTERED,
               "Extent3".DATE_OF_DEAL AS DATE_OF_DEAL,
               "Extent3".FLOW_DATE_START AS FLOW_DATE_START,
               "Extent3".FLOW_DATE_END AS FLOW_DATE_END,
               "Extent3".DEAL_NUMBER AS DEAL_NUMBER,
               "Extent3".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
               "Extent3".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
               "Extent3".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
               "Extent3".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
               "Extent3".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
               "Extent3".CONTACT_OTHER AS CONTACT_OTHER,
               "Extent3".MO_CONTACT_ID AS MO_CONTACT_ID,
               "Extent3".MO_CONTACT_NAME AS MO_CONTACT_NAME,
               "Extent3".PIPELINE_ID AS PIPELINE_ID,
               "Extent3".PIPELINE_CD AS PIPELINE_CD,
               "Extent3".ZONE_ID AS ZONE_ID,
               "Extent3".ZONE_CD AS ZONE_CD,
               "Extent3".LOCATION_ID AS LOCATION_ID,
               "Extent3".LOCATION_CD AS LOCATION_CD,
               "Extent3".DEAL_TYPE_ID AS DEAL_TYPE_ID,
               "Extent3".DEAL_TYPE AS DEAL_TYPE,
               "Extent3".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
               "Extent3".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
               "Extent3".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
               "Extent3".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
               "Extent3".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
               "Extent3".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
               "Extent3".RATE_PLAN_ID AS RATE_PLAN_ID,
               "Extent3".PROMOTED AS PROMOTED,
               "Extent3".DELIVERED AS DELIVERED,
               "Extent3".CANCELED AS CANCELED,
               "Extent3".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
               "Extent3".DEAL_COMMENT AS DEAL_COMMENT,
               "Extent3".ENTERED_BY AS ENTERED_BY2,
               "Extent3".LAST_UPDATE_USER AS LAST_UPDATE_USER3,
               "Extent3".LAST_UPDATE_TMS AS LAST_UPDATE_TMS3,
               "Extent3".NEED_ACCOUNT AS NEED_ACCOUNT,
               "Extent3".RESUBMITTED AS RESUBMITTED,
               "Extent3".STORAGE_TRANSFER AS STORAGE_TRANSFER,
               "Extent3".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
               "Extent3".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
               "Extent3".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
               "Extent3".ROW_VERSION AS ROW_VERSION3,
               "Extent3".DEAL552CODE_ID AS DEAL552CODE_ID,
               "Extent3".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
               "Extent3".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
               "Extent3".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
            FROM GCSM9.DEAL_CONFIRMATION "Extent1" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent2" ON "Extent1".DEAL_CONFIRM_ID =
            "Extent2".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent3" ON "Extent1".DEAL_SS_ID = "Extent3".DEAL_SS_ID 
            WHERE ((1 = "Extent1".CONF_STATUS_ID) 
            AND (5 <> "Extent1".CONF_STATUS_ID)) 
            AND ("Extent3".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter1" INNER JOIN
            GCSM9.DEAL_SS "Extent4" ON "Filter1".DEAL_SS_ID2 = "Extent4".DEAL_SS_ID LEFT OUTER JOIN GCSM9.DEAL_SS "Extent5" ON 
            "Filter1".DEAL_SS_ID2 = "Extent5".DEAL_SS_ID LEFT OUTER JOIN (
            SELECT "Extent6".DEAL_CONF_CONTACTLIST_ID AS DEAL_CONF_CONTACTLIST_ID,
               "Extent6".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID,
               "Extent6".REMOVED AS REMOVED,
               "Extent6".CONF_SEND_METHOD_DESC AS CONF_SEND_METHOD_DESC,
               "Extent6".CONF_SENT_DATE AS CONF_SENT_DATE,
               "Extent6".INCLUDE_BATCH AS INCLUDE_BATCH,
               "Extent6".ENTERED_BY AS ENTERED_BY,
               "Extent6".LAST_UPDATE_USER AS LAST_UPDATE_USER,
               "Extent6".LAST_UPDATE_TMS AS LAST_UPDATE_TMS,
               "Extent6".ROW_VERSION AS ROW_VERSION,
               "Extent6".CONTACT_METHOD_ID AS CONTACT_METHOD_ID,
               "Extent7".CONTACT_ID AS CONTACT_ID,
               "Extent7".CONTACT_DEPT_ID AS CONTACT_DEPT_ID,
               "Extent7".LN_ID AS LN_ID,
               "Extent7".STATUS AS STATUS,
               "Extent7".FIRST_NAME AS FIRST_NAME,
               "Extent7".LAST_NAME AS LAST_NAME,
               "Extent7".NAME AS NAME,
               "Extent7".TITLE AS TITLE,
               "Extent7".COMPANY AS COMPANY,
               "Extent7".WORK_PHONE AS WORK_PHONE,
               "Extent7".CELL_PHONE AS CELL_PHONE,
               "Extent7".FAX AS FAX,
               "Extent7".EMAIL AS EMAIL,
               "Extent7".IM AS IM,
               "Extent7".STREET AS STREET,
               "Extent7".CITY AS CITY,
               "Extent7".STATE AS STATE,
               "Extent7".ZIP AS ZIP,
               "Extent7".SEND_CONFIRM AS SEND_CONFIRM,
               "Extent7".AUTO_SEND AS AUTO_SEND,
               "Extent7".LN_FLAG AS LN_FLAG,
               "Extent7"."COMMENT" AS "COMMENT",
               "Extent7".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
               "Extent7".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
               "Extent7".ROW_VERSION AS ROW_VERSION1,
               1 AS C1
            FROM GCSM9.DEAL_CONF_CONTACTLIST "Extent6" LEFT OUTER JOIN GCSM9.CONTACT "Extent7" ON "Extent6".CONTACT_ID = "Extent7".CONTACT_ID
            ) "Project1" ON "Filter1".DEAL_CONFIRM_ID1 = "Project1".DEAL_CONFIRM_ID 
         WHERE "Extent4".FLOW_DATE_START <= TO_TIMESTAMP('2010-02-28 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff') UNION ALL 
         SELECT 2 AS C1,
            "Filter3".DEAL_CONFIRM_ID3 AS DEAL_CONFIRM_ID,
            "Filter3".DEAL_ID3 AS DEAL_ID,
            "Filter3".ACTION_DATE AS ACTION_DATE,
            "Filter3".CONF_STATUS_ID AS CONF_STATUS_ID,
            "Filter3".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
            "Filter3".CONF_SENT_DATE AS CONF_SENT_DATE,
            "Filter3".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
            "Filter3".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
            "Filter3".CONF_COMMENT AS CONF_COMMENT,
            "Filter3".ENTERED_BY3 AS ENTERED_BY,
            "Filter3".LAST_UPDATE_USER4 AS LAST_UPDATE_USER,
            "Filter3".LAST_UPDATE_TMS4 AS LAST_UPDATE_TMS,
            "Filter3".ROW_VERSION4 AS ROW_VERSION,
            "Filter3".PREVENT_SEND AS PREVENT_SEND,
            "Filter3".DEAL_SS_ID3 AS DEAL_SS_ID,
            "Extent11".DEAL_SS_ID AS DEAL_SS_ID1,
            1 AS C2,
            1 AS C3,
            "Extent12".DEAL_SS_ID AS DEAL_SS_ID2,
            "Extent12".DEAL_ID AS DEAL_ID1,
            "Extent12".DATE_ENTERED AS DATE_ENTERED,
            "Extent12".DATE_OF_DEAL AS DATE_OF_DEAL,
            "Extent12".FLOW_DATE_START AS FLOW_DATE_START,
            "Extent12".FLOW_DATE_END AS FLOW_DATE_END,
            "Extent12".DEAL_NUMBER AS DEAL_NUMBER,
            "Extent12".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
            "Extent12".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
            "Extent12".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
            "Extent12".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
            "Extent12".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
            "Extent12".CONTACT_OTHER AS CONTACT_OTHER,
            "Extent12".MO_CONTACT_ID AS MO_CONTACT_ID,
            "Extent12".MO_CONTACT_NAME AS MO_CONTACT_NAME,
            "Extent12".PIPELINE_ID AS PIPELINE_ID,
            "Extent12".PIPELINE_CD AS PIPELINE_CD,
            "Extent12".ZONE_ID AS ZONE_ID,
            "Extent12".ZONE_CD AS ZONE_CD,
            "Extent12".LOCATION_ID AS LOCATION_ID,
            "Extent12".LOCATION_CD AS LOCATION_CD,
            "Extent12".DEAL_TYPE_ID AS DEAL_TYPE_ID,
            "Extent12".DEAL_TYPE AS DEAL_TYPE,
            "Extent12".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
            "Extent12".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
            "Extent12".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
            "Extent12".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
            "Extent12".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
            "Extent12".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
            "Extent12".RATE_PLAN_ID AS RATE_PLAN_ID,
            "Extent12".PROMOTED AS PROMOTED,
            "Extent12".DELIVERED AS DELIVERED,
            "Extent12".CANCELED AS CANCELED,
            "Extent12".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
            "Extent12".DEAL_COMMENT AS DEAL_COMMENT,
            "Extent12".ENTERED_BY AS ENTERED_BY1,
            "Extent12".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
            "Extent12".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
            "Extent12".NEED_ACCOUNT AS NEED_ACCOUNT,
            "Extent12".RESUBMITTED AS RESUBMITTED,
            "Extent12".STORAGE_TRANSFER AS STORAGE_TRANSFER,
            "Extent12".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
            "Extent12".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
            "Extent12".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
            "Extent12".ROW_VERSION AS ROW_VERSION1,
            "Extent12".DEAL552CODE_ID AS DEAL552CODE_ID,
            "Extent12".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
            "Extent12".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
            "Extent12".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
            "Filter3".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
            "Filter3".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
            "Filter3".DEAL_CONFIRM_ID4 AS DEAL_CONFIRM_ID1,
            FLOOR(CAST(NULL AS NUMBER)) AS C4,
            FLOOR(CAST(NULL AS NUMBER)) AS C5,
            FLOOR(CAST(NULL AS NUMBER)) AS C6,
            TO_CHAR(NULL) AS C7,
            CAST(NULL AS TIMESTAMP(9)) AS C8,
            FLOOR(CAST(NULL AS NUMBER)) AS C9,
            TO_CHAR(NULL) AS C10,
            TO_CHAR(NULL) AS C11,
            CAST(NULL AS TIMESTAMP(9)) AS C12,
            FLOOR(CAST(NULL AS NUMBER)) AS C13,
            FLOOR(CAST(NULL AS NUMBER)) AS C14,
            FLOOR(CAST(NULL AS NUMBER)) AS C15,
            FLOOR(CAST(NULL AS NUMBER)) AS C16,
            FLOOR(CAST(NULL AS NUMBER)) AS C17,
            TO_CHAR(NULL) AS C18,
            FLOOR(CAST(NULL AS NUMBER)) AS C19,
            TO_CHAR(NULL) AS C20,
            TO_CHAR(NULL) AS C21,
            TO_CHAR(NULL) AS C22,
            TO_CHAR(NULL) AS C23,
            TO_CHAR(NULL) AS C24,
            TO_CHAR(NULL) AS C25,
            TO_CHAR(NULL) AS C26,
            TO_CHAR(NULL) AS C27,
            TO_CHAR(NULL) AS C28,
            TO_CHAR(NULL) AS C29,
            TO_CHAR(NULL) AS C30,
            TO_CHAR(NULL) AS C31,
            TO_CHAR(NULL) AS C32,
            TO_CHAR(NULL) AS C33,
            FLOOR(CAST(NULL AS NUMBER)) AS C34,
            FLOOR(CAST(NULL AS NUMBER)) AS C35,
            FLOOR(CAST(NULL AS NUMBER)) AS C36,
            TO_CHAR(NULL) AS C37,
            TO_CHAR(NULL) AS C38,
            CAST(NULL AS TIMESTAMP(9)) AS C39,
            FLOOR(CAST(NULL AS NUMBER)) AS C40,
            1 AS C41,
            "Extent13".DEAL_PRICING_SS_ID AS DEAL_PRICING_SS_ID,
            "Extent13".DEAL_PRICING_ID AS DEAL_PRICING_ID,
            "Extent13".DEAL_ID AS DEAL_ID2,
            "Extent13".DEAL_NUMBER AS DEAL_NUMBER1,
            "Extent13".VOLUME_MIN AS VOLUME_MIN,
            "Extent13".VOLUME_MAX AS VOLUME_MAX,
            "Extent13".VOLUME_TYPE_ID AS VOLUME_TYPE_ID,
            "Extent13".DEAL_VOLUME_TYPE AS DEAL_VOLUME_TYPE,
            "Extent13".PRICE AS PRICE,
            "Extent13".DEAL_PRICE_TYPE_ID AS DEAL_PRICE_TYPE_ID,
            "Extent13".DEAL_PRICE_TYPE AS DEAL_PRICE_TYPE,
            "Extent13".PRICE_DESCRIPTION AS PRICE_DESCRIPTION,
            "Extent13".PRICE_INDEX_PIPELINE_ID AS PRICE_INDEX_PIPELINE_ID,
            "Extent13".PIPELINE_CD AS PIPELINE_CD1,
            "Extent13".PRICE_INDEX_LOCATION_ID AS PRICE_INDEX_LOCATION_ID,
            "Extent13".LOCATION_CD AS LOCATION_CD1,
            "Extent13".PRICE_INDEX_PRICE_TYPE_ID AS PRICE_INDEX_PRICE_TYPE_ID,
            "Extent13".PRICE_TYPE AS PRICE_TYPE,
            "Extent13".PRICE_INDEX_HML_FLAG AS PRICE_INDEX_HML_FLAG,
            "Extent13".PRICE_INDEX_ADDER AS PRICE_INDEX_ADDER,
            "Extent13".ENTERED_BY AS ENTERED_BY2,
            "Extent13".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
            "Extent13".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
            "Extent13".ROW_VERSION AS ROW_VERSION2,
            "Extent13".DEAL_SS_ID AS DEAL_SS_ID3,
            FLOOR(CAST(NULL AS NUMBER)) AS C42,
            FLOOR(CAST(NULL AS NUMBER)) AS C43,
            FLOOR(CAST(NULL AS NUMBER)) AS C44,
            FLOOR(CAST(NULL AS NUMBER)) AS C45,
            FLOOR(CAST(NULL AS NUMBER)) AS C46,
            FLOOR(CAST(NULL AS NUMBER)) AS C47,
            FLOOR(CAST(NULL AS NUMBER)) AS C48,
            FLOOR(CAST(NULL AS NUMBER)) AS C49,
            TO_CHAR(NULL) AS C50,
            FLOOR(CAST(NULL AS NUMBER)) AS C51,
            FLOOR(CAST(NULL AS NUMBER)) AS C52,
            CAST(NULL AS NUMBER) AS C53,
            CAST(NULL AS NUMBER) AS C54,
            FLOOR(CAST(NULL AS NUMBER)) AS C55,
            TO_CHAR(NULL) AS C56,
            TO_CHAR(NULL) AS C57,
            TO_CHAR(NULL) AS C58,
            TO_CHAR(NULL) AS C59,
            TO_CHAR(NULL) AS C60,
            TO_CHAR(NULL) AS C61,
            FLOOR(CAST(NULL AS NUMBER)) AS C62,
            TO_CHAR(NULL) AS C63,
            TO_CHAR(NULL) AS C64,
            CAST(NULL AS NUMBER) AS C65,
            TO_CHAR(NULL) AS C66,
            TO_CHAR(NULL) AS C67,
            CAST(NULL AS TIMESTAMP(9)) AS C68,
            FLOOR(CAST(NULL AS NUMBER)) AS C69,
            TO_CHAR(NULL) AS C70,
            TO_CHAR(NULL) AS C71,
            FLOOR(CAST(NULL AS NUMBER)) AS C72,
            FLOOR(CAST(NULL AS NUMBER)) AS C73,
            FLOOR(CAST(NULL AS NUMBER)) AS C74,
            FLOOR(CAST(NULL AS NUMBER)) AS C75,
            FLOOR(CAST(NULL AS NUMBER)) AS C76,
            FLOOR(CAST(NULL AS NUMBER)) AS C77,
            FLOOR(CAST(NULL AS NUMBER)) AS C78,
            FLOOR(CAST(NULL AS NUMBER)) AS C79,
            CAST(NULL AS TIMESTAMP(9)) AS C80,
            FLOOR(CAST(NULL AS NUMBER)) AS C81,
            FLOOR(CAST(NULL AS NUMBER)) AS C82,
            CAST(NULL AS NUMBER) AS C83,
            TO_CHAR(NULL) AS C84,
            TO_CHAR(NULL) AS C85,
            CAST(NULL AS TIMESTAMP(9)) AS C86,
            FLOOR(CAST(NULL AS NUMBER)) AS C87,
            FLOOR(CAST(NULL AS NUMBER)) AS C88
         FROM (
            SELECT "Extent8".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID3,
               "Extent8".DEAL_ID AS DEAL_ID3,
               "Extent8".ACTION_DATE AS ACTION_DATE,
               "Extent8".CONF_STATUS_ID AS CONF_STATUS_ID,
               "Extent8".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
               "Extent8".CONF_SENT_DATE AS CONF_SENT_DATE,
               "Extent8".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
               "Extent8".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
               "Extent8".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
               "Extent8".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
               "Extent8".CONF_COMMENT AS CONF_COMMENT,
               "Extent8".ENTERED_BY AS ENTERED_BY3,
               "Extent8".LAST_UPDATE_USER AS LAST_UPDATE_USER4,
               "Extent8".LAST_UPDATE_TMS AS LAST_UPDATE_TMS4,
               "Extent8".ROW_VERSION AS ROW_VERSION4,
               "Extent8".PREVENT_SEND AS PREVENT_SEND,
               "Extent8".DEAL_SS_ID AS DEAL_SS_ID4,
               "Extent9".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID4,
               "Extent9".CONFIRMATION_PDF AS CONFIRMATION_PDF,
               "Extent9".LAST_UPDATE_USER AS LAST_UPDATE_USER5,
               "Extent9".LAST_UPDATE_TMS AS LAST_UPDATE_TMS5,
               "Extent9".ROW_VERSION AS ROW_VERSION5,
               "Extent10".DEAL_SS_ID AS DEAL_SS_ID3,
               "Extent10".DEAL_ID AS DEAL_ID4,
               "Extent10".DATE_ENTERED AS DATE_ENTERED,
               "Extent10".DATE_OF_DEAL AS DATE_OF_DEAL,
               "Extent10".FLOW_DATE_START AS FLOW_DATE_START,
               "Extent10".FLOW_DATE_END AS FLOW_DATE_END,
               "Extent10".DEAL_NUMBER AS DEAL_NUMBER,
               "Extent10".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
               "Extent10".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
               "Extent10".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
               "Extent10".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
               "Extent10".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
               "Extent10".CONTACT_OTHER AS CONTACT_OTHER,
               "Extent10".MO_CONTACT_ID AS MO_CONTACT_ID,
               "Extent10".MO_CONTACT_NAME AS MO_CONTACT_NAME,
               "Extent10".PIPELINE_ID AS PIPELINE_ID,
               "Extent10".PIPELINE_CD AS PIPELINE_CD,
               "Extent10".ZONE_ID AS ZONE_ID,
               "Extent10".ZONE_CD AS ZONE_CD,
               "Extent10".LOCATION_ID AS LOCATION_ID,
               "Extent10".LOCATION_CD AS LOCATION_CD,
               "Extent10".DEAL_TYPE_ID AS DEAL_TYPE_ID,
               "Extent10".DEAL_TYPE AS DEAL_TYPE,
               "Extent10".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
               "Extent10".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
               "Extent10".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
               "Extent10".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
               "Extent10".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
               "Extent10".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
               "Extent10".RATE_PLAN_ID AS RATE_PLAN_ID,
               "Extent10".PROMOTED AS PROMOTED,
               "Extent10".DELIVERED AS DELIVERED,
               "Extent10".CANCELED AS CANCELED,
               "Extent10".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
               "Extent10".DEAL_COMMENT AS DEAL_COMMENT,
               "Extent10".ENTERED_BY AS ENTERED_BY4,
               "Extent10".LAST_UPDATE_USER AS LAST_UPDATE_USER6,
               "Extent10".LAST_UPDATE_TMS AS LAST_UPDATE_TMS6,
               "Extent10".NEED_ACCOUNT AS NEED_ACCOUNT,
               "Extent10".RESUBMITTED AS RESUBMITTED,
               "Extent10".STORAGE_TRANSFER AS STORAGE_TRANSFER,
               "Extent10".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
               "Extent10".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
               "Extent10".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
               "Extent10".ROW_VERSION AS ROW_VERSION6,
               "Extent10".DEAL552CODE_ID AS DEAL552CODE_ID,
               "Extent10".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
               "Extent10".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
               "Extent10".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
            FROM GCSM9.DEAL_CONFIRMATION "Extent8" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent9" ON "Extent8".DEAL_CONFIRM_ID =
            "Extent9".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent10" ON "Extent8".DEAL_SS_ID = "Extent10".DEAL_SS_ID 
            WHERE ((1 = "Extent8".CONF_STATUS_ID) 
            AND (5 <> "Extent8".CONF_STATUS_ID)) 
            AND ("Extent10".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter3" INNER 
            JOIN GCSM9.DEAL_SS "Extent11" ON "Filter3".DEAL_SS_ID4 = "Extent11".DEAL_SS_ID LEFT OUTER JOIN GCSM9.DEAL_SS "Extent12" ON 
            "Filter3".DEAL_SS_ID4 = "Extent12".DEAL_SS_ID INNER JOIN GCSM9.DEAL_PRICING_SS "Extent13" ON "Filter3".DEAL_SS_ID4 = 
            "Extent13".DEAL_SS_ID 
         WHERE "Extent11".FLOW_DATE_START <= TO_TIMESTAMP('2010-02-28 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) "UnionAll1" UNION ALL
      SELECT 3 AS C1,
         "Filter5".DEAL_CONFIRM_ID5 AS DEAL_CONFIRM_ID,
         "Filter5".DEAL_ID5 AS DEAL_ID,
         "Filter5".ACTION_DATE AS ACTION_DATE,
         "Filter5".CONF_STATUS_ID AS CONF_STATUS_ID,
         "Filter5".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
         "Filter5".CONF_SENT_DATE AS CONF_SENT_DATE,
         "Filter5".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
         "Filter5".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
         "Filter5".CONF_COMMENT AS CONF_COMMENT,
         "Filter5".ENTERED_BY5 AS ENTERED_BY,
         "Filter5".LAST_UPDATE_USER7 AS LAST_UPDATE_USER,
         "Filter5".LAST_UPDATE_TMS7 AS LAST_UPDATE_TMS,
         "Filter5".ROW_VERSION7 AS ROW_VERSION,
         "Filter5".PREVENT_SEND AS PREVENT_SEND,
         "Filter5".DEAL_SS_ID5 AS DEAL_SS_ID,
         "Extent17".DEAL_SS_ID AS DEAL_SS_ID1,
         1 AS C2,
         1 AS C3,
         "Extent18".DEAL_SS_ID AS DEAL_SS_ID2,
         "Extent18".DEAL_ID AS DEAL_ID1,
         "Extent18".DATE_ENTERED AS DATE_ENTERED,
         "Extent18".DATE_OF_DEAL AS DATE_OF_DEAL,
         "Extent18".FLOW_DATE_START AS FLOW_DATE_START,
         "Extent18".FLOW_DATE_END AS FLOW_DATE_END,
         "Extent18".DEAL_NUMBER AS DEAL_NUMBER,
         "Extent18".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
         "Extent18".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
         "Extent18".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
         "Extent18".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
         "Extent18".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
         "Extent18".CONTACT_OTHER AS CONTACT_OTHER,
         "Extent18".MO_CONTACT_ID AS MO_CONTACT_ID,
         "Extent18".MO_CONTACT_NAME AS MO_CONTACT_NAME,
         "Extent18".PIPELINE_ID AS PIPELINE_ID,
         "Extent18".PIPELINE_CD AS PIPELINE_CD,
         "Extent18".ZONE_ID AS ZONE_ID,
         "Extent18".ZONE_CD AS ZONE_CD,
         "Extent18".LOCATION_ID AS LOCATION_ID,
         "Extent18".LOCATION_CD AS LOCATION_CD,
         "Extent18".DEAL_TYPE_ID AS DEAL_TYPE_ID,
         "Extent18".DEAL_TYPE AS DEAL_TYPE,
         "Extent18".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
         "Extent18".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
         "Extent18".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
         "Extent18".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
         "Extent18".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
         "Extent18".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
         "Extent18".RATE_PLAN_ID AS RATE_PLAN_ID,
         "Extent18".PROMOTED AS PROMOTED,
         "Extent18".DELIVERED AS DELIVERED,
         "Extent18".CANCELED AS CANCELED,
         "Extent18".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
         "Extent18".DEAL_COMMENT AS DEAL_COMMENT,
         "Extent18".ENTERED_BY AS ENTERED_BY1,
         "Extent18".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
         "Extent18".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
         "Extent18".NEED_ACCOUNT AS NEED_ACCOUNT,
         "Extent18".RESUBMITTED AS RESUBMITTED,
         "Extent18".STORAGE_TRANSFER AS STORAGE_TRANSFER,
         "Extent18".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
         "Extent18".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
         "Extent18".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
         "Extent18".ROW_VERSION AS ROW_VERSION1,
         "Extent18".DEAL552CODE_ID AS DEAL552CODE_ID,
         "Extent18".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
         "Extent18".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
         "Extent18".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
         "Filter5".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
         "Filter5".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
         "Filter5".DEAL_CONFIRM_ID6 AS DEAL_CONFIRM_ID1,
         FLOOR(CAST(NULL AS NUMBER)) AS C4,
         FLOOR(CAST(NULL AS NUMBER)) AS C5,
         FLOOR(CAST(NULL AS NUMBER)) AS C6,
         TO_CHAR(NULL) AS C7,
         CAST(NULL AS TIMESTAMP(9)) AS C8,
         FLOOR(CAST(NULL AS NUMBER)) AS C9,
         TO_CHAR(NULL) AS C10,
         TO_CHAR(NULL) AS C11,
         CAST(NULL AS TIMESTAMP(9)) AS C12,
         FLOOR(CAST(NULL AS NUMBER)) AS C13,
         FLOOR(CAST(NULL AS NUMBER)) AS C14,
         FLOOR(CAST(NULL AS NUMBER)) AS C15,
         FLOOR(CAST(NULL AS NUMBER)) AS C16,
         FLOOR(CAST(NULL AS NUMBER)) AS C17,
         TO_CHAR(NULL) AS C18,
         FLOOR(CAST(NULL AS NUMBER)) AS C19,
         TO_CHAR(NULL) AS C20,
         TO_CHAR(NULL) AS C21,
         TO_CHAR(NULL) AS C22,
         TO_CHAR(NULL) AS C23,
         TO_CHAR(NULL) AS C24,
         TO_CHAR(NULL) AS C25,
         TO_CHAR(NULL) AS C26,
         TO_CHAR(NULL) AS C27,
         TO_CHAR(NULL) AS C28,
         TO_CHAR(NULL) AS C29,
         TO_CHAR(NULL) AS C30,
         TO_CHAR(NULL) AS C31,
         TO_CHAR(NULL) AS C32,
         TO_CHAR(NULL) AS C33,
         FLOOR(CAST(NULL AS NUMBER)) AS C34,
         FLOOR(CAST(NULL AS NUMBER)) AS C35,
         FLOOR(CAST(NULL AS NUMBER)) AS C36,
         TO_CHAR(NULL) AS C37,
         TO_CHAR(NULL) AS C38,
         CAST(NULL AS TIMESTAMP(9)) AS C39,
         FLOOR(CAST(NULL AS NUMBER)) AS C40,
         FLOOR(CAST(NULL AS NUMBER)) AS C41,
         FLOOR(CAST(NULL AS NUMBER)) AS C42,
         FLOOR(CAST(NULL AS NUMBER)) AS C43,
         FLOOR(CAST(NULL AS NUMBER)) AS C44,
         FLOOR(CAST(NULL AS NUMBER)) AS C45,
         FLOOR(CAST(NULL AS NUMBER)) AS C46,
         FLOOR(CAST(NULL AS NUMBER)) AS C47,
         FLOOR(CAST(NULL AS NUMBER)) AS C48,
         TO_CHAR(NULL) AS C49,
         CAST(NULL AS NUMBER) AS C50,
         FLOOR(CAST(NULL AS NUMBER)) AS C51,
         TO_CHAR(NULL) AS C52,
         TO_CHAR(NULL) AS C53,
         TO_CHAR(NULL) AS C54,
         TO_CHAR(NULL) AS C55,
         TO_CHAR(NULL) AS C56,
         TO_CHAR(NULL) AS C57,
         FLOOR(CAST(NULL AS NUMBER)) AS C58,
         TO_CHAR(NULL) AS C59,
         TO_CHAR(NULL) AS C60,
         CAST(NULL AS NUMBER) AS C61,
         TO_CHAR(NULL) AS C62,
         TO_CHAR(NULL) AS C63,
         CAST(NULL AS TIMESTAMP(9)) AS C64,
         FLOOR(CAST(NULL AS NUMBER)) AS C65,
         FLOOR(CAST(NULL AS NUMBER)) AS C66,
         1 AS C67,
         "Extent19".DEAL_TRX_PRICING_SS_ID AS DEAL_TRX_PRICING_SS_ID,
         "Extent19".DEAL_TRX_PRICING_ID AS DEAL_TRX_PRICING_ID,
         "Extent19".DEAL_TRX_ID AS DEAL_TRX_ID,
         "Extent19".DEAL_ID AS DEAL_ID2,
         "Extent19".DEAL_NUMBER AS DEAL_NUMBER1,
         "Extent19".DEAL_PRICING_ID AS DEAL_PRICING_ID,
         "Extent19".VOLUME_TYPE_ID AS VOLUME_TYPE_ID,
         "Extent19".DEAL_VOLUME_TYPE AS DEAL_VOLUME_TYPE,
         "Extent19".VOLUME_MIN AS VOLUME_MIN,
         "Extent19".VOLUME_MAX AS VOLUME_MAX,
         "Extent19".NET_PRICE AS NET_PRICE,
         "Extent19".PRICE AS PRICE,
         "Extent19".DEAL_PRICE_TYPE_ID AS DEAL_PRICE_TYPE_ID,
         "Extent19".DEAL_PRICE_TYPE AS DEAL_PRICE_TYPE,
         "Extent19".PRICE_DESCRIPTION AS PRICE_DESCRIPTION,
         "Extent19".PRICE_INDEX_PIPELINE_ID AS PRICE_INDEX_PIPELINE_ID,
         "Extent19".PIPELINE_CD AS PIPELINE_CD1,
         "Extent19".PRICE_INDEX_LOCATION_ID AS PRICE_INDEX_LOCATION_ID,
         "Extent19".LOCATION_CD AS LOCATION_CD1,
         "Extent19".PRICE_INDEX_PRICE_TYPE_ID AS PRICE_INDEX_PRICE_TYPE_ID,
         "Extent19".PRICE_TYPE AS PRICE_TYPE,
         "Extent19".PRICE_INDEX_HML_FLAG AS PRICE_INDEX_HML_FLAG,
         "Extent19".PRICE_INDEX_ADDER AS PRICE_INDEX_ADDER,
         "Extent19".ENTERED_BY AS ENTERED_BY2,
         "Extent19".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
         "Extent19".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
         "Extent19".PRICE_VAL_STATUS_ID AS PRICE_VAL_STATUS_ID,
         "Extent19".DEAL_PRICE_VAL_STATUS AS DEAL_PRICE_VAL_STATUS,
         "Extent19".PRICE_VAL_COMMENT AS PRICE_VAL_COMMENT,
         "Extent19".PRICE_CHANGED AS PRICE_CHANGED,
         "Extent19".ROW_VERSION AS ROW_VERSION2,
         "Extent19".DEAL_SS_ID AS DEAL_SS_ID3,
         FLOOR(CAST(NULL AS NUMBER)) AS C68,
         FLOOR(CAST(NULL AS NUMBER)) AS C69,
         FLOOR(CAST(NULL AS NUMBER)) AS C70,
         FLOOR(CAST(NULL AS NUMBER)) AS C71,
         FLOOR(CAST(NULL AS NUMBER)) AS C72,
         CAST(NULL AS TIMESTAMP(9)) AS C73,
         FLOOR(CAST(NULL AS NUMBER)) AS C74,
         FLOOR(CAST(NULL AS NUMBER)) AS C75,
         CAST(NULL AS NUMBER) AS C76,
         TO_CHAR(NULL) AS C77,
         TO_CHAR(NULL) AS C78,
         CAST(NULL AS TIMESTAMP(9)) AS C79,
         FLOOR(CAST(NULL AS NUMBER)) AS C80,
         FLOOR(CAST(NULL AS NUMBER)) AS C81
      FROM (
         SELECT "Extent14".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID5,
            "Extent14".DEAL_ID AS DEAL_ID5,
            "Extent14".ACTION_DATE AS ACTION_DATE,
            "Extent14".CONF_STATUS_ID AS CONF_STATUS_ID,
            "Extent14".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
            "Extent14".CONF_SENT_DATE AS CONF_SENT_DATE,
            "Extent14".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
            "Extent14".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
            "Extent14".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
            "Extent14".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
            "Extent14".CONF_COMMENT AS CONF_COMMENT,
            "Extent14".ENTERED_BY AS ENTERED_BY5,
            "Extent14".LAST_UPDATE_USER AS LAST_UPDATE_USER7,
            "Extent14".LAST_UPDATE_TMS AS LAST_UPDATE_TMS7,
            "Extent14".ROW_VERSION AS ROW_VERSION7,
            "Extent14".PREVENT_SEND AS PREVENT_SEND,
            "Extent14".DEAL_SS_ID AS DEAL_SS_ID6,
            "Extent15".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID6,
            "Extent15".CONFIRMATION_PDF AS CONFIRMATION_PDF,
            "Extent15".LAST_UPDATE_USER AS LAST_UPDATE_USER8,
            "Extent15".LAST_UPDATE_TMS AS LAST_UPDATE_TMS8,
            "Extent15".ROW_VERSION AS ROW_VERSION8,
            "Extent16".DEAL_SS_ID AS DEAL_SS_ID5,
            "Extent16".DEAL_ID AS DEAL_ID6,
            "Extent16".DATE_ENTERED AS DATE_ENTERED,
            "Extent16".DATE_OF_DEAL AS DATE_OF_DEAL,
            "Extent16".FLOW_DATE_START AS FLOW_DATE_START,
            "Extent16".FLOW_DATE_END AS FLOW_DATE_END,
            "Extent16".DEAL_NUMBER AS DEAL_NUMBER,
            "Extent16".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
            "Extent16".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
            "Extent16".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
            "Extent16".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
            "Extent16".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
            "Extent16".CONTACT_OTHER AS CONTACT_OTHER,
            "Extent16".MO_CONTACT_ID AS MO_CONTACT_ID,
            "Extent16".MO_CONTACT_NAME AS MO_CONTACT_NAME,
            "Extent16".PIPELINE_ID AS PIPELINE_ID,
            "Extent16".PIPELINE_CD AS PIPELINE_CD,
            "Extent16".ZONE_ID AS ZONE_ID,
            "Extent16".ZONE_CD AS ZONE_CD,
            "Extent16".LOCATION_ID AS LOCATION_ID,
            "Extent16".LOCATION_CD AS LOCATION_CD,
            "Extent16".DEAL_TYPE_ID AS DEAL_TYPE_ID,
            "Extent16".DEAL_TYPE AS DEAL_TYPE,
            "Extent16".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
            "Extent16".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
            "Extent16".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
            "Extent16".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
            "Extent16".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
            "Extent16".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
            "Extent16".RATE_PLAN_ID AS RATE_PLAN_ID,
            "Extent16".PROMOTED AS PROMOTED,
            "Extent16".DELIVERED AS DELIVERED,
            "Extent16".CANCELED AS CANCELED,
            "Extent16".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
            "Extent16".DEAL_COMMENT AS DEAL_COMMENT,
            "Extent16".ENTERED_BY AS ENTERED_BY6,
            "Extent16".LAST_UPDATE_USER AS LAST_UPDATE_USER9,
            "Extent16".LAST_UPDATE_TMS AS LAST_UPDATE_TMS9,
            "Extent16".NEED_ACCOUNT AS NEED_ACCOUNT,
            "Extent16".RESUBMITTED AS RESUBMITTED,
            "Extent16".STORAGE_TRANSFER AS STORAGE_TRANSFER,
            "Extent16".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
            "Extent16".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
            "Extent16".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
            "Extent16".ROW_VERSION AS ROW_VERSION9,
            "Extent16".DEAL552CODE_ID AS DEAL552CODE_ID,
            "Extent16".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
            "Extent16".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
            "Extent16".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
         FROM GCSM9.DEAL_CONFIRMATION "Extent14" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent15" ON "Extent14".DEAL_CONFIRM_ID =
         "Extent15".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent16" ON "Extent14".DEAL_SS_ID = "Extent16".DEAL_SS_ID 
         WHERE ((1 = "Extent14".CONF_STATUS_ID) 
         AND (5 <> "Extent14".CONF_STATUS_ID)) 
         AND ("Extent16".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter5" INNER JOIN 
         GCSM9.DEAL_SS "Extent17" ON "Filter5".DEAL_SS_ID6 = "Extent17".DEAL_SS_ID LEFT OUTER JOIN GCSM9.DEAL_SS "Extent18" ON 
         "Filter5".DEAL_SS_ID6 = "Extent18".DEAL_SS_ID INNER JOIN GCSM9.DEAL_TRX_PRICING_SS "Extent19" ON "Filter5".DEAL_SS_ID6 = 
         "Extent19".DEAL_SS_ID 
      WHERE "Extent17".FLOW_DATE_START <= TO_TIMESTAMP('2010-02-28 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) "UnionAll2" UNION ALL 
   SELECT 4 AS C1,
      "Filter7".DEAL_CONFIRM_ID7 AS DEAL_CONFIRM_ID,
      "Filter7".DEAL_ID7 AS DEAL_ID,
      "Filter7".ACTION_DATE AS ACTION_DATE,
      "Filter7".CONF_STATUS_ID AS CONF_STATUS_ID,
      "Filter7".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
      "Filter7".CONF_SENT_DATE AS CONF_SENT_DATE,
      "Filter7".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
      "Filter7".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
      "Filter7".CONF_COMMENT AS CONF_COMMENT,
      "Filter7".ENTERED_BY7 AS ENTERED_BY,
      "Filter7".LAST_UPDATE_USER10 AS LAST_UPDATE_USER,
      "Filter7".LAST_UPDATE_TMS10 AS LAST_UPDATE_TMS,
      "Filter7".ROW_VERSION10 AS ROW_VERSION,
      "Filter7".PREVENT_SEND AS PREVENT_SEND,
      "Filter7".DEAL_SS_ID7 AS DEAL_SS_ID,
      "Extent23".DEAL_SS_ID AS DEAL_SS_ID1,
      1 AS C2,
      1 AS C3,
      "Extent24".DEAL_SS_ID AS DEAL_SS_ID2,
      "Extent24".DEAL_ID AS DEAL_ID1,
      "Extent24".DATE_ENTERED AS DATE_ENTERED,
      "Extent24".DATE_OF_DEAL AS DATE_OF_DEAL,
      "Extent24".FLOW_DATE_START AS FLOW_DATE_START,
      "Extent24".FLOW_DATE_END AS FLOW_DATE_END,
      "Extent24".DEAL_NUMBER AS DEAL_NUMBER,
      "Extent24".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
      "Extent24".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
      "Extent24".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
      "Extent24".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
      "Extent24".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
      "Extent24".CONTACT_OTHER AS CONTACT_OTHER,
      "Extent24".MO_CONTACT_ID AS MO_CONTACT_ID,
      "Extent24".MO_CONTACT_NAME AS MO_CONTACT_NAME,
      "Extent24".PIPELINE_ID AS PIPELINE_ID,
      "Extent24".PIPELINE_CD AS PIPELINE_CD,
      "Extent24".ZONE_ID AS ZONE_ID,
      "Extent24".ZONE_CD AS ZONE_CD,
      "Extent24".LOCATION_ID AS LOCATION_ID,
      "Extent24".LOCATION_CD AS LOCATION_CD,
      "Extent24".DEAL_TYPE_ID AS DEAL_TYPE_ID,
      "Extent24".DEAL_TYPE AS DEAL_TYPE,
      "Extent24".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
      "Extent24".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
      "Extent24".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
      "Extent24".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
      "Extent24".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
      "Extent24".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
      "Extent24".RATE_PLAN_ID AS RATE_PLAN_ID,
      "Extent24".PROMOTED AS PROMOTED,
      "Extent24".DELIVERED AS DELIVERED,
      "Extent24".CANCELED AS CANCELED,
      "Extent24".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
      "Extent24".DEAL_COMMENT AS DEAL_COMMENT,
      "Extent24".ENTERED_BY AS ENTERED_BY1,
      "Extent24".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
      "Extent24".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
      "Extent24".NEED_ACCOUNT AS NEED_ACCOUNT,
      "Extent24".RESUBMITTED AS RESUBMITTED,
      "Extent24".STORAGE_TRANSFER AS STORAGE_TRANSFER,
      "Extent24".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
      "Extent24".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
      "Extent24".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
      "Extent24".ROW_VERSION AS ROW_VERSION1,
      "Extent24".DEAL552CODE_ID AS DEAL552CODE_ID,
      "Extent24".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
      "Extent24".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
      "Extent24".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
      "Filter7".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
      "Filter7".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
      "Filter7".DEAL_CONFIRM_ID8 AS DEAL_CONFIRM_ID1,
      FLOOR(CAST(NULL AS NUMBER)) AS C4,
      FLOOR(CAST(NULL AS NUMBER)) AS C5,
      FLOOR(CAST(NULL AS NUMBER)) AS C6,
      TO_CHAR(NULL) AS C7,
      CAST(NULL AS TIMESTAMP(9)) AS C8,
      FLOOR(CAST(NULL AS NUMBER)) AS C9,
      TO_CHAR(NULL) AS C10,
      TO_CHAR(NULL) AS C11,
      CAST(NULL AS TIMESTAMP(9)) AS C12,
      FLOOR(CAST(NULL AS NUMBER)) AS C13,
      FLOOR(CAST(NULL AS NUMBER)) AS C14,
      FLOOR(CAST(NULL AS NUMBER)) AS C15,
      FLOOR(CAST(NULL AS NUMBER)) AS C16,
      FLOOR(CAST(NULL AS NUMBER)) AS C17,
      TO_CHAR(NULL) AS C18,
      FLOOR(CAST(NULL AS NUMBER)) AS C19,
      TO_CHAR(NULL) AS C20,
      TO_CHAR(NULL) AS C21,
      TO_CHAR(NULL) AS C22,
      TO_CHAR(NULL) AS C23,
      TO_CHAR(NULL) AS C24,
      TO_CHAR(NULL) AS C25,
      TO_CHAR(NULL) AS C26,
      TO_CHAR(NULL) AS C27,
      TO_CHAR(NULL) AS C28,
      TO_CHAR(NULL) AS C29,
      TO_CHAR(NULL) AS C30,
      TO_CHAR(NULL) AS C31,
      TO_CHAR(NULL) AS C32,
      TO_CHAR(NULL) AS C33,
      FLOOR(CAST(NULL AS NUMBER)) AS C34,
      FLOOR(CAST(NULL AS NUMBER)) AS C35,
      FLOOR(CAST(NULL AS NUMBER)) AS C36,
      TO_CHAR(NULL) AS C37,
      TO_CHAR(NULL) AS C38,
      CAST(NULL AS TIMESTAMP(9)) AS C39,
      FLOOR(CAST(NULL AS NUMBER)) AS C40,
      FLOOR(CAST(NULL AS NUMBER)) AS C41,
      FLOOR(CAST(NULL AS NUMBER)) AS C42,
      FLOOR(CAST(NULL AS NUMBER)) AS C43,
      FLOOR(CAST(NULL AS NUMBER)) AS C44,
      FLOOR(CAST(NULL AS NUMBER)) AS C45,
      FLOOR(CAST(NULL AS NUMBER)) AS C46,
      FLOOR(CAST(NULL AS NUMBER)) AS C47,
      FLOOR(CAST(NULL AS NUMBER)) AS C48,
      TO_CHAR(NULL) AS C49,
      CAST(NULL AS NUMBER) AS C50,
      FLOOR(CAST(NULL AS NUMBER)) AS C51,
      TO_CHAR(NULL) AS C52,
      TO_CHAR(NULL) AS C53,
      TO_CHAR(NULL) AS C54,
      TO_CHAR(NULL) AS C55,
      TO_CHAR(NULL) AS C56,
      TO_CHAR(NULL) AS C57,
      FLOOR(CAST(NULL AS NUMBER)) AS C58,
      TO_CHAR(NULL) AS C59,
      TO_CHAR(NULL) AS C60,
      CAST(NULL AS NUMBER) AS C61,
      TO_CHAR(NULL) AS C62,
      TO_CHAR(NULL) AS C63,
      CAST(NULL AS TIMESTAMP(9)) AS C64,
      FLOOR(CAST(NULL AS NUMBER)) AS C65,
      FLOOR(CAST(NULL AS NUMBER)) AS C66,
      FLOOR(CAST(NULL AS NUMBER)) AS C67,
      FLOOR(CAST(NULL AS NUMBER)) AS C68,
      FLOOR(CAST(NULL AS NUMBER)) AS C69,
      FLOOR(CAST(NULL AS NUMBER)) AS C70,
      FLOOR(CAST(NULL AS NUMBER)) AS C71,
      FLOOR(CAST(NULL AS NUMBER)) AS C72,
      FLOOR(CAST(NULL AS NUMBER)) AS C73,
      FLOOR(CAST(NULL AS NUMBER)) AS C74,
      TO_CHAR(NULL) AS C75,
      FLOOR(CAST(NULL AS NUMBER)) AS C76,
      FLOOR(CAST(NULL AS NUMBER)) AS C77,
      CAST(NULL AS NUMBER) AS C78,
      CAST(NULL AS NUMBER) AS C79,
      FLOOR(CAST(NULL AS NUMBER)) AS C80,
      TO_CHAR(NULL) AS C81,
      TO_CHAR(NULL) AS C82,
      TO_CHAR(NULL) AS C83,
      TO_CHAR(NULL) AS C84,
      TO_CHAR(NULL) AS C85,
      TO_CHAR(NULL) AS C86,
      FLOOR(CAST(NULL AS NUMBER)) AS C87,
      TO_CHAR(NULL) AS C88,
      TO_CHAR(NULL) AS C89,
      CAST(NULL AS NUMBER) AS C90,
      TO_CHAR(NULL) AS C91,
      TO_CHAR(NULL) AS C92,
      CAST(NULL AS TIMESTAMP(9)) AS C93,
      FLOOR(CAST(NULL AS NUMBER)) AS C94,
      TO_CHAR(NULL) AS C95,
      TO_CHAR(NULL) AS C96,
      FLOOR(CAST(NULL AS NUMBER)) AS C97,
      FLOOR(CAST(NULL AS NUMBER)) AS C98,
      FLOOR(CAST(NULL AS NUMBER)) AS C99,
      1 AS C100,
      "Extent25".DEAL_TRX_SS_ID AS DEAL_TRX_SS_ID,
      "Extent25".DEAL_TRX_ID AS DEAL_TRX_ID,
      "Extent25".DEAL_ID AS DEAL_ID2,
      "Extent25".DEAL_NUMBER AS DEAL_NUMBER1,
      "Extent25".FLOW_DATE AS FLOW_DATE,
      "Extent25".VOLUME AS VOLUME,
      "Extent25".VOLUME_CHANGED AS VOLUME_CHANGED,
      "Extent25".FINAL_PRICE AS FINAL_PRICE,
      "Extent25".ENTERED_BY AS ENTERED_BY2,
      "Extent25".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
      "Extent25".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
      "Extent25".ROW_VERSION AS ROW_VERSION2,
      "Extent25".DEAL_SS_ID AS DEAL_SS_ID3
   FROM (
      SELECT "Extent20".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID7,
         "Extent20".DEAL_ID AS DEAL_ID7,
         "Extent20".ACTION_DATE AS ACTION_DATE,
         "Extent20".CONF_STATUS_ID AS CONF_STATUS_ID,
         "Extent20".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
         "Extent20".CONF_SENT_DATE AS CONF_SENT_DATE,
         "Extent20".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
         "Extent20".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
         "Extent20".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
         "Extent20".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
         "Extent20".CONF_COMMENT AS CONF_COMMENT,
         "Extent20".ENTERED_BY AS ENTERED_BY7,
         "Extent20".LAST_UPDATE_USER AS LAST_UPDATE_USER10,
         "Extent20".LAST_UPDATE_TMS AS LAST_UPDATE_TMS10,
         "Extent20".ROW_VERSION AS ROW_VERSION10,
         "Extent20".PREVENT_SEND AS PREVENT_SEND,
         "Extent20".DEAL_SS_ID AS DEAL_SS_ID8,
         "Extent21".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID8,
         "Extent21".CONFIRMATION_PDF AS CONFIRMATION_PDF,
         "Extent21".LAST_UPDATE_USER AS LAST_UPDATE_USER11,
         "Extent21".LAST_UPDATE_TMS AS LAST_UPDATE_TMS11,
         "Extent21".ROW_VERSION AS ROW_VERSION11,
         "Extent22".DEAL_SS_ID AS DEAL_SS_ID7,
         "Extent22".DEAL_ID AS DEAL_ID8,
         "Extent22".DATE_ENTERED AS DATE_ENTERED,
         "Extent22".DATE_OF_DEAL AS DATE_OF_DEAL,
         "Extent22".FLOW_DATE_START AS FLOW_DATE_START,
         "Extent22".FLOW_DATE_END AS FLOW_DATE_END,
         "Extent22".DEAL_NUMBER AS DEAL_NUMBER,
         "Extent22".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
         "Extent22".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
         "Extent22".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
         "Extent22".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
         "Extent22".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
         "Extent22".CONTACT_OTHER AS CONTACT_OTHER,
         "Extent22".MO_CONTACT_ID AS MO_CONTACT_ID,
         "Extent22".MO_CONTACT_NAME AS MO_CONTACT_NAME,
         "Extent22".PIPELINE_ID AS PIPELINE_ID,
         "Extent22".PIPELINE_CD AS PIPELINE_CD,
         "Extent22".ZONE_ID AS ZONE_ID,
         "Extent22".ZONE_CD AS ZONE_CD,
         "Extent22".LOCATION_ID AS LOCATION_ID,
         "Extent22".LOCATION_CD AS LOCATION_CD,
         "Extent22".DEAL_TYPE_ID AS DEAL_TYPE_ID,
         "Extent22".DEAL_TYPE AS DEAL_TYPE,
         "Extent22".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
         "Extent22".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
         "Extent22".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
         "Extent22".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
         "Extent22".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
         "Extent22".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
         "Extent22".RATE_PLAN_ID AS RATE_PLAN_ID,
         "Extent22".PROMOTED AS PROMOTED,
         "Extent22".DELIVERED AS DELIVERED,
         "Extent22".CANCELED AS CANCELED,
         "Extent22".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
         "Extent22".DEAL_COMMENT AS DEAL_COMMENT,
         "Extent22".ENTERED_BY AS ENTERED_BY8,
         "Extent22".LAST_UPDATE_USER AS LAST_UPDATE_USER12,
         "Extent22".LAST_UPDATE_TMS AS LAST_UPDATE_TMS12,
         "Extent22".NEED_ACCOUNT AS NEED_ACCOUNT,
         "Extent22".RESUBMITTED AS RESUBMITTED,
         "Extent22".STORAGE_TRANSFER AS STORAGE_TRANSFER,
         "Extent22".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
         "Extent22".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
         "Extent22".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
         "Extent22".ROW_VERSION AS ROW_VERSION12,
         "Extent22".DEAL552CODE_ID AS DEAL552CODE_ID,
         "Extent22".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
         "Extent22".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
         "Extent22".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
      FROM GCSM9.DEAL_CONFIRMATION "Extent20" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent21" ON "Extent20".DEAL_CONFIRM_ID = 
      "Extent21".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent22" ON "Extent20".DEAL_SS_ID = "Extent22".DEAL_SS_ID 
      WHERE ((1 = "Extent20".CONF_STATUS_ID) 
      AND (5 <> "Extent20".CONF_STATUS_ID)) 
      AND ("Extent22".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter7" INNER JOIN 
      GCSM9.DEAL_SS "Extent23" ON "Filter7".DEAL_SS_ID8 = "Extent23".DEAL_SS_ID LEFT OUTER JOIN GCSM9.DEAL_SS "Extent24" ON "Filter7".DEAL_SS_ID8
      = "Extent24".DEAL_SS_ID INNER JOIN GCSM9.DEAL_TRX_SS "Extent25" ON "Filter7".DEAL_SS_ID8 = "Extent25".DEAL_SS_ID 
   WHERE "Extent23".FLOW_DATE_START <= TO_TIMESTAMP('2010-02-28 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) "UnionAll3" 
ORDER BY "UnionAll3".C2 ASC, "UnionAll3".C16 ASC, "UnionAll3".C17 ASC, "UnionAll3".C20 ASC, "UnionAll3".C71 ASC, "UnionAll3".C1 ASC 
[/code]

The problem is that this query only returns some of the records that should be returned.  And only in one of our database environments.  We have done the obvious things and all of the tables are the same.  There are some differences in indexes and constraints between the database where the query works and where it doesn't.
Also, if we comment out the one of the date range where clause, i.e.:
		//.Where(c => c.DealSnapShot.FlowDateStart <= filter.FlowDateEnd)
The resulting query does return all the expected records in all database environments.  Here is what the working query looks like:

[code]SELECT "UnionAll3".C2 AS C1,
   "UnionAll3".C3 AS C2,
   "UnionAll3".C4 AS C3,
   "UnionAll3".C5 AS C4,
   "UnionAll3".C6 AS C5,
   "UnionAll3".C7 AS C6,
   "UnionAll3".C8 AS C7,
   "UnionAll3".C9 AS C8,
   "UnionAll3".C10 AS C9,
   "UnionAll3".C11 AS C10,
   "UnionAll3".C12 AS C11,
   "UnionAll3".C13 AS C12,
   "UnionAll3".C14 AS C13,
   "UnionAll3".C15 AS C14,
   "UnionAll3".C16 AS C15,
   "UnionAll3".C17 AS C16,
   "UnionAll3".C18 AS C17,
   "UnionAll3".C19 AS C18,
   "UnionAll3".C20 AS C19,
   "UnionAll3".C21 AS C20,
   "UnionAll3".C22 AS C21,
   "UnionAll3".C23 AS C22,
   "UnionAll3".C24 AS C23,
   "UnionAll3".C25 AS C24,
   "UnionAll3".C26 AS C25,
   "UnionAll3".C27 AS C26,
   "UnionAll3".C28 AS C27,
   "UnionAll3".C29 AS C28,
   "UnionAll3".C30 AS C29,
   "UnionAll3".C31 AS C30,
   "UnionAll3".C32 AS C31,
   "UnionAll3".C33 AS C32,
   "UnionAll3".C34 AS C33,
   "UnionAll3".C35 AS C34,
   "UnionAll3".C36 AS C35,
   "UnionAll3".C37 AS C36,
   "UnionAll3".C38 AS C37,
   "UnionAll3".C39 AS C38,
   "UnionAll3".C40 AS C39,
   "UnionAll3".C41 AS C40,
   "UnionAll3".C42 AS C41,
   "UnionAll3".C43 AS C42,
   "UnionAll3".C44 AS C43,
   "UnionAll3".C45 AS C44,
   "UnionAll3".C46 AS C45,
   "UnionAll3".C47 AS C46,
   "UnionAll3".C48 AS C47,
   "UnionAll3".C49 AS C48,
   "UnionAll3".C50 AS C49,
   "UnionAll3".C51 AS C50,
   "UnionAll3".C52 AS C51,
   "UnionAll3".C53 AS C52,
   "UnionAll3".C54 AS C53,
   "UnionAll3".C55 AS C54,
   "UnionAll3".C56 AS C55,
   "UnionAll3".C57 AS C56,
   "UnionAll3".C58 AS C57,
   "UnionAll3".C59 AS C58,
   "UnionAll3".C60 AS C59,
   "UnionAll3".C61 AS C60,
   "UnionAll3".C62 AS C61,
   "UnionAll3".C63 AS C62,
   "UnionAll3".C64 AS C63,
   "UnionAll3".C65 AS C64,
   "UnionAll3".C66 AS C65,
   "UnionAll3".C67 AS C66,
   "UnionAll3".C68 AS C67,
   "UnionAll3".C69 AS C68,
   "UnionAll3".C70 AS C69,
   "UnionAll3".C1 AS C70,
   "UnionAll3".C71 AS C71,
   "UnionAll3".C72 AS C72,
   "UnionAll3".C73 AS C73,
   "UnionAll3".C74 AS C74,
   "UnionAll3".C75 AS C75,
   "UnionAll3".C76 AS C76,
   "UnionAll3".C77 AS C77,
   "UnionAll3".C78 AS C78,
   "UnionAll3".C79 AS C79,
   "UnionAll3".C80 AS C80,
   "UnionAll3".C81 AS C81,
   "UnionAll3".C82 AS C82,
   "UnionAll3".C83 AS C83,
   "UnionAll3".C84 AS C84,
   "UnionAll3".C85 AS C85,
   "UnionAll3".C86 AS C86,
   "UnionAll3".C87 AS C87,
   "UnionAll3".C88 AS C88,
   "UnionAll3".C89 AS C89,
   "UnionAll3".C90 AS C90,
   "UnionAll3".C91 AS C91,
   "UnionAll3".C92 AS C92,
   "UnionAll3".C93 AS C93,
   "UnionAll3".C94 AS C94,
   "UnionAll3".C95 AS C95,
   "UnionAll3".C96 AS C96,
   "UnionAll3".C97 AS C97,
   "UnionAll3".C98 AS C98,
   "UnionAll3".C99 AS C99,
   "UnionAll3".C100 AS C100,
   "UnionAll3".C101 AS C101,
   "UnionAll3".C102 AS C102,
   "UnionAll3".C103 AS C103,
   "UnionAll3".C104 AS C104,
   "UnionAll3".C105 AS C105,
   "UnionAll3".C106 AS C106,
   "UnionAll3".C107 AS C107,
   "UnionAll3".C108 AS C108,
   "UnionAll3".C109 AS C109,
   "UnionAll3".C110 AS C110,
   "UnionAll3".C111 AS C111,
   "UnionAll3".C112 AS C112,
   "UnionAll3".C113 AS C113,
   "UnionAll3".C114 AS C114,
   "UnionAll3".C115 AS C115,
   "UnionAll3".C116 AS C116,
   "UnionAll3".C117 AS C117,
   "UnionAll3".C118 AS C118,
   "UnionAll3".C119 AS C119,
   "UnionAll3".C120 AS C120,
   "UnionAll3".C121 AS C121,
   "UnionAll3".C122 AS C122,
   "UnionAll3".C123 AS C123,
   "UnionAll3".C124 AS C124,
   "UnionAll3".C125 AS C125,
   "UnionAll3".C126 AS C126,
   "UnionAll3".C127 AS C127,
   "UnionAll3".C128 AS C128,
   "UnionAll3".C129 AS C129,
   "UnionAll3".C130 AS C130,
   "UnionAll3".C131 AS C131,
   "UnionAll3".C132 AS C132,
   "UnionAll3".C133 AS C133,
   "UnionAll3".C134 AS C134,
   "UnionAll3".C135 AS C135,
   "UnionAll3".C136 AS C136,
   "UnionAll3".C137 AS C137,
   "UnionAll3".C138 AS C138,
   "UnionAll3".C139 AS C139,
   "UnionAll3".C140 AS C140,
   "UnionAll3".C141 AS C141,
   "UnionAll3".C142 AS C142,
   "UnionAll3".C143 AS C143,
   "UnionAll3".C144 AS C144,
   "UnionAll3".C145 AS C145,
   "UnionAll3".C146 AS C146,
   "UnionAll3".C147 AS C147,
   "UnionAll3".C148 AS C148,
   "UnionAll3".C149 AS C149,
   "UnionAll3".C150 AS C150,
   "UnionAll3".C151 AS C151,
   "UnionAll3".C152 AS C152,
   "UnionAll3".C153 AS C153,
   "UnionAll3".C154 AS C154,
   "UnionAll3".C155 AS C155,
   "UnionAll3".C156 AS C156,
   "UnionAll3".C157 AS C157,
   "UnionAll3".C158 AS C158,
   "UnionAll3".C159 AS C159,
   "UnionAll3".C160 AS C160,
   "UnionAll3".C161 AS C161,
   "UnionAll3".C162 AS C162,
   "UnionAll3".C163 AS C163,
   "UnionAll3".C164 AS C164,
   "UnionAll3".C165 AS C165,
   "UnionAll3".C166 AS C166,
   "UnionAll3".C167 AS C167,
   "UnionAll3".C168 AS C168,
   "UnionAll3".C169 AS C169,
   "UnionAll3".C170 AS C170,
   "UnionAll3".C171 AS C171,
   "UnionAll3".C172 AS C172,
   "UnionAll3".C173 AS C173,
   "UnionAll3".C174 AS C174,
   "UnionAll3".C175 AS C175,
   "UnionAll3".C176 AS C176,
   "UnionAll3".C177 AS C177,
   "UnionAll3".C178 AS C178,
   "UnionAll3".C179 AS C179,
   "UnionAll3".C180 AS C180
FROM (
   SELECT "UnionAll2".C1 AS C1,
      "UnionAll2".C2 AS C2,
      "UnionAll2".C3 AS C3,
      "UnionAll2".C4 AS C4,
      "UnionAll2".C5 AS C5,
      "UnionAll2".C6 AS C6,
      "UnionAll2".C7 AS C7,
      "UnionAll2".C8 AS C8,
      "UnionAll2".C9 AS C9,
      "UnionAll2".C10 AS C10,
      "UnionAll2".C11 AS C11,
      "UnionAll2".C12 AS C12,
      "UnionAll2".C13 AS C13,
      "UnionAll2".C14 AS C14,
      "UnionAll2".C15 AS C15,
      "UnionAll2".C16 AS C16,
      "UnionAll2".C17 AS C17,
      "UnionAll2".C18 AS C18,
      "UnionAll2".C19 AS C19,
      "UnionAll2".C20 AS C20,
      "UnionAll2".C21 AS C21,
      "UnionAll2".C22 AS C22,
      "UnionAll2".C23 AS C23,
      "UnionAll2".C24 AS C24,
      "UnionAll2".C25 AS C25,
      "UnionAll2".C26 AS C26,
      "UnionAll2".C27 AS C27,
      "UnionAll2".C28 AS C28,
      "UnionAll2".C29 AS C29,
      "UnionAll2".C30 AS C30,
      "UnionAll2".C31 AS C31,
      "UnionAll2".C32 AS C32,
      "UnionAll2".C33 AS C33,
      "UnionAll2".C34 AS C34,
      "UnionAll2".C35 AS C35,
      "UnionAll2".C36 AS C36,
      "UnionAll2".C37 AS C37,
      "UnionAll2".C38 AS C38,
      "UnionAll2".C39 AS C39,
      "UnionAll2".C40 AS C40,
      "UnionAll2".C41 AS C41,
      "UnionAll2".C42 AS C42,
      "UnionAll2".C43 AS C43,
      "UnionAll2".C44 AS C44,
      "UnionAll2".C45 AS C45,
      "UnionAll2".C46 AS C46,
      "UnionAll2".C47 AS C47,
      "UnionAll2".C48 AS C48,
      "UnionAll2".C49 AS C49,
      "UnionAll2".C50 AS C50,
      "UnionAll2".C51 AS C51,
      "UnionAll2".C52 AS C52,
      "UnionAll2".C53 AS C53,
      "UnionAll2".C54 AS C54,
      "UnionAll2".C55 AS C55,
      "UnionAll2".C56 AS C56,
      "UnionAll2".C57 AS C57,
      "UnionAll2".C58 AS C58,
      "UnionAll2".C59 AS C59,
      "UnionAll2".C60 AS C60,
      "UnionAll2".C61 AS C61,
      "UnionAll2".C62 AS C62,
      "UnionAll2".C63 AS C63,
      "UnionAll2".C64 AS C64,
      "UnionAll2".C65 AS C65,
      "UnionAll2".C66 AS C66,
      "UnionAll2".C67 AS C67,
      "UnionAll2".C68 AS C68,
      "UnionAll2".C69 AS C69,
      "UnionAll2".C70 AS C70,
      "UnionAll2".C71 AS C71,
      "UnionAll2".C72 AS C72,
      "UnionAll2".C73 AS C73,
      "UnionAll2".C74 AS C74,
      "UnionAll2".C75 AS C75,
      "UnionAll2".C76 AS C76,
      "UnionAll2".C77 AS C77,
      "UnionAll2".C78 AS C78,
      "UnionAll2".C79 AS C79,
      "UnionAll2".C80 AS C80,
      "UnionAll2".C81 AS C81,
      "UnionAll2".C82 AS C82,
      "UnionAll2".C83 AS C83,
      "UnionAll2".C84 AS C84,
      "UnionAll2".C85 AS C85,
      "UnionAll2".C86 AS C86,
      "UnionAll2".C87 AS C87,
      "UnionAll2".C88 AS C88,
      "UnionAll2".C89 AS C89,
      "UnionAll2".C90 AS C90,
      "UnionAll2".C91 AS C91,
      "UnionAll2".C92 AS C92,
      "UnionAll2".C93 AS C93,
      "UnionAll2".C94 AS C94,
      "UnionAll2".C95 AS C95,
      "UnionAll2".C96 AS C96,
      "UnionAll2".C97 AS C97,
      "UnionAll2".C98 AS C98,
      "UnionAll2".C99 AS C99,
      "UnionAll2".C100 AS C100,
      "UnionAll2".C101 AS C101,
      "UnionAll2".C102 AS C102,
      "UnionAll2".C103 AS C103,
      "UnionAll2".C104 AS C104,
      "UnionAll2".C105 AS C105,
      "UnionAll2".C106 AS C106,
      "UnionAll2".C107 AS C107,
      "UnionAll2".C108 AS C108,
      "UnionAll2".C109 AS C109,
      "UnionAll2".C110 AS C110,
      "UnionAll2".C111 AS C111,
      "UnionAll2".C112 AS C112,
      "UnionAll2".C113 AS C113,
      "UnionAll2".C114 AS C114,
      "UnionAll2".C115 AS C115,
      "UnionAll2".C116 AS C116,
      "UnionAll2".C117 AS C117,
      "UnionAll2".C118 AS C118,
      "UnionAll2".C119 AS C119,
      "UnionAll2".C120 AS C120,
      "UnionAll2".C121 AS C121,
      "UnionAll2".C122 AS C122,
      "UnionAll2".C123 AS C123,
      "UnionAll2".C124 AS C124,
      "UnionAll2".C125 AS C125,
      "UnionAll2".C126 AS C126,
      "UnionAll2".C127 AS C127,
      "UnionAll2".C128 AS C128,
      "UnionAll2".C129 AS C129,
      "UnionAll2".C130 AS C130,
      "UnionAll2".C131 AS C131,
      "UnionAll2".C132 AS C132,
      "UnionAll2".C133 AS C133,
      "UnionAll2".C134 AS C134,
      "UnionAll2".C135 AS C135,
      "UnionAll2".C136 AS C136,
      "UnionAll2".C137 AS C137,
      "UnionAll2".C138 AS C138,
      "UnionAll2".C139 AS C139,
      "UnionAll2".C140 AS C140,
      "UnionAll2".C141 AS C141,
      "UnionAll2".C142 AS C142,
      "UnionAll2".C143 AS C143,
      "UnionAll2".C144 AS C144,
      "UnionAll2".C145 AS C145,
      "UnionAll2".C146 AS C146,
      "UnionAll2".C147 AS C147,
      "UnionAll2".C148 AS C148,
      "UnionAll2".C149 AS C149,
      "UnionAll2".C150 AS C150,
      "UnionAll2".C151 AS C151,
      "UnionAll2".C152 AS C152,
      "UnionAll2".C153 AS C153,
      "UnionAll2".C154 AS C154,
      "UnionAll2".C155 AS C155,
      "UnionAll2".C156 AS C156,
      "UnionAll2".C157 AS C157,
      "UnionAll2".C158 AS C158,
      "UnionAll2".C159 AS C159,
      "UnionAll2".C160 AS C160,
      "UnionAll2".C161 AS C161,
      "UnionAll2".C162 AS C162,
      "UnionAll2".C163 AS C163,
      "UnionAll2".C164 AS C164,
      "UnionAll2".C165 AS C165,
      "UnionAll2".C166 AS C166,
      "UnionAll2".C167 AS C167,
      "UnionAll2".C168 AS C168,
      "UnionAll2".C169 AS C169,
      "UnionAll2".C170 AS C170,
      "UnionAll2".C171 AS C171,
      "UnionAll2".C172 AS C172,
      "UnionAll2".C173 AS C173,
      "UnionAll2".C174 AS C174,
      "UnionAll2".C175 AS C175,
      "UnionAll2".C176 AS C176,
      "UnionAll2".C177 AS C177,
      "UnionAll2".C178 AS C178,
      "UnionAll2".C179 AS C179,
      "UnionAll2".C180 AS C180
   FROM (
      SELECT "UnionAll1".C1 AS C1,
         "UnionAll1".DEAL_CONFIRM_ID AS C2,
         "UnionAll1".DEAL_ID AS C3,
         "UnionAll1".ACTION_DATE AS C4,
         "UnionAll1".CONF_STATUS_ID AS C5,
         "UnionAll1".CONF_SEND_STATUS_ID AS C6,
         "UnionAll1".CONF_SENT_DATE AS C7,
         "UnionAll1".CONF_SEND_METHOD_OTHER_DESC AS C8,
         "UnionAll1".CONF_RECEIVE_DATE AS C9,
         "UnionAll1".CONF_COMMENT AS C10,
         "UnionAll1".ENTERED_BY AS C11,
         "UnionAll1".LAST_UPDATE_USER AS C12,
         "UnionAll1".LAST_UPDATE_TMS AS C13,
         "UnionAll1".ROW_VERSION AS C14,
         "UnionAll1".PREVENT_SEND AS C15,
         "UnionAll1".DEAL_SS_ID AS C16,
         "UnionAll1".C2 AS C17,
         "UnionAll1".C3 AS C18,
         "UnionAll1".DEAL_SS_ID1 AS C19,
         "UnionAll1".DEAL_ID1 AS C20,
         "UnionAll1".DATE_ENTERED AS C21,
         "UnionAll1".DATE_OF_DEAL AS C22,
         "UnionAll1".FLOW_DATE_START AS C23,
         "UnionAll1".FLOW_DATE_END AS C24,
         "UnionAll1".DEAL_NUMBER AS C25,
         "UnionAll1".BUS_ASSOCIATE_ID AS C26,
         "UnionAll1".BUS_ASSOCIATE_CD AS C27,
         "UnionAll1".BUS_ASSOCIATE_NAME AS C28,
         "UnionAll1".SUPPLY_CONTACT_ID AS C29,
         "UnionAll1".SUPPLY_CONTACT_NAME AS C30,
         "UnionAll1".CONTACT_OTHER AS C31,
         "UnionAll1".MO_CONTACT_ID AS C32,
         "UnionAll1".MO_CONTACT_NAME AS C33,
         "UnionAll1".PIPELINE_ID AS C34,
         "UnionAll1".PIPELINE_CD AS C35,
         "UnionAll1".ZONE_ID AS C36,
         "UnionAll1".ZONE_CD AS C37,
         "UnionAll1".LOCATION_ID AS C38,
         "UnionAll1".LOCATION_CD AS C39,
         "UnionAll1".DEAL_TYPE_ID AS C40,
         "UnionAll1".DEAL_TYPE AS C41,
         "UnionAll1".SUPPLY_CONTRACT_ID AS C42,
         "UnionAll1".SUPPLY_CONTRACT_NBR AS C43,
         "UnionAll1".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS C44,
         "UnionAll1".SUPPLY_CONTRACT_JURISDICTN_CD AS C45,
         "UnionAll1".SUPPLY_CONTRACT_TYPE AS C46,
         "UnionAll1".GMS_BROKER_ACCT_NBR AS C47,
         "UnionAll1".RATE_PLAN_ID AS C48,
         "UnionAll1".PROMOTED AS C49,
         "UnionAll1".DELIVERED AS C50,
         "UnionAll1".CANCELED AS C51,
         "UnionAll1".DEAL_TERMS_CHANGED AS C52,
         "UnionAll1".DEAL_COMMENT AS C53,
         "UnionAll1".ENTERED_BY1 AS C54,
         "UnionAll1".LAST_UPDATE_USER1 AS C55,
         "UnionAll1".LAST_UPDATE_TMS1 AS C56,
         "UnionAll1".NEED_ACCOUNT AS C57,
         "UnionAll1".RESUBMITTED AS C58,
         "UnionAll1".STORAGE_TRANSFER AS C59,
         "UnionAll1".MO_CONTACT_OTHER AS C60,
         "UnionAll1".SPECIAL_CONDITIONS AS C61,
         "UnionAll1".HAS_ATTACHED_SHEET AS C62,
         "UnionAll1".ROW_VERSION1 AS C63,
         "UnionAll1".DEAL552CODE_ID AS C64,
         "UnionAll1".FLOW_DATE_START_YEAR AS C65,
         "UnionAll1".FLOW_DATE_START_MONTH AS C66,
         "UnionAll1".SYNC_TO_GMS_FAILED AS C67,
         "UnionAll1".CONF_RECEIVE_METHOD_ID AS C68,
         "UnionAll1".CONF_SEND_METHOD_ID AS C69,
         "UnionAll1".DEAL_CONFIRM_ID1 AS C70,
         "UnionAll1".C4 AS C71,
         "UnionAll1".DEAL_CONF_CONTACTLIST_ID AS C72,
         "UnionAll1".REMOVED AS C73,
         "UnionAll1".CONF_SEND_METHOD_DESC AS C74,
         "UnionAll1".CONF_SENT_DATE1 AS C75,
         "UnionAll1".INCLUDE_BATCH AS C76,
         "UnionAll1".ENTERED_BY2 AS C77,
         "UnionAll1".LAST_UPDATE_USER2 AS C78,
         "UnionAll1".LAST_UPDATE_TMS2 AS C79,
         "UnionAll1".ROW_VERSION2 AS C80,
         "UnionAll1".DEAL_CONFIRM_ID2 AS C81,
         "UnionAll1".CONTACT_METHOD_ID AS C82,
         "UnionAll1".CONTACT_ID AS C83,
         "UnionAll1".CONTACT_DEPT_ID AS C84,
         "UnionAll1".LN_ID AS C85,
         "UnionAll1".STATUS AS C86,
         "UnionAll1".FIRST_NAME AS C87,
         "UnionAll1".LAST_NAME AS C88,
         "UnionAll1".NAME AS C89,
         "UnionAll1".TITLE AS C90,
         "UnionAll1".COMPANY AS C91,
         "UnionAll1".WORK_PHONE AS C92,
         "UnionAll1".CELL_PHONE AS C93,
         "UnionAll1".FAX AS C94,
         "UnionAll1".EMAIL AS C95,
         "UnionAll1".IM AS C96,
         "UnionAll1".STREET AS C97,
         "UnionAll1".CITY AS C98,
         "UnionAll1".STATE AS C99,
         "UnionAll1".ZIP AS C100,
         "UnionAll1".SEND_CONFIRM AS C101,
         "UnionAll1".AUTO_SEND AS C102,
         "UnionAll1".LN_FLAG AS C103,
         "UnionAll1"."COMMENT" AS C104,
         "UnionAll1".LAST_UPDATE_USER3 AS C105,
         "UnionAll1".LAST_UPDATE_TMS3 AS C106,
         "UnionAll1".ROW_VERSION3 AS C107,
         "UnionAll1".C5 AS C108,
         "UnionAll1".C6 AS C109,
         "UnionAll1".C7 AS C110,
         "UnionAll1".C8 AS C111,
         "UnionAll1".C9 AS C112,
         "UnionAll1".C10 AS C113,
         "UnionAll1".C11 AS C114,
         "UnionAll1".C12 AS C115,
         "UnionAll1".C13 AS C116,
         "UnionAll1".C14 AS C117,
         "UnionAll1".C15 AS C118,
         "UnionAll1".C16 AS C119,
         "UnionAll1".C17 AS C120,
         "UnionAll1".C18 AS C121,
         "UnionAll1".C19 AS C122,
         "UnionAll1".C20 AS C123,
         "UnionAll1".C21 AS C124,
         "UnionAll1".C22 AS C125,
         "UnionAll1".C23 AS C126,
         "UnionAll1".C24 AS C127,
         "UnionAll1".C25 AS C128,
         "UnionAll1".C26 AS C129,
         "UnionAll1".C27 AS C130,
         "UnionAll1".C28 AS C131,
         "UnionAll1".C29 AS C132,
         "UnionAll1".C30 AS C133,
         "UnionAll1".C31 AS C134,
         "UnionAll1".C32 AS C135,
         "UnionAll1".C33 AS C136,
         "UnionAll1".C34 AS C137,
         "UnionAll1".C35 AS C138,
         "UnionAll1".C36 AS C139,
         "UnionAll1".C37 AS C140,
         "UnionAll1".C38 AS C141,
         "UnionAll1".C39 AS C142,
         "UnionAll1".C40 AS C143,
         "UnionAll1".C41 AS C144,
         "UnionAll1".C42 AS C145,
         "UnionAll1".C43 AS C146,
         "UnionAll1".C44 AS C147,
         "UnionAll1".C45 AS C148,
         "UnionAll1".C46 AS C149,
         "UnionAll1".C47 AS C150,
         "UnionAll1".C48 AS C151,
         "UnionAll1".C49 AS C152,
         "UnionAll1".C50 AS C153,
         "UnionAll1".C51 AS C154,
         "UnionAll1".C52 AS C155,
         "UnionAll1".C53 AS C156,
         "UnionAll1".C54 AS C157,
         "UnionAll1".C55 AS C158,
         "UnionAll1".C56 AS C159,
         "UnionAll1".C57 AS C160,
         "UnionAll1".C58 AS C161,
         "UnionAll1".C59 AS C162,
         "UnionAll1".C60 AS C163,
         "UnionAll1".C61 AS C164,
         "UnionAll1".C62 AS C165,
         "UnionAll1".C63 AS C166,
         "UnionAll1".C64 AS C167,
         "UnionAll1".C65 AS C168,
         "UnionAll1".C66 AS C169,
         "UnionAll1".C67 AS C170,
         "UnionAll1".C68 AS C171,
         "UnionAll1".C69 AS C172,
         "UnionAll1".C70 AS C173,
         "UnionAll1".C71 AS C174,
         "UnionAll1".C72 AS C175,
         "UnionAll1".C73 AS C176,
         "UnionAll1".C74 AS C177,
         "UnionAll1".C75 AS C178,
         "UnionAll1".C76 AS C179,
         "UnionAll1".C77 AS C180
      FROM (
         SELECT "Project1".C1 AS C1,
            "Filter1".DEAL_CONFIRM_ID1 AS DEAL_CONFIRM_ID,
            "Filter1".DEAL_ID1 AS DEAL_ID,
            "Filter1".ACTION_DATE AS ACTION_DATE,
            "Filter1".CONF_STATUS_ID AS CONF_STATUS_ID,
            "Filter1".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
            "Filter1".CONF_SENT_DATE AS CONF_SENT_DATE,
            "Filter1".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
            "Filter1".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
            "Filter1".CONF_COMMENT AS CONF_COMMENT,
            "Filter1".ENTERED_BY1 AS ENTERED_BY,
            "Filter1".LAST_UPDATE_USER1 AS LAST_UPDATE_USER,
            "Filter1".LAST_UPDATE_TMS1 AS LAST_UPDATE_TMS,
            "Filter1".ROW_VERSION1 AS ROW_VERSION,
            "Filter1".PREVENT_SEND AS PREVENT_SEND,
            "Filter1".DEAL_SS_ID1 AS DEAL_SS_ID,
            1 AS C2,
            1 AS C3,
            "Extent4".DEAL_SS_ID AS DEAL_SS_ID1,
            "Extent4".DEAL_ID AS DEAL_ID1,
            "Extent4".DATE_ENTERED AS DATE_ENTERED,
            "Extent4".DATE_OF_DEAL AS DATE_OF_DEAL,
            "Extent4".FLOW_DATE_START AS FLOW_DATE_START,
            "Extent4".FLOW_DATE_END AS FLOW_DATE_END,
            "Extent4".DEAL_NUMBER AS DEAL_NUMBER,
            "Extent4".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
            "Extent4".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
            "Extent4".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
            "Extent4".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
            "Extent4".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
            "Extent4".CONTACT_OTHER AS CONTACT_OTHER,
            "Extent4".MO_CONTACT_ID AS MO_CONTACT_ID,
            "Extent4".MO_CONTACT_NAME AS MO_CONTACT_NAME,
            "Extent4".PIPELINE_ID AS PIPELINE_ID,
            "Extent4".PIPELINE_CD AS PIPELINE_CD,
            "Extent4".ZONE_ID AS ZONE_ID,
            "Extent4".ZONE_CD AS ZONE_CD,
            "Extent4".LOCATION_ID AS LOCATION_ID,
            "Extent4".LOCATION_CD AS LOCATION_CD,
            "Extent4".DEAL_TYPE_ID AS DEAL_TYPE_ID,
            "Extent4".DEAL_TYPE AS DEAL_TYPE,
            "Extent4".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
            "Extent4".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
            "Extent4".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
            "Extent4".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
            "Extent4".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
            "Extent4".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
            "Extent4".RATE_PLAN_ID AS RATE_PLAN_ID,
            "Extent4".PROMOTED AS PROMOTED,
            "Extent4".DELIVERED AS DELIVERED,
            "Extent4".CANCELED AS CANCELED,
            "Extent4".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
            "Extent4".DEAL_COMMENT AS DEAL_COMMENT,
            "Extent4".ENTERED_BY AS ENTERED_BY1,
            "Extent4".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
            "Extent4".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
            "Extent4".NEED_ACCOUNT AS NEED_ACCOUNT,
            "Extent4".RESUBMITTED AS RESUBMITTED,
            "Extent4".STORAGE_TRANSFER AS STORAGE_TRANSFER,
            "Extent4".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
            "Extent4".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
            "Extent4".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
            "Extent4".ROW_VERSION AS ROW_VERSION1,
            "Extent4".DEAL552CODE_ID AS DEAL552CODE_ID,
            "Extent4".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
            "Extent4".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
            "Extent4".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
            "Filter1".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
            "Filter1".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
            "Filter1".DEAL_CONFIRM_ID2 AS DEAL_CONFIRM_ID1,
            "Project1".C1 AS C4,
            "Project1".DEAL_CONF_CONTACTLIST_ID AS DEAL_CONF_CONTACTLIST_ID,
            "Project1".REMOVED AS REMOVED,
            "Project1".CONF_SEND_METHOD_DESC AS CONF_SEND_METHOD_DESC,
            "Project1".CONF_SENT_DATE AS CONF_SENT_DATE1,
            "Project1".INCLUDE_BATCH AS INCLUDE_BATCH,
            "Project1".ENTERED_BY AS ENTERED_BY2,
            "Project1".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
            "Project1".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
            "Project1".ROW_VERSION AS ROW_VERSION2,
            "Project1".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID2,
            "Project1".CONTACT_METHOD_ID AS CONTACT_METHOD_ID,
            "Project1".CONTACT_ID AS CONTACT_ID,
            "Project1".CONTACT_DEPT_ID AS CONTACT_DEPT_ID,
            "Project1".LN_ID AS LN_ID,
            "Project1".STATUS AS STATUS,
            "Project1".FIRST_NAME AS FIRST_NAME,
            "Project1".LAST_NAME AS LAST_NAME,
            "Project1".NAME AS NAME,
            "Project1".TITLE AS TITLE,
            "Project1".COMPANY AS COMPANY,
            "Project1".WORK_PHONE AS WORK_PHONE,
            "Project1".CELL_PHONE AS CELL_PHONE,
            "Project1".FAX AS FAX,
            "Project1".EMAIL AS EMAIL,
            "Project1".IM AS IM,
            "Project1".STREET AS STREET,
            "Project1".CITY AS CITY,
            "Project1".STATE AS STATE,
            "Project1".ZIP AS ZIP,
            "Project1".SEND_CONFIRM AS SEND_CONFIRM,
            "Project1".AUTO_SEND AS AUTO_SEND,
            "Project1".LN_FLAG AS LN_FLAG,
            "Project1"."COMMENT" AS "COMMENT",
            "Project1".LAST_UPDATE_USER1 AS LAST_UPDATE_USER3,
            "Project1".LAST_UPDATE_TMS1 AS LAST_UPDATE_TMS3,
            "Project1".ROW_VERSION1 AS ROW_VERSION3,
            FLOOR(CAST(NULL AS NUMBER)) AS C5,
            FLOOR(CAST(NULL AS NUMBER)) AS C6,
            FLOOR(CAST(NULL AS NUMBER)) AS C7,
            FLOOR(CAST(NULL AS NUMBER)) AS C8,
            FLOOR(CAST(NULL AS NUMBER)) AS C9,
            FLOOR(CAST(NULL AS NUMBER)) AS C10,
            FLOOR(CAST(NULL AS NUMBER)) AS C11,
            FLOOR(CAST(NULL AS NUMBER)) AS C12,
            TO_CHAR(NULL) AS C13,
            CAST(NULL AS NUMBER) AS C14,
            FLOOR(CAST(NULL AS NUMBER)) AS C15,
            TO_CHAR(NULL) AS C16,
            TO_CHAR(NULL) AS C17,
            TO_CHAR(NULL) AS C18,
            TO_CHAR(NULL) AS C19,
            TO_CHAR(NULL) AS C20,
            TO_CHAR(NULL) AS C21,
            FLOOR(CAST(NULL AS NUMBER)) AS C22,
            TO_CHAR(NULL) AS C23,
            TO_CHAR(NULL) AS C24,
            CAST(NULL AS NUMBER) AS C25,
            TO_CHAR(NULL) AS C26,
            TO_CHAR(NULL) AS C27,
            CAST(NULL AS TIMESTAMP(9)) AS C28,
            FLOOR(CAST(NULL AS NUMBER)) AS C29,
            FLOOR(CAST(NULL AS NUMBER)) AS C30,
            FLOOR(CAST(NULL AS NUMBER)) AS C31,
            FLOOR(CAST(NULL AS NUMBER)) AS C32,
            FLOOR(CAST(NULL AS NUMBER)) AS C33,
            FLOOR(CAST(NULL AS NUMBER)) AS C34,
            FLOOR(CAST(NULL AS NUMBER)) AS C35,
            FLOOR(CAST(NULL AS NUMBER)) AS C36,
            FLOOR(CAST(NULL AS NUMBER)) AS C37,
            FLOOR(CAST(NULL AS NUMBER)) AS C38,
            TO_CHAR(NULL) AS C39,
            FLOOR(CAST(NULL AS NUMBER)) AS C40,
            FLOOR(CAST(NULL AS NUMBER)) AS C41,
            CAST(NULL AS NUMBER) AS C42,
            CAST(NULL AS NUMBER) AS C43,
            FLOOR(CAST(NULL AS NUMBER)) AS C44,
            TO_CHAR(NULL) AS C45,
            TO_CHAR(NULL) AS C46,
            TO_CHAR(NULL) AS C47,
            TO_CHAR(NULL) AS C48,
            TO_CHAR(NULL) AS C49,
            TO_CHAR(NULL) AS C50,
            FLOOR(CAST(NULL AS NUMBER)) AS C51,
            TO_CHAR(NULL) AS C52,
            TO_CHAR(NULL) AS C53,
            CAST(NULL AS NUMBER) AS C54,
            TO_CHAR(NULL) AS C55,
            TO_CHAR(NULL) AS C56,
            CAST(NULL AS TIMESTAMP(9)) AS C57,
            FLOOR(CAST(NULL AS NUMBER)) AS C58,
            TO_CHAR(NULL) AS C59,
            TO_CHAR(NULL) AS C60,
            FLOOR(CAST(NULL AS NUMBER)) AS C61,
            FLOOR(CAST(NULL AS NUMBER)) AS C62,
            FLOOR(CAST(NULL AS NUMBER)) AS C63,
            FLOOR(CAST(NULL AS NUMBER)) AS C64,
            FLOOR(CAST(NULL AS NUMBER)) AS C65,
            FLOOR(CAST(NULL AS NUMBER)) AS C66,
            FLOOR(CAST(NULL AS NUMBER)) AS C67,
            FLOOR(CAST(NULL AS NUMBER)) AS C68,
            CAST(NULL AS TIMESTAMP(9)) AS C69,
            FLOOR(CAST(NULL AS NUMBER)) AS C70,
            FLOOR(CAST(NULL AS NUMBER)) AS C71,
            CAST(NULL AS NUMBER) AS C72,
            TO_CHAR(NULL) AS C73,
            TO_CHAR(NULL) AS C74,
            CAST(NULL AS TIMESTAMP(9)) AS C75,
            FLOOR(CAST(NULL AS NUMBER)) AS C76,
            FLOOR(CAST(NULL AS NUMBER)) AS C77
         FROM (
            SELECT "Extent1".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID1,
               "Extent1".DEAL_ID AS DEAL_ID1,
               "Extent1".ACTION_DATE AS ACTION_DATE,
               "Extent1".CONF_STATUS_ID AS CONF_STATUS_ID,
               "Extent1".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
               "Extent1".CONF_SENT_DATE AS CONF_SENT_DATE,
               "Extent1".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
               "Extent1".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
               "Extent1".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
               "Extent1".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
               "Extent1".CONF_COMMENT AS CONF_COMMENT,
               "Extent1".ENTERED_BY AS ENTERED_BY1,
               "Extent1".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
               "Extent1".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
               "Extent1".ROW_VERSION AS ROW_VERSION1,
               "Extent1".PREVENT_SEND AS PREVENT_SEND,
               "Extent1".DEAL_SS_ID AS DEAL_SS_ID2,
               "Extent2".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID2,
               "Extent2".CONFIRMATION_PDF AS CONFIRMATION_PDF,
               "Extent2".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
               "Extent2".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
               "Extent2".ROW_VERSION AS ROW_VERSION2,
               "Extent3".DEAL_SS_ID AS DEAL_SS_ID1,
               "Extent3".DEAL_ID AS DEAL_ID2,
               "Extent3".DATE_ENTERED AS DATE_ENTERED,
               "Extent3".DATE_OF_DEAL AS DATE_OF_DEAL,
               "Extent3".FLOW_DATE_START AS FLOW_DATE_START,
               "Extent3".FLOW_DATE_END AS FLOW_DATE_END,
               "Extent3".DEAL_NUMBER AS DEAL_NUMBER,
               "Extent3".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
               "Extent3".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
               "Extent3".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
               "Extent3".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
               "Extent3".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
               "Extent3".CONTACT_OTHER AS CONTACT_OTHER,
               "Extent3".MO_CONTACT_ID AS MO_CONTACT_ID,
               "Extent3".MO_CONTACT_NAME AS MO_CONTACT_NAME,
               "Extent3".PIPELINE_ID AS PIPELINE_ID,
               "Extent3".PIPELINE_CD AS PIPELINE_CD,
               "Extent3".ZONE_ID AS ZONE_ID,
               "Extent3".ZONE_CD AS ZONE_CD,
               "Extent3".LOCATION_ID AS LOCATION_ID,
               "Extent3".LOCATION_CD AS LOCATION_CD,
               "Extent3".DEAL_TYPE_ID AS DEAL_TYPE_ID,
               "Extent3".DEAL_TYPE AS DEAL_TYPE,
               "Extent3".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
               "Extent3".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
               "Extent3".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
               "Extent3".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
               "Extent3".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
               "Extent3".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
               "Extent3".RATE_PLAN_ID AS RATE_PLAN_ID,
               "Extent3".PROMOTED AS PROMOTED,
               "Extent3".DELIVERED AS DELIVERED,
               "Extent3".CANCELED AS CANCELED,
               "Extent3".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
               "Extent3".DEAL_COMMENT AS DEAL_COMMENT,
               "Extent3".ENTERED_BY AS ENTERED_BY2,
               "Extent3".LAST_UPDATE_USER AS LAST_UPDATE_USER3,
               "Extent3".LAST_UPDATE_TMS AS LAST_UPDATE_TMS3,
               "Extent3".NEED_ACCOUNT AS NEED_ACCOUNT,
               "Extent3".RESUBMITTED AS RESUBMITTED,
               "Extent3".STORAGE_TRANSFER AS STORAGE_TRANSFER,
               "Extent3".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
               "Extent3".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
               "Extent3".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
               "Extent3".ROW_VERSION AS ROW_VERSION3,
               "Extent3".DEAL552CODE_ID AS DEAL552CODE_ID,
               "Extent3".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
               "Extent3".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
               "Extent3".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
            FROM GCSM9.DEAL_CONFIRMATION "Extent1" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent2" ON "Extent1".DEAL_CONFIRM_ID =
            "Extent2".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent3" ON "Extent1".DEAL_SS_ID = "Extent3".DEAL_SS_ID 
            WHERE ((1 = "Extent1".CONF_STATUS_ID) 
            AND (5 <> "Extent1".CONF_STATUS_ID)) 
            AND ("Extent3".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter1" LEFT OUTER
            JOIN GCSM9.DEAL_SS "Extent4" ON "Filter1".DEAL_SS_ID2 = "Extent4".DEAL_SS_ID LEFT OUTER JOIN (
            SELECT "Extent5".DEAL_CONF_CONTACTLIST_ID AS DEAL_CONF_CONTACTLIST_ID,
               "Extent5".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID,
               "Extent5".REMOVED AS REMOVED,
               "Extent5".CONF_SEND_METHOD_DESC AS CONF_SEND_METHOD_DESC,
               "Extent5".CONF_SENT_DATE AS CONF_SENT_DATE,
               "Extent5".INCLUDE_BATCH AS INCLUDE_BATCH,
               "Extent5".ENTERED_BY AS ENTERED_BY,
               "Extent5".LAST_UPDATE_USER AS LAST_UPDATE_USER,
               "Extent5".LAST_UPDATE_TMS AS LAST_UPDATE_TMS,
               "Extent5".ROW_VERSION AS ROW_VERSION,
               "Extent5".CONTACT_METHOD_ID AS CONTACT_METHOD_ID,
               "Extent6".CONTACT_ID AS CONTACT_ID,
               "Extent6".CONTACT_DEPT_ID AS CONTACT_DEPT_ID,
               "Extent6".LN_ID AS LN_ID,
               "Extent6".STATUS AS STATUS,
               "Extent6".FIRST_NAME AS FIRST_NAME,
               "Extent6".LAST_NAME AS LAST_NAME,
               "Extent6".NAME AS NAME,
               "Extent6".TITLE AS TITLE,
               "Extent6".COMPANY AS COMPANY,
               "Extent6".WORK_PHONE AS WORK_PHONE,
               "Extent6".CELL_PHONE AS CELL_PHONE,
               "Extent6".FAX AS FAX,
               "Extent6".EMAIL AS EMAIL,
               "Extent6".IM AS IM,
               "Extent6".STREET AS STREET,
               "Extent6".CITY AS CITY,
               "Extent6".STATE AS STATE,
               "Extent6".ZIP AS ZIP,
               "Extent6".SEND_CONFIRM AS SEND_CONFIRM,
               "Extent6".AUTO_SEND AS AUTO_SEND,
               "Extent6".LN_FLAG AS LN_FLAG,
               "Extent6"."COMMENT" AS "COMMENT",
               "Extent6".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
               "Extent6".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
               "Extent6".ROW_VERSION AS ROW_VERSION1,
               1 AS C1
            FROM GCSM9.DEAL_CONF_CONTACTLIST "Extent5" LEFT OUTER JOIN GCSM9.CONTACT "Extent6" ON "Extent5".CONTACT_ID = "Extent6".CONTACT_ID
            ) "Project1" ON "Filter1".DEAL_CONFIRM_ID1 = "Project1".DEAL_CONFIRM_ID UNION ALL 
         SELECT 2 AS C1,
            "Filter2".DEAL_CONFIRM_ID3 AS DEAL_CONFIRM_ID,
            "Filter2".DEAL_ID3 AS DEAL_ID,
            "Filter2".ACTION_DATE AS ACTION_DATE,
            "Filter2".CONF_STATUS_ID AS CONF_STATUS_ID,
            "Filter2".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
            "Filter2".CONF_SENT_DATE AS CONF_SENT_DATE,
            "Filter2".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
            "Filter2".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
            "Filter2".CONF_COMMENT AS CONF_COMMENT,
            "Filter2".ENTERED_BY3 AS ENTERED_BY,
            "Filter2".LAST_UPDATE_USER4 AS LAST_UPDATE_USER,
            "Filter2".LAST_UPDATE_TMS4 AS LAST_UPDATE_TMS,
            "Filter2".ROW_VERSION4 AS ROW_VERSION,
            "Filter2".PREVENT_SEND AS PREVENT_SEND,
            "Filter2".DEAL_SS_ID3 AS DEAL_SS_ID,
            1 AS C2,
            1 AS C3,
            "Extent10".DEAL_SS_ID AS DEAL_SS_ID1,
            "Extent10".DEAL_ID AS DEAL_ID1,
            "Extent10".DATE_ENTERED AS DATE_ENTERED,
            "Extent10".DATE_OF_DEAL AS DATE_OF_DEAL,
            "Extent10".FLOW_DATE_START AS FLOW_DATE_START,
            "Extent10".FLOW_DATE_END AS FLOW_DATE_END,
            "Extent10".DEAL_NUMBER AS DEAL_NUMBER,
            "Extent10".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
            "Extent10".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
            "Extent10".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
            "Extent10".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
            "Extent10".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
            "Extent10".CONTACT_OTHER AS CONTACT_OTHER,
            "Extent10".MO_CONTACT_ID AS MO_CONTACT_ID,
            "Extent10".MO_CONTACT_NAME AS MO_CONTACT_NAME,
            "Extent10".PIPELINE_ID AS PIPELINE_ID,
            "Extent10".PIPELINE_CD AS PIPELINE_CD,
            "Extent10".ZONE_ID AS ZONE_ID,
            "Extent10".ZONE_CD AS ZONE_CD,
            "Extent10".LOCATION_ID AS LOCATION_ID,
            "Extent10".LOCATION_CD AS LOCATION_CD,
            "Extent10".DEAL_TYPE_ID AS DEAL_TYPE_ID,
            "Extent10".DEAL_TYPE AS DEAL_TYPE,
            "Extent10".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
            "Extent10".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
            "Extent10".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
            "Extent10".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
            "Extent10".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
            "Extent10".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
            "Extent10".RATE_PLAN_ID AS RATE_PLAN_ID,
            "Extent10".PROMOTED AS PROMOTED,
            "Extent10".DELIVERED AS DELIVERED,
            "Extent10".CANCELED AS CANCELED,
            "Extent10".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
            "Extent10".DEAL_COMMENT AS DEAL_COMMENT,
            "Extent10".ENTERED_BY AS ENTERED_BY1,
            "Extent10".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
            "Extent10".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
            "Extent10".NEED_ACCOUNT AS NEED_ACCOUNT,
            "Extent10".RESUBMITTED AS RESUBMITTED,
            "Extent10".STORAGE_TRANSFER AS STORAGE_TRANSFER,
            "Extent10".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
            "Extent10".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
            "Extent10".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
            "Extent10".ROW_VERSION AS ROW_VERSION1,
            "Extent10".DEAL552CODE_ID AS DEAL552CODE_ID,
            "Extent10".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
            "Extent10".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
            "Extent10".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
            "Filter2".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
            "Filter2".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
            "Filter2".DEAL_CONFIRM_ID4 AS DEAL_CONFIRM_ID1,
            FLOOR(CAST(NULL AS NUMBER)) AS C4,
            FLOOR(CAST(NULL AS NUMBER)) AS C5,
            FLOOR(CAST(NULL AS NUMBER)) AS C6,
            TO_CHAR(NULL) AS C7,
            CAST(NULL AS TIMESTAMP(9)) AS C8,
            FLOOR(CAST(NULL AS NUMBER)) AS C9,
            TO_CHAR(NULL) AS C10,
            TO_CHAR(NULL) AS C11,
            CAST(NULL AS TIMESTAMP(9)) AS C12,
            FLOOR(CAST(NULL AS NUMBER)) AS C13,
            FLOOR(CAST(NULL AS NUMBER)) AS C14,
            FLOOR(CAST(NULL AS NUMBER)) AS C15,
            FLOOR(CAST(NULL AS NUMBER)) AS C16,
            FLOOR(CAST(NULL AS NUMBER)) AS C17,
            TO_CHAR(NULL) AS C18,
            FLOOR(CAST(NULL AS NUMBER)) AS C19,
            TO_CHAR(NULL) AS C20,
            TO_CHAR(NULL) AS C21,
            TO_CHAR(NULL) AS C22,
            TO_CHAR(NULL) AS C23,
            TO_CHAR(NULL) AS C24,
            TO_CHAR(NULL) AS C25,
            TO_CHAR(NULL) AS C26,
            TO_CHAR(NULL) AS C27,
            TO_CHAR(NULL) AS C28,
            TO_CHAR(NULL) AS C29,
            TO_CHAR(NULL) AS C30,
            TO_CHAR(NULL) AS C31,
            TO_CHAR(NULL) AS C32,
            TO_CHAR(NULL) AS C33,
            FLOOR(CAST(NULL AS NUMBER)) AS C34,
            FLOOR(CAST(NULL AS NUMBER)) AS C35,
            FLOOR(CAST(NULL AS NUMBER)) AS C36,
            TO_CHAR(NULL) AS C37,
            TO_CHAR(NULL) AS C38,
            CAST(NULL AS TIMESTAMP(9)) AS C39,
            FLOOR(CAST(NULL AS NUMBER)) AS C40,
            1 AS C41,
            "Extent11".DEAL_PRICING_SS_ID AS DEAL_PRICING_SS_ID,
            "Extent11".DEAL_PRICING_ID AS DEAL_PRICING_ID,
            "Extent11".DEAL_ID AS DEAL_ID2,
            "Extent11".DEAL_NUMBER AS DEAL_NUMBER1,
            "Extent11".VOLUME_MIN AS VOLUME_MIN,
            "Extent11".VOLUME_MAX AS VOLUME_MAX,
            "Extent11".VOLUME_TYPE_ID AS VOLUME_TYPE_ID,
            "Extent11".DEAL_VOLUME_TYPE AS DEAL_VOLUME_TYPE,
            "Extent11".PRICE AS PRICE,
            "Extent11".DEAL_PRICE_TYPE_ID AS DEAL_PRICE_TYPE_ID,
            "Extent11".DEAL_PRICE_TYPE AS DEAL_PRICE_TYPE,
            "Extent11".PRICE_DESCRIPTION AS PRICE_DESCRIPTION,
            "Extent11".PRICE_INDEX_PIPELINE_ID AS PRICE_INDEX_PIPELINE_ID,
            "Extent11".PIPELINE_CD AS PIPELINE_CD1,
            "Extent11".PRICE_INDEX_LOCATION_ID AS PRICE_INDEX_LOCATION_ID,
            "Extent11".LOCATION_CD AS LOCATION_CD1,
            "Extent11".PRICE_INDEX_PRICE_TYPE_ID AS PRICE_INDEX_PRICE_TYPE_ID,
            "Extent11".PRICE_TYPE AS PRICE_TYPE,
            "Extent11".PRICE_INDEX_HML_FLAG AS PRICE_INDEX_HML_FLAG,
            "Extent11".PRICE_INDEX_ADDER AS PRICE_INDEX_ADDER,
            "Extent11".ENTERED_BY AS ENTERED_BY2,
            "Extent11".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
            "Extent11".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
            "Extent11".ROW_VERSION AS ROW_VERSION2,
            "Extent11".DEAL_SS_ID AS DEAL_SS_ID2,
            FLOOR(CAST(NULL AS NUMBER)) AS C42,
            FLOOR(CAST(NULL AS NUMBER)) AS C43,
            FLOOR(CAST(NULL AS NUMBER)) AS C44,
            FLOOR(CAST(NULL AS NUMBER)) AS C45,
            FLOOR(CAST(NULL AS NUMBER)) AS C46,
            FLOOR(CAST(NULL AS NUMBER)) AS C47,
            FLOOR(CAST(NULL AS NUMBER)) AS C48,
            FLOOR(CAST(NULL AS NUMBER)) AS C49,
            TO_CHAR(NULL) AS C50,
            FLOOR(CAST(NULL AS NUMBER)) AS C51,
            FLOOR(CAST(NULL AS NUMBER)) AS C52,
            CAST(NULL AS NUMBER) AS C53,
            CAST(NULL AS NUMBER) AS C54,
            FLOOR(CAST(NULL AS NUMBER)) AS C55,
            TO_CHAR(NULL) AS C56,
            TO_CHAR(NULL) AS C57,
            TO_CHAR(NULL) AS C58,
            TO_CHAR(NULL) AS C59,
            TO_CHAR(NULL) AS C60,
            TO_CHAR(NULL) AS C61,
            FLOOR(CAST(NULL AS NUMBER)) AS C62,
            TO_CHAR(NULL) AS C63,
            TO_CHAR(NULL) AS C64,
            CAST(NULL AS NUMBER) AS C65,
            TO_CHAR(NULL) AS C66,
            TO_CHAR(NULL) AS C67,
            CAST(NULL AS TIMESTAMP(9)) AS C68,
            FLOOR(CAST(NULL AS NUMBER)) AS C69,
            TO_CHAR(NULL) AS C70,
            TO_CHAR(NULL) AS C71,
            FLOOR(CAST(NULL AS NUMBER)) AS C72,
            FLOOR(CAST(NULL AS NUMBER)) AS C73,
            FLOOR(CAST(NULL AS NUMBER)) AS C74,
            FLOOR(CAST(NULL AS NUMBER)) AS C75,
            FLOOR(CAST(NULL AS NUMBER)) AS C76,
            FLOOR(CAST(NULL AS NUMBER)) AS C77,
            FLOOR(CAST(NULL AS NUMBER)) AS C78,
            FLOOR(CAST(NULL AS NUMBER)) AS C79,
            CAST(NULL AS TIMESTAMP(9)) AS C80,
            FLOOR(CAST(NULL AS NUMBER)) AS C81,
            FLOOR(CAST(NULL AS NUMBER)) AS C82,
            CAST(NULL AS NUMBER) AS C83,
            TO_CHAR(NULL) AS C84,
            TO_CHAR(NULL) AS C85,
            CAST(NULL AS TIMESTAMP(9)) AS C86,
            FLOOR(CAST(NULL AS NUMBER)) AS C87,
            FLOOR(CAST(NULL AS NUMBER)) AS C88
         FROM (
            SELECT "Extent7".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID3,
               "Extent7".DEAL_ID AS DEAL_ID3,
               "Extent7".ACTION_DATE AS ACTION_DATE,
               "Extent7".CONF_STATUS_ID AS CONF_STATUS_ID,
               "Extent7".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
               "Extent7".CONF_SENT_DATE AS CONF_SENT_DATE,
               "Extent7".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
               "Extent7".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
               "Extent7".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
               "Extent7".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
               "Extent7".CONF_COMMENT AS CONF_COMMENT,
               "Extent7".ENTERED_BY AS ENTERED_BY3,
               "Extent7".LAST_UPDATE_USER AS LAST_UPDATE_USER4,
               "Extent7".LAST_UPDATE_TMS AS LAST_UPDATE_TMS4,
               "Extent7".ROW_VERSION AS ROW_VERSION4,
               "Extent7".PREVENT_SEND AS PREVENT_SEND,
               "Extent7".DEAL_SS_ID AS DEAL_SS_ID4,
               "Extent8".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID4,
               "Extent8".CONFIRMATION_PDF AS CONFIRMATION_PDF,
               "Extent8".LAST_UPDATE_USER AS LAST_UPDATE_USER5,
               "Extent8".LAST_UPDATE_TMS AS LAST_UPDATE_TMS5,
               "Extent8".ROW_VERSION AS ROW_VERSION5,
               "Extent9".DEAL_SS_ID AS DEAL_SS_ID3,
               "Extent9".DEAL_ID AS DEAL_ID4,
               "Extent9".DATE_ENTERED AS DATE_ENTERED,
               "Extent9".DATE_OF_DEAL AS DATE_OF_DEAL,
               "Extent9".FLOW_DATE_START AS FLOW_DATE_START,
               "Extent9".FLOW_DATE_END AS FLOW_DATE_END,
               "Extent9".DEAL_NUMBER AS DEAL_NUMBER,
               "Extent9".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
               "Extent9".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
               "Extent9".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
               "Extent9".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
               "Extent9".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
               "Extent9".CONTACT_OTHER AS CONTACT_OTHER,
               "Extent9".MO_CONTACT_ID AS MO_CONTACT_ID,
               "Extent9".MO_CONTACT_NAME AS MO_CONTACT_NAME,
               "Extent9".PIPELINE_ID AS PIPELINE_ID,
               "Extent9".PIPELINE_CD AS PIPELINE_CD,
               "Extent9".ZONE_ID AS ZONE_ID,
               "Extent9".ZONE_CD AS ZONE_CD,
               "Extent9".LOCATION_ID AS LOCATION_ID,
               "Extent9".LOCATION_CD AS LOCATION_CD,
               "Extent9".DEAL_TYPE_ID AS DEAL_TYPE_ID,
               "Extent9".DEAL_TYPE AS DEAL_TYPE,
               "Extent9".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
               "Extent9".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
               "Extent9".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
               "Extent9".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
               "Extent9".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
               "Extent9".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
               "Extent9".RATE_PLAN_ID AS RATE_PLAN_ID,
               "Extent9".PROMOTED AS PROMOTED,
               "Extent9".DELIVERED AS DELIVERED,
               "Extent9".CANCELED AS CANCELED,
               "Extent9".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
               "Extent9".DEAL_COMMENT AS DEAL_COMMENT,
               "Extent9".ENTERED_BY AS ENTERED_BY4,
               "Extent9".LAST_UPDATE_USER AS LAST_UPDATE_USER6,
               "Extent9".LAST_UPDATE_TMS AS LAST_UPDATE_TMS6,
               "Extent9".NEED_ACCOUNT AS NEED_ACCOUNT,
               "Extent9".RESUBMITTED AS RESUBMITTED,
               "Extent9".STORAGE_TRANSFER AS STORAGE_TRANSFER,
               "Extent9".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
               "Extent9".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
               "Extent9".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
               "Extent9".ROW_VERSION AS ROW_VERSION6,
               "Extent9".DEAL552CODE_ID AS DEAL552CODE_ID,
               "Extent9".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
               "Extent9".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
               "Extent9".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
            FROM GCSM9.DEAL_CONFIRMATION "Extent7" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent8" ON "Extent7".DEAL_CONFIRM_ID =
            "Extent8".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent9" ON "Extent7".DEAL_SS_ID = "Extent9".DEAL_SS_ID 
            WHERE ((1 = "Extent7".CONF_STATUS_ID) 
            AND (5 <> "Extent7".CONF_STATUS_ID)) 
            AND ("Extent9".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter2" LEFT OUTER
            JOIN GCSM9.DEAL_SS "Extent10" ON "Filter2".DEAL_SS_ID4 = "Extent10".DEAL_SS_ID INNER JOIN GCSM9.DEAL_PRICING_SS "Extent11" 
            ON "Filter2".DEAL_SS_ID4 = "Extent11".DEAL_SS_ID) "UnionAll1" UNION ALL 
      SELECT 3 AS C1,
         "Filter3".DEAL_CONFIRM_ID5 AS DEAL_CONFIRM_ID,
         "Filter3".DEAL_ID5 AS DEAL_ID,
         "Filter3".ACTION_DATE AS ACTION_DATE,
         "Filter3".CONF_STATUS_ID AS CONF_STATUS_ID,
         "Filter3".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
         "Filter3".CONF_SENT_DATE AS CONF_SENT_DATE,
         "Filter3".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
         "Filter3".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
         "Filter3".CONF_COMMENT AS CONF_COMMENT,
         "Filter3".ENTERED_BY5 AS ENTERED_BY,
         "Filter3".LAST_UPDATE_USER7 AS LAST_UPDATE_USER,
         "Filter3".LAST_UPDATE_TMS7 AS LAST_UPDATE_TMS,
         "Filter3".ROW_VERSION7 AS ROW_VERSION,
         "Filter3".PREVENT_SEND AS PREVENT_SEND,
         "Filter3".DEAL_SS_ID5 AS DEAL_SS_ID,
         1 AS C2,
         1 AS C3,
         "Extent15".DEAL_SS_ID AS DEAL_SS_ID1,
         "Extent15".DEAL_ID AS DEAL_ID1,
         "Extent15".DATE_ENTERED AS DATE_ENTERED,
         "Extent15".DATE_OF_DEAL AS DATE_OF_DEAL,
         "Extent15".FLOW_DATE_START AS FLOW_DATE_START,
         "Extent15".FLOW_DATE_END AS FLOW_DATE_END,
         "Extent15".DEAL_NUMBER AS DEAL_NUMBER,
         "Extent15".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
         "Extent15".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
         "Extent15".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
         "Extent15".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
         "Extent15".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
         "Extent15".CONTACT_OTHER AS CONTACT_OTHER,
         "Extent15".MO_CONTACT_ID AS MO_CONTACT_ID,
         "Extent15".MO_CONTACT_NAME AS MO_CONTACT_NAME,
         "Extent15".PIPELINE_ID AS PIPELINE_ID,
         "Extent15".PIPELINE_CD AS PIPELINE_CD,
         "Extent15".ZONE_ID AS ZONE_ID,
         "Extent15".ZONE_CD AS ZONE_CD,
         "Extent15".LOCATION_ID AS LOCATION_ID,
         "Extent15".LOCATION_CD AS LOCATION_CD,
         "Extent15".DEAL_TYPE_ID AS DEAL_TYPE_ID,
         "Extent15".DEAL_TYPE AS DEAL_TYPE,
         "Extent15".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
         "Extent15".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
         "Extent15".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
         "Extent15".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
         "Extent15".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
         "Extent15".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
         "Extent15".RATE_PLAN_ID AS RATE_PLAN_ID,
         "Extent15".PROMOTED AS PROMOTED,
         "Extent15".DELIVERED AS DELIVERED,
         "Extent15".CANCELED AS CANCELED,
         "Extent15".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
         "Extent15".DEAL_COMMENT AS DEAL_COMMENT,
         "Extent15".ENTERED_BY AS ENTERED_BY1,
         "Extent15".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
         "Extent15".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
         "Extent15".NEED_ACCOUNT AS NEED_ACCOUNT,
         "Extent15".RESUBMITTED AS RESUBMITTED,
         "Extent15".STORAGE_TRANSFER AS STORAGE_TRANSFER,
         "Extent15".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
         "Extent15".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
         "Extent15".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
         "Extent15".ROW_VERSION AS ROW_VERSION1,
         "Extent15".DEAL552CODE_ID AS DEAL552CODE_ID,
         "Extent15".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
         "Extent15".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
         "Extent15".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
         "Filter3".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
         "Filter3".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
         "Filter3".DEAL_CONFIRM_ID6 AS DEAL_CONFIRM_ID1,
         FLOOR(CAST(NULL AS NUMBER)) AS C4,
         FLOOR(CAST(NULL AS NUMBER)) AS C5,
         FLOOR(CAST(NULL AS NUMBER)) AS C6,
         TO_CHAR(NULL) AS C7,
         CAST(NULL AS TIMESTAMP(9)) AS C8,
         FLOOR(CAST(NULL AS NUMBER)) AS C9,
         TO_CHAR(NULL) AS C10,
         TO_CHAR(NULL) AS C11,
         CAST(NULL AS TIMESTAMP(9)) AS C12,
         FLOOR(CAST(NULL AS NUMBER)) AS C13,
         FLOOR(CAST(NULL AS NUMBER)) AS C14,
         FLOOR(CAST(NULL AS NUMBER)) AS C15,
         FLOOR(CAST(NULL AS NUMBER)) AS C16,
         FLOOR(CAST(NULL AS NUMBER)) AS C17,
         TO_CHAR(NULL) AS C18,
         FLOOR(CAST(NULL AS NUMBER)) AS C19,
         TO_CHAR(NULL) AS C20,
         TO_CHAR(NULL) AS C21,
         TO_CHAR(NULL) AS C22,
         TO_CHAR(NULL) AS C23,
         TO_CHAR(NULL) AS C24,
         TO_CHAR(NULL) AS C25,
         TO_CHAR(NULL) AS C26,
         TO_CHAR(NULL) AS C27,
         TO_CHAR(NULL) AS C28,
         TO_CHAR(NULL) AS C29,
         TO_CHAR(NULL) AS C30,
         TO_CHAR(NULL) AS C31,
         TO_CHAR(NULL) AS C32,
         TO_CHAR(NULL) AS C33,
         FLOOR(CAST(NULL AS NUMBER)) AS C34,
         FLOOR(CAST(NULL AS NUMBER)) AS C35,
         FLOOR(CAST(NULL AS NUMBER)) AS C36,
         TO_CHAR(NULL) AS C37,
         TO_CHAR(NULL) AS C38,
         CAST(NULL AS TIMESTAMP(9)) AS C39,
         FLOOR(CAST(NULL AS NUMBER)) AS C40,
         FLOOR(CAST(NULL AS NUMBER)) AS C41,
         FLOOR(CAST(NULL AS NUMBER)) AS C42,
         FLOOR(CAST(NULL AS NUMBER)) AS C43,
         FLOOR(CAST(NULL AS NUMBER)) AS C44,
         FLOOR(CAST(NULL AS NUMBER)) AS C45,
         FLOOR(CAST(NULL AS NUMBER)) AS C46,
         FLOOR(CAST(NULL AS NUMBER)) AS C47,
         FLOOR(CAST(NULL AS NUMBER)) AS C48,
         TO_CHAR(NULL) AS C49,
         CAST(NULL AS NUMBER) AS C50,
         FLOOR(CAST(NULL AS NUMBER)) AS C51,
         TO_CHAR(NULL) AS C52,
         TO_CHAR(NULL) AS C53,
         TO_CHAR(NULL) AS C54,
         TO_CHAR(NULL) AS C55,
         TO_CHAR(NULL) AS C56,
         TO_CHAR(NULL) AS C57,
         FLOOR(CAST(NULL AS NUMBER)) AS C58,
         TO_CHAR(NULL) AS C59,
         TO_CHAR(NULL) AS C60,
         CAST(NULL AS NUMBER) AS C61,
         TO_CHAR(NULL) AS C62,
         TO_CHAR(NULL) AS C63,
         CAST(NULL AS TIMESTAMP(9)) AS C64,
         FLOOR(CAST(NULL AS NUMBER)) AS C65,
         FLOOR(CAST(NULL AS NUMBER)) AS C66,
         1 AS C67,
         "Extent16".DEAL_TRX_PRICING_SS_ID AS DEAL_TRX_PRICING_SS_ID,
         "Extent16".DEAL_TRX_PRICING_ID AS DEAL_TRX_PRICING_ID,
         "Extent16".DEAL_TRX_ID AS DEAL_TRX_ID,
         "Extent16".DEAL_ID AS DEAL_ID2,
         "Extent16".DEAL_NUMBER AS DEAL_NUMBER1,
         "Extent16".DEAL_PRICING_ID AS DEAL_PRICING_ID,
         "Extent16".VOLUME_TYPE_ID AS VOLUME_TYPE_ID,
         "Extent16".DEAL_VOLUME_TYPE AS DEAL_VOLUME_TYPE,
         "Extent16".VOLUME_MIN AS VOLUME_MIN,
         "Extent16".VOLUME_MAX AS VOLUME_MAX,
         "Extent16".NET_PRICE AS NET_PRICE,
         "Extent16".PRICE AS PRICE,
         "Extent16".DEAL_PRICE_TYPE_ID AS DEAL_PRICE_TYPE_ID,
         "Extent16".DEAL_PRICE_TYPE AS DEAL_PRICE_TYPE,
         "Extent16".PRICE_DESCRIPTION AS PRICE_DESCRIPTION,
         "Extent16".PRICE_INDEX_PIPELINE_ID AS PRICE_INDEX_PIPELINE_ID,
         "Extent16".PIPELINE_CD AS PIPELINE_CD1,
         "Extent16".PRICE_INDEX_LOCATION_ID AS PRICE_INDEX_LOCATION_ID,
         "Extent16".LOCATION_CD AS LOCATION_CD1,
         "Extent16".PRICE_INDEX_PRICE_TYPE_ID AS PRICE_INDEX_PRICE_TYPE_ID,
         "Extent16".PRICE_TYPE AS PRICE_TYPE,
         "Extent16".PRICE_INDEX_HML_FLAG AS PRICE_INDEX_HML_FLAG,
         "Extent16".PRICE_INDEX_ADDER AS PRICE_INDEX_ADDER,
         "Extent16".ENTERED_BY AS ENTERED_BY2,
         "Extent16".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
         "Extent16".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
         "Extent16".PRICE_VAL_STATUS_ID AS PRICE_VAL_STATUS_ID,
         "Extent16".DEAL_PRICE_VAL_STATUS AS DEAL_PRICE_VAL_STATUS,
         "Extent16".PRICE_VAL_COMMENT AS PRICE_VAL_COMMENT,
         "Extent16".PRICE_CHANGED AS PRICE_CHANGED,
         "Extent16".ROW_VERSION AS ROW_VERSION2,
         "Extent16".DEAL_SS_ID AS DEAL_SS_ID2,
         FLOOR(CAST(NULL AS NUMBER)) AS C68,
         FLOOR(CAST(NULL AS NUMBER)) AS C69,
         FLOOR(CAST(NULL AS NUMBER)) AS C70,
         FLOOR(CAST(NULL AS NUMBER)) AS C71,
         FLOOR(CAST(NULL AS NUMBER)) AS C72,
         CAST(NULL AS TIMESTAMP(9)) AS C73,
         FLOOR(CAST(NULL AS NUMBER)) AS C74,
         FLOOR(CAST(NULL AS NUMBER)) AS C75,
         CAST(NULL AS NUMBER) AS C76,
         TO_CHAR(NULL) AS C77,
         TO_CHAR(NULL) AS C78,
         CAST(NULL AS TIMESTAMP(9)) AS C79,
         FLOOR(CAST(NULL AS NUMBER)) AS C80,
         FLOOR(CAST(NULL AS NUMBER)) AS C81
      FROM (
         SELECT "Extent12".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID5,
            "Extent12".DEAL_ID AS DEAL_ID5,
            "Extent12".ACTION_DATE AS ACTION_DATE,
            "Extent12".CONF_STATUS_ID AS CONF_STATUS_ID,
            "Extent12".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
            "Extent12".CONF_SENT_DATE AS CONF_SENT_DATE,
            "Extent12".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
            "Extent12".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
            "Extent12".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
            "Extent12".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
            "Extent12".CONF_COMMENT AS CONF_COMMENT,
            "Extent12".ENTERED_BY AS ENTERED_BY5,
            "Extent12".LAST_UPDATE_USER AS LAST_UPDATE_USER7,
            "Extent12".LAST_UPDATE_TMS AS LAST_UPDATE_TMS7,
            "Extent12".ROW_VERSION AS ROW_VERSION7,
            "Extent12".PREVENT_SEND AS PREVENT_SEND,
            "Extent12".DEAL_SS_ID AS DEAL_SS_ID6,
            "Extent13".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID6,
            "Extent13".CONFIRMATION_PDF AS CONFIRMATION_PDF,
            "Extent13".LAST_UPDATE_USER AS LAST_UPDATE_USER8,
            "Extent13".LAST_UPDATE_TMS AS LAST_UPDATE_TMS8,
            "Extent13".ROW_VERSION AS ROW_VERSION8,
            "Extent14".DEAL_SS_ID AS DEAL_SS_ID5,
            "Extent14".DEAL_ID AS DEAL_ID6,
            "Extent14".DATE_ENTERED AS DATE_ENTERED,
            "Extent14".DATE_OF_DEAL AS DATE_OF_DEAL,
            "Extent14".FLOW_DATE_START AS FLOW_DATE_START,
            "Extent14".FLOW_DATE_END AS FLOW_DATE_END,
            "Extent14".DEAL_NUMBER AS DEAL_NUMBER,
            "Extent14".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
            "Extent14".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
            "Extent14".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
            "Extent14".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
            "Extent14".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
            "Extent14".CONTACT_OTHER AS CONTACT_OTHER,
            "Extent14".MO_CONTACT_ID AS MO_CONTACT_ID,
            "Extent14".MO_CONTACT_NAME AS MO_CONTACT_NAME,
            "Extent14".PIPELINE_ID AS PIPELINE_ID,
            "Extent14".PIPELINE_CD AS PIPELINE_CD,
            "Extent14".ZONE_ID AS ZONE_ID,
            "Extent14".ZONE_CD AS ZONE_CD,
            "Extent14".LOCATION_ID AS LOCATION_ID,
            "Extent14".LOCATION_CD AS LOCATION_CD,
            "Extent14".DEAL_TYPE_ID AS DEAL_TYPE_ID,
            "Extent14".DEAL_TYPE AS DEAL_TYPE,
            "Extent14".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
            "Extent14".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
            "Extent14".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
            "Extent14".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
            "Extent14".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
            "Extent14".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
            "Extent14".RATE_PLAN_ID AS RATE_PLAN_ID,
            "Extent14".PROMOTED AS PROMOTED,
            "Extent14".DELIVERED AS DELIVERED,
            "Extent14".CANCELED AS CANCELED,
            "Extent14".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
            "Extent14".DEAL_COMMENT AS DEAL_COMMENT,
            "Extent14".ENTERED_BY AS ENTERED_BY6,
            "Extent14".LAST_UPDATE_USER AS LAST_UPDATE_USER9,
            "Extent14".LAST_UPDATE_TMS AS LAST_UPDATE_TMS9,
            "Extent14".NEED_ACCOUNT AS NEED_ACCOUNT,
            "Extent14".RESUBMITTED AS RESUBMITTED,
            "Extent14".STORAGE_TRANSFER AS STORAGE_TRANSFER,
            "Extent14".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
            "Extent14".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
            "Extent14".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
            "Extent14".ROW_VERSION AS ROW_VERSION9,
            "Extent14".DEAL552CODE_ID AS DEAL552CODE_ID,
            "Extent14".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
            "Extent14".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
            "Extent14".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
         FROM GCSM9.DEAL_CONFIRMATION "Extent12" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent13" ON "Extent12".DEAL_CONFIRM_ID =
         "Extent13".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent14" ON "Extent12".DEAL_SS_ID = "Extent14".DEAL_SS_ID 
         WHERE ((1 = "Extent12".CONF_STATUS_ID) 
         AND (5 <> "Extent12".CONF_STATUS_ID)) 
         AND ("Extent14".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter3" LEFT OUTER 
         JOIN GCSM9.DEAL_SS "Extent15" ON "Filter3".DEAL_SS_ID6 = "Extent15".DEAL_SS_ID INNER JOIN GCSM9.DEAL_TRX_PRICING_SS "Extent16"
         ON "Filter3".DEAL_SS_ID6 = "Extent16".DEAL_SS_ID) "UnionAll2" UNION ALL 
   SELECT 4 AS C1,
      "Filter4".DEAL_CONFIRM_ID7 AS DEAL_CONFIRM_ID,
      "Filter4".DEAL_ID7 AS DEAL_ID,
      "Filter4".ACTION_DATE AS ACTION_DATE,
      "Filter4".CONF_STATUS_ID AS CONF_STATUS_ID,
      "Filter4".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
      "Filter4".CONF_SENT_DATE AS CONF_SENT_DATE,
      "Filter4".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
      "Filter4".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
      "Filter4".CONF_COMMENT AS CONF_COMMENT,
      "Filter4".ENTERED_BY7 AS ENTERED_BY,
      "Filter4".LAST_UPDATE_USER10 AS LAST_UPDATE_USER,
      "Filter4".LAST_UPDATE_TMS10 AS LAST_UPDATE_TMS,
      "Filter4".ROW_VERSION10 AS ROW_VERSION,
      "Filter4".PREVENT_SEND AS PREVENT_SEND,
      "Filter4".DEAL_SS_ID7 AS DEAL_SS_ID,
      1 AS C2,
      1 AS C3,
      "Extent20".DEAL_SS_ID AS DEAL_SS_ID1,
      "Extent20".DEAL_ID AS DEAL_ID1,
      "Extent20".DATE_ENTERED AS DATE_ENTERED,
      "Extent20".DATE_OF_DEAL AS DATE_OF_DEAL,
      "Extent20".FLOW_DATE_START AS FLOW_DATE_START,
      "Extent20".FLOW_DATE_END AS FLOW_DATE_END,
      "Extent20".DEAL_NUMBER AS DEAL_NUMBER,
      "Extent20".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
      "Extent20".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
      "Extent20".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
      "Extent20".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
      "Extent20".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
      "Extent20".CONTACT_OTHER AS CONTACT_OTHER,
      "Extent20".MO_CONTACT_ID AS MO_CONTACT_ID,
      "Extent20".MO_CONTACT_NAME AS MO_CONTACT_NAME,
      "Extent20".PIPELINE_ID AS PIPELINE_ID,
      "Extent20".PIPELINE_CD AS PIPELINE_CD,
      "Extent20".ZONE_ID AS ZONE_ID,
      "Extent20".ZONE_CD AS ZONE_CD,
      "Extent20".LOCATION_ID AS LOCATION_ID,
      "Extent20".LOCATION_CD AS LOCATION_CD,
      "Extent20".DEAL_TYPE_ID AS DEAL_TYPE_ID,
      "Extent20".DEAL_TYPE AS DEAL_TYPE,
      "Extent20".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
      "Extent20".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
      "Extent20".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
      "Extent20".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
      "Extent20".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
      "Extent20".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
      "Extent20".RATE_PLAN_ID AS RATE_PLAN_ID,
      "Extent20".PROMOTED AS PROMOTED,
      "Extent20".DELIVERED AS DELIVERED,
      "Extent20".CANCELED AS CANCELED,
      "Extent20".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
      "Extent20".DEAL_COMMENT AS DEAL_COMMENT,
      "Extent20".ENTERED_BY AS ENTERED_BY1,
      "Extent20".LAST_UPDATE_USER AS LAST_UPDATE_USER1,
      "Extent20".LAST_UPDATE_TMS AS LAST_UPDATE_TMS1,
      "Extent20".NEED_ACCOUNT AS NEED_ACCOUNT,
      "Extent20".RESUBMITTED AS RESUBMITTED,
      "Extent20".STORAGE_TRANSFER AS STORAGE_TRANSFER,
      "Extent20".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
      "Extent20".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
      "Extent20".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
      "Extent20".ROW_VERSION AS ROW_VERSION1,
      "Extent20".DEAL552CODE_ID AS DEAL552CODE_ID,
      "Extent20".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
      "Extent20".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
      "Extent20".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED,
      "Filter4".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
      "Filter4".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
      "Filter4".DEAL_CONFIRM_ID8 AS DEAL_CONFIRM_ID1,
      FLOOR(CAST(NULL AS NUMBER)) AS C4,
      FLOOR(CAST(NULL AS NUMBER)) AS C5,
      FLOOR(CAST(NULL AS NUMBER)) AS C6,
      TO_CHAR(NULL) AS C7,
      CAST(NULL AS TIMESTAMP(9)) AS C8,
      FLOOR(CAST(NULL AS NUMBER)) AS C9,
      TO_CHAR(NULL) AS C10,
      TO_CHAR(NULL) AS C11,
      CAST(NULL AS TIMESTAMP(9)) AS C12,
      FLOOR(CAST(NULL AS NUMBER)) AS C13,
      FLOOR(CAST(NULL AS NUMBER)) AS C14,
      FLOOR(CAST(NULL AS NUMBER)) AS C15,
      FLOOR(CAST(NULL AS NUMBER)) AS C16,
      FLOOR(CAST(NULL AS NUMBER)) AS C17,
      TO_CHAR(NULL) AS C18,
      FLOOR(CAST(NULL AS NUMBER)) AS C19,
      TO_CHAR(NULL) AS C20,
      TO_CHAR(NULL) AS C21,
      TO_CHAR(NULL) AS C22,
      TO_CHAR(NULL) AS C23,
      TO_CHAR(NULL) AS C24,
      TO_CHAR(NULL) AS C25,
      TO_CHAR(NULL) AS C26,
      TO_CHAR(NULL) AS C27,
      TO_CHAR(NULL) AS C28,
      TO_CHAR(NULL) AS C29,
      TO_CHAR(NULL) AS C30,
      TO_CHAR(NULL) AS C31,
      TO_CHAR(NULL) AS C32,
      TO_CHAR(NULL) AS C33,
      FLOOR(CAST(NULL AS NUMBER)) AS C34,
      FLOOR(CAST(NULL AS NUMBER)) AS C35,
      FLOOR(CAST(NULL AS NUMBER)) AS C36,
      TO_CHAR(NULL) AS C37,
      TO_CHAR(NULL) AS C38,
      CAST(NULL AS TIMESTAMP(9)) AS C39,
      FLOOR(CAST(NULL AS NUMBER)) AS C40,
      FLOOR(CAST(NULL AS NUMBER)) AS C41,
      FLOOR(CAST(NULL AS NUMBER)) AS C42,
      FLOOR(CAST(NULL AS NUMBER)) AS C43,
      FLOOR(CAST(NULL AS NUMBER)) AS C44,
      FLOOR(CAST(NULL AS NUMBER)) AS C45,
      FLOOR(CAST(NULL AS NUMBER)) AS C46,
      FLOOR(CAST(NULL AS NUMBER)) AS C47,
      FLOOR(CAST(NULL AS NUMBER)) AS C48,
      TO_CHAR(NULL) AS C49,
      CAST(NULL AS NUMBER) AS C50,
      FLOOR(CAST(NULL AS NUMBER)) AS C51,
      TO_CHAR(NULL) AS C52,
      TO_CHAR(NULL) AS C53,
      TO_CHAR(NULL) AS C54,
      TO_CHAR(NULL) AS C55,
      TO_CHAR(NULL) AS C56,
      TO_CHAR(NULL) AS C57,
      FLOOR(CAST(NULL AS NUMBER)) AS C58,
      TO_CHAR(NULL) AS C59,
      TO_CHAR(NULL) AS C60,
      CAST(NULL AS NUMBER) AS C61,
      TO_CHAR(NULL) AS C62,
      TO_CHAR(NULL) AS C63,
      CAST(NULL AS TIMESTAMP(9)) AS C64,
      FLOOR(CAST(NULL AS NUMBER)) AS C65,
      FLOOR(CAST(NULL AS NUMBER)) AS C66,
      FLOOR(CAST(NULL AS NUMBER)) AS C67,
      FLOOR(CAST(NULL AS NUMBER)) AS C68,
      FLOOR(CAST(NULL AS NUMBER)) AS C69,
      FLOOR(CAST(NULL AS NUMBER)) AS C70,
      FLOOR(CAST(NULL AS NUMBER)) AS C71,
      FLOOR(CAST(NULL AS NUMBER)) AS C72,
      FLOOR(CAST(NULL AS NUMBER)) AS C73,
      FLOOR(CAST(NULL AS NUMBER)) AS C74,
      TO_CHAR(NULL) AS C75,
      FLOOR(CAST(NULL AS NUMBER)) AS C76,
      FLOOR(CAST(NULL AS NUMBER)) AS C77,
      CAST(NULL AS NUMBER) AS C78,
      CAST(NULL AS NUMBER) AS C79,
      FLOOR(CAST(NULL AS NUMBER)) AS C80,
      TO_CHAR(NULL) AS C81,
      TO_CHAR(NULL) AS C82,
      TO_CHAR(NULL) AS C83,
      TO_CHAR(NULL) AS C84,
      TO_CHAR(NULL) AS C85,
      TO_CHAR(NULL) AS C86,
      FLOOR(CAST(NULL AS NUMBER)) AS C87,
      TO_CHAR(NULL) AS C88,
      TO_CHAR(NULL) AS C89,
      CAST(NULL AS NUMBER) AS C90,
      TO_CHAR(NULL) AS C91,
      TO_CHAR(NULL) AS C92,
      CAST(NULL AS TIMESTAMP(9)) AS C93,
      FLOOR(CAST(NULL AS NUMBER)) AS C94,
      TO_CHAR(NULL) AS C95,
      TO_CHAR(NULL) AS C96,
      FLOOR(CAST(NULL AS NUMBER)) AS C97,
      FLOOR(CAST(NULL AS NUMBER)) AS C98,
      FLOOR(CAST(NULL AS NUMBER)) AS C99,
      1 AS C100,
      "Extent21".DEAL_TRX_SS_ID AS DEAL_TRX_SS_ID,
      "Extent21".DEAL_TRX_ID AS DEAL_TRX_ID,
      "Extent21".DEAL_ID AS DEAL_ID2,
      "Extent21".DEAL_NUMBER AS DEAL_NUMBER1,
      "Extent21".FLOW_DATE AS FLOW_DATE,
      "Extent21".VOLUME AS VOLUME,
      "Extent21".VOLUME_CHANGED AS VOLUME_CHANGED,
      "Extent21".FINAL_PRICE AS FINAL_PRICE,
      "Extent21".ENTERED_BY AS ENTERED_BY2,
      "Extent21".LAST_UPDATE_USER AS LAST_UPDATE_USER2,
      "Extent21".LAST_UPDATE_TMS AS LAST_UPDATE_TMS2,
      "Extent21".ROW_VERSION AS ROW_VERSION2,
      "Extent21".DEAL_SS_ID AS DEAL_SS_ID2
   FROM (
      SELECT "Extent17".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID7,
         "Extent17".DEAL_ID AS DEAL_ID7,
         "Extent17".ACTION_DATE AS ACTION_DATE,
         "Extent17".CONF_STATUS_ID AS CONF_STATUS_ID,
         "Extent17".CONF_SEND_STATUS_ID AS CONF_SEND_STATUS_ID,
         "Extent17".CONF_SENT_DATE AS CONF_SENT_DATE,
         "Extent17".CONF_SEND_METHOD_ID AS CONF_SEND_METHOD_ID,
         "Extent17".CONF_SEND_METHOD_OTHER_DESC AS CONF_SEND_METHOD_OTHER_DESC,
         "Extent17".CONF_RECEIVE_METHOD_ID AS CONF_RECEIVE_METHOD_ID,
         "Extent17".CONF_RECEIVE_DATE AS CONF_RECEIVE_DATE,
         "Extent17".CONF_COMMENT AS CONF_COMMENT,
         "Extent17".ENTERED_BY AS ENTERED_BY7,
         "Extent17".LAST_UPDATE_USER AS LAST_UPDATE_USER10,
         "Extent17".LAST_UPDATE_TMS AS LAST_UPDATE_TMS10,
         "Extent17".ROW_VERSION AS ROW_VERSION10,
         "Extent17".PREVENT_SEND AS PREVENT_SEND,
         "Extent17".DEAL_SS_ID AS DEAL_SS_ID8,
         "Extent18".DEAL_CONFIRM_ID AS DEAL_CONFIRM_ID8,
         "Extent18".CONFIRMATION_PDF AS CONFIRMATION_PDF,
         "Extent18".LAST_UPDATE_USER AS LAST_UPDATE_USER11,
         "Extent18".LAST_UPDATE_TMS AS LAST_UPDATE_TMS11,
         "Extent18".ROW_VERSION AS ROW_VERSION11,
         "Extent19".DEAL_SS_ID AS DEAL_SS_ID7,
         "Extent19".DEAL_ID AS DEAL_ID8,
         "Extent19".DATE_ENTERED AS DATE_ENTERED,
         "Extent19".DATE_OF_DEAL AS DATE_OF_DEAL,
         "Extent19".FLOW_DATE_START AS FLOW_DATE_START,
         "Extent19".FLOW_DATE_END AS FLOW_DATE_END,
         "Extent19".DEAL_NUMBER AS DEAL_NUMBER,
         "Extent19".BUS_ASSOCIATE_ID AS BUS_ASSOCIATE_ID,
         "Extent19".BUS_ASSOCIATE_CD AS BUS_ASSOCIATE_CD,
         "Extent19".BUS_ASSOCIATE_NAME AS BUS_ASSOCIATE_NAME,
         "Extent19".SUPPLY_CONTACT_ID AS SUPPLY_CONTACT_ID,
         "Extent19".SUPPLY_CONTACT_NAME AS SUPPLY_CONTACT_NAME,
         "Extent19".CONTACT_OTHER AS CONTACT_OTHER,
         "Extent19".MO_CONTACT_ID AS MO_CONTACT_ID,
         "Extent19".MO_CONTACT_NAME AS MO_CONTACT_NAME,
         "Extent19".PIPELINE_ID AS PIPELINE_ID,
         "Extent19".PIPELINE_CD AS PIPELINE_CD,
         "Extent19".ZONE_ID AS ZONE_ID,
         "Extent19".ZONE_CD AS ZONE_CD,
         "Extent19".LOCATION_ID AS LOCATION_ID,
         "Extent19".LOCATION_CD AS LOCATION_CD,
         "Extent19".DEAL_TYPE_ID AS DEAL_TYPE_ID,
         "Extent19".DEAL_TYPE AS DEAL_TYPE,
         "Extent19".SUPPLY_CONTRACT_ID AS SUPPLY_CONTRACT_ID,
         "Extent19".SUPPLY_CONTRACT_NBR AS SUPPLY_CONTRACT_NBR,
         "Extent19".SUPPLY_CONTRACT_SUPPLY_TYPE_CD AS SUPPLY_CONTRACT_SUPPLY_TYPE_CD,
         "Extent19".SUPPLY_CONTRACT_JURISDICTN_CD AS SUPPLY_CONTRACT_JURISDICTN_CD,
         "Extent19".SUPPLY_CONTRACT_TYPE AS SUPPLY_CONTRACT_TYPE,
         "Extent19".GMS_BROKER_ACCT_NBR AS GMS_BROKER_ACCT_NBR,
         "Extent19".RATE_PLAN_ID AS RATE_PLAN_ID,
         "Extent19".PROMOTED AS PROMOTED,
         "Extent19".DELIVERED AS DELIVERED,
         "Extent19".CANCELED AS CANCELED,
         "Extent19".DEAL_TERMS_CHANGED AS DEAL_TERMS_CHANGED,
         "Extent19".DEAL_COMMENT AS DEAL_COMMENT,
         "Extent19".ENTERED_BY AS ENTERED_BY8,
         "Extent19".LAST_UPDATE_USER AS LAST_UPDATE_USER12,
         "Extent19".LAST_UPDATE_TMS AS LAST_UPDATE_TMS12,
         "Extent19".NEED_ACCOUNT AS NEED_ACCOUNT,
         "Extent19".RESUBMITTED AS RESUBMITTED,
         "Extent19".STORAGE_TRANSFER AS STORAGE_TRANSFER,
         "Extent19".MO_CONTACT_OTHER AS MO_CONTACT_OTHER,
         "Extent19".SPECIAL_CONDITIONS AS SPECIAL_CONDITIONS,
         "Extent19".HAS_ATTACHED_SHEET AS HAS_ATTACHED_SHEET,
         "Extent19".ROW_VERSION AS ROW_VERSION12,
         "Extent19".DEAL552CODE_ID AS DEAL552CODE_ID,
         "Extent19".FLOW_DATE_START_YEAR AS FLOW_DATE_START_YEAR,
         "Extent19".FLOW_DATE_START_MONTH AS FLOW_DATE_START_MONTH,
         "Extent19".SYNC_TO_GMS_FAILED AS SYNC_TO_GMS_FAILED
      FROM GCSM9.DEAL_CONFIRMATION "Extent17" LEFT OUTER JOIN GCSM9.DEAL_CONFIRMATION_PDF "Extent18" ON "Extent17".DEAL_CONFIRM_ID = 
      "Extent18".DEAL_CONFIRM_ID INNER JOIN GCSM9.DEAL_SS "Extent19" ON "Extent17".DEAL_SS_ID = "Extent19".DEAL_SS_ID 
      WHERE ((1 = "Extent17".CONF_STATUS_ID) 
      AND (5 <> "Extent17".CONF_STATUS_ID)) 
      AND ("Extent19".FLOW_DATE_END >= TO_TIMESTAMP('2010-02-01 00:00:00.000', 'yyyy-mm-dd hh24:mi:ss.ff')) ) "Filter4" LEFT OUTER JOIN
      GCSM9.DEAL_SS "Extent20" ON "Filter4".DEAL_SS_ID8 = "Extent20".DEAL_SS_ID INNER JOIN GCSM9.DEAL_TRX_SS "Extent21" ON "Filter4".DEAL_SS_ID8
      = "Extent21".DEAL_SS_ID) "UnionAll3" 
ORDER BY "UnionAll3".C2 ASC, "UnionAll3".C16 ASC, "UnionAll3".C19 ASC, "UnionAll3".C70 ASC, "UnionAll3".C1 ASC[/code]

A diff. on these two SQL files shows some obvious differences re: the where clause, and this one weird difference:

[code]"UnionAll3".C71 AS C70,
"UnionAll3".C1 AS C71,[/code]

vs.

[code]"UnionAll3".C1 AS C70,
"UnionAll3".C71 AS C71,[/code]

So, my questions are as follows:
1) Which tool actually creates this SQL statement?  
2) Is it possible that differences in Indexes on the tables could alter the way the SQL Generator generates the SQL?
3) Is this fixed in a newer release?

Thanks,
Simon