[Home] [Help]
45: *
46: * 20-MAY-2005 Susan Feinstein Bug 4165704 Inventory Convergence
47: * 18-OCT-2005 Susan Feinstein Bug 4640143 Added material detail id to gmd_wip_spec_vrs table
48: * 05-JAN-2006 Joe DiIorio Bug#4691545 Removed profile reference to
49: * NVL(fnd_profile.value('QC$EXACTSPECMATCH'),'N');
50: * and replaced with call to gmd_quality_config.
51: * Added FUNCTION GET_CONF_MATCH_VALUE as
52: * profile needs to be retrieved for each org that
53: * is passed.
1747: AND gr.delete_mark = 0
1748: AND gr.formula_id = bh.formula_id
1749: AND bh.batch_id = md.batch_id
1750: AND bh.batch_type = 0
1751: AND ( ( bh.batch_status IN (2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*-- wip or completed */
1752: OR ( bh.batch_status IN (2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) /*-- 4619570 wip or completed or closed */
1753: AND md.inventory_item_id = p_sample_rec.inventory_item_id /*--batch must be for item*/
1754: --AND bh.plant_code = p_sample_rec.organization_id -- bug 5291723 - plant code replace with organization
1755: AND bh.organization_id = p_sample_rec.organization_id -- bug 5291723
1748: AND gr.formula_id = bh.formula_id
1749: AND bh.batch_id = md.batch_id
1750: AND bh.batch_type = 0
1751: AND ( ( bh.batch_status IN (2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*-- wip or completed */
1752: OR ( bh.batch_status IN (2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) /*-- 4619570 wip or completed or closed */
1753: AND md.inventory_item_id = p_sample_rec.inventory_item_id /*--batch must be for item*/
1754: --AND bh.plant_code = p_sample_rec.organization_id -- bug 5291723 - plant code replace with organization
1755: AND bh.organization_id = p_sample_rec.organization_id -- bug 5291723
1756: AND bh.batch_status = gl.lookup_code