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_QC_STATUS_TL

Line 2299: gmd_qc_status_tl t

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
2303: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'

Line 2306: gmd_qc_status_tl t

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
2310: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'

Line 2313: gmd_qc_status_tl t

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
2317: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'

Line 2320: gmd_qc_status_tl t

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
2324: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'

Line 2327: gmd_qc_status_tl t

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
2331: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'

Line 2334: gmd_qc_status_tl t

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
2338: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S';

Line 2341: gmd_qc_status_tl t

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
2345: AND b.spec_vr_status = t.status_code AND t.entity_type = 'S'; */