DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on MTL_LOT_NUMBERS

Line 3546: mtl_lot_numbers l,

3542: SELECT u.lot_number,
3543: ABS(SUM(u.transaction_quantity)) transaction_quantity,
3544: ABS(SUM(u.secondary_transaction_quantity)) secondary_transaction_quantity -- INVCONV
3545: FROM mtl_transaction_lot_numbers u,
3546: mtl_lot_numbers l,
3547: mtl_material_transactions m
3548: WHERE m.transaction_id = u.transaction_id
3549: AND u.inventory_item_id = l_inventory_item_id
3550: AND m.transaction_source_type_id = 2