APPS.GMD_SPEC_GRP dependencies on GMD_QC_STATUS

Line 119: FROM gmd_qc_status

115:
116:
117: CURSOR c_status (p_spec_status NUMBER) IS
118: SELECT 1
119: FROM gmd_qc_status
120: WHERE status_code = p_spec_status
121: AND delete_mark = 0
122: and entity_type = 'S';
123:

Line 2314: FROM gmd_qc_status a

2310: RETURN BOOLEAN IS
2311:
2312: CURSOR c_status (p_status_code NUMBER) IS
2313: SELECT a.updateable
2314: FROM gmd_qc_status a
2315: WHERE a.status_type =
2316: (SELECT status_type
2317: FROM gmd_qc_status b
2318: WHERE b.status_code = p_status_code

Line 2317: FROM gmd_qc_status b

2313: SELECT a.updateable
2314: FROM gmd_qc_status a
2315: WHERE a.status_type =
2316: (SELECT status_type
2317: FROM gmd_qc_status b
2318: WHERE b.status_code = p_status_code
2319: and b.entity_type = 'S')
2320: and a.entity_type = 'S'
2321: ;

Line 2371: gmd_qc_status_tl t

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

Line 2378: gmd_qc_status_tl t

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

Line 2385: gmd_qc_status_tl t

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

Line 2392: gmd_qc_status_tl t

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

Line 2399: gmd_qc_status_tl t

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

Line 2406: gmd_qc_status_tl t

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

Line 2413: gmd_qc_status_tl t

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

Line 2462: From gmd_specifications_b a, gmd_qc_status b

2458: END IF;
2459:
2460: OPEN Status_cur FOR
2461: Select b.version_enabled
2462: From gmd_specifications_b a, gmd_qc_status b
2463: Where a.spec_id = p_entity_id
2464: And a.spec_status = b.status_code
2465: and b.entity_type = 'S';
2466: FETCH Status_cur INTO l_version_enabled;

Line 2768: FROM gmd_qc_status_next

2764: SELECT decode(p_mode, 'S', current_status,
2765: 'P', pending_status,
2766: 'R', rework_status,
2767: 'A', target_status)
2768: FROM gmd_qc_status_next
2769: WHERE current_status = p_current_status
2770: AND target_status = p_target_status
2771: AND entity_type = p_entity_type
2772: ;