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_SPEC_GRP dependencies on GMD_SAMPLING_EVENTS

Line 2365: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_ALL_SPEC_VRS b

2361: -- perf bug 4924529 sql id 14687024 (FTS and MJC)
2362:
2363: CURSOR cr_spec_exist_in_sample IS
2364: /*
2365: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_ALL_SPEC_VRS b
2366: WHERE
2367: b.spec_id = p_spec_id
2368: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID ; */
2369:

Line 2370: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_INVENTORY_SPEC_VRS b,

2366: WHERE
2367: b.spec_id = p_spec_id
2368: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID ; */
2369:
2370: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_INVENTORY_SPEC_VRS b,
2371: gmd_qc_status_tl t
2372: WHERE
2373: b.spec_id = p_spec_id
2374: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

Line 2377: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_WIP_SPEC_VRS b,

2373: b.spec_id = p_spec_id
2374: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2375: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2376: UNION
2377: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_WIP_SPEC_VRS b,
2378: gmd_qc_status_tl t
2379: WHERE
2380: b.spec_id = p_spec_id
2381: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

Line 2384: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_CUSTOMER_SPEC_VRS b,

2380: b.spec_id = p_spec_id
2381: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2382: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2383: UNION
2384: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_CUSTOMER_SPEC_VRS b,
2385: gmd_qc_status_tl t
2386: WHERE
2387: b.spec_id = p_spec_id
2388: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

Line 2391: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_SUPPLIER_SPEC_VRS b,

2387: b.spec_id = p_spec_id
2388: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2389: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2390: UNION
2391: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_SUPPLIER_SPEC_VRS b,
2392: gmd_qc_status_tl t
2393: WHERE
2394: b.spec_id = p_spec_id
2395: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

Line 2398: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_MONITORING_SPEC_VRS b,

2394: b.spec_id = p_spec_id
2395: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2396: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2397: UNION
2398: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_MONITORING_SPEC_VRS b,
2399: gmd_qc_status_tl t
2400: WHERE
2401: b.spec_id = p_spec_id
2402: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

Line 2405: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_STABILITY_SPEC_VRS b,

2401: b.spec_id = p_spec_id
2402: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2403: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2404: UNION
2405: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_STABILITY_SPEC_VRS b,
2406: gmd_qc_status_tl t
2407: WHERE
2408: b.spec_id = p_spec_id
2409: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

Line 2412: /*SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_COM_SPEC_VRS_VL b,

2408: b.spec_id = p_spec_id
2409: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2410: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S';
2411:
2412: /*SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_COM_SPEC_VRS_VL b,
2413: gmd_qc_status_tl t
2414: WHERE
2415: b.spec_id = p_spec_id
2416: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID