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.WSMPLBJT dependencies on MTL_LOT_NUMBERS

Line 291: /* Bugfix 4317714: Add second where clause to also check for mtl_lot_numbers if uniqueness constraint is across items */

287: SELECT 1
288: FROM wip_entities
289: where wip_entity_name = temp_name
290: and organization_id = X_Organization_id)
291: /* Bugfix 4317714: Add second where clause to also check for mtl_lot_numbers if uniqueness constraint is across items */
292: OR EXISTS(
293: SELECT 1
294: FROM mtl_lot_numbers
295: where lot_number = temp_name

Line 294: FROM mtl_lot_numbers

290: and organization_id = X_Organization_id)
291: /* Bugfix 4317714: Add second where clause to also check for mtl_lot_numbers if uniqueness constraint is across items */
292: OR EXISTS(
293: SELECT 1
294: FROM mtl_lot_numbers
295: where lot_number = temp_name
296: and organization_id = X_Organization_id
297: and inventory_item_id = X_Item_Id));
298: /* End bugfix 4317714 */