APPS.GMD_SAMPLES_GRP dependencies on GMD_COMPOSITE_SPEC_DISP

Line 1874: FROM gmd_composite_spec_disp csd , gmd_event_spec_disp esd

1870:
1871: -- check whether the passed driving spec is current.If not raise error.
1872: SELECT esd.SPEC_USED_FOR_LOT_ATTRIB_IND ,esd.sampling_event_id,csd.disposition
1873: INTO l_sample_disp_curr_flag , l_sampling_event_id ,l_compare_sample_disp
1874: FROM gmd_composite_spec_disp csd , gmd_event_spec_disp esd
1875: WHERE csd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id
1876: AND esd.event_spec_disp_id = csd.event_spec_disp_id
1877: FOR UPDATE OF esd.SPEC_USED_FOR_LOT_ATTRIB_IND , csd.disposition NOWAIT;
1878:

Line 1890: UPDATE gmd_composite_spec_disp

1886: END IF;
1887:
1888: l_position := '035' ;
1889:
1890: UPDATE gmd_composite_spec_disp
1891: SET disposition = p_to_disposition
1892: WHERE composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id ;
1893:
1894: SELECT nvl(sample_active_cnt,0),nvl(sample_req_cnt,1)

Line 2542: GMD_EVENT_SPEC_DISP esd, GMD_COMPOSITE_SPEC_DISP csd

2538:
2539: CURSOR cur_auto_complete_bstep_comp IS
2540: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
2541: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,
2542: GMD_EVENT_SPEC_DISP esd, GMD_COMPOSITE_SPEC_DISP csd
2543: WHERE csd.COMPOSITE_SPEC_DISP_ID = p_composite_spec_disp_id
2544: AND esd.EVENT_SPEC_DISP_ID = csd.EVENT_SPEC_DISP_ID
2545: AND gse.SAMPLING_EVENT_ID = esd.SAMPLING_EVENT_ID
2546: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;

Line 2651: FROM GMD_COMPOSITE_SPEC_DISP csd,

2647: l_lot_number,
2648: l_sampling_event_id,
2649: l_batch_id,
2650: l_step_no
2651: FROM GMD_COMPOSITE_SPEC_DISP csd,
2652: GMD_EVENT_SPEC_DISP esd ,
2653: GMD_SAMPLING_EVENTS gse,
2654: MTL_SYSTEM_ITEMS_b_kfv iim
2655: WHERE csd.composite_spec_disp_id = p_composite_spec_disp_id