APPS.GMD_COA_DATA_NEW dependencies on GMD_SPECIFICATIONS_B

Line 62: gmd_specifications_b gsb, -- qc_spec_mst qsm

58: specification,
59: gst.test_uom uom,
60: gcs.text_code spec_text_code
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

Line 93: gmd_specifications_b gsb, -- qc_spec_mst qsm

89: specification,
90: gst.test_uom uom,
91: gcs.text_code spec_text_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

Line 145: gmd_specifications_b gsb, -- qc_spec_mst qsm

141: specification,
142: gst.test_uom uom,
143: gcs.text_code spec_text_code
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

Line 190: p_qc_spec_id IN gmd_specifications_b.spec_id%TYPE,

186: p_cust_id IN op_cust_mst.cust_id%TYPE,
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)

Line 194: p_spec_text_code IN gmd_specifications_b.text_code%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;
198:

Line 876: gmd_specifications_b gsb,

872: gmd_spec_results gsr,
873: gmd_spec_tests_b gst ,
874: gmd_sampling_events gse,
875: gmd_event_spec_disp ges,
876: gmd_specifications_b gsb,
877: gmd_sample_spec_disp gss
878:
879: where gs.sample_id = gr.sample_id
880: and gse.sampling_event_id = gs.sampling_event_id

Line 927: gmd_specifications_b gsb,

923: gmd_spec_results gsr,
924: gmd_spec_tests_b gst ,
925: gmd_sampling_events gse,
926: gmd_event_spec_disp ges,
927: gmd_specifications_b gsb,
928: gmd_sample_spec_disp gss
929:
930: where gs.sample_id = gr.sample_id
931: and gse.sampling_event_id = gs.sampling_event_id

Line 974: from gmd_specifications_b gsb,

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

Line 995: from gmd_specifications_b gsb,

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