SElECT DISTINCT ASDM_UID FROM ALMA.ASA_SCIENCE WHERE MEMBER_OUSS_ID = 'uid://A001/X12a3/X80e';

SELECT NGAS_FILE_ID FROM ALMA.ASA_PRODUCT_FILES WHERE ASA_OUS_ID = 'uid://A001/X12a3/X80e' AND FILE_CLASS IN ('calibration', 'script');

SELECT DISTINCT PROJECT_CODE FROM ASA_PROJECT JOIN ASA_SCIENCE ON ASA_PROJECT.PROJECT_UID = ASA_SCIENCE.PROJECT_UID WHERE  MEMBER_OUSS_ID='uid://A001/X12a3/X80e';

SELECT OBSUNITSETUID, OBSUNITSETPARTID FROM AQUA_OUS WHERE OUS_STATUS_ENTITY_ID = 'uid://A001/X12a3/X80e';

SELECT DISTINCT SCHEDBLOCK_UID FROM ALMA.ASA_SCIENCE WHERE MEMBER_OUSS_ID = 'uid://A001/X12a3/X80e';

SELECT STATUS_ENTITY_ID FROM ALMA.SCHED_BLOCK_STATUS WHERE DOMAIN_ENTITY_ID = 'uid://A001/X12a3/X804';

SELECT XML FROM ALMA.OBS_UNIT_SET_STATUS WHERE STATUS_ENTITY_ID = 'uid://A001/X12a3/X80e';

SELECT DISTINCT SCIENCE_GOAL_OUSS_ID, GROUP_OUSS_ID, MEMBER_OUSS_ID FROM ALMA.ASA_SCIENCE WHERE MEMBER_OUSS_ID = 'uid://A001/X12a3/X80e';