APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_SAMPLES

Line 464: from gmd_samples

460: select retest_action_code
461: , resample_action_code
462: from gmd_quality_config
463: where organization_id = (select organization_id
464: from gmd_samples
465: where sample_id =p_sample_id)
466: order by orgn_code;
467: l_action_code c_action_code%ROWTYPE;
468: l_sample gmd_samples%rowtype;

Line 468: l_sample gmd_samples%rowtype;

464: from gmd_samples
465: where sample_id =p_sample_id)
466: order by orgn_code;
467: l_action_code c_action_code%ROWTYPE;
468: l_sample gmd_samples%rowtype;
469: test_ids gmd_api_pub.number_tab;
470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;
471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;
472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

Line 801: FROM gmd_samples

797: ELSIF (l_validate_res.result_action_code = l_action_code.resample_action_code) THEN
798: -- notification for taking the sample.
799: SELECT inventory_item_id, lot_number
800: INTO l_inventory_item_id, l_lot_number
801: FROM gmd_samples
802: WHERE sample_id = p_sample_id;
803: gmd_api_pub.raise (P_EVENT_NAME => 'oracle.apps.gmi.lotretestdate.update',
804: P_EVENT_KEY => to_char(l_inventory_item_id)
805: ||'-'|| l_lot_number);