ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
patrasch79
Posts: 10
Joined: Sat 01 Dec 2012 08:53

ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Post by patrasch79 » Fri 11 Oct 2013 14:44

Hi!

I'm working with Oracle dotConnect 7.9.333, but i had the same problem earlier too.

I have a base type "Element" and a few derived types "XXXElement", "YYYElement" and so on...
Lets say "Element" is not abstract and can be a valid instance itself too.

I want so search over all kind of Elements so i do a "Union" with all Element querys.
This causes the error... i think the reason is the "DISTINCT" in the generated statement.
If i use "Concat" instead of "Union" it works, but i get multiple results, because XXXElement is a Element too.

My entity model should be ok...So why does not work "Union"?, "Concat" works!

P.S. if i just Union the derived types "XXXElement", "YYYElement" i get the error "ORA-00932: inconsistent datatypes: expected - got NCLOB." ... if i add the base type "Element" too then i get ORA-12704: character set mismatch.

with Concat is works in every case
Last edited by patrasch79 on Fri 11 Oct 2013 14:50, edited 2 times in total.

patrasch79
Posts: 10
Joined: Sat 01 Dec 2012 08:53

Re: ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Post by patrasch79 » Fri 11 Oct 2013 14:47

this is the generated Statement with Concat that works:
SELECT
UnionAll5.C1,
UnionAll5.C2,
UnionAll5.C3,
UnionAll5.C4,
UnionAll5.C5,
UnionAll5.C6,
UnionAll5.C7,
UnionAll5.C8,
UnionAll5.C9,
UnionAll5.C10,
UnionAll5.C11,
UnionAll5.C12,
UnionAll5.C13,
UnionAll5.C14,
UnionAll5.C15,
UnionAll5.C16,
UnionAll5.C17,
UnionAll5.C18,
UnionAll5.C19,
UnionAll5.C20,
UnionAll5.C21,
UnionAll5.C22,
UnionAll5.C23,
UnionAll5.C24,
UnionAll5.C25,
UnionAll5.C26,
UnionAll5.C27,
UnionAll5.C28,
UnionAll5.C29,
UnionAll5.C30,
UnionAll5.C31,
UnionAll5.C32,
UnionAll5.C33,
UnionAll5.C34,
UnionAll5.C35,
UnionAll5.C36,
UnionAll5.C37,
UnionAll5.C38,
UnionAll5.C39,
UnionAll5.C40,
UnionAll5.C41,
UnionAll5.C42,
UnionAll5.C43
FROM (SELECT
UnionAll4.C1,
UnionAll4.C2,
UnionAll4.C3,
UnionAll4.C4,
UnionAll4.C5,
UnionAll4.C6,
UnionAll4.C7,
UnionAll4.C8,
UnionAll4.C9,
UnionAll4.C10,
UnionAll4.C11,
UnionAll4.C12,
UnionAll4.C13,
UnionAll4.C14,
UnionAll4.C15,
UnionAll4.C16,
UnionAll4.C17,
UnionAll4.C18,
UnionAll4.C19,
UnionAll4.C20,
UnionAll4.C21,
UnionAll4.C22,
UnionAll4.C23,
UnionAll4.C24,
UnionAll4.C25,
UnionAll4.C26,
UnionAll4.C27,
UnionAll4.C28,
UnionAll4.C29,
UnionAll4.C30,
UnionAll4.C31,
UnionAll4.C32,
UnionAll4.C33,
UnionAll4.C34,
UnionAll4.C35,
UnionAll4.C36,
UnionAll4.C37,
UnionAll4.C38,
UnionAll4.C39,
UnionAll4.C40,
UnionAll4.C41,
UnionAll4.C42,
UnionAll4.C43
FROM (SELECT
UnionAll3.C1,
UnionAll3.C2,
UnionAll3.C3,
UnionAll3.C4,
UnionAll3.C5,
UnionAll3.C6,
UnionAll3.C7,
UnionAll3.C8,
UnionAll3.C9,
UnionAll3.C10,
UnionAll3.C11,
UnionAll3.C12,
UnionAll3.C13,
UnionAll3.C14,
UnionAll3.C15,
UnionAll3.C16,
UnionAll3.C17,
UnionAll3.C18,
UnionAll3.C19,
UnionAll3.C20,
UnionAll3.C21,
UnionAll3.C22,
UnionAll3.C23,
UnionAll3.C24,
UnionAll3.C25,
UnionAll3.C26,
UnionAll3.C27,
UnionAll3.C28,
UnionAll3.C29,
UnionAll3.C30,
UnionAll3.C31,
UnionAll3.C32,
UnionAll3.C33,
UnionAll3.C34,
UnionAll3.C35,
UnionAll3.C36,
UnionAll3.C37,
UnionAll3.C38,
UnionAll3.C39,
UnionAll3.C40,
UnionAll3.C41,
UnionAll3.C42,
UnionAll3.C43
FROM (SELECT
UnionAll2.C1,
UnionAll2.C2,
UnionAll2.C3,
UnionAll2.C4,
UnionAll2.C5,
UnionAll2.C6,
UnionAll2.C7,
UnionAll2.C8,
UnionAll2.C9,
UnionAll2.C10,
UnionAll2.C11,
UnionAll2.C12,
UnionAll2.C13,
UnionAll2.C14,
UnionAll2.C15,
UnionAll2.C16,
UnionAll2.C17,
UnionAll2.C18,
UnionAll2.C19,
UnionAll2.C20,
UnionAll2.C21,
UnionAll2.C22,
UnionAll2.C23,
UnionAll2.C24,
UnionAll2.C25,
UnionAll2.C26,
UnionAll2.C27,
UnionAll2.C28,
UnionAll2.C29,
UnionAll2.C30,
UnionAll2.C31,
UnionAll2.C32,
UnionAll2.C33,
UnionAll2.C34,
UnionAll2.C35,
UnionAll2.C36,
UnionAll2.C37,
UnionAll2.C38,
UnionAll2.C39,
UnionAll2.C40,
UnionAll2.C41,
UnionAll2.C42,
UnionAll2.C43
FROM (SELECT
UnionAll1.C1,
UnionAll1.ID AS C2,
UnionAll1.CODE AS C3,
UnionAll1.INDX AS C4,
UnionAll1.VARIANT AS C5,
UnionAll1.MASTA_ID AS C6,
UnionAll1.COSTC_ID AS C7,
UnionAll1.INCOMPLETE_F AS C8,
UnionAll1.ACCNT_ID AS C9,
UnionAll1.FOLDR_ID AS C10,
UnionAll1.ECCFG_ID AS C11,
UnionAll1.MASTT_ID AS C12,
UnionAll1.C2 AS C13,
UnionAll1.C3 AS C14,
UnionAll1.C4 AS C15,
UnionAll1.C5 AS C16,
UnionAll1.C6 AS C17,
UnionAll1.C7 AS C18,
UnionAll1.C8 AS C19,
UnionAll1.C9 AS C20,
UnionAll1.C10 AS C21,
UnionAll1.C11 AS C22,
UnionAll1.C12 AS C23,
UnionAll1.C13 AS C24,
UnionAll1.C14 AS C25,
UnionAll1.C15 AS C26,
UnionAll1.C16 AS C27,
UnionAll1.C17 AS C28,
UnionAll1.C18 AS C29,
UnionAll1.C19 AS C30,
UnionAll1.C20 AS C31,
UnionAll1.C21 AS C32,
UnionAll1.C22 AS C33,
UnionAll1.C23 AS C34,
UnionAll1.C24 AS C35,
UnionAll1.C25 AS C36,
UnionAll1.C26 AS C37,
UnionAll1.C27 AS C38,
UnionAll1.C28 AS C39,
UnionAll1.C29 AS C40,
UnionAll1.C30 AS C41,
UnionAll1.C31 AS C42,
UnionAll1.C32 AS C43
FROM (SELECT
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN '0X' WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN '0X0X' WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN '0X1X' WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN '0X2X' WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN '0X3X' ELSE '0X4X' END AS C1,
Filter1.ID1 AS ID,
Filter1.CODE1 AS CODE,
Filter1.INDX,
Filter1.VARIANT,
Filter1.MASTA_ID,
Filter1.COSTC_ID,
Filter1.INCOMPLETE_F,
Filter1.ACCNT_ID,
Filter1.FOLDR_ID,
Filter1.ECCFG_ID,
Filter1.MASTT_ID,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOC_SOURCE_S WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C2,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOC_PATH WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) END AS C3,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_CHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.CREATION_DATE_TIME WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_CHAR(NULL) END AS C4,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_CHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.CHANGED_DATE_TIME WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_CHAR(NULL) END AS C5,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.CHANGED_ACCNT_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C6,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_CHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.ADDED_DATE_TIME WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_CHAR(NULL) END AS C7,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.ADDED_ACCNT_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C8,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOC_SIZE WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C9,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.LANGU_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C10,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOBIN_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C11,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN Filter1.UNIT WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) END AS C12,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN Filter1.CONSUM_F WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C13,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN Filter1.QUANTITY WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C14,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCLOB(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.CALC WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCLOB(NULL) END AS C15,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCLOB(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.CALC_POSTFIX WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCLOB(NULL) END AS C16,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.F_TYPE_S WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C17,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.DIMENSION WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) END AS C18,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.TIME_TYPE_S WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C19,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.COURSE_OF_TIME_S WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C20,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN Filter1.PR_POINTS END AS C21,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN Filter1.PARTS_COUNT END AS C22,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN Filter1.TIMES_ID1 END AS C23,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) ELSE Filter1.SHORT_CODE END AS C24,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.ANMET_ID END AS C25,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.VACRM1_VACRI_ID END AS C26,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.VACRM2_VACRI_ID END AS C27,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.VACRM3_VACRI_ID END AS C28,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.TIMES_ID2 END AS C29,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.TIME_CALC_MODE_F END AS C30,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.PRACTICE_LEVEL_F END AS C31,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.TIMES_DIRTY_F END AS C32
FROM (SELECT
Extent1.ID AS ID1,
Extent1.CODE AS CODE1,
Extent1.INDX,
Extent1.VARIANT,
Extent1.MASTA_ID,
Extent1.COSTC_ID,
Extent1.INCOMPLETE_F,
Extent1.ACCNT_ID,
Extent1.FOLDR_ID,
Extent1.ECCFG_ID,
Extent1.MASTT_ID,
Project1.ID AS ID2,
Project1.DOC_SOURCE_S,
Project1.DOC_PATH,
Project1.CREATION_DATE_TIME,
Project1.CHANGED_DATE_TIME,
Project1.CHANGED_ACCNT_ID,
Project1.ADDED_DATE_TIME,
Project1.ADDED_ACCNT_ID,
Project1.DOC_SIZE,
Project1.LANGU_ID,
Project1.DOBIN_ID,
Project1.C1 AS C11,
Project2.ID AS ID3,
Project2.PR_POINTS,
Project2.PARTS_COUNT,
Project2.TIMES_ID AS TIMES_ID1,
Project2.C1 AS C15,
Project3.ID AS ID4,
Project3.SHORT_CODE,
Project3.ANMET_ID,
Project3.VACRM1_VACRI_ID,
Project3.VACRM2_VACRI_ID,
Project3.VACRM3_VACRI_ID,
Project3.TIMES_ID AS TIMES_ID2,
Project3.TIME_CALC_MODE_F,
Project3.PRACTICE_LEVEL_F,
Project3.TIMES_DIRTY_F,
Project3.C1 AS C12,
Project4.ID AS ID5,
Project4.CALC,
Project4.CALC_POSTFIX,
Project4.F_TYPE_S,
Project4.DIMENSION,
Project4.TIME_TYPE_S,
Project4.COURSE_OF_TIME_S,
Project4.C1 AS C13,
Project5.ID AS ID6,
Project5.UNIT,
Project5.CONSUM_F,
Project5.QUANTITY,
Project5.C1 AS C14,
Extent7.ID AS ID7,
Extent7.CODE AS CODE2,
Extent7.CLMOD_ID,
Extent7.ADDCL_ID,
Extent7.ALCOS_ID,
Extent7.ICON
FROM TICON.MASTR Extent1
LEFT OUTER JOIN (SELECT
Extent2.ID,
Extent2.DOC_SOURCE_S,
Extent2.DOC_PATH,
Extent2.CREATION_DATE_TIME,
Extent2.CHANGED_DATE_TIME,
Extent2.CHANGED_ACCNT_ID,
Extent2.ADDED_DATE_TIME,
Extent2.ADDED_ACCNT_ID,
Extent2.DOC_SIZE,
Extent2.LANGU_ID,
Extent2.DOBIN_ID,
1 AS C1
FROM TICON.DOCUM0E Extent2 ) Project1 ON Extent1.ID = Project1.ID
LEFT OUTER JOIN (SELECT
Extent3.ID,
Extent3.PR_POINTS,
Extent3.PARTS_COUNT,
Extent3.TIMES_ID,
1 AS C1
FROM TICON.POKON0E Extent3 ) Project2 ON Extent1.ID = Project2.ID
LEFT OUTER JOIN (SELECT
Extent4.ID,
Extent4.SHORT_CODE,
Extent4.ANMET_ID,
Extent4.VACRM1_VACRI_ID,
Extent4.VACRM2_VACRI_ID,
Extent4.VACRM3_VACRI_ID,
Extent4.TIMES_ID,
Extent4.TIME_CALC_MODE_F,
Extent4.PRACTICE_LEVEL_F,
Extent4.TIMES_DIRTY_F,
1 AS C1
FROM TICON.TELEM0E Extent4 ) Project3 ON Extent1.ID = Project3.ID
LEFT OUTER JOIN (SELECT
Extent5.ID,
Extent5.CALC,
Extent5.CALC_POSTFIX,
Extent5.F_TYPE_S,
Extent5.DIMENSION,
Extent5.TIME_TYPE_S,
Extent5.COURSE_OF_TIME_S,
1 AS C1
FROM TICON.FODEF0E Extent5 ) Project4 ON Extent1.ID = Project4.ID
LEFT OUTER JOIN (SELECT
Extent6.ID,
Extent6.UNIT,
Extent6.CONSUM_F,
Extent6.QUANTITY,
1 AS C1
FROM TICON.ASSIM0E Extent6 ) Project5 ON Extent1.ID = Project5.ID
INNER JOIN TICON.ECCFG Extent7 ON Extent1.ECCFG_ID = Extent7.ID
WHERE (Extent1.FOLDR_ID = 10) AND (Extent7.CLMOD_ID > 999) ) Filter1
INNER JOIN TICON.CLMOD Extent8 ON Filter1.CLMOD_ID = Extent8.ID
WHERE Extent8.INSTALLED_F = 1
UNION ALL
SELECT
'0X4X' AS C1,
Filter3.ID8 AS ID,
Filter3.CODE3 AS CODE,
Filter3.INDX,
Filter3.VARIANT,
Filter3.MASTA_ID,
Filter3.COSTC_ID,
Filter3.INCOMPLETE_F,
Filter3.ACCNT_ID,
Filter3.FOLDR_ID,
Filter3.ECCFG_ID,
Filter3.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_NCHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_NCHAR(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
TO_NCLOB(NULL) AS C15,
TO_NCLOB(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NCHAR(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NUMBER(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
Filter3.SHORT_CODE,
Filter3.ANMET_ID,
Filter3.VACRM1_VACRI_ID,
Filter3.VACRM2_VACRI_ID,
Filter3.VACRM3_VACRI_ID,
Filter3.TIMES_ID,
Filter3.TIME_CALC_MODE_F,
Filter3.PRACTICE_LEVEL_F,
Filter3.TIMES_DIRTY_F
FROM (SELECT
Extent9.ID AS ID8,
Extent9.SHORT_CODE,
Extent9.ANMET_ID,
Extent9.VACRM1_VACRI_ID,
Extent9.VACRM2_VACRI_ID,
Extent9.VACRM3_VACRI_ID,
Extent9.TIMES_ID,
Extent9.TIME_CALC_MODE_F,
Extent9.PRACTICE_LEVEL_F,
Extent9.TIMES_DIRTY_F,
Extent10.ID AS ID9,
Extent10.CODE AS CODE3,
Extent10.INDX,
Extent10.VARIANT,
Extent10.MASTA_ID,
Extent10.COSTC_ID,
Extent10.INCOMPLETE_F,
Extent10.ACCNT_ID,
Extent10.FOLDR_ID,
Extent10.ECCFG_ID,
Extent10.MASTT_ID,
Extent11.ID AS ID10,
Extent11.CODE AS CODE4,
Extent11.CLMOD_ID,
Extent11.ADDCL_ID,
Extent11.ALCOS_ID,
Extent11.ICON
FROM TICON.TELEM0E Extent9
INNER JOIN TICON.MASTR Extent10 ON Extent9.ID = Extent10.ID
INNER JOIN TICON.ECCFG Extent11 ON Extent10.ECCFG_ID = Extent11.ID
WHERE (Extent10.FOLDR_ID = 10) AND (Extent11.CLMOD_ID > 999) ) Filter3
INNER JOIN TICON.CLMOD Extent12 ON Filter3.CLMOD_ID = Extent12.ID
WHERE Extent12.INSTALLED_F = 1) UnionAll1
UNION ALL
SELECT
'0X2X' AS C1,
Filter5.ID11 AS ID,
Filter5.CODE5 AS CODE,
Filter5.INDX,
Filter5.VARIANT,
Filter5.MASTA_ID,
Filter5.COSTC_ID,
Filter5.INCOMPLETE_F,
Filter5.ACCNT_ID,
Filter5.FOLDR_ID,
Filter5.ECCFG_ID,
Filter5.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_NCHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_NCHAR(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
Filter5.CALC,
Filter5.CALC_POSTFIX,
Filter5.F_TYPE_S,
Filter5.DIMENSION,
Filter5.TIME_TYPE_S,
Filter5.COURSE_OF_TIME_S,
TO_NUMBER(NULL) AS C15,
TO_NUMBER(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NCHAR(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NUMBER(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
TO_NUMBER(NULL) AS C24,
TO_NUMBER(NULL) AS C25,
TO_NUMBER(NULL) AS C26
FROM (SELECT
Extent13.ID AS ID11,
Extent13.CALC,
Extent13.CALC_POSTFIX,
Extent13.F_TYPE_S,
Extent13.DIMENSION,
Extent13.TIME_TYPE_S,
Extent13.COURSE_OF_TIME_S,
Extent14.ID AS ID12,
Extent14.CODE AS CODE5,
Extent14.INDX,
Extent14.VARIANT,
Extent14.MASTA_ID,
Extent14.COSTC_ID,
Extent14.INCOMPLETE_F,
Extent14.ACCNT_ID,
Extent14.FOLDR_ID,
Extent14.ECCFG_ID,
Extent14.MASTT_ID,
Extent15.ID AS ID13,
Extent15.CODE AS CODE6,
Extent15.CLMOD_ID,
Extent15.ADDCL_ID,
Extent15.ALCOS_ID,
Extent15.ICON
FROM TICON.FODEF0E Extent13
INNER JOIN TICON.MASTR Extent14 ON Extent13.ID = Extent14.ID
INNER JOIN TICON.ECCFG Extent15 ON Extent14.ECCFG_ID = Extent15.ID
WHERE (Extent14.FOLDR_ID = 10) AND (Extent15.CLMOD_ID > 999) ) Filter5
INNER JOIN TICON.CLMOD Extent16 ON Filter5.CLMOD_ID = Extent16.ID
WHERE Extent16.INSTALLED_F = 1) UnionAll2
UNION ALL
SELECT
'0X3X' AS C1,
Filter7.ID14 AS ID,
Filter7.CODE7 AS CODE,
Filter7.INDX,
Filter7.VARIANT,
Filter7.MASTA_ID,
Filter7.COSTC_ID,
Filter7.INCOMPLETE_F,
Filter7.ACCNT_ID,
Filter7.FOLDR_ID,
Filter7.ECCFG_ID,
Filter7.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_NCHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_NCHAR(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
TO_NCLOB(NULL) AS C15,
TO_NCLOB(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NCHAR(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
Filter7.PR_POINTS,
Filter7.PARTS_COUNT,
Filter7.TIMES_ID,
TO_NCHAR(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
TO_NUMBER(NULL) AS C24,
TO_NUMBER(NULL) AS C25,
TO_NUMBER(NULL) AS C26,
TO_NUMBER(NULL) AS C27,
TO_NUMBER(NULL) AS C28,
TO_NUMBER(NULL) AS C29
FROM (SELECT
Extent17.ID AS ID14,
Extent17.PR_POINTS,
Extent17.PARTS_COUNT,
Extent17.TIMES_ID,
Extent18.ID AS ID15,
Extent18.CODE AS CODE7,
Extent18.INDX,
Extent18.VARIANT,
Extent18.MASTA_ID,
Extent18.COSTC_ID,
Extent18.INCOMPLETE_F,
Extent18.ACCNT_ID,
Extent18.FOLDR_ID,
Extent18.ECCFG_ID,
Extent18.MASTT_ID,
Extent19.ID AS ID16,
Extent19.CODE AS CODE8,
Extent19.CLMOD_ID,
Extent19.ADDCL_ID,
Extent19.ALCOS_ID,
Extent19.ICON
FROM TICON.POKON0E Extent17
INNER JOIN TICON.MASTR Extent18 ON Extent17.ID = Extent18.ID
INNER JOIN TICON.ECCFG Extent19 ON Extent18.ECCFG_ID = Extent19.ID
WHERE (Extent18.FOLDR_ID = 10) AND (Extent19.CLMOD_ID > 999) ) Filter7
INNER JOIN TICON.CLMOD Extent20 ON Filter7.CLMOD_ID = Extent20.ID
WHERE Extent20.INSTALLED_F = 1) UnionAll3
UNION ALL
SELECT
'0X0X' AS C1,
Filter9.ID17 AS ID,
Filter9.CODE9 AS CODE,
Filter9.INDX,
Filter9.VARIANT,
Filter9.MASTA_ID,
Filter9.COSTC_ID,
Filter9.INCOMPLETE_F,
Filter9.ACCNT_ID,
Filter9.FOLDR_ID,
Filter9.ECCFG_ID,
Filter9.MASTT_ID,
Filter9.DOC_SOURCE_S,
Filter9.DOC_PATH,
Filter9.CREATION_DATE_TIME,
Filter9.CHANGED_DATE_TIME,
Filter9.CHANGED_ACCNT_ID,
Filter9.ADDED_DATE_TIME,
Filter9.ADDED_ACCNT_ID,
Filter9.DOC_SIZE,
Filter9.LANGU_ID,
Filter9.DOBIN_ID,
TO_NCHAR(NULL) AS C2,
TO_NUMBER(NULL) AS C3,
TO_NUMBER(NULL) AS C4,
TO_NCLOB(NULL) AS C5,
TO_NCLOB(NULL) AS C6,
TO_NUMBER(NULL) AS C7,
TO_NCHAR(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_NUMBER(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NCHAR(NULL) AS C14,
TO_NUMBER(NULL) AS C15,
TO_NUMBER(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NUMBER(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NUMBER(NULL) AS C21,
TO_NUMBER(NULL) AS C22
FROM (SELECT
Extent21.ID AS ID17,
Extent21.DOC_SOURCE_S,
Extent21.DOC_PATH,
Extent21.CREATION_DATE_TIME,
Extent21.CHANGED_DATE_TIME,
Extent21.CHANGED_ACCNT_ID,
Extent21.ADDED_DATE_TIME,
Extent21.ADDED_ACCNT_ID,
Extent21.DOC_SIZE,
Extent21.LANGU_ID,
Extent21.DOBIN_ID,
Extent22.ID AS ID18,
Extent22.CODE AS CODE9,
Extent22.INDX,
Extent22.VARIANT,
Extent22.MASTA_ID,
Extent22.COSTC_ID,
Extent22.INCOMPLETE_F,
Extent22.ACCNT_ID,
Extent22.FOLDR_ID,
Extent22.ECCFG_ID,
Extent22.MASTT_ID,
Extent23.ID AS ID19,
Extent23.CODE AS CODE10,
Extent23.CLMOD_ID,
Extent23.ADDCL_ID,
Extent23.ALCOS_ID,
Extent23.ICON
FROM TICON.DOCUM0E Extent21
INNER JOIN TICON.MASTR Extent22 ON Extent21.ID = Extent22.ID
INNER JOIN TICON.ECCFG Extent23 ON Extent22.ECCFG_ID = Extent23.ID
WHERE (Extent22.FOLDR_ID = 10) AND (Extent23.CLMOD_ID > 999) ) Filter9
INNER JOIN TICON.CLMOD Extent24 ON Filter9.CLMOD_ID = Extent24.ID
WHERE Extent24.INSTALLED_F = 1) UnionAll4
UNION ALL
SELECT
'0X1X' AS C1,
Filter11.ID20 AS ID,
Filter11.CODE11 AS CODE,
Filter11.INDX,
Filter11.VARIANT,
Filter11.MASTA_ID,
Filter11.COSTC_ID,
Filter11.INCOMPLETE_F,
Filter11.ACCNT_ID,
Filter11.FOLDR_ID,
Filter11.ECCFG_ID,
Filter11.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_NCHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
Filter11.UNIT,
Filter11.CONSUM_F,
Filter11.QUANTITY,
TO_NCLOB(NULL) AS C12,
TO_NCLOB(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
TO_NCHAR(NULL) AS C15,
TO_NUMBER(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NUMBER(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NCHAR(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
TO_NUMBER(NULL) AS C24,
TO_NUMBER(NULL) AS C25,
TO_NUMBER(NULL) AS C26,
TO_NUMBER(NULL) AS C27,
TO_NUMBER(NULL) AS C28,
TO_NUMBER(NULL) AS C29
FROM (SELECT
Extent25.ID AS ID20,
Extent25.UNIT,
Extent25.CONSUM_F,
Extent25.QUANTITY,
Extent26.ID AS ID21,
Extent26.CODE AS CODE11,
Extent26.INDX,
Extent26.VARIANT,
Extent26.MASTA_ID,
Extent26.COSTC_ID,
Extent26.INCOMPLETE_F,
Extent26.ACCNT_ID,
Extent26.FOLDR_ID,
Extent26.ECCFG_ID,
Extent26.MASTT_ID,
Extent27.ID AS ID22,
Extent27.CODE AS CODE12,
Extent27.CLMOD_ID,
Extent27.ADDCL_ID,
Extent27.ALCOS_ID,
Extent27.ICON
FROM TICON.ASSIM0E Extent25
INNER JOIN TICON.MASTR Extent26 ON Extent25.ID = Extent26.ID
INNER JOIN TICON.ECCFG Extent27 ON Extent26.ECCFG_ID = Extent27.ID
WHERE (Extent26.FOLDR_ID = 10) AND (Extent27.CLMOD_ID > 999) ) Filter11
INNER JOIN TICON.CLMOD Extent28 ON Filter11.CLMOD_ID = Extent28.ID
WHERE Extent28.INSTALLED_F = 1) UnionAll5;

patrasch79
Posts: 10
Joined: Sat 01 Dec 2012 08:53

Re: ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Post by patrasch79 » Fri 11 Oct 2013 14:47

this is the generated statement with Union that DOES NOT work:
SELECT
Distinct5.C1,
Distinct5.C2,
Distinct5.C3,
Distinct5.C4,
Distinct5.C5,
Distinct5.C6,
Distinct5.C7,
Distinct5.C8,
Distinct5.C9,
Distinct5.C10,
Distinct5.C11,
Distinct5.C12,
Distinct5.C13,
Distinct5.C14,
Distinct5.C15,
Distinct5.C16,
Distinct5.C17,
Distinct5.C18,
Distinct5.C19,
Distinct5.C20,
Distinct5.C21,
Distinct5.C22,
Distinct5.C23,
Distinct5.C24,
Distinct5.C25,
Distinct5.C26,
Distinct5.C27,
Distinct5.C28,
Distinct5.C29,
Distinct5.C30,
Distinct5.C31,
Distinct5.C32,
Distinct5.C33,
Distinct5.C34,
Distinct5.C35,
Distinct5.C36,
Distinct5.C37,
Distinct5.C38,
Distinct5.C39,
Distinct5.C40,
Distinct5.C41,
Distinct5.C42,
Distinct5.C43
FROM ( SELECT DISTINCT
UnionAll5.C1,
UnionAll5.C2,
UnionAll5.C3,
UnionAll5.C4,
UnionAll5.C5,
UnionAll5.C6,
UnionAll5.C7,
UnionAll5.C8,
UnionAll5.C9,
UnionAll5.C10,
UnionAll5.C11,
UnionAll5.C12,
UnionAll5.C13,
UnionAll5.C14,
UnionAll5.C15,
UnionAll5.C16,
UnionAll5.C17,
UnionAll5.C18,
UnionAll5.C19,
UnionAll5.C20,
UnionAll5.C21,
UnionAll5.C22,
UnionAll5.C23,
UnionAll5.C24,
UnionAll5.C25,
UnionAll5.C26,
UnionAll5.C27,
UnionAll5.C28,
UnionAll5.C29,
UnionAll5.C30,
UnionAll5.C31,
UnionAll5.C32,
UnionAll5.C33,
UnionAll5.C34,
UnionAll5.C35,
UnionAll5.C36,
UnionAll5.C37,
UnionAll5.C38,
UnionAll5.C39,
UnionAll5.C40,
UnionAll5.C41,
UnionAll5.C42,
UnionAll5.C43,
UnionAll5.C44
FROM (SELECT
Distinct4.C1,
Distinct4.C2,
Distinct4.C3,
Distinct4.C4,
Distinct4.C5,
Distinct4.C6,
Distinct4.C7,
Distinct4.C8,
Distinct4.C9,
Distinct4.C10,
Distinct4.C11,
Distinct4.C12,
Distinct4.C13,
Distinct4.C14,
Distinct4.C15,
Distinct4.C16,
Distinct4.C17,
Distinct4.C18,
Distinct4.C19,
Distinct4.C20,
Distinct4.C21,
Distinct4.C22,
Distinct4.C23,
Distinct4.C24,
Distinct4.C25,
Distinct4.C26,
Distinct4.C27,
Distinct4.C28,
Distinct4.C29,
Distinct4.C30,
Distinct4.C31,
Distinct4.C32,
Distinct4.C33,
Distinct4.C34,
Distinct4.C35,
Distinct4.C36,
Distinct4.C37,
Distinct4.C38,
Distinct4.C39,
Distinct4.C40,
Distinct4.C41,
Distinct4.C42,
Distinct4.C43,
Distinct4.C44
FROM ( SELECT DISTINCT
UnionAll4.C1,
UnionAll4.C2,
UnionAll4.C3,
UnionAll4.C4,
UnionAll4.C5,
UnionAll4.C6,
UnionAll4.C7,
UnionAll4.C8,
UnionAll4.C9,
UnionAll4.C10,
UnionAll4.C11,
UnionAll4.C12,
UnionAll4.C13,
UnionAll4.C14,
UnionAll4.C15,
UnionAll4.C16,
UnionAll4.C17,
UnionAll4.C18,
UnionAll4.C19,
UnionAll4.C20,
UnionAll4.C21,
UnionAll4.C22,
UnionAll4.C23,
UnionAll4.C24,
UnionAll4.C25,
UnionAll4.C26,
UnionAll4.C27,
UnionAll4.C28,
UnionAll4.C29,
UnionAll4.C30,
UnionAll4.C31,
UnionAll4.C32,
UnionAll4.C33,
UnionAll4.C34,
UnionAll4.C35,
UnionAll4.C36,
UnionAll4.C37,
UnionAll4.C38,
UnionAll4.C39,
UnionAll4.C40,
UnionAll4.C41,
UnionAll4.C42,
UnionAll4.C43,
UnionAll4.C44
FROM (SELECT
Distinct3.C1,
Distinct3.C2,
Distinct3.C3,
Distinct3.C4,
Distinct3.C5,
Distinct3.C6,
Distinct3.C7,
Distinct3.C8,
Distinct3.C9,
Distinct3.C10,
Distinct3.C11,
Distinct3.C12,
Distinct3.C13,
Distinct3.C14,
Distinct3.C15,
Distinct3.C16,
Distinct3.C17,
Distinct3.C18,
Distinct3.C19,
Distinct3.C20,
Distinct3.C21,
Distinct3.C22,
Distinct3.C23,
Distinct3.C24,
Distinct3.C25,
Distinct3.C26,
Distinct3.C27,
Distinct3.C28,
Distinct3.C29,
Distinct3.C30,
Distinct3.C31,
Distinct3.C32,
Distinct3.C33,
Distinct3.C34,
Distinct3.C35,
Distinct3.C36,
Distinct3.C37,
Distinct3.C38,
Distinct3.C39,
Distinct3.C40,
Distinct3.C41,
Distinct3.C42,
Distinct3.C43,
Distinct3.C44
FROM ( SELECT DISTINCT
UnionAll3.C1,
UnionAll3.C2,
UnionAll3.C3,
UnionAll3.C4,
UnionAll3.C5,
UnionAll3.C6,
UnionAll3.C7,
UnionAll3.C8,
UnionAll3.C9,
UnionAll3.C10,
UnionAll3.C11,
UnionAll3.C12,
UnionAll3.C13,
UnionAll3.C14,
UnionAll3.C15,
UnionAll3.C16,
UnionAll3.C17,
UnionAll3.C18,
UnionAll3.C19,
UnionAll3.C20,
UnionAll3.C21,
UnionAll3.C22,
UnionAll3.C23,
UnionAll3.C24,
UnionAll3.C25,
UnionAll3.C26,
UnionAll3.C27,
UnionAll3.C28,
UnionAll3.C29,
UnionAll3.C30,
UnionAll3.C31,
UnionAll3.C32,
UnionAll3.C33,
UnionAll3.C34,
UnionAll3.C35,
UnionAll3.C36,
UnionAll3.C37,
UnionAll3.C38,
UnionAll3.C39,
UnionAll3.C40,
UnionAll3.C41,
UnionAll3.C42,
UnionAll3.C43,
UnionAll3.C44
FROM (SELECT
Distinct2.C1,
Distinct2.C2,
Distinct2.C3,
Distinct2.C4,
Distinct2.C5,
Distinct2.C6,
Distinct2.C7,
Distinct2.C8,
Distinct2.C9,
Distinct2.C10,
Distinct2.C11,
Distinct2.C12,
Distinct2.C13,
Distinct2.C14,
Distinct2.C15,
Distinct2.C16,
Distinct2.C17,
Distinct2.C18,
Distinct2.C19,
Distinct2.C20,
Distinct2.C21,
Distinct2.C22,
Distinct2.C23,
Distinct2.C24,
Distinct2.C25,
Distinct2.C26,
Distinct2.C27,
Distinct2.C28,
Distinct2.C29,
Distinct2.C30,
Distinct2.C31,
Distinct2.C32,
Distinct2.C33,
Distinct2.C34,
Distinct2.C35,
Distinct2.C36,
Distinct2.C37,
Distinct2.C38,
Distinct2.C39,
Distinct2.C40,
Distinct2.C41,
Distinct2.C42,
Distinct2.C43,
Distinct2.C44
FROM ( SELECT DISTINCT
UnionAll2.C1,
UnionAll2.C2,
UnionAll2.C3,
UnionAll2.C4,
UnionAll2.C5,
UnionAll2.C6,
UnionAll2.C7,
UnionAll2.C8,
UnionAll2.C9,
UnionAll2.C10,
UnionAll2.C11,
UnionAll2.C12,
UnionAll2.C13,
UnionAll2.C14,
UnionAll2.C15,
UnionAll2.C16,
UnionAll2.C17,
UnionAll2.C18,
UnionAll2.C19,
UnionAll2.C20,
UnionAll2.C21,
UnionAll2.C22,
UnionAll2.C23,
UnionAll2.C24,
UnionAll2.C25,
UnionAll2.C26,
UnionAll2.C27,
UnionAll2.C28,
UnionAll2.C29,
UnionAll2.C30,
UnionAll2.C31,
UnionAll2.C32,
UnionAll2.C33,
UnionAll2.C34,
UnionAll2.C35,
UnionAll2.C36,
UnionAll2.C37,
UnionAll2.C38,
UnionAll2.C39,
UnionAll2.C40,
UnionAll2.C41,
UnionAll2.C42,
UnionAll2.C43,
UnionAll2.C44
FROM (SELECT
Distinct1.C1,
Distinct1.C2,
Distinct1.C3,
Distinct1.C4,
Distinct1.C5,
Distinct1.C6,
Distinct1.C7,
Distinct1.C8,
Distinct1.C9,
Distinct1.C10,
Distinct1.C11,
Distinct1.C12,
Distinct1.C13,
Distinct1.C14,
Distinct1.C15,
Distinct1.C16,
Distinct1.C17,
Distinct1.C18,
Distinct1.C19,
Distinct1.C20,
Distinct1.C21,
Distinct1.C22,
Distinct1.C23,
Distinct1.C24,
Distinct1.C25,
Distinct1.C26,
Distinct1.C27,
Distinct1.C28,
Distinct1.C29,
Distinct1.C30,
Distinct1.C31,
Distinct1.C32,
Distinct1.C33,
Distinct1.C34,
Distinct1.C35,
Distinct1.C36,
Distinct1.C37,
Distinct1.C38,
Distinct1.C39,
Distinct1.C40,
Distinct1.C41,
Distinct1.C42,
Distinct1.C43,
Distinct1.C44
FROM ( SELECT DISTINCT
UnionAll1.C1,
UnionAll1.ID AS C2,
UnionAll1.CODE AS C3,
UnionAll1.INDX AS C4,
UnionAll1.VARIANT AS C5,
UnionAll1.MASTA_ID AS C6,
UnionAll1.COSTC_ID AS C7,
UnionAll1.INCOMPLETE_F AS C8,
UnionAll1.ACCNT_ID AS C9,
UnionAll1.FOLDR_ID AS C10,
UnionAll1.ECCFG_ID AS C11,
UnionAll1.MASTT_ID AS C12,
UnionAll1.C2 AS C13,
UnionAll1.C3 AS C14,
UnionAll1.C4 AS C15,
UnionAll1.C5 AS C16,
UnionAll1.C6 AS C17,
UnionAll1.C7 AS C18,
UnionAll1.C8 AS C19,
UnionAll1.C9 AS C20,
UnionAll1.C10 AS C21,
UnionAll1.C11 AS C22,
UnionAll1.C12 AS C23,
UnionAll1.C13 AS C24,
UnionAll1.C14 AS C25,
UnionAll1.C15 AS C26,
UnionAll1.C16 AS C27,
UnionAll1.C17 AS C28,
UnionAll1.C18 AS C29,
UnionAll1.C19 AS C30,
UnionAll1.C20 AS C31,
UnionAll1.C21 AS C32,
UnionAll1.C22 AS C33,
UnionAll1.C23 AS C34,
UnionAll1.C24 AS C35,
UnionAll1.C25 AS C36,
UnionAll1.C26 AS C37,
UnionAll1.C27 AS C38,
UnionAll1.C28 AS C39,
UnionAll1.C29 AS C40,
UnionAll1.C30 AS C41,
UnionAll1.C31 AS C42,
UnionAll1.C32 AS C43,
UnionAll1.ECCFG_ID1 AS C44
FROM (SELECT
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN '0X' WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN '0X0X' WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN '0X1X' WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN '0X2X' WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN '0X3X' ELSE '0X4X' END AS C1,
Filter1.ID1 AS ID,
Filter1.CODE1 AS CODE,
Filter1.INDX,
Filter1.VARIANT,
Filter1.MASTA_ID,
Filter1.COSTC_ID,
Filter1.INCOMPLETE_F,
Filter1.ACCNT_ID,
Filter1.FOLDR_ID,
Filter1.ECCFG_ID,
Filter1.MASTT_ID,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOC_SOURCE_S WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C2,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOC_PATH WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) END AS C3,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_CHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.CREATION_DATE_TIME WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_CHAR(NULL) END AS C4,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_CHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.CHANGED_DATE_TIME WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_CHAR(NULL) END AS C5,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.CHANGED_ACCNT_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C6,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_CHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.ADDED_DATE_TIME WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_CHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_CHAR(NULL) END AS C7,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.ADDED_ACCNT_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C8,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOC_SIZE WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C9,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.LANGU_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C10,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN Filter1.DOBIN_ID WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C11,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN Filter1.UNIT WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) END AS C12,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN Filter1.CONSUM_F WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C13,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN Filter1.QUANTITY WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C14,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCLOB(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.CALC WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCLOB(NULL) END AS C15,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCLOB(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCLOB(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.CALC_POSTFIX WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCLOB(NULL) END AS C16,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.F_TYPE_S WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C17,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.DIMENSION WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) END AS C18,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.TIME_TYPE_S WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C19,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN Filter1.COURSE_OF_TIME_S WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) END AS C20,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN Filter1.PR_POINTS END AS C21,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN Filter1.PARTS_COUNT END AS C22,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN Filter1.TIMES_ID1 END AS C23,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NCHAR(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NCHAR(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NCHAR(NULL) ELSE Filter1.SHORT_CODE END AS C24,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.ANMET_ID END AS C25,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.VACRM1_VACRI_ID END AS C26,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.VACRM2_VACRI_ID END AS C27,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.VACRM3_VACRI_ID END AS C28,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.TIMES_ID2 END AS C29,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.TIME_CALC_MODE_F END AS C30,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.PRACTICE_LEVEL_F END AS C31,
CASE WHEN (((( NOT ((Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL))) AND ( NOT ((Filter1.C12 = 1) AND (Filter1.C12 IS NOT NULL)))) AND ( NOT ((Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL)))) AND ( NOT ((Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL)))) AND ( NOT ((Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL))) THEN TO_NUMBER(NULL) WHEN (Filter1.C11 = 1) AND (Filter1.C11 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C14 = 1) AND (Filter1.C14 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C13 = 1) AND (Filter1.C13 IS NOT NULL) THEN TO_NUMBER(NULL) WHEN (Filter1.C15 = 1) AND (Filter1.C15 IS NOT NULL) THEN TO_NUMBER(NULL) ELSE Filter1.TIMES_DIRTY_F END AS C32,
Filter1.ECCFG_ID AS ECCFG_ID1
FROM (SELECT
Extent1.ID AS ID1,
Extent1.CODE AS CODE1,
Extent1.INDX,
Extent1.VARIANT,
Extent1.MASTA_ID,
Extent1.COSTC_ID,
Extent1.INCOMPLETE_F,
Extent1.ACCNT_ID,
Extent1.FOLDR_ID,
Extent1.ECCFG_ID,
Extent1.MASTT_ID,
Project1.ID AS ID2,
Project1.DOC_SOURCE_S,
Project1.DOC_PATH,
Project1.CREATION_DATE_TIME,
Project1.CHANGED_DATE_TIME,
Project1.CHANGED_ACCNT_ID,
Project1.ADDED_DATE_TIME,
Project1.ADDED_ACCNT_ID,
Project1.DOC_SIZE,
Project1.LANGU_ID,
Project1.DOBIN_ID,
Project1.C1 AS C11,
Project2.ID AS ID3,
Project2.PR_POINTS,
Project2.PARTS_COUNT,
Project2.TIMES_ID AS TIMES_ID1,
Project2.C1 AS C15,
Project3.ID AS ID4,
Project3.SHORT_CODE,
Project3.ANMET_ID,
Project3.VACRM1_VACRI_ID,
Project3.VACRM2_VACRI_ID,
Project3.VACRM3_VACRI_ID,
Project3.TIMES_ID AS TIMES_ID2,
Project3.TIME_CALC_MODE_F,
Project3.PRACTICE_LEVEL_F,
Project3.TIMES_DIRTY_F,
Project3.C1 AS C12,
Project4.ID AS ID5,
Project4.CALC,
Project4.CALC_POSTFIX,
Project4.F_TYPE_S,
Project4.DIMENSION,
Project4.TIME_TYPE_S,
Project4.COURSE_OF_TIME_S,
Project4.C1 AS C13,
Project5.ID AS ID6,
Project5.UNIT,
Project5.CONSUM_F,
Project5.QUANTITY,
Project5.C1 AS C14,
Extent7.ID AS ID7,
Extent7.CODE AS CODE2,
Extent7.CLMOD_ID,
Extent7.ADDCL_ID,
Extent7.ALCOS_ID,
Extent7.ICON
FROM TICON.MASTR Extent1
LEFT OUTER JOIN (SELECT
Extent2.ID,
Extent2.DOC_SOURCE_S,
Extent2.DOC_PATH,
Extent2.CREATION_DATE_TIME,
Extent2.CHANGED_DATE_TIME,
Extent2.CHANGED_ACCNT_ID,
Extent2.ADDED_DATE_TIME,
Extent2.ADDED_ACCNT_ID,
Extent2.DOC_SIZE,
Extent2.LANGU_ID,
Extent2.DOBIN_ID,
1 AS C1
FROM TICON.DOCUM0E Extent2 ) Project1 ON Extent1.ID = Project1.ID
LEFT OUTER JOIN (SELECT
Extent3.ID,
Extent3.PR_POINTS,
Extent3.PARTS_COUNT,
Extent3.TIMES_ID,
1 AS C1
FROM TICON.POKON0E Extent3 ) Project2 ON Extent1.ID = Project2.ID
LEFT OUTER JOIN (SELECT
Extent4.ID,
Extent4.SHORT_CODE,
Extent4.ANMET_ID,
Extent4.VACRM1_VACRI_ID,
Extent4.VACRM2_VACRI_ID,
Extent4.VACRM3_VACRI_ID,
Extent4.TIMES_ID,
Extent4.TIME_CALC_MODE_F,
Extent4.PRACTICE_LEVEL_F,
Extent4.TIMES_DIRTY_F,
1 AS C1
FROM TICON.TELEM0E Extent4 ) Project3 ON Extent1.ID = Project3.ID
LEFT OUTER JOIN (SELECT
Extent5.ID,
Extent5.CALC,
Extent5.CALC_POSTFIX,
Extent5.F_TYPE_S,
Extent5.DIMENSION,
Extent5.TIME_TYPE_S,
Extent5.COURSE_OF_TIME_S,
1 AS C1
FROM TICON.FODEF0E Extent5 ) Project4 ON Extent1.ID = Project4.ID
LEFT OUTER JOIN (SELECT
Extent6.ID,
Extent6.UNIT,
Extent6.CONSUM_F,
Extent6.QUANTITY,
1 AS C1
FROM TICON.ASSIM0E Extent6 ) Project5 ON Extent1.ID = Project5.ID
INNER JOIN TICON.ECCFG Extent7 ON Extent1.ECCFG_ID = Extent7.ID
WHERE (Extent1.FOLDR_ID = 10) AND (Extent7.CLMOD_ID > 999) ) Filter1
INNER JOIN TICON.CLMOD Extent8 ON Filter1.CLMOD_ID = Extent8.ID
WHERE Extent8.INSTALLED_F = 1
UNION ALL
SELECT
'0X4X' AS C1,
Filter3.ID8 AS ID,
Filter3.CODE3 AS CODE,
Filter3.INDX,
Filter3.VARIANT,
Filter3.MASTA_ID,
Filter3.COSTC_ID,
Filter3.INCOMPLETE_F,
Filter3.ACCNT_ID,
Filter3.FOLDR_ID,
Filter3.ECCFG_ID,
Filter3.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_NCHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_NCHAR(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
TO_NCLOB(NULL) AS C15,
TO_NCLOB(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NCHAR(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NUMBER(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
Filter3.SHORT_CODE,
Filter3.ANMET_ID,
Filter3.VACRM1_VACRI_ID,
Filter3.VACRM2_VACRI_ID,
Filter3.VACRM3_VACRI_ID,
Filter3.TIMES_ID,
Filter3.TIME_CALC_MODE_F,
Filter3.PRACTICE_LEVEL_F,
Filter3.TIMES_DIRTY_F,
Filter3.ECCFG_ID AS ECCFG_ID1
FROM (SELECT
Extent9.ID AS ID8,
Extent9.SHORT_CODE,
Extent9.ANMET_ID,
Extent9.VACRM1_VACRI_ID,
Extent9.VACRM2_VACRI_ID,
Extent9.VACRM3_VACRI_ID,
Extent9.TIMES_ID,
Extent9.TIME_CALC_MODE_F,
Extent9.PRACTICE_LEVEL_F,
Extent9.TIMES_DIRTY_F,
Extent10.ID AS ID9,
Extent10.CODE AS CODE3,
Extent10.INDX,
Extent10.VARIANT,
Extent10.MASTA_ID,
Extent10.COSTC_ID,
Extent10.INCOMPLETE_F,
Extent10.ACCNT_ID,
Extent10.FOLDR_ID,
Extent10.ECCFG_ID,
Extent10.MASTT_ID,
Extent11.ID AS ID10,
Extent11.CODE AS CODE4,
Extent11.CLMOD_ID,
Extent11.ADDCL_ID,
Extent11.ALCOS_ID,
Extent11.ICON
FROM TICON.TELEM0E Extent9
INNER JOIN TICON.MASTR Extent10 ON Extent9.ID = Extent10.ID
INNER JOIN TICON.ECCFG Extent11 ON Extent10.ECCFG_ID = Extent11.ID
WHERE (Extent10.FOLDR_ID = 10) AND (Extent11.CLMOD_ID > 999) ) Filter3
INNER JOIN TICON.CLMOD Extent12 ON Filter3.CLMOD_ID = Extent12.ID
WHERE Extent12.INSTALLED_F = 1) UnionAll1
) Distinct1
UNION ALL
SELECT
'0X2X' AS C1,
Filter5.ID11 AS ID,
Filter5.CODE5 AS CODE,
Filter5.INDX,
Filter5.VARIANT,
Filter5.MASTA_ID,
Filter5.COSTC_ID,
Filter5.INCOMPLETE_F,
Filter5.ACCNT_ID,
Filter5.FOLDR_ID,
Filter5.ECCFG_ID,
Filter5.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_CHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_CHAR(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
Filter5.CALC,
Filter5.CALC_POSTFIX,
Filter5.F_TYPE_S,
Filter5.DIMENSION,
Filter5.TIME_TYPE_S,
Filter5.COURSE_OF_TIME_S,
TO_NUMBER(NULL) AS C15,
TO_NUMBER(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_CHAR(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NUMBER(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
TO_NUMBER(NULL) AS C24,
TO_NUMBER(NULL) AS C25,
TO_NUMBER(NULL) AS C26,
Filter5.ECCFG_ID AS ECCFG_ID1
FROM (SELECT
Extent13.ID AS ID11,
Extent13.CALC,
Extent13.CALC_POSTFIX,
Extent13.F_TYPE_S,
Extent13.DIMENSION,
Extent13.TIME_TYPE_S,
Extent13.COURSE_OF_TIME_S,
Extent14.ID AS ID12,
Extent14.CODE AS CODE5,
Extent14.INDX,
Extent14.VARIANT,
Extent14.MASTA_ID,
Extent14.COSTC_ID,
Extent14.INCOMPLETE_F,
Extent14.ACCNT_ID,
Extent14.FOLDR_ID,
Extent14.ECCFG_ID,
Extent14.MASTT_ID,
Extent15.ID AS ID13,
Extent15.CODE AS CODE6,
Extent15.CLMOD_ID,
Extent15.ADDCL_ID,
Extent15.ALCOS_ID,
Extent15.ICON
FROM TICON.FODEF0E Extent13
INNER JOIN TICON.MASTR Extent14 ON Extent13.ID = Extent14.ID
INNER JOIN TICON.ECCFG Extent15 ON Extent14.ECCFG_ID = Extent15.ID
WHERE (Extent14.FOLDR_ID = 10) AND (Extent15.CLMOD_ID > 999) ) Filter5
INNER JOIN TICON.CLMOD Extent16 ON Filter5.CLMOD_ID = Extent16.ID
WHERE Extent16.INSTALLED_F = 1) UnionAll2
) Distinct2
UNION ALL
SELECT
'0X3X' AS C1,
Filter7.ID14 AS ID,
Filter7.CODE7 AS CODE,
Filter7.INDX,
Filter7.VARIANT,
Filter7.MASTA_ID,
Filter7.COSTC_ID,
Filter7.INCOMPLETE_F,
Filter7.ACCNT_ID,
Filter7.FOLDR_ID,
Filter7.ECCFG_ID,
Filter7.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_CHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_CHAR(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
TO_CHAR(NULL) AS C15,
TO_CHAR(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_CHAR(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
Filter7.PR_POINTS,
Filter7.PARTS_COUNT,
Filter7.TIMES_ID,
TO_CHAR(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
TO_NUMBER(NULL) AS C24,
TO_NUMBER(NULL) AS C25,
TO_NUMBER(NULL) AS C26,
TO_NUMBER(NULL) AS C27,
TO_NUMBER(NULL) AS C28,
TO_NUMBER(NULL) AS C29,
Filter7.ECCFG_ID AS ECCFG_ID1
FROM (SELECT
Extent17.ID AS ID14,
Extent17.PR_POINTS,
Extent17.PARTS_COUNT,
Extent17.TIMES_ID,
Extent18.ID AS ID15,
Extent18.CODE AS CODE7,
Extent18.INDX,
Extent18.VARIANT,
Extent18.MASTA_ID,
Extent18.COSTC_ID,
Extent18.INCOMPLETE_F,
Extent18.ACCNT_ID,
Extent18.FOLDR_ID,
Extent18.ECCFG_ID,
Extent18.MASTT_ID,
Extent19.ID AS ID16,
Extent19.CODE AS CODE8,
Extent19.CLMOD_ID,
Extent19.ADDCL_ID,
Extent19.ALCOS_ID,
Extent19.ICON
FROM TICON.POKON0E Extent17
INNER JOIN TICON.MASTR Extent18 ON Extent17.ID = Extent18.ID
INNER JOIN TICON.ECCFG Extent19 ON Extent18.ECCFG_ID = Extent19.ID
WHERE (Extent18.FOLDR_ID = 10) AND (Extent19.CLMOD_ID > 999) ) Filter7
INNER JOIN TICON.CLMOD Extent20 ON Filter7.CLMOD_ID = Extent20.ID
WHERE Extent20.INSTALLED_F = 1) UnionAll3
) Distinct3
UNION ALL
SELECT
'0X0X' AS C1,
Filter9.ID17 AS ID,
Filter9.CODE9 AS CODE,
Filter9.INDX,
Filter9.VARIANT,
Filter9.MASTA_ID,
Filter9.COSTC_ID,
Filter9.INCOMPLETE_F,
Filter9.ACCNT_ID,
Filter9.FOLDR_ID,
Filter9.ECCFG_ID,
Filter9.MASTT_ID,
Filter9.DOC_SOURCE_S,
Filter9.DOC_PATH,
Filter9.CREATION_DATE_TIME,
Filter9.CHANGED_DATE_TIME,
Filter9.CHANGED_ACCNT_ID,
Filter9.ADDED_DATE_TIME,
Filter9.ADDED_ACCNT_ID,
Filter9.DOC_SIZE,
Filter9.LANGU_ID,
Filter9.DOBIN_ID,
TO_CHAR(NULL) AS C2,
TO_NUMBER(NULL) AS C3,
TO_NUMBER(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_CHAR(NULL) AS C6,
TO_NUMBER(NULL) AS C7,
TO_CHAR(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
TO_NUMBER(NULL) AS C12,
TO_NUMBER(NULL) AS C13,
TO_CHAR(NULL) AS C14,
TO_NUMBER(NULL) AS C15,
TO_NUMBER(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NUMBER(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_NUMBER(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
Filter9.ECCFG_ID AS ECCFG_ID1
FROM (SELECT
Extent21.ID AS ID17,
Extent21.DOC_SOURCE_S,
Extent21.DOC_PATH,
Extent21.CREATION_DATE_TIME,
Extent21.CHANGED_DATE_TIME,
Extent21.CHANGED_ACCNT_ID,
Extent21.ADDED_DATE_TIME,
Extent21.ADDED_ACCNT_ID,
Extent21.DOC_SIZE,
Extent21.LANGU_ID,
Extent21.DOBIN_ID,
Extent22.ID AS ID18,
Extent22.CODE AS CODE9,
Extent22.INDX,
Extent22.VARIANT,
Extent22.MASTA_ID,
Extent22.COSTC_ID,
Extent22.INCOMPLETE_F,
Extent22.ACCNT_ID,
Extent22.FOLDR_ID,
Extent22.ECCFG_ID,
Extent22.MASTT_ID,
Extent23.ID AS ID19,
Extent23.CODE AS CODE10,
Extent23.CLMOD_ID,
Extent23.ADDCL_ID,
Extent23.ALCOS_ID,
Extent23.ICON
FROM TICON.DOCUM0E Extent21
INNER JOIN TICON.MASTR Extent22 ON Extent21.ID = Extent22.ID
INNER JOIN TICON.ECCFG Extent23 ON Extent22.ECCFG_ID = Extent23.ID
WHERE (Extent22.FOLDR_ID = 10) AND (Extent23.CLMOD_ID > 999) ) Filter9
INNER JOIN TICON.CLMOD Extent24 ON Filter9.CLMOD_ID = Extent24.ID
WHERE Extent24.INSTALLED_F = 1) UnionAll4
) Distinct4
UNION ALL
SELECT
'0X1X' AS C1,
Filter11.ID20 AS ID,
Filter11.CODE11 AS CODE,
Filter11.INDX,
Filter11.VARIANT,
Filter11.MASTA_ID,
Filter11.COSTC_ID,
Filter11.INCOMPLETE_F,
Filter11.ACCNT_ID,
Filter11.FOLDR_ID,
Filter11.ECCFG_ID,
Filter11.MASTT_ID,
TO_NUMBER(NULL) AS C2,
TO_CHAR(NULL) AS C3,
TO_CHAR(NULL) AS C4,
TO_CHAR(NULL) AS C5,
TO_NUMBER(NULL) AS C6,
TO_CHAR(NULL) AS C7,
TO_NUMBER(NULL) AS C8,
TO_NUMBER(NULL) AS C9,
TO_NUMBER(NULL) AS C10,
TO_NUMBER(NULL) AS C11,
Filter11.UNIT,
Filter11.CONSUM_F,
Filter11.QUANTITY,
TO_CHAR(NULL) AS C12,
TO_CHAR(NULL) AS C13,
TO_NUMBER(NULL) AS C14,
TO_CHAR(NULL) AS C15,
TO_NUMBER(NULL) AS C16,
TO_NUMBER(NULL) AS C17,
TO_NUMBER(NULL) AS C18,
TO_NUMBER(NULL) AS C19,
TO_NUMBER(NULL) AS C20,
TO_CHAR(NULL) AS C21,
TO_NUMBER(NULL) AS C22,
TO_NUMBER(NULL) AS C23,
TO_NUMBER(NULL) AS C24,
TO_NUMBER(NULL) AS C25,
TO_NUMBER(NULL) AS C26,
TO_NUMBER(NULL) AS C27,
TO_NUMBER(NULL) AS C28,
TO_NUMBER(NULL) AS C29,
Filter11.ECCFG_ID AS ECCFG_ID1
FROM (SELECT
Extent25.ID AS ID20,
Extent25.UNIT,
Extent25.CONSUM_F,
Extent25.QUANTITY,
Extent26.ID AS ID21,
Extent26.CODE AS CODE11,
Extent26.INDX,
Extent26.VARIANT,
Extent26.MASTA_ID,
Extent26.COSTC_ID,
Extent26.INCOMPLETE_F,
Extent26.ACCNT_ID,
Extent26.FOLDR_ID,
Extent26.ECCFG_ID,
Extent26.MASTT_ID,
Extent27.ID AS ID22,
Extent27.CODE AS CODE12,
Extent27.CLMOD_ID,
Extent27.ADDCL_ID,
Extent27.ALCOS_ID,
Extent27.ICON
FROM TICON.ASSIM0E Extent25
INNER JOIN TICON.MASTR Extent26 ON Extent25.ID = Extent26.ID
INNER JOIN TICON.ECCFG Extent27 ON Extent26.ECCFG_ID = Extent27.ID
WHERE (Extent26.FOLDR_ID = 10) AND (Extent27.CLMOD_ID > 999) ) Filter11
INNER JOIN TICON.CLMOD Extent28 ON Filter11.CLMOD_ID = Extent28.ID
WHERE Extent28.INSTALLED_F = 1) UnionAll5
) Distinct5;


patrasch79
Posts: 10
Joined: Sat 01 Dec 2012 08:53

Re: ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Post by patrasch79 » Mon 14 Oct 2013 15:16

so i think the problem is the DISTINCT, which is generated on UNION querys.
without DISTINCT it seems to work, but the result rows are mupltiple, which i do not want :-)

DISTINCT says: give me the distinct combination of all columns of the select statement. And since CLOB, NCLOB,... can not be (directly) compared to each other ORACLE returns datatypes error.

So this is a bug?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Post by Shalex » Tue 15 Oct 2013 08:15

Could you please send us a small test project with the corresponding DDL script for reproducing the problem in our environment?

patrasch79
Posts: 10
Joined: Sat 01 Dec 2012 08:53

Re: ORA-12704: character set mismatch AND ORA-00932: inconsistent datatypes: expected - got NCLOB.

Post by patrasch79 » Thu 24 Oct 2013 16:13

Hi!

I've sent the example via contact formular.

Post Reply