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 3956: FROM mtl_item_revisions mir

3952: IF l_item_rev_ctl = 2 THEN
3953: */
3954: SELECT MAX(revision)
3955: INTO l_item_revision
3956: FROM mtl_item_revisions mir
3957: WHERE inventory_item_id = p_item_id
3958: AND organization_id = l_orgn_id
3959: AND effectivity_date < SYSDATE
3960: AND implementation_date is not null /* Added for Bug 7110794 */

Line 3964: FROM mtl_item_revisions mir1

3960: AND implementation_date is not null /* Added for Bug 7110794 */
3961: AND effectivity_date =
3962: (
3963: SELECT MAX(effectivity_date)
3964: FROM mtl_item_revisions mir1
3965: WHERE mir1.inventory_item_id = mir.inventory_item_id
3966: AND mir1.organization_id = mir.organization_id
3967: AND implementation_date is not null /* Added for Bug 7110794 */
3968: AND effectivity_date < SYSDATE