[Home] [Help]
61: from
62: gmd_specifications_b gsb, -- qc_spec_mst qsm
63: gmd_customer_spec_vrs gcs,
64: gmd_spec_tests_b gst,
65: gmd_qc_tests_b gt
66: where
67: gcs.cust_id = (select of_cust_id from op_cust_mst where cust_id= c_cust_id)
68: and (c_item_id is NULL or gsb.item_id = c_item_id)
69: and gcs.orgn_code = c_orgn_code
92: from
93: gmd_specifications_b gsb, -- qc_spec_mst qsm
94: gmd_customer_spec_vrs gcs,
95: gmd_spec_tests_b gst,
96: gmd_qc_tests_b gt
97: where
98: gcs.cust_id = (select of_cust_id from op_cust_mst where cust_id = c_cust_id)
99: and (c_item_id is NULL or gsb.item_id = c_item_id)
100: and gcs.orgn_code is null
144: from
145: gmd_specifications_b gsb, -- qc_spec_mst qsm
146: gmd_inventory_spec_vrs gcs,
147: gmd_spec_tests_b gst,
148: gmd_qc_tests_b gt
149: where
150: ((l_chk_whse_null =1 and gcs.whse_code is NULL)
151: OR (l_chk_whse_null=0 and
152: (c_whse_code is NULL or gcs.whse_code = c_whse_code)
187: p_item_id IN ic_item_mst.item_id%TYPE,
188: p_whse_code IN ic_whse_mst.whse_code%TYPE,
189: p_lot_id IN ic_lots_mst.lot_id%TYPE,
190: p_qc_spec_id IN gmd_specifications_b.spec_id%TYPE,
191: p_assay_code IN gmd_qc_tests_b.test_code%TYPE,
192: p_specification IN gmd_spec_tests.target_value_char%TYPE,
193: p_UOM IN gmd_qc_tests_b.test_unit%TYPE,
194: p_spec_text_code IN gmd_specifications_b.text_code%TYPE)
195: IS
189: p_lot_id IN ic_lots_mst.lot_id%TYPE,
190: p_qc_spec_id IN gmd_specifications_b.spec_id%TYPE,
191: p_assay_code IN gmd_qc_tests_b.test_code%TYPE,
192: p_specification IN gmd_spec_tests.target_value_char%TYPE,
193: p_UOM IN gmd_qc_tests_b.test_unit%TYPE,
194: p_spec_text_code IN gmd_specifications_b.text_code%TYPE)
195: IS
196: BEGIN
197: dtl_tbl_ndx := dtl_tbl_ndx + 1;
867: gst.text_code spec_text_code,
868: gr.text_code rslt_text_code
869: from gmd_samples gs,
870: gmd_results gr,
871: gmd_qc_tests_b gt,
872: gmd_spec_results gsr,
873: gmd_spec_tests_b gst ,
874: gmd_sampling_events gse,
875: gmd_event_spec_disp ges,
918: gst.text_code spec_text_code,
919: gr.text_code rslt_text_code
920: from gmd_samples gs,
921: gmd_results gr,
922: gmd_qc_tests_b gt,
923: gmd_spec_results gsr,
924: gmd_spec_tests_b gst ,
925: gmd_sampling_events gse,
926: gmd_event_spec_disp ges,
964:
965: CURSOR get_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
966: c_cust_id op_cust_mst.cust_id%TYPE,
967: c_orgn_code gmd_customer_spec_vrs.ORGN_CODE%TYPE,
968: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
969: IS
970: select gsb.spec_id qc_spec_id,
971: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
972: specification,
973: gcs.text_code spec_text_code
974: from gmd_specifications_b gsb,
975: gmd_customer_spec_vrs gcs,
976: gmd_spec_tests_b gst,
977: gmd_qc_tests_b gt
978: where gsb.spec_id = gcs.spec_id
979: and gsb.spec_id = gst.spec_id
980: and gst.test_id = gt.test_id
981: and gsb.item_id = c_item_id
985: and gsb.delete_mark= 0;
986:
987: CURSOR get_global_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
988: c_cust_id op_cust_mst.cust_id%TYPE,
989: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
990: IS
991: select gsb.spec_id qc_spec_id,
992: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
993: specification,
994: gcs.text_code spec_text_code
995: from gmd_specifications_b gsb,
996: gmd_customer_spec_vrs gcs,
997: gmd_spec_tests_b gst,
998: gmd_qc_tests_b gt
999: where gsb.spec_id = gcs.spec_id
1000: and gsb.spec_id = gst.spec_id
1001: and gst.test_id = gt.test_id
1002: and gsb.item_id = c_item_id
1005: and gcs.orgn_code is NULL
1006: and gsb.delete_mark= 0;
1007:
1008:
1009: CURSOR get_assay_info (c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
1010: IS
1011: select gt.test_desc assay_desc
1012: from gmd_qc_tests gt
1013: where gt.test_code = c_assay_code
1008:
1009: CURSOR get_assay_info (c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
1010: IS
1011: select gt.test_desc assay_desc
1012: from gmd_qc_tests gt
1013: where gt.test_code = c_assay_code
1014: and gt.delete_mark = 0;
1015:
1016: tbl_ndx BINARY_INTEGER := 0;