SELECT
			'"Default Organization" IS NEEDED FOR YOUR DIVISION AND POSITION HIERARCHY TO OPERATE PROPERLY BUT THE "Default Organization" DOES NOT EXIST IN YOUR SYSTEM.' AS Error_message
		FROM
			SIEBEL.S_ADDR_PER T1,
			SIEBEL.S_PARTY T2,
			SIEBEL.S_POSTN T3,
			SIEBEL.S_ORG_EXT T4,
			SIEBEL.S_CON_ADDR T5,
			SIEBEL.S_ORG_EXT T6,
			SIEBEL.S_ORG_EXT T7,
			SIEBEL.S_BU T8,
			SIEBEL.S_ORG_EXT T9
		WHERE
			T9.PAR_BU_ID = T6.PAR_ROW_ID (+) AND
			T9.PAR_DIVN_ID = T7.PAR_ROW_ID (+) AND
			T2.PAR_PARTY_ID = T4.PAR_ROW_ID (+) AND
			T9.PR_MGR_POSTN_ID = T3.PAR_ROW_ID (+) AND
			T2.ROW_ID = T9.PAR_ROW_ID AND
			T2.ROW_ID = T8.PAR_ROW_ID (+) AND
			T9.PR_ADDR_ID = T5.ADDR_PER_ID (+) AND
			T9.ROW_ID = T5.ACCNT_ID (+) AND
			T9.PR_ADDR_ID = T1.ROW_ID (+) AND
			(T9.INT_ORG_FLG = 'Y') AND
			UPPER(T9.NAME) = 'DEFAULT ORGANIZATION'
			GROUP BY T9.ROW_ID HAVING COUNT(T9.ROW_ID)=0
UNION
SELECT
 'YOUR SYSTEM CONTAINS MORE THAN ONE "Default Organization". THIS MAY CAUSE YOUR DIVISION AND POSITION HIERARCHY NOT TO OPERATE PROPERLY.' AS error_message
FROM
			SIEBEL.S_ADDR_PER T1,
			SIEBEL.S_PARTY T2,
			SIEBEL.S_POSTN T3,
			SIEBEL.S_ORG_EXT T4,
			SIEBEL.S_CON_ADDR T5,
			SIEBEL.S_ORG_EXT T6,
			SIEBEL.S_ORG_EXT T7,
			SIEBEL.S_BU T8,
			SIEBEL.S_ORG_EXT T9
		WHERE
			T9.PAR_BU_ID = T6.PAR_ROW_ID (+) AND
			T9.PAR_DIVN_ID = T7.PAR_ROW_ID (+) AND
			T2.PAR_PARTY_ID = T4.PAR_ROW_ID (+) AND
			T9.PR_MGR_POSTN_ID = T3.PAR_ROW_ID (+) AND
			T2.ROW_ID = T9.PAR_ROW_ID AND
			T2.ROW_ID = T8.PAR_ROW_ID (+) AND
			T9.PR_ADDR_ID = T5.ADDR_PER_ID (+) AND
			T9.ROW_ID = T5.ACCNT_ID (+) AND
			T9.PR_ADDR_ID = T1.ROW_ID (+) AND
			(T9.INT_ORG_FLG = 'Y') AND
			UPPER(T9.NAME) = 'DEFAULT ORGANIZATION'
			GROUP BY T9.NAME HAVING COUNT(T9.NAME)>1
UNION
SELECT	DISTINCT
			'THE ROW_ID OF THE "Default Organization" IN YOUR SYSTEM IS'||' '||CHR(39)||T9.ROW_ID||CHR(39)||'.'||' '||'THIS IS INCORRECT AND SHOULD BE'||' '||CHR(39)||'0-R9NH'||CHR(39)||'.'||' '||'THIS ERROR MAY CAUSE YOUR DIVISION AND POSITION HIERARCHY NOT TO OPERATE PROPERLY.' AS error_message
		FROM
			SIEBEL.S_ADDR_PER T1,
			SIEBEL.S_PARTY T2,
			SIEBEL.S_POSTN T3,
			SIEBEL.S_ORG_EXT T4,
			SIEBEL.S_CON_ADDR T5,
			SIEBEL.S_ORG_EXT T6,
			SIEBEL.S_ORG_EXT T7,
			SIEBEL.S_BU T8,
			SIEBEL.S_ORG_EXT T9
		WHERE
			T9.PAR_BU_ID = T6.PAR_ROW_ID (+) AND
			T9.PAR_DIVN_ID = T7.PAR_ROW_ID (+) AND
			T2.PAR_PARTY_ID = T4.PAR_ROW_ID (+) AND
			T9.PR_MGR_POSTN_ID = T3.PAR_ROW_ID (+) AND
			T2.ROW_ID = T9.PAR_ROW_ID AND
			T2.ROW_ID = T8.PAR_ROW_ID (+) AND
			T9.PR_ADDR_ID = T5.ADDR_PER_ID (+) AND
			T9.ROW_ID = T5.ACCNT_ID (+) AND
			T9.PR_ADDR_ID = T1.ROW_ID (+) AND
			(T9.INT_ORG_FLG = 'Y') AND
			UPPER(T9.NAME) = 'DEFAULT ORGANIZATION' AND
			T9.ROW_ID <>'0-R9NH'
UNION
SELECT
			'DIVISION NAMED'||' '||CHR(39)||T9.NAME||CHR(39)||' '||'HAS THE VALUE OF ITS "ORGANIZATION" FIELD AS'||' '||CHR(39)||T6.NAME||CHR(39)||'.'||' '||'THIS IS INCORRECT AND ITS ORGANIZATION FIELD VALUE SHOULD BE "Default Organization".' AS errro_message
		FROM
			SIEBEL.S_ADDR_PER T1,
			SIEBEL.S_PARTY T2,
			SIEBEL.S_POSTN T3,
			SIEBEL.S_ORG_EXT T4,
			SIEBEL.S_CON_ADDR T5,
			SIEBEL.S_ORG_EXT T6,
			SIEBEL.S_ORG_EXT T7,
			SIEBEL.S_BU T8,
			SIEBEL.S_ORG_EXT T9
		WHERE
			T9.PAR_BU_ID = T6.PAR_ROW_ID AND
			T9.PAR_DIVN_ID = T7.PAR_ROW_ID (+) AND
			T2.PAR_PARTY_ID = T4.PAR_ROW_ID (+) AND
			T9.PR_MGR_POSTN_ID = T3.PAR_ROW_ID (+) AND
			T2.ROW_ID = T9.PAR_ROW_ID AND
			T2.ROW_ID = T8.PAR_ROW_ID (+) AND
			T9.PR_ADDR_ID = T5.ADDR_PER_ID (+) AND
			T9.ROW_ID = T5.ACCNT_ID (+) AND
			T9.PR_ADDR_ID = T1.ROW_ID (+) AND
			(T9.INT_ORG_FLG = 'Y')
		AND
			UPPER(T6.NAME) <> 'DEFAULT ORGANIZATION';

SELECT
  CASE WHEN CNTR  = 0 THEN '"Default Organization" IS NEEDED FOR YOUR DIVISION AND POSITION HIERARCHY TO OPERATE PROPERLY BUT THE "Default Organization" DOES NOT EXIST IN YOUR SYSTEM.'
       ELSE 'YOUR SYSTEM CONTAINS MORE THAN ONE "Default Organization". THIS MAY CAUSE YOUR DIVISION AND POSITION HIERARCHY NOT TO OPERATE PROPERLY.'
  END AS ERROR_MESSAGE
FROM (SELECT COUNT(*) CNTR
      FROM 
        SIEBEL.S_ORG_EXT T9, SIEBEL.S_PARTY T2
        WHERE (T9.INT_ORG_FLG = 'Y') AND UPPER(T9.NAME) = 'DEFAULT ORGANIZATION'
           AND T2.ROW_ID = T9.PAR_ROW_ID
        HAVING ( CNTR(*) = 0 OR CNTR(*) > 1 )