Here is an API approach to create Samples from backend and add Test results to Samples. Firstly we need to create Sample using API gmd_samples_pub.create_samples… Read More »OPM Quality: API to create Samples and Add Test Results to Samples
/********************************************************* *PURPOSE: Query to List Test Codes Information * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT gqtb.test_id, gqtb.test_code, gqtt.test_desc, gqtb.test_class, gtmb.test_method_code, lkp1.meaning data_type, gqtb.test_unit, lkp2.meaning priority… Read More »OPM Quality – Query to List Test Codes Information
/********************************************************* *PURPOSE: Query to List Specification and Tests Information * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT gsb.spec_id, gsb.spec_name, gsb.spec_vers version, gs.meaning spec_status, lkp1.meaning spec_type, msi.segment1… Read More »OPM Quality – Query to List Specification and Tests Information
/********************************************************* *PURPOSE: Query to List Samples Information * *AUTHOR: Shailender Thallam * **********************************************************/ SELECT gs.sample_no, sample_desc, gs.organization_id, msi.segment1 item_number, msi.description , gs.sampling_event_id , gs.step_no ,… Read More »OPM Quality – Query to List Samples Information