Category Archives: OPM

OPM Quality: API to create Samples and Add Test Results to Samples

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 and then add Test Results to the Sample by using gmd_results_pub.add_tests_to_sample API. Points to note Specification will be automatically picked up based on the item and org combination. Sample Type… Read More »

Category: OPM

OPM Quality – Query to List Test Codes Information

/********************************************************* *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 , gqtb.min_value_num, gqtb.max_value_num, gqtb.test_group_order ordering FROM gmd_qc_tests_b gqtb, gmd_qc_tests_tl gqtt, gmd_test_methods_b gtmb, gem_lookups lkp1, gem_lookups lkp2 WHERE 1 = 1 AND gqtb.test_id = 16 AND gqtb.test_id = gqtt.test_id AND gqtt.language… Read More »

Category: OPM

OPM Quality – Query to List Specification and Tests 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 item, msi.description item_desc, fu.user_name owner, gstb.seq, gqtb.test_code, gtmb.test_method_code, gstb.test_qty, gstb.test_qty_uom, gstb.test_replicate FROM gmd_specifications_b gsb, gmd_specifications_tl gst, fnd_user fu, gmd_status_tl gs, gem_lookups lkp1, mtl_system_items_b msi, gmd_spec_tests_b gstb, gmd_qc_tests_b gqtb, gmd_test_methods_b gtmb… Read More »

Category: OPM

OPM Quality – Query to List Samples 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 , gs.step_id , gs.sample_id , gs.sample_no , gs.sample_desc , gs.type , gs.qc_lab_orgn_code , gs.item_id , gs.location , gs.expiration_date , gs.lot_id , gs.lot_no , gs.batch_id , gs.recipe_id , gs.formula_id , gs.formulaline_id ,… Read More »

Category: OPM