When I try to reformat the following select statement, one of my CPU goes to the max and stays there. I have to kill it after about ten minutes.
SELECT * FROM (SELECT RegistrationEO.PARTY_TAX_PROFILE_ID
, RegistrationEO.REGISTRATION_ID
, RegistrationEO.TAX_REGIME_CODE
, RegistrationEO.TAX
, RegistrationEO.TAX_JURISDICTION_CODE
, RegistrationEO.REP_PARTY_TAX_NAME
, RegistrationEO.REGISTRATION_NUMBER
, RegistrationEO.DEFAULT_REGISTRATION_FLAG
, RegistrationEO.REGISTRATION_TYPE_CODE
, RegistrationEO.REGISTRATION_STATUS_CODE
, RegistrationEO.REGISTRATION_SOURCE_CODE
, RegistrationEO.REGISTRATION_REASON_CODE
, RegistrationEO.EFFECTIVE_FROM
, RegistrationEO.EFFECTIVE_TO
, RegistrationEO.ROUNDING_RULE_CODE
, RegistrationEO.SELF_ASSESS_FLAG
, RegistrationEO.INCLUSIVE_TAX_FLAG
, RegistrationEO.REP_TAX_AUTHORITY_ID
, RegistrationEO.COLL_TAX_AUTHORITY_ID
, RegistrationEO.BANK_ID
, RegistrationEO.BANK_BRANCH_ID
, RegistrationEO.BANK_ACCOUNT_NUM
, RegistrationEO.TAX_CLASSIFICATION_CODE
, RegistrationEO.LEGAL_REGISTRATION_ID
, RegistrationEO.LEGAL_LOCATION_ID
, RegistrationEO.ACCOUNT_ID
, RegistrationEO.ACCOUNT_SITE_ID
, RepTaxAuthorities.PARTY_NAME Rep_Tax_Auth_Name
, CollTaxAuthorities.PARTY_NAME Coll_Tax_Auth_Name
, RegistrationEO.TAX_AUTHORITY_ID
, 'Y' AS Database_Row
, IssTaxAuthorities.PARTY_NAME Iss_Tax_Auth_Name
, BankTaxAuthorities.PARTY_NAME Bank_Name
, BranchTaxAuthorities.PARTY_NAME Branch_Name
, decode (RegistrationEO.LEGAL_LOCATION_ID
,null
,null
, loc.Location_Code || ':' || ' ' || ' ' || loc.Town_OR_City || ' ' || loc.Region_1) AS Address
, CASE WHEN RegistrationEO.EFFECTIVE_TO is NULL
AND SYSDATE > RegistrationEO.EFFECTIVE_FROM THEN 'Y' ELSE CASE WHEN SYSDATE BETWEEN Registrati
WORKAROUND:
None
STATUS:
Waiting for fix in a future version of Toad for Oracle.
