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 2293: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_ALL_SPEC_VRS b

2289: -- perf bug 4924529 sql id 14687024 (FTS and MJC)
2290:
2291: CURSOR cr_spec_exist_in_sample IS
2292: /*
2293: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_ALL_SPEC_VRS b
2294: WHERE
2295: b.spec_id = p_spec_id
2296: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID ; */
2297:

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

2294: WHERE
2295: b.spec_id = p_spec_id
2296: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID ; */
2297:
2298: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_INVENTORY_SPEC_VRS b,
2299: gmd_qc_status_tl t
2300: WHERE
2301: b.spec_id = p_spec_id
2302: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

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

2301: b.spec_id = p_spec_id
2302: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2303: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2304: UNION
2305: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_WIP_SPEC_VRS b,
2306: gmd_qc_status_tl t
2307: WHERE
2308: b.spec_id = p_spec_id
2309: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

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

2308: b.spec_id = p_spec_id
2309: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2310: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2311: UNION
2312: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_CUSTOMER_SPEC_VRS b,
2313: gmd_qc_status_tl t
2314: WHERE
2315: b.spec_id = p_spec_id
2316: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

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

2315: b.spec_id = p_spec_id
2316: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2317: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2318: UNION
2319: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_SUPPLIER_SPEC_VRS b,
2320: gmd_qc_status_tl t
2321: WHERE
2322: b.spec_id = p_spec_id
2323: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

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

2322: b.spec_id = p_spec_id
2323: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2324: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2325: UNION
2326: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_MONITORING_SPEC_VRS b,
2327: gmd_qc_status_tl t
2328: WHERE
2329: b.spec_id = p_spec_id
2330: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

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

2329: b.spec_id = p_spec_id
2330: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2331: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'
2332: UNION
2333: SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_STABILITY_SPEC_VRS b,
2334: gmd_qc_status_tl t
2335: WHERE
2336: b.spec_id = p_spec_id
2337: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID

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

2336: b.spec_id = p_spec_id
2337: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID
2338: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S';
2339:
2340: /*SELECT '1' FROM GMD_SAMPLING_EVENTS a , GMD_COM_SPEC_VRS_VL b,
2341: gmd_qc_status_tl t
2342: WHERE
2343: b.spec_id = p_spec_id
2344: AND b.SPEC_VR_ID = a.ORIGINAL_SPEC_VR_ID