DBA Data[Home] [Help]

APPS.OE_DELAYED_REQUESTS_UTIL dependencies on MTL_UNIT_TRANSACTIONS_ALL_V

Line 3562: FROM mtl_unit_transactions_all_v u,

3558:
3559: -- Added fix for bug 4493305
3560: CURSOR serial_numbers is
3561: SELECT DISTINCT u.serial_number
3562: FROM mtl_unit_transactions_all_v u,
3563: mtl_material_transactions m
3564: WHERE m.transaction_id = u.transaction_id
3565: AND m.INVENTORY_ITEM_ID = l_inventory_item_id
3566: AND u.serial_number = NVL(l_serial_number,u.serial_number)

Line 3577: FROM mtl_unit_transactions_all_v u,

3573:
3574: CURSOR lot_serial_numbers is
3575: SELECT DISTINCT t.lot_number,
3576: u.serial_number
3577: FROM mtl_unit_transactions_all_v u,
3578: mtl_material_transactions m,
3579: mtl_transaction_lot_val_v t
3580: WHERE u.serial_number = NVL(l_serial_number,u.serial_number)
3581: AND u.INVENTORY_ITEM_ID = t.inventory_item_id