DBA Data[Home] [Help]

APPS.INV_TRX_RELIEF_C_PVT dependencies on MTL_UNIT_TRANSACTIONS

Line 1634: mtl_serial_numbers msn, mtl_unit_transactions mut WHERE

1630:
1631: BEGIN
1632: SELECT msn.inventory_item_id, msn.serial_number bulk collect INTO
1633: l_serial_number_table FROM
1634: mtl_serial_numbers msn, mtl_unit_transactions mut WHERE
1635: msn.reservation_id = l_reservation_id AND msn.current_organization_id =
1636: p_organization_id AND msn.inventory_item_id = p_inventory_item_id
1637: AND mut.transaction_id = p_transaction_id AND msn.serial_number =
1638: mut.serial_number AND msn.inventory_item_id = mut.inventory_item_id