SELECT
"SUBMISSION"."SUBMISSIONID", "SUBMISSION"."U_SUBMISSION_TYPE", "SUBMISSION"."U_PRODUCT", "SUBMISSION"."U_LOT_NUMBER", "SUBMISSION"."U_RELEASED_DATE", "SAMPLE"."SAMPLEID", "SAMPLE"."U_SAMPLE_TYPE", "SAMPLE"."U_CONTAINER", "SYSUSER"."U_NAME", "SDIDATAITEM"."SDCID", "SDIDATAITEM"."PARAMID", "SDIDATAITEM"."PARAMTYPE", "SDIDATAITEM"."DISPLAYVALUE", "SDIDATAITEM"."DISPLAYUNITS", "SDIDATAITEM"."NOTES", "SDISPEC"."CONDITION", "PARAMLIST"."U_DOCUMENT_ID", "PARAMLIST"."U_TITLE", "SPEC"."U_DOCUMENT_ID", "SPEC"."U_DOCUMENT_TITLE"
FROM
"SAPPHIRE"."SUBMISSION" "SUBMISSION",
"SAPPHIRE"."SAMPLE" "SAMPLE",
"SAPPHIRE"."SYSUSER" "SYSUSER",
"SAPPHIRE"."SDIDATAITEM" "SDIDATAITEM",
"SAPPHIRE"."SDISPEC" "SDISPEC",
"SAPPHIRE"."PARAMLIST" "PARAMLIST",
"SAPPHIRE"."SPEC" "SPEC"
WHERE
"SUBMISSION"."SUBMISSIONID" = "SAMPLE"."U_SUBMISSIONID" AND
"SUBMISSION"."U_RELEASED_BY" = "SYSUSER"."SYSUSERID" AND
"SAMPLE"."SAMPLEID" = "SDIDATAITEM"."KEYID1" AND
"SAMPLE"."SAMPLEID" = "SDISPEC"."KEYID1" AND
"SDIDATAITEM"."PARAMLISTID" = "PARAMLIST"."PARAMLISTID" AND
"SDISPEC"."SPECID" = "SPEC"."SPECID" AND
"SDIDATAITEM"."SDCID" = 'Sample' AND
"SUBMISSION"."SUBMISSIONID" = 'QC-05-00692' AND
"SAMPLE"."U_SAMPLE_TYPE" = 'Final' AND
"SDIDATAITEM"."PARAMTYPE" <> 'Level 2'