DBA Data[Home] [Help]

APPS.GMD_COA_DATA_OM dependencies on GMD_CUSTOMER_SPEC_VRS

Line 388: c_orgn_code gmd_customer_spec_vrs.ORGN_CODE%TYPE,

384:
385:
386: CURSOR get_cust_spec (c_item_id ic_item_mst.item_id%TYPE,
387: c_cust_id hz_cust_accounts.cust_account_id%TYPE,
388: c_orgn_code gmd_customer_spec_vrs.ORGN_CODE%TYPE,
389: c_assay_code gmd_qc_tests_b.TEST_CODE%TYPE)
390: IS
391: select gsb.spec_id qc_spec_id,
392: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)

Line 396: gmd_customer_spec_vrs gcs,

392: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
393: specification,
394: gcs.text_code spec_text_code
395: from gmd_specifications_b gsb,
396: gmd_customer_spec_vrs gcs,
397: gmd_spec_tests_b gst,
398: gmd_qc_tests_b gt
399: where gsb.spec_id = gcs.spec_id
400: and gsb.spec_id = gst.spec_id

Line 418: gmd_customer_spec_vrs gcs,

414: decode(gst.target_value_char, null, to_char(gst.target_value_num),gst.target_value_char)
415: specification,
416: gcs.text_code spec_text_code
417: from gmd_specifications_b gsb,
418: gmd_customer_spec_vrs gcs,
419: gmd_spec_tests_b gst,
420: gmd_qc_tests_b gt
421: where gsb.spec_id = gcs.spec_id
422: and gsb.spec_id = gst.spec_id