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

Line 1589: AND ( ( bh.batch_status IN (1,2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') )

1585: AND gr.formula_id = bh.formula_id
1586: AND bh.batch_id = md.batch_id
1587: AND bh.batch_type = 0 -- Only BATCH, no FPO
1588: --AND bh.batch_status IN (1, 2) -- PENDING or WIP BATCH only.
1589: AND ( ( bh.batch_status IN (1,2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') )
1590: or ( bh.batch_status IN (1,2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Bug # 4619570
1591: AND md.inventory_item_id = p_spec.inventory_item_id
1592: AND bh.organization_id = l_wip_vr.organization_id
1593: AND bh.batch_id = l_wip_vr.batch_id

Line 1590: or ( bh.batch_status IN (1,2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Bug # 4619570

1586: AND bh.batch_id = md.batch_id
1587: AND bh.batch_type = 0 -- Only BATCH, no FPO
1588: --AND bh.batch_status IN (1, 2) -- PENDING or WIP BATCH only.
1589: AND ( ( bh.batch_status IN (1,2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') )
1590: or ( bh.batch_status IN (1,2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Bug # 4619570
1591: AND md.inventory_item_id = p_spec.inventory_item_id
1592: AND bh.organization_id = l_wip_vr.organization_id
1593: AND bh.batch_id = l_wip_vr.batch_id
1594: AND NVL( l_wip_vr.recipe_id, gr.recipe_id) = gr.recipe_id