APPS.GMD_COA_DATA_NEW dependencies on GMD_CUSTOMER_SPEC_VRS

Line 63: gmd_customer_spec_vrs gcs,

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
67: gcs.cust_id = (select of_cust_id from op_cust_mst where cust_id= c_cust_id)

Line 94: gmd_customer_spec_vrs gcs,

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
98: gcs.cust_id = (select of_cust_id from op_cust_mst where cust_id = c_cust_id)

Line 967: c_orgn_code gmd_customer_spec_vrs.ORGN_CODE%TYPE,

963:
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)

Line 975: gmd_customer_spec_vrs gcs,

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

Line 996: gmd_customer_spec_vrs gcs,

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