OWNER	VIEW_NAME	TEXT_LENGTH	TEXT	TYPE_TEXT_LENGTH	TYPE_TEXT	OID_TEXT_LENGTH	OID_TEXT	VIEW_TYPE_OWNER	VIEW_TYPE	SUPERVIEW_NAME
ICMADMIN	ALL_DOCUMENTS	10065	(select TO_NUMBER('110048') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110048001) UNION ALL (select TO_NUMBER('110049') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110049001) UNION ALL (select TO_NUMBER('110050') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110050001) UNION ALL (select TO_NUMBER('110051') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110051001) UNION ALL (select TO_NUMBER('110052') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110052001) UNION ALL (select TO_NUMBER('110053') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110053001) UNION ALL (select TO_NUMBER('110054') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110054001) UNION ALL (select TO_NUMBER('110055') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110055001) UNION ALL (select TO_NUMBER('110056') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,NOTREQUIREDATMARKETDATE,RECEIVEDFROMMARKETDATE,RECEIVEDFROMMARKETUSER,SENTTOMARKETDATE,SENTTOMARKETUSER,DATESIGNED,SECOREUPDATEDDATE,SECOREUPDATEDUSER from DOC_TYPE_110056001) UNION ALL (select TO_NUMBER('110057') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110057001) UNION ALL (select TO_NUMBER('110058') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110058001) UNION ALL (select TO_NUMBER('110059') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110059001) UNION ALL (select TO_NUMBER('110060') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110060001) UNION ALL (select TO_NUMBER('110061') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110061001) UNION ALL (select TO_NUMBER('110062') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110062001) UNION ALL (select TO_NUMBER('110063') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110063001) UNION ALL (select TO_NUMBER('110064') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110064001) UNION ALL (select TO_NUMBER('110065') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,null as RECEIVEDFROMCAMUDATE,null as SECOREUPDATEDATE,null as SENTTOCAMUDATE,null as SENTTOCAMUUSER,null as RECEIVEDFROMCAMUUSER,EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110065001) UNION ALL (select TO_NUMBER('110066') as typeid,documentid, comments, dealreviewnumber, documentstatus, datescanned, userscanned, maker, checker, boid, skid,markets, filename, location,RECEIVEDFROMCAMUDATE,SECOREUPDATEDDATE as SECOREUPDATEDATE,SENTTOCAMUDATE,SENTTOCAMUUSER,RECEIVEDFROMCAMUUSER,null as EXPIRYDATE,null as NOTREQUIREDATMARKETDATE,null as RECEIVEDFROMMARKETDATE,null as RECEIVEDFROMMARKETUSER,null as SENTTOMARKETDATE,null as SENTTOMARKETUSER,null as DATESIGNED,null as SECOREUPDATEDDATE,null as SECOREUPDATEDUSER from DOC_TYPE_110066001)	(null)	(null)	(null)	(null)	(null)	(null)	(null)