APPS.GMD_SPEC_GRP dependencies on GMD_QC_STATUS

Line 104: FROM gmd_qc_status

100:
101:
102: CURSOR c_status (p_spec_status NUMBER) IS
103: SELECT 1
104: FROM gmd_qc_status
105: WHERE status_code = p_spec_status
106: AND delete_mark = 0
107: and entity_type = 'S';
108:

Line 2242: FROM gmd_qc_status a

2238: RETURN BOOLEAN IS
2239:
2240: CURSOR c_status (p_status_code NUMBER) IS
2241: SELECT a.updateable
2242: FROM gmd_qc_status a
2243: WHERE a.status_type =
2244: (SELECT status_type
2245: FROM gmd_qc_status b
2246: WHERE b.status_code = p_status_code

Line 2245: FROM gmd_qc_status b

2241: SELECT a.updateable
2242: FROM gmd_qc_status a
2243: WHERE a.status_type =
2244: (SELECT status_type
2245: FROM gmd_qc_status b
2246: WHERE b.status_code = p_status_code
2247: and b.entity_type = 'S')
2248: and a.entity_type = 'S'
2249: ;

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'; */

Line 2390: From gmd_specifications_b a, gmd_qc_status b

2386: END IF;
2387:
2388: OPEN Status_cur FOR
2389: Select b.version_enabled
2390: From gmd_specifications_b a, gmd_qc_status b
2391: Where a.spec_id = p_entity_id
2392: And a.spec_status = b.status_code
2393: and b.entity_type = 'S';
2394: FETCH Status_cur INTO l_version_enabled;

Line 2696: FROM gmd_qc_status_next

2692: SELECT decode(p_mode, 'S', current_status,
2693: 'P', pending_status,
2694: 'R', rework_status,
2695: 'A', target_status)
2696: FROM gmd_qc_status_next
2697: WHERE current_status = p_current_status
2698: AND target_status = p_target_status
2699: AND entity_type = p_entity_type
2700: ;