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';