DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on MTL_LOT_NUMBERS

Line 3303: mtl_lot_numbers l,

3299: SELECT u.lot_number,
3300: ABS(SUM(u.transaction_quantity)) transaction_quantity,
3301: ABS(SUM(u.secondary_transaction_quantity)) secondary_transaction_quantity -- INVCONV
3302: FROM mtl_transaction_lot_numbers u,
3303: mtl_lot_numbers l,
3304: mtl_material_transactions m
3305: WHERE m.transaction_id = u.transaction_id
3306: AND u.inventory_item_id = l_inventory_item_id
3307: AND m.transaction_source_type_id = 2