eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SAMPLES_GRP dependencies on GMD_EVENT_SPEC_DISP

Line 131: gmd_event_spec_disp esd

127: SELECT se.sampling_event_id
128: FROM gmd_sampling_events se,
129: -- gmd_specifications_b s,
130: -- gmd_inventory_spec_vrs ivr,
131: gmd_event_spec_disp esd
132: -- WHERE s.spec_id = ivr.spec_id
133: -- AND ivr.spec_vr_id = esd.spec_vr_id
134: -- AND esd.sampling_event_id = se.sampling_event_id
135: WHERE esd.sampling_event_id = se.sampling_event_id

Line 165: gmd_event_spec_disp esd

161: -- Bug 4640143: added material detail id
162: CURSOR c_wip_sampling_event IS
163: SELECT se.sampling_event_id
164: FROM gmd_sampling_events se,
165: gmd_event_spec_disp esd
166: WHERE esd.sampling_event_id = se.sampling_event_id
167: AND ( (esd.spec_vr_id = p_spec_vr_id) OR
168: (esd.spec_vr_id is null and p_spec_vr_id is null ))
169: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 234: gmd_event_spec_disp esd

230: SELECT se.sampling_event_id
231: FROM gmd_sampling_events se,
232: -- gmd_specifications_b s,
233: -- gmd_customer_spec_vrs cvr,
234: gmd_event_spec_disp esd
235: -- WHERE s.spec_id = cvr.spec_id
236: -- AND cvr.spec_vr_id = esd.spec_vr_id
237: WHERE esd.sampling_event_id = se.sampling_event_id
238: AND ( (esd.spec_vr_id = p_spec_vr_id) OR

Line 287: gmd_event_spec_disp esd

283: SELECT se.sampling_event_id
284: FROM gmd_sampling_events se,
285: -- gmd_specifications_b s,
286: -- gmd_supplier_spec_vrs svr,
287: gmd_event_spec_disp esd
288: -- WHERE s.spec_id = svr.spec_id
289: -- AND svr.spec_vr_id = esd.spec_vr_id
290: WHERE esd.sampling_event_id = se.sampling_event_id
291: AND ( (esd.spec_vr_id = p_spec_vr_id) OR

Line 342: gmd_event_spec_disp esd

338: SELECT se.sampling_event_id
339: FROM gmd_sampling_events se,
340: -- gmd_specifications_b s,
341: -- gmd_monitoring_spec_vrs svr,
342: gmd_event_spec_disp esd
343: -- WHERE s.spec_id = svr.spec_id
344: -- AND svr.spec_vr_id = esd.spec_vr_id
345: WHERE esd.sampling_event_id = se.sampling_event_id
346: AND ( (esd.spec_vr_id = p_spec_vr_id) OR

Line 388: gmd_event_spec_disp esd

384: SELECT se.sampling_event_id
385: FROM gmd_sampling_events se,
386: -- gmd_specifications_b s,
387: -- gmd_monitoring_spec_vrs svr,
388: gmd_event_spec_disp esd
389: -- WHERE s.spec_id = svr.spec_id
390: -- AND svr.spec_vr_id = esd.spec_vr_id
391: WHERE esd.sampling_event_id = se.sampling_event_id
392: AND se.source = p_sample.source

Line 514: gmd_event_spec_disp esd

510: SELECT se.sampling_event_id
511: FROM gmd_sampling_events se,
512: gmd_specifications_b s,
513: gmd_inventory_spec_vrs ivr,
514: gmd_event_spec_disp esd
515: WHERE s.spec_id = ivr.spec_id
516: AND ivr.spec_vr_id = esd.spec_vr_id
517: AND esd.sampling_event_id = se.sampling_event_id
518: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 555: gmd_event_spec_disp esd

551: SELECT se.sampling_event_id
552: FROM gmd_sampling_events se,
553: gmd_specifications_b s,
554: gmd_wip_spec_vrs wvr,
555: gmd_event_spec_disp esd
556: WHERE s.spec_id = wvr.spec_id
557: AND wvr.spec_vr_id = esd.spec_vr_id
558: AND esd.sampling_event_id = se.sampling_event_id
559: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 621: gmd_event_spec_disp esd

617: SELECT se.sampling_event_id
618: FROM gmd_sampling_events se,
619: gmd_specifications_b s,
620: gmd_customer_spec_vrs cvr,
621: gmd_event_spec_disp esd
622: WHERE s.spec_id = cvr.spec_id
623: AND cvr.spec_vr_id = esd.spec_vr_id
624: AND esd.sampling_event_id = se.sampling_event_id
625: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 668: gmd_event_spec_disp esd

664: SELECT se.sampling_event_id
665: FROM gmd_sampling_events se,
666: gmd_specifications_b s,
667: gmd_supplier_spec_vrs svr,
668: gmd_event_spec_disp esd
669: WHERE s.spec_id = svr.spec_id
670: AND svr.spec_vr_id = esd.spec_vr_id
671: AND esd.sampling_event_id = se.sampling_event_id
672: AND esd.spec_used_for_lot_attrib_ind = 'Y'

Line 711: gmd_event_spec_disp esd

707: SELECT se.sampling_event_id
708: FROM gmd_sampling_events se,
709: gmd_specifications_b s,
710: gmd_monitoring_spec_vrs svr,
711: gmd_event_spec_disp esd
712: WHERE s.spec_id = svr.spec_id
713: AND svr.spec_vr_id = esd.spec_vr_id
714: AND esd.sampling_event_id = se.sampling_event_id
715: AND ((se.organization_id is NULL AND p_sample.organization_id IS NULL) OR

Line 754: gmd_event_spec_disp esd

750: SELECT se.sampling_event_id
751: FROM gmd_sampling_events se,
752: gmd_specifications_b s,
753: gmd_monitoring_spec_vrs svr,
754: gmd_event_spec_disp esd
755: WHERE s.spec_id = svr.spec_id
756: AND svr.spec_vr_id = esd.spec_vr_id
757: AND esd.sampling_event_id = se.sampling_event_id
758: AND se.source = p_sample.source

Line 1562: FROM gmd_event_spec_disp

1558:
1559: -- check whether the passed driving spec is current.If not raise error.
1560: SELECT SPEC_USED_FOR_LOT_ATTRIB_IND ,sampling_event_id,disposition
1561: INTO l_sample_disp_curr_flag , l_sampling_event_id , l_curr_event_disp
1562: FROM gmd_event_spec_disp
1563: WHERE event_spec_disp_id = l_event_spec_disp_id
1564: FOR UPDATE OF SPEC_USED_FOR_LOT_ATTRIB_IND NOWAIT;
1565:
1566: IF NVL(l_sample_disp_curr_flag,'N') = 'N' THEN

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 1858: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

1854: END IF;
1855:
1856: -- get MAXIMUM sample disposition from all the samples for that event.
1857: SELECT MAX(ssd.disposition) INTO l_max_disposition
1858: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
1859: WHERE esd.event_spec_disp_id = l_event_spec_disp_id
1860: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
1861: AND esd.delete_mark = 0
1862: AND ssd.delete_mark = 0

Line 1892: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd

1888: END IF;
1889:
1890: SELECT MAX(ssd.disposition),MIN(ssd.disposition)
1891: INTO l_max_disposition,l_min_disposition
1892: FROM gmd_event_spec_disp esd, gmd_sample_spec_disp ssd
1893: WHERE
1894: esd.event_spec_disp_id = l_event_spec_disp_id
1895: AND esd.event_spec_disp_id = ssd.event_spec_disp_id
1896: AND esd.delete_mark = 0

Line 1932: UPDATE gmd_event_spec_disp

1928: gmd_debug.put_line('Final disp last =>'||l_final_event_disp);
1929: END IF;
1930:
1931: -- Set the disposition of the Event spec disp
1932: UPDATE gmd_event_spec_disp
1933: SET disposition = l_final_event_disp,
1934: last_updated_by = l_last_updated_by,
1935: last_update_date = l_last_update_date,
1936: last_update_login = l_last_update_login

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 2394: GMD_EVENT_SPEC_DISP esd ,

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
2398: and csd.event_spec_disp_id = esd.event_spec_disp_id

Line 5597: gmd_event_spec_disp c,

5593: SELECT b.disposition,
5594: d.meaning sample_disposition,
5595: e.meaning source
5596: FROM gmd_sample_spec_disp b,
5597: gmd_event_spec_disp c,
5598: gmd_samples s,
5599: fnd_lookup_values_vl d,
5600: fnd_lookup_values_vl e
5601: WHERE b.sample_id = p_sample.sample_id

Line 5614: gmd_event_spec_disp c,

5610: SELECT b.disposition,
5611: d.meaning sample_disposition,
5612: e.meaning source
5613: FROM gmd_sample_spec_disp b,
5614: gmd_event_spec_disp c,
5615: gmd_samples s,
5616: fnd_lookup_values d,
5617: fnd_lookup_values e
5618: WHERE b.sample_id =p_sample.sample_id