APPS.GMD_STABILITY_STUDIES_GRP dependencies on GMD_SS_VARIANTS

Line 67: FROM gmd_ss_variants

63: l_progress VARCHAR2(3);
64:
65: CURSOR cr_all_variants IS
66: SELECT variant_id , variant_no,retained_samples ,sample_qty , sample_quantity_uom , storage_organization_id -- INVCONV
67: FROM gmd_ss_variants
68: WHERE material_source_id = p_source_id
69: AND delete_mark = 0 ;
70:
71: l_variant_count NUMBER(5) := 0 ;

Line 72: l_variant_no GMD_SS_VARIANTS.VARIANT_NO%TYPE;

68: WHERE material_source_id = p_source_id
69: AND delete_mark = 0 ;
70:
71: l_variant_count NUMBER(5) := 0 ;
72: l_variant_no GMD_SS_VARIANTS.VARIANT_NO%TYPE;
73: l_tl_samples NUMBER(5) ;
74: l_tl_time_points_with_samples NUMBER(5);
75: l_tl_time_points NUMBER(5) ;
76:

Line 339: ( select 'x' from gmd_ss_variants

335: SELECT source_organization_id,lot_number,recipe_no
336: FROM gmd_ss_material_sources -- INVCONV
337: WHERE ss_id = p_ss_id
338: and not exists
339: ( select 'x' from gmd_ss_variants
340: where material_source_id = source_id ) ;
341:
342: CURSOR cr_variants_storage_spec IS
343: SELECT a.storage_spec_id,b.spec_name,b.spec_vers

Line 344: FROM gmd_ss_variants a,gmd_specifications b

340: where material_source_id = source_id ) ;
341:
342: CURSOR cr_variants_storage_spec IS
343: SELECT a.storage_spec_id,b.spec_name,b.spec_vers
344: FROM gmd_ss_variants a,gmd_specifications b
345: WHERE a.ss_id = p_ss_id
346: and a.storage_spec_id = b.spec_id
347: and b.spec_status not in (400,700) ;
348:

Line 514: FROM gmd_ss_material_sources a , gmd_ss_variants b -- INVCONV

510: --Bug#3583299. Changed a condition in the 'where' clause from 'a.ss_id = b.ss_id' to 'a.source_id = b.material_source_id'
511: --in 'cr_material_src_yield_date' cursor.
512: CURSOR cr_material_src_yield_date IS
513: SELECT source_organization_id,lot_number,recipe_no,yield_date,variant_no
514: FROM gmd_ss_material_sources a , gmd_ss_variants b -- INVCONV
515: WHERE a.ss_id = p_ss_id
516: AND a.source_id = b.material_source_id
517: AND ((a.yield_date IS NULL) OR (a.yield_date > b.scheduled_start_date)) ;
518:

Line 521: FROM gmd_ss_material_sources a , gmd_ss_variants b -- INVCONV

517: AND ((a.yield_date IS NULL) OR (a.yield_date > b.scheduled_start_date)) ;
518:
519: CURSOR cr_variant_storage_date IS
520: SELECT source_organization_id,lot_number,recipe_no,variant_no
521: FROM gmd_ss_material_sources a , gmd_ss_variants b -- INVCONV
522: WHERE a.ss_id = p_ss_id
523: AND a.ss_id = b.ss_id
524: AND b.storage_date IS NULL ;
525: