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

Line 162: FROM mtl_item_revisions mir -- Use max to return the maximum revision num)

158: ** this
159: */
160: SELECT max(mir.revision) -- Bug 448708 (a no of revisions could have same effective date
161: INTO X_item_revision -- thus returning more than 1 row and causing errors
162: FROM mtl_item_revisions mir -- Use max to return the maximum revision num)
163: WHERE mir.organization_id = X_organization_id
164: AND mir.inventory_item_id = X_item_id
165: AND mir.effectivity_date in
166: (SELECT MAX(mir2.effectivity_date)

Line 167: FROM mtl_item_revisions mir2

163: WHERE mir.organization_id = X_organization_id
164: AND mir.inventory_item_id = X_item_id
165: AND mir.effectivity_date in
166: (SELECT MAX(mir2.effectivity_date)
167: FROM mtl_item_revisions mir2
168: WHERE mir2.organization_id = X_organization_id
169: AND mir2.inventory_item_id = X_item_id
170: /* Bug 1407438 - Filtering revisions which are not effective on current
171: date and also those which are not implemented */