DBA Data[Home] [Help]

APPS.INV_TRX_RELIEF_C_PVT dependencies on MTL_SERIAL_NUMBERS

Line 1631: mtl_serial_numbers msn, mtl_unit_transactions mut WHERE

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