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_STABILITY_STUDIES_GRP dependencies on GMD_SS_MATERIAL_SOURCES

Line 108: WHERE ss_id = (SELECT ss_id FROM gmd_ss_material_sources WHERE source_id = p_source_id);

104:
105: -- Retrieving inventory item id INVCONV
106: SELECT inventory_item_id, organization_id INTO l_inventory_item_id, l_organization_id -- INVCONV
107: FROM gmd_stability_studies_b
108: WHERE ss_id = (SELECT ss_id FROM gmd_ss_material_sources WHERE source_id = p_source_id);
109:
110: SELECT source_organization_id INTO l_source_organization_id
111: FROM gmd_ss_material_sources
112: WHERE source_id = p_source_id;

Line 111: FROM gmd_ss_material_sources

107: FROM gmd_stability_studies_b
108: WHERE ss_id = (SELECT ss_id FROM gmd_ss_material_sources WHERE source_id = p_source_id);
109:
110: SELECT source_organization_id INTO l_source_organization_id
111: FROM gmd_ss_material_sources
112: WHERE source_id = p_source_id;
113:
114: SELECT primary_uom_code INTO l_item_uom -- INVCONV
115: FROM mtl_system_items_b

Line 120: FROM gmd_ss_material_sources

116: WHERE inventory_item_id = l_inventory_item_id
117: AND organization_id = l_source_organization_id;
118:
119: SELECT NVL(lot_number,0) INTO l_lot_number -- INVCONV
120: FROM gmd_ss_material_sources
121: WHERE source_id = p_source_id ;
122:
123: l_progress := '020';
124:

Line 263: SELECT source_id,source_organization_id, lot_number,sample_qty FROM gmd_ss_material_sources -- INVCONV

259: x_return_status OUT NOCOPY VARCHAR2)
260: IS
261:
262: CURSOR cr_material_sources_lot IS
263: SELECT source_id,source_organization_id, lot_number,sample_qty FROM gmd_ss_material_sources -- INVCONV
264: WHERE ss_id = p_ss_id and lot_number IS NOT NULL ;
265:
266: cr_material_sources_lot_rec cr_material_sources_lot%ROWTYPE ;
267:

Line 322: l_sample_uom_out GMD_SS_MATERIAL_SOURCES.SAMPLE_QUANTITY_UOM%TYPE ;

318: l_inventory_item_id NUMBER ; -- INVCONV
319: l_organization_id NUMBER; -- INVCONV
320: l_sample_numbering NUMBER(3);
321: l_sample_qty_out NUMBER;
322: l_sample_uom_out GMD_SS_MATERIAL_SOURCES.SAMPLE_QUANTITY_UOM%TYPE ;
323: l_source_label VARCHAR2(200);
324: l_temp NUMBER;
325: l_quality_parameters GMD_QUALITY_CONFIG%ROWTYPE; -- INVCONV
326: l_return_status VARCHAR2(1); -- INVCONV

Line 331: SELECT source_id FROM gmd_ss_material_sources

327: l_orgn_found BOOLEAN; -- INVCONV
328: l_source_organization_code VARCHAR2(3);
329:
330: CURSOR cr_material_sources IS
331: SELECT source_id FROM gmd_ss_material_sources
332: WHERE ss_id = p_ss_id ;
333:
334: CURSOR cr_material_src_variant IS
335: SELECT source_organization_id,lot_number,recipe_no

Line 336: FROM gmd_ss_material_sources -- INVCONV

332: WHERE ss_id = p_ss_id ;
333:
334: CURSOR cr_material_src_variant IS
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 ) ;

Line 397: FROM gmd_ss_material_sources

393: l_progress := '030';
394: -- The required number of source materials has been specified.
395:
396: SELECT count(1) into l_actual_mtrl_src_cnt
397: FROM gmd_ss_material_sources
398: WHERE ss_id = p_ss_id ;
399:
400: IF l_actual_mtrl_src_cnt < l_material_sources_cnt THEN
401: gmd_api_pub.log_message('GMD_SS_MTRL_SRC_CNT_LESS','MTRL_CNT',to_char(l_material_sources_cnt));

Line 420: FROM gmd_ss_material_sources

416: p_sample_uom => l_sample_uom_out,
417: x_return_status => l_return_status) ;
418:
419: SELECT source_id INTO l_temp
420: FROM gmd_ss_material_sources
421: WHERE source_id = cr_material_sources_rec.source_id
422: FOR UPDATE OF sample_qty NOWAIT ;
423:
424: IF l_return_status = 'S' then

Line 425: UPDATE gmd_ss_material_sources

421: WHERE source_id = cr_material_sources_rec.source_id
422: FOR UPDATE OF sample_qty NOWAIT ;
423:
424: IF l_return_status = 'S' then
425: UPDATE gmd_ss_material_sources
426: SET sample_qty = l_sample_qty_out,
427: sample_quantity_uom = l_sample_uom_out, -- INVCONV
428: last_updated_by = fnd_global.user_id,
429: last_update_date = sysdate,

Line 505: FROM gmd_ss_material_sources -- INVCONV

501: REQ_FIELDS_MISSING EXCEPTION;
502:
503: CURSOR cr_material_src_smpl_event IS
504: SELECT source_organization_id,lot_number,recipe_no,sampling_event_id
505: FROM gmd_ss_material_sources -- INVCONV
506: WHERE ss_id = p_ss_id
507: AND (sampling_event_id IS NULL OR lot_number IS NULL) ; -- INVCONV
508:
509:

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: