DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 3302: FROM mtl_transaction_lot_numbers u,

3298: CURSOR lot_numbers is
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