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_SAMPLES_PUB dependencies on FND_PROFILE

Line 49: * NVL(fnd_profile.value('QC$EXACTSPECMATCH'),'N');

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.

Line 1841: AND ( ( bh.batch_status IN (2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /-- wip or completed /

1837: AND gr.delete_mark = 0
1838: AND gr.formula_id = bh.formula_id
1839: AND bh.batch_id = md.batch_id
1840: AND bh.batch_type = 0
1841: AND ( ( bh.batch_status IN (2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*-- wip or completed */
1842: 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 */
1843: AND md.inventory_item_id = p_sample_rec.inventory_item_id /*--batch must be for item*/
1844: --AND bh.plant_code = p_sample_rec.organization_id -- bug 5291723 - plant code replace with organization
1845: AND bh.organization_id = p_sample_rec.organization_id -- bug 5291723

Line 1842: 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 /

1838: AND gr.formula_id = bh.formula_id
1839: AND bh.batch_id = md.batch_id
1840: AND bh.batch_type = 0
1841: AND ( ( bh.batch_status IN (2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*-- wip or completed */
1842: 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 */
1843: AND md.inventory_item_id = p_sample_rec.inventory_item_id /*--batch must be for item*/
1844: --AND bh.plant_code = p_sample_rec.organization_id -- bug 5291723 - plant code replace with organization
1845: AND bh.organization_id = p_sample_rec.organization_id -- bug 5291723
1846: AND bh.batch_status = gl.lookup_code

Line 1870: NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*--

1866: AND grvr.recipe_validity_rule_id = gbh.recipe_validity_rule_id
1867: AND gr.recipe_id = grvr.recipe_id
1868: AND gbh.batch_type = 0
1869: AND ( ( gbh.batch_status IN (2, 3) and (
1870: NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*--
1871: wip or completed */
1872: OR ( gbh.batch_status IN (2, 3, 4 ) and (
1873: NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) /*-- wip
1874: or completed or closed */

Line 1873: NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) /*-- wip

1869: AND ( ( gbh.batch_status IN (2, 3) and (
1870: NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) /*--
1871: wip or completed */
1872: OR ( gbh.batch_status IN (2, 3, 4 ) and (
1873: NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) /*-- wip
1874: or completed or closed */
1875: ;
1876:
1877: