Menu Path

SELECT DECODE(a.new_fields + a.del_fields + a.chg_fields, 0, 'Build New', DECODE(a.new_fields + a.del_fields, 0, '?Alter Old', 'Alter Old')) status, DECODE(b.rectype, 0, 'Table', 'View') rec_type,a.recname RECORD,a.new_fields,a.del_fields,a.chg_fieldsFROM (SELECT objectvalue1 recname,NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 1))),0) new_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(upgradeaction, 1, 1))),0) del_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 0, DECODE(upgradeaction, 0, 1)))),0) chg_fields FROM psprojectitemWHERE projectname = :1AND objecttype = 0 -- records onlyAND upgradeaction <> 2 --ignore None action'GROUP BY objectvalue1) a,psrecdefn bWHERE a.recname = b.recnameAND b.rectype IN (0,1) -- tables and views onlyORDER BY 2, 1 DESC, 3

Junk dont follow this does not amasek sense

UPDATE XXXX ESET CH_CC_REP = (SELECT E1.PERSON_ID FROM PS_CH_WORKER_EXT E1 WHERE E1.CH_CORP_ANUM_ID = (SELECT SUBSTR(CH_CONV_L_ORG,2,6) FROM PS_CH_LEAD_STG S1 WHERE S1.LEAD_ID =E.LEAD_ID) )WHERE EXISTS (SELECT 'Y' FROM PS_CH_LEAD_STG S WHERE E.LEAD_ID =S.LEAD_ID AND E.LEAD_ID ='LEA3692712') Solution Admin Search collection Setup

List of all tables with new /Old ones in compares.
SELECT DECODE(a.new_fields + a.del_fields + a.chg_fields, 0, 'Build New', DECODE(a.new_fields + a.del_fields, 0, '?Alter Old', 'Alter Old')) status, DECODE(b.rectype, 0, 'Table', 'View') rec_type,a.recname RECORD,a.new_fields,a.del_fields,a.chg_fieldsFROM (SELECT objectvalue1 recname,NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 1))),0) new_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(upgradeaction, 1, 1))),0) del_fields, NVL(SUM(DECODE(objectid2, 2, DECODE(targetstatus, 1, 0, DECODE(upgradeaction, 0, 1)))),0) chg_fields FROM psprojectitemWHERE projectname = :1AND objecttype = 0 -- records onlyAND upgradeaction <> 2 --ignore None action'GROUP BY objectvalue1) a,psrecdefn bWHERE a.recname = b.recnameAND b.rectype IN (0,1) -- tables and views onlyORDER BY 2, 1 DESC, 3

SELECT * FROM PS_RI_INTERACTION A
, (
SELECT S1.* FROM
(SELECT CH_ECN_ACCT_NUM, BO_ID FROM champ.PS_CH_FIN_ACCOUNT a WHERE bo_id NOT IN (SELECT bo_id FROM champ.PS_RD_PERSON)) S1,PS_RI_INTERACTION R
WHERE R.BO_ID_CUST = S1.BO_ID