DBA Data[Home] [Help]

APPS.INV_LPN_RESERVATIONS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 850: mtl_serial_numbers msn

846: CURSOR serials_lpn(v_reservation_id NUMBER) IS
847: SELECT msn.inventory_item_id,
848: msn.serial_number
849: FROM mtl_reservations mr,
850: mtl_serial_numbers msn
851: WHERE mr.organization_id = p_organization_id
852: AND (p_inventory_item_id IS NULL OR mr.inventory_item_id = p_inventory_item_id)
853: AND mr.reservation_id = msn.reservation_id
854: AND mr.lpn_id=p_lpn_id

Line 1083: mtl_serial_numbers msn

1079: CURSOR serials_lpn(v_reservation_id NUMBER) IS
1080: SELECT msn.inventory_item_id,
1081: msn.serial_number
1082: FROM mtl_reservations mr,
1083: mtl_serial_numbers msn
1084: WHERE mr.organization_id = p_organization_id
1085: AND (p_inventory_item_id IS NULL OR mr.inventory_item_id = p_inventory_item_id)
1086: AND mr.reservation_id = msn.reservation_id
1087: AND mr.lpn_id=p_lpn_id