SELECT * FROM faas_list WHERE TDNO = '07-0001-03047';
SELECT * FROM faas_list WHERE pin = '076-07-0001-090-04';
select * from rpu where objid = 'RPU7dfbbb45:16cd05ae6fe:-299a';
select * from realproperty where objid = 'RP7dfbbb45:16cd05ae6fe:-299c';

select * from landrpu where objid = 'RPU8e21d99:16bf81f3b61:-5360';

select * from landdetail where landrpuid = 'RPU8e21d99:16bf81f3b61:-5360';
select * from landdetail where landrpuid = 'RPU7dfbbb45:16cd05ae6fe:-299a';

/* RUN TO EDIT
UPDATE faas_list SET state = 'INTERIM' WHERE TDNO = '07-0001-03047';
UPDATE faas SET state = 'INTERIM' WHERE TDNO = '07-0001-03047';
*/

/* RUN AFTER SAVE
UPDATE faas_list SET state = 'CURRENT' WHERE TDNO = '07-0001-03047';
UPDATE faas SET state = 'CURRENT' WHERE TDNO = '07-0001-03047';

/* RUN for notification
Select * from notification

Select tdno from faas_list where lguid = '07607' and state not in ( 'interim' ) order by pin