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.INV_MINMAX_PVT dependencies on MTL_ITEM_REVISIONS

Line 3963: FROM mtl_item_revisions mir

3959: IF l_item_rev_ctl = 2 THEN
3960: */
3961: SELECT MAX(revision)
3962: INTO l_item_revision
3963: FROM mtl_item_revisions mir
3964: WHERE inventory_item_id = p_item_id
3965: AND organization_id = l_orgn_id
3966: AND effectivity_date < SYSDATE
3967: AND implementation_date is not null /* Added for Bug 7110794 */

Line 3971: FROM mtl_item_revisions mir1

3967: AND implementation_date is not null /* Added for Bug 7110794 */
3968: AND effectivity_date =
3969: (
3970: SELECT MAX(effectivity_date)
3971: FROM mtl_item_revisions mir1
3972: WHERE mir1.inventory_item_id = mir.inventory_item_id
3973: AND mir1.organization_id = mir.organization_id
3974: AND implementation_date is not null /* Added for Bug 7110794 */
3975: AND effectivity_date < SYSDATE