APPS.GMD_SAMPLES_GRP dependencies on GMD_COMPOSITE_SPEC_DISP

Line 1724: FROM gmd_composite_spec_disp csd , gmd_event_spec_disp esd

1720:
1721: -- check whether the passed driving spec is current.If not raise error.
1722: SELECT esd.SPEC_USED_FOR_LOT_ATTRIB_IND ,esd.sampling_event_id,csd.disposition
1723: INTO l_sample_disp_curr_flag , l_sampling_event_id ,l_compare_sample_disp
1724: FROM gmd_composite_spec_disp csd , gmd_event_spec_disp esd
1725: WHERE csd.composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id
1726: AND esd.event_spec_disp_id = csd.event_spec_disp_id
1727: FOR UPDATE OF esd.SPEC_USED_FOR_LOT_ATTRIB_IND , csd.disposition NOWAIT;
1728:

Line 1740: UPDATE gmd_composite_spec_disp

1736: END IF;
1737:
1738: l_position := '035' ;
1739:
1740: UPDATE gmd_composite_spec_disp
1741: SET disposition = p_to_disposition
1742: WHERE composite_spec_disp_id = p_update_disp_rec.composite_spec_disp_id ;
1743:
1744: SELECT nvl(sample_active_cnt,0),nvl(sample_req_cnt,1)

Line 2313: GMD_EVENT_SPEC_DISP esd, GMD_COMPOSITE_SPEC_DISP csd

2309:
2310: CURSOR cur_auto_complete_bstep_comp IS
2311: SELECT NVL(wip.AUTO_COMPLETE_BATCH_STEP,'N')
2312: FROM GMD_WIP_SPEC_VRS wip,GMD_SAMPLING_EVENTS gse,
2313: GMD_EVENT_SPEC_DISP esd, GMD_COMPOSITE_SPEC_DISP csd
2314: WHERE csd.COMPOSITE_SPEC_DISP_ID = p_composite_spec_disp_id
2315: AND esd.EVENT_SPEC_DISP_ID = csd.EVENT_SPEC_DISP_ID
2316: AND gse.SAMPLING_EVENT_ID = esd.SAMPLING_EVENT_ID
2317: AND wip.SPEC_VR_ID = gse.ORIGINAL_SPEC_VR_ID;

Line 2393: FROM GMD_COMPOSITE_SPEC_DISP csd,

2389: l_lot_number,
2390: l_sampling_event_id,
2391: l_batch_id,
2392: l_step_no
2393: FROM GMD_COMPOSITE_SPEC_DISP csd,
2394: GMD_EVENT_SPEC_DISP esd ,
2395: GMD_SAMPLING_EVENTS gse,
2396: MTL_SYSTEM_ITEMS_b_kfv iim
2397: WHERE csd.composite_spec_disp_id = p_composite_spec_disp_id