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 1631: AND ( ( bh.batch_status IN (1,2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') )

1627: AND gr.formula_id = bh.formula_id
1628: AND bh.batch_id = md.batch_id
1629: AND bh.batch_type = 0 -- Only BATCH, no FPO
1630: --AND bh.batch_status IN (1, 2) -- PENDING or WIP BATCH only.
1631: AND ( ( bh.batch_status IN (1,2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') )
1632: or ( bh.batch_status IN (1,2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Bug # 4619570
1633: AND md.inventory_item_id = p_spec.inventory_item_id
1634: AND bh.organization_id = l_wip_vr.organization_id
1635: AND bh.batch_id = l_wip_vr.batch_id

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

1628: AND bh.batch_id = md.batch_id
1629: AND bh.batch_type = 0 -- Only BATCH, no FPO
1630: --AND bh.batch_status IN (1, 2) -- PENDING or WIP BATCH only.
1631: AND ( ( bh.batch_status IN (1,2, 3) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') )
1632: or ( bh.batch_status IN (1,2, 3,4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Bug # 4619570
1633: AND md.inventory_item_id = p_spec.inventory_item_id
1634: AND bh.organization_id = l_wip_vr.organization_id
1635: AND bh.batch_id = l_wip_vr.batch_id
1636: AND NVL( l_wip_vr.recipe_id, gr.recipe_id) = gr.recipe_id