Matrix Wanted Via SQl Script
SELECT gs.sample_no , yy.receipt_num receipt_number , flv.MEANING, gt.test_code assay_code2, DECODE (gt.TEST_TYPE , 'T' , gr.RESULT_VALUE_CHAR , 'E' , gr.RESULT_VALUE_NUM , 'N' , gr.RESULT_VALUE_NUM , 'L' , gr.RESULT_VALUE_NUM , gr.RESULT_VALUE_CHAR ) Result FROM po_vendors pvm, mtl_system_items_kfv msi, -- nsrivast,4443253 mtl_lot_Numbers mln, -- nsrivast,4443253 gmd_samples gs, gmd_results gr, gmd_qc_tests_b gt , gmd_spec_results gsr , GMD_QC_E_SPEC_TESTS_V gst , gmd_sampling_events gse, gmd_event_spec_disp ges , rcv_transactions rt , -- to get receipt quantity rcv_shipment_headers yy , rcv_shipment_lines zz , -- GMD_QC_E_SUPP_SAMPLE_DTLS_V gqs, --to get receipt Number and po informations ***** Warning: Oracle Internal Use Only ***** FND_USER fu , -- to get sampler description FND_LOOKUP_VALUES_VL flv
0